(프로그래머/MySQL) 서울의 레스토랑 목록 인쇄

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