5.3

Simple GROUP BY Query

Code Example:

USE bike;
SELECT category_id, AVG(list_price)
FROM product
GROUP BY category_id

Results:

ag_02.png

USE bike:

SELECT category_id, AVG(list_price):


FROM product:

GROUP BY category_id: