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