Подзапросы и CTE

CTE с WITH

Содержание курса

Нужно найти все товары с максимальной ценой, вынеся вычисление максимума в CTE max_price. Какой запрос решает задачу?

WITH max_price AS (SELECT MAX(price) AS value FROM products) SELECT title FROM products WHERE price = (SELECT value FROM max_price);

WITH max_price AS (SELECT MAX(price) AS value FROM products) SELECT title FROM products WHERE price = value;

WITH max_price AS (SELECT MAX(price) AS value FROM products) SELECT title FROM max_price WHERE price = value;

WITH max_price AS (SELECT MAX(price) AS value FROM products) SELECT title FROM products WHERE price > (SELECT value FROM max_price);