Grouping and Aggregation 1
Q: Count the products in each category.
SELECT category, Count(category)
FROM Products
GROUP BY category
ORDER BY Count(category) DESC;