[프로그래머스, 131116] 식품분류별 가장 비싼 식품의 정보 조회하기 (mysql)

https://school.programmers.co.kr/learn/courses/30/lessons/131116

프로그래머스

728x90

---

SELECT origin.category, origin.price as max_price, origin.product_name
FROM food_product as origin, (
    SELECT category, MAX(price) as price
    FROM food_product
    WHERE category in ('과자', '국', '김치', '식용유')
    GROUP BY category
) as max_price
WHERE origin.category = max_price.category
AND origin.price = max_price.price
ORDER BY max_price DESC