[PGS]서울에 위치한 식당 목록 출력하기

• JOIN + GROUP BY + ROUND

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