Database: bakery_1
Question: Count the number of goods for each food type.
SQL:
SELECT count(*) ,  food FROM goods GROUP BY food