Решение к #Задача3: SELECT p.name AS product_name, pi | SQL задачи

Решение к #Задача3:

SELECT p.name AS product_name,
pi.count,
pi.price
FROM purchase_item pi
JOIN product p
ON p.product_id = pi.product_id
WHERE pi.price = (SELECT max(pim.price)
FROM purchase_item pim)

#задача