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:

This content is provided to you freely by EdTech Books.

Access it online or download it at https://edtechbooks.org/learning_mysql/simple_group_by_quer.