지방에서 서울까지

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