Click in order · SQL and MySQL course · Module 6: Aggregation and grouping
Average price in each category
Click the tokens in order to build a query that computes the average book price in each category:
Items to click
- FROM ksiazki
- ;
- SELECT kategoria_id, AVG(cena)
- GROUP BY kategoria_id
You can check the correct answer by solving this task in the CodeWorlds game.