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

🔗 서울에 위치한 식당 목록 출력하기

🦈 MySQL 🦈

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

 

⭕️ Oralce ⭕️

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

 

 

 

---

Oracle에서는 집계함수를 제외한 모든 SELECT 절을 GROUP BY 절에 명시해줘야 한다.