식품분류별 가장 비싼 식품의 정보 조회하기

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