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. Only show categories with an average above 600.
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.