# 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.