[SELECT/LEVEL4] 서울에 위치한 식당 목록 출력하기 (MySQL/Oracle)

MySQL/Oracle

SELECT 
      A.REST_ID
    , A.REST_NAME
    , FOOD_TYPE
    , FAVORITES
    , ADDRESS
    , ROUND(AVG(REVIEW_SCORE),2) SCORE
from REST_INFO A, REST_REVIEW B
where A.REST_ID = B.REST_ID
AND ADDRESS LIKE '서울%'
GROUP BY REST_ID
ORDER BY SCORE DESC,FAVORITES DESC

SELECT 
      A.REST_ID
    , A.REST_NAME
    , A.FOOD_TYPE
    , A.FAVORITES
    , A.ADDRESS
    , ROUND(AVG(B.REVIEW_SCORE),2) SCORE
from REST_INFO A, REST_REVIEW B
where A.REST_ID = B.REST_ID
AND A.ADDRESS LIKE '서울%'
GROUP BY A.REST_ID
    , A.REST_NAME
    , A.FOOD_TYPE
    , A.FAVORITES
    , A.ADDRESS
ORDER BY SCORE DESC,FAVORITES DESC