[SELECT] 서울에 위치한 식당목록 출력

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

프로그래머스

 

 

level4

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