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

---

CREATE 문

CREATE TABLE FOOD_PRODUCT  (
PRODUCT_ID			VARCHAR(10)	NOT NULL,
PRODUCT_NAME			VARCHAR(50)	NOT NULL,
PRODUCT_CD			VARCHAR(10)	NULL,
CATEGORY			VARCHAR(10)	NULL,
PRICE				NUMBER		NULL
)

 

---

• 내 풀이

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
         WHERE CATEGORY IN ('과자' , '국' , '식용유' ,'김치')
         GROUP BY CATEGORY
        )
ORDER BY PRICE DESC;

조건문에 컬럼을 여러개 넣고 서브쿼리를 적용