Under Assignment#$3$ module, you'll find a script to create SCM $($Supply Chain

Management$)$ database and its $8$ tables of good$\_$classifications, buyers, staff,

orderdetails, orders, merchandise, shipping$\_$companies, and suppliers. Download

this file SCM$.$sql and make sure to execute the commands it contains.

Question#$1$: Write a query that returns a table indicating the total number of products in each classification. Table results should be sorted by the total number of

products in descending order. Please Use SQL