[SQL문제풀기] 년, 월, 성별 별 상품 구매 회원 수 구하기

문제

MYSQL

내가 작성한 정답

SELECT YEAR(S.SALES_DATE) YEAR, MONTH(S.SALES_DATE) MONTH, U.GENDER, COUNT(DISTINCT S.USER_ID) USERS
FROM USER_INFO U
JOIN ONLINE_SALE S ON U.USER_ID = S.USER_ID AND U.GENDER IS NOT NULL
GROUP BY YEAR(S.SALES_DATE), MONTH(S.SALES_DATE), U.GENDER
ORDER BY 1,2,3;

ORACLE

내가 작성한 정답

SELECT EXTRACT(YEAR FROM S.SALES_DATE) YEAR, TO_CHAR(S.SALES_DATE,'MM')+0 MONTH, U.GENDER,  COUNT(DISTINCT S.USER_ID) USERS
FROM USER_INFO U
JOIN ONLINE_SALE S ON U.USER_ID = S.USER_ID AND U.GENDER IS NOT NULL
GROUP BY EXTRACT(YEAR FROM S.SALES_DATE), TO_CHAR(S.SALES_DATE,'MM'), U.GENDER
ORDER BY 1,2,3;