기록

문제 https://school.programmers.co.kr/learn/courses/30/lessons/131118#qna 코드 SELECT RI.REST_ID, RI.REST_NAME, RI.FOOD_TYPE, RI.FAVORITES, RI.ADDRESS, RR.SCORE FROM REST_INFO RI INNER JOIN ( SELECT REST_ID, ROUND(AVG(REVIEW_SCORE),2) AS SCORE FROM REST_REVIEW GROUP BY REST_ID ) RR ON RI.REST_ID = RR.REST_ID WHERE ADDRESS LIKE '서울%' ORDER BY RR.SCORE DESC, RI.FAVORITES DESC마무리하면서 아래 풀이를 CTE를..