[프로그래머스] 서울에 위치한 식당 목록 출력하기

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

프로그래머스

 

 

내 풀이

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