Consider the following schema: SUPPLIERS (SID, SNAME, ADDRESS) PARTS (PID, PNAME, COLOR) CATALOG (SID, PID, COST) The primary key fields are underlined, and the foreign keys are italicized. Thus, SID is the key for SUPPLIERS, PID is the key for PARTS, and SID and PID together form the key for CATALOG. The CATALOG relation lists the prices charged for parts by suppliers. CATALOG. SID is a foreign key referring to SUPPLIERS. SID and CATALOG. PID is a foreign key referring to PARTS. PID.
Write the following query in SQL in the given space below:
For each supplier, list the SID, name of supplier i. e. SNAME, and the number of parts they supply, sorted in the descending order of the number of parts they supply.