💻 프로그래밍/프로그래머스

프로그래머스 - 서울에 위치한 식당 목록 출력하기

ssoniya 2025. 2. 12. 21:25

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