프로그래머스 SQL 연습문제: 서울에 위치한 식당 목록 출력하기

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

SELECT
    I.REST_ID,
    I.REST_NAME,
    I.FOOD_TYPE,
    I.FAVORITES,
    I.ADDRESS,
    ROUND(R.AVG_SCORE, 2) AS SCORE
FROM REST_INFO I
INNER JOIN
(
    SELECT REST_ID, AVG(REVIEW_SCORE) AS AVG_SCORE
    FROM REST_REVIEW
    GROUP BY REST_ID
) R
ON I.REST_ID = R.REST_ID
WHERE I.ADDRESS LIKE '서울%'
ORDER BY
    SCORE DESC,
    I.FAVORITES DESC;