SQL오류 WITH CUBE
-
게시물 수정 , 삭제는 로그인 필요
SELECT YEAR(ORDER_DATE) AS 연고,
CHANNEL_CODE AS 채널코드,
SUM(SALES_AMT) AS 주문금액
FROM EDU.ORDER
GROUP BY YEAR(ORDER_DATE),
CHANNEL_CODE
WITH CUBE
ORDER BY 1 DESC, 2 ASC
;
MYSQL 워크벤치에서 실습중인데 저렇게 치면 오류나는데 왜그런건가요 ㅠㅠ?
완전 초보인데 설명부탁드립니다!!
SELECT YEAR(ORDER_DATE) AS 연고,
CHANNEL_CODE AS 채널코드,
SUM(SALES_AMT) AS 주문금액
FROM EDU.ORDER
GROUP BY YEAR(ORDER_DATE),
CHANNEL_CODE
WITH CUBE
ORDER BY 1 DESC, 2 ASC
;
MYSQL 워크벤치에서 실습중인데 저렇게 치면 오류나는데 왜그런건가요 ㅠㅠ?
완전 초보인데 설명부탁드립니다!!