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

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

프로그래머스

 

select rest_id, rest_name, food_type, favorites, address, round(avg(review_score),2) as score
from rest_info natural join rest_review
where address like "서울%"
group by rest_id, rest_name, food_type, favorites, address
order by score desc, favorites desc