Database: bakery_1
Question: What are highest, lowest, and average prices of goods, grouped and ordered by flavor?
SQL:
SELECT max(price) ,  min(price) ,  avg(price) ,  flavor FROM goods GROUP BY flavor ORDER BY flavor