1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
-- 코드를 입력하세요
select
    a.*
from (
        SELECT
              a.REST_ID
            , a.REST_NAME
            , a.FOOD_TYPE
            , a.FAVORITES
            , a.ADDRESS
            , round(avg(b.REVIEW_SCORE), 2) as score
        from
            REST_INFO a
                inner join REST_REVIEW b
            on a.REST_ID = b.REST_ID
        where
            a.address like '서울%'
        group by
            a.REST_ID
) a
order by
    a.score desc, a.FAVORITES desc