[MySQL] 프로그래머스 식품분류별 가장 비싼 식품의 정보 조회하기 풀이

문제 확인

---

프로그래머스

 

나의 풀이

---

방법 1

SELECT category, MAX(price) AS 'max_price', product_name
FROM food_product
GROUP BY category
HAVING category IN ('과자', '국', '김치', '식용유')
ORDER BY 'MAX_PRICE' DESC;

 

방법2

SELECT
    category,
    price AS 'max_price',
    product_name
FROM food_product
WHERE (category, price) IN 
(SELECT
    category, 
    MAX(price) AS 'max_price' 
    FROM food_product
    GROUP BY category
    HAVING category IN ('과자', '국', '김치', '식용유'))
ORDER BY price DESC;