문제 링크: https://school.programmers.co.kr/learn/courses/30/lessons/131116 정상 코드. 방법 1. 상관 서브 쿼리 사용 SELECT CATEGORY, PRICE, PRODUCT_NAME FROM FOOD_PRODUCT F WHERE CATEGORY IN('과자', '국', '김치', '식용유') AND PRICE = (SELECT MAX(PRICE) FROM FOOD_PRODUCT AS S WHERE S.CATEGORY = F.CATEGORY) ORDER BY PRICE DESC 방법 2. 윈도우 함수 사용 SELECT CATEGORY, PRICE, PRODUCT_NAME FROM FOOD_PRODUCT WHERE CATEGORY IN('과자', '국..
