서울에 위치한 식당 목록 출력하기

[ji-0630]

문제 설명

[ji-0630]

나의 풀이

SELECT i.REST_ID, i.REST_NAME, i.FOOD_TYPE, i.FAVORITES, i.ADDRESS, r.REVIEW_SCORE
from REST_INFO i inner join 
            (select REST_ID, round(avg(REVIEW_SCORE), 2) as REVIEW_SCORE
             from REST_REVIEW
             group by REST_ID) r
on i.REST_ID = r.REST_ID
where i.ADDRESS like "서울%"
order by r.REVIEW_SCORE desc, i.FAVORITES desc