[프로그래머스/SQL] GROUP BY 식품분류별 가장 비싼 식품의 정보 조회하기
문제 설명 문제 풀이 1 2 3 4 5 6 7 8 9 select category, price "Max_PRICE", product_name from food_product where (category, price) in ( SELECT category, max(price) from food_product group by category having category in ('과자', '국', '김치', '식용유') ) order by 2 desc; Colored by Color Scripter cs