Scalar Subqueries

A scalar subquery returns exactly one value (one row, one column). You can use it anywhere a single value is expected.

Using in SELECT

SELECT 
    name,
    price,
    (SELECT AVG(price) FROM products) as avg_price
FROM products;

This adds the average price as a column to every row.

Your Task

Write a query that shows each product's name, price, and the maximum price across all products (as max_price).

Order by price descending and limit to 5 results.