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.