Database: customers_and_orders
Question: List all product type codes and the number of products in each type.
SQL:
SELECT product_type_code ,  count(*) FROM Products GROUP BY product_type_code