Database: customers_and_orders
Question: How many products are there for each product type?
SQL:
SELECT product_type_code ,  count(*) FROM Products GROUP BY product_type_code