컬럼의 데이터 평균을 소수점 둘째자리까지 표현한다! (셋째자리에서 반올림한다.)
SELECT REST_INFO.REST_ID, REST_NAME,FOOD_TYPE, FAVORITES, ADDRESS, ROUND(AVG(REVIEW_SCORE),2) as SCORE
FROM REST_INFO
left JOIN REST_REVIEW ON REST_INFO.REST_ID = REST_REVIEW.REST_ID
where ADDRESS LIKE '서울%' AND REVIEW_SCORE IS NOT NULL
group by REST_ID
ORDER BY AVG(REVIEW_SCORE) DESC, FAVORITES DESC