[프로그래머스 SQL 고득점 Kit] GROUP BY: 식품분류별 가장 비싼 식품의 정보 조회하기

문제

 

 

 

정답

SELECT CATEGORY, PRICE AS MAX_PRICE, PRODUCT_NAME
FROM FOOD_PRODUCT
WHERE PRICE IN (SELECT MAX(PRICE)
                FROM FOOD_PRODUCT
                GROUP BY CATEGORY) 
            AND CATEGORY IN ('과자', '국', '김치', '식용유')
ORDER BY MAX_PRICE DESC