[SQL문제풀기] 식품분류별 가장 비싼 식품의 정보 조회하기

문제

MYSQL, ORACLE

내가 작성한 정답

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