Database: bakery_1
Question: How many goods are available for each food type?
SQL:
SELECT count(*) ,  food FROM goods GROUP BY food