https://whdgus928.tistory.com/29
https://jaehwaseo.tistory.com/30
[CATEGORY로 그룹핑만 시켜준 경우]
SELECT *
from FOOD_PRODUCT
where CATEGORY in ('과자', '국', '김치', '식용유')
group by CATEGORY
order by PRICE desc;
[틀린 코드]
SELECT CATEGORY, max(PRICE) as MAX_PRICE, PRODUCT_NAME
from FOOD_PRODUCT
where CATEGORY in ('과자', '국', '김치', '식용유')
group by CATEGORY
order by MAX_PRICE desc;
https://monawa.tistory.com/126
https://school.programmers.co.kr/questions/38854
https://jaehwaseo.tistory.com/30
[수정한 코드]
SELECT CATEGORY, price as MAX_PRICE, PRODUCT_NAME
from FOOD_PRODUCT
where (CATEGORY, price) in (select CATEGORY, max(price) from FOOD_PRODUCT
where CATEGORY in ('과자', '국', '김치','식용유')
group by CATEGORY
)
order by MAX_PRICE desc;