나의 오라클 정답공유

임석현

2022.11.3 14:32

나의 오라클 정답공유

WITH LAST AS
(
SELECT X.RESTID AS RESTID
,ROUND(AVG(X.REVIEWSCORE),2) AS SCORE
FROM RESTREVIEW X

GROUP BY X.RESTID
)
SELECT A.RESTID,A.RESTNAME,A.FOODTYPE,A.FAVORITES,A.ADDRESS,T.SCORE
FROM RESTINFO A, LAST T

WHERE A.RESTID = T.REST_ID
AND A.ADDRESS LIKE '서울%' -- %서울% 입력하면 틀리다고 나옵니다.
ORDER BY T.SCORE DESC, A.FAVORITES DESC

작성중인 코드―solution.sql

1
2
3
4
5
6
7
8
9
10
11
12
WITH LAST AS
(
    SELECT X.REST_ID AS REST_ID 
          ,ROUND(AVG(X.REVIEW_SCORE),2) AS SCORE
      FROM REST_REVIEW X     
   GROUP BY X.REST_ID
)
SELECT A.REST_ID,A.REST_NAME,A.FOOD_TYPE,A.FAVORITES,A.ADDRESS,T.SCORE
  FROM REST_INFO A, LAST T   
 WHERE A.REST_ID = T.REST_ID
   AND A.ADDRESS LIKE '서울%'
ORDER BY T.SCORE DESC, A.FAVORITES DESC

임석현

2022.11.3 14:32

나의 오라클 정답공유

작성중인 코드―solution.sql

0 개의 답변

답변 쓰기

This input form supports markdown syntax. Please refer to 마크다운 가이드.