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

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

프로그래머스

---

728x90

select ri.REST_ID, REST_NAME, FOOD_TYPE, FAVORITES, ADDRESS, round(avg(review_score), 2) as SCORE
from rest_info as ri
right outer join rest_review as rr
on ri.rest_id = rr.rest_id
where address like '서울%'
group by rr.rest_id
order by score desc, favorites desc