FIRST_VALUE Function

FIRST_VALUE(column) returns the first value in the window:

FIRST_VALUE(name) OVER(PARTITION BY category ORDER BY price DESC)

This gets the name of the most expensive product in each category.

Your Task

For each product, show:

• name, category, price
• The most expensive product's name in that category (as category_leader)

Order by category, then price descending.