A coffee shop has a sales table with columns drink_type and…
A coffee shop has a sales table with columns drink_type and quantity. The manager wants to see how many drinks of each type were sold. Which query should they use? SELECT drink_type, SUM(quantity) FROM sales GROUP BY drink_type SELECT SUM(quantity) FROM sales SELECT drink_type, quantity FROM sales ORDER BY drink_type SELECT * FROM sales GROUP BY quantity Answer: SELECT drink_type, SUM(quantity) FROM sales GROUP BY drink_type Explanation: GROUP BY drink_type ensures sales are summarized by each drink type, while SUM(quantity) adds up total sales per type. A plain SUM(quantity) gives one total, not per type. Ordering without aggregation only sorts. Grouping by quantity is incorrect because it groups by values sold, not drink type.