Category-Wise Average Product Price in Northwind

Easy
34
91.2% Acceptance

Your task is to explore the database and craft an SQL query to answer the given challenge.

Relevant Tables:

  • products
  • categories

Challenge:
Show the category name and the average product unit price for each category, rounding the result to two decimal places. The column names must be category_name, average_unit_price and ordered by average_unit_price in descending order

Important Concepts:

  • JOIN: Understand how to use the JOIN clause to combine rows from two or more tables based on a related column.
  • GROUP BY: Grasp the concept of grouping rows that have the same values in specified columns into summary rows.
  • Aggregate Functions: Familiarize yourself with SQL aggregate functions, like AVG, to compute a single result value from a set of input values.
  • ROUND: Know how to use this function to round the numbers to the desired decimal places.
  • ORDER BY: To show the desired rows in the required order based on the column name

Best of luck! Craft your query keeping these concepts in mind.