Loading…
Build a CTE that calculates the average unit_price for each category_id, and then in the final query join it to the categories table to display category_name and the computed average rounded to 2 decimal places. Only show categories with an average above 600, ordered by category_name ascending.
Create a free account to save your progress and reveal the worked answer for this free exercise. The complete practice library is available with Practice Pass or Mastery.