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

문제

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

프로그래머스

 

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