지방에서 서울까지

-- 코드를 입력하세요 SELECT A.REST_ID, B.REST_NAME, B.FOOD_TYPE, B.FAVORITES, B.ADDRESS, ROUND(AVG(REVIEW_SCORE), 2) AS SCORE FROM REST_REVIEW A INNER JOIN (SELECT REST_ID, REST_NAME, FOOD_TYPE, FAVORITES, ADDRESS FROM REST_INFO WHERE SUBSTR(ADDRESS, 1, 2) = '서울') B ON A.REST_ID = B.REST_ID GROUP BY 1 ORDER BY SCORE DESC , B.FAVORITES DESC

SELECT DISTINCT A.CART_ID FROM (SELECT CART_ID, NAME FROM CART_PRODUCTS WHERE NAME = 'Yogurt') A LEFT JOIN (SELECT CART_ID, NAME FROM CART_PRODUCTS WHERE NAME = 'Milk') B ON A.CART_ID = B.CART_ID WHERE A.NAME IS NOT NULL AND B.NAME IS NOT NULL

SELECT ID, NAME, HOST_ID FROM PLACES WHERE PLACES.HOST_ID IN (SELECT HOST_ID FROM (SELECT HOST_ID,COUNT(HOST_ID) AS H_CNT FROM PLACES GROUP BY HOST_ID HAVING H_CNT >= 2)A)

SELECT D.MEMBER_NAME, A.REVIEW_TEXT, DATE_FORMAT(A.REVIEW_DATE, "%Y-%m-%d") FROM (SELECT A.MEMBER_ID, A.REVIEW_TEXT, A.REVIEW_DATE FROM REST_REVIEW A INNER JOIN (SELECT * FROM (SELECT MEMBER_ID, RANK() OVER(ORDER BY CNT DESC) RNK FROM (SELECT MEMBER_ID, COUNT(MEMBER_ID) AS CNT FROM REST_REVIEW GROUP BY 1) A) B WHERE B.RNK = 1) C ON C.MEMBER_ID = A.MEMBER_ID) A INNER JOIN MEMBER_PROFILE D ON A.ME..

SELECT A.* FROM ( SELECT SUBSTRING(SALES_DATE,1,10) , PRODUCT_ID , USER_ID , SUM(SALES_AMOUNT) FROM ONLINE_SALE WHERE SUBSTRING(SALES_DATE,6,2) = '03' GROUP BY 1,2,3 UNION ALL SELECT SUBSTRING(OFF.SALES_DATE,1,10) , OFF.PRODUCT_ID , NULL AS USER_ID , SUM(OFF.SALES_AMOUNT) FROM OFFLINE_SALE OFF WHERE SUBSTRING(OFF.SALES_DATE,6,2) = '03' GROUP BY 1,2,3 ) A ORDER BY 1,2,3

SET @hour := -1; -- 변수 선언 SELECT (@hour := @hour + 1) as HOUR, (SELECT COUNT(*) FROM ANIMAL_OUTS WHERE HOUR(DATETIME) = @hour) as COUNT FROM ANIMAL_OUTS WHERE @hour < 23