[프로그래머스]-즐겨찾기가 가장 많은 식당 정보 출력하기 Level3 Oracle풀이

https://school.programmers.co.kr/learn/courses/30/lessons/131123

프로그래머스

 

 

-- 코드를 입력하세요
select A.food_type,A.REST_ID,A.REST_NAME, B.favorites 

from  
    ( SELECT *
FROM REST_INFO 
 ) A

JOIN

( SELECT food_type,max(favorites) as favorites
FROM REST_INFO 
group by food_type ) B

On A.food_type = B.food_type and A.favorites=B.favorites
ORDER BY 1 desc;