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

https://school.programmers.co.kr/learn/courses/30/lessons/131118

프로그래머스

 

 

 

where절 사용

select R.REST_ID,
    REST_NAME,
    FOOD_TYPE,
    FAVORITES,
    ADDRESS
    , round(AVG(REVIEW_SCORE),2) AS SCORE
from REST_INFO AS I
JOIN REST_REVIEW AS R on I.REST_ID=R.REST_ID
where ADDRESS LIKE '서울%'
order by SCORE desc,FAVORITES desc

 

 

 

having절 사용

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 as I
join REST_REVIEW as R on I.REST_ID=R.REST_ID
group by R.REST_ID
having I.ADDRESS  LIKE '서울%'
order by SCORE desc, FAVORITES desc