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 BYU-I Books.

Access it online or download it at https://books.byui.edu/learning_mysql/simple_group_by_quer.