Q9. Report on the top Customer Names and their Total Order Quantity, where Total Order Quantity is greater than 100, order results by Total Order Quantity in Descending order. Hint: Join Order Details, Order and Customers. Sum the Quantity ordered in Quantity Details for all the Orders for every Customer, but only for sum of quantity > 100.

Q.11. Report on the Shipper CompanyName and their Total Orders shipped. Order by Count of Orders Shipped in Descending order. Hint: Join Orders and Shippers, display the Count of OrderIds for each shipper, and order by count of OrderIds in descending order

Note: The query below works in W3Schools, ER model has the name Shippers.CompanyName

Q12. Report on the Category Names and the Count of Products within each category. Sort by Count of Products in Descending Order. Hint: Join Categories and Products, and Count # of Categories in the Product table. Order by Count # of Categories.

\begin{tabular}{|l|l|} \hline \multicolumn{2}{|c|}{ Oder Dwals } \\ \hline PK.FK1 & OrdonD \\ PK.FK2 & Procuctio \\ \hline & UnaPriceOuantlyDisooumt \\ \hline \end{tabular}