[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
WHERE U.GENDER IS NOT NULL
GROUP BY YEAR(S.SALES_DATE), MONTH(S.SALES_DATE), U.GENDER
ORDER BY YEAR ASC, MONTH ASC, GENDER ASC

ORACLE

내가 작성한 정답

SELECT EXTRACT(YEAR FROM S.SALES_DATE) YEAR, EXTRACT(MONTH FROM S.SALES_DATE) MONTH,
        U.GENDER, COUNT(DISTINCT U.USER_ID) USERS
FROM USER_INFO U
JOIN ONLINE_SALE S ON U.USER_ID = S.USER_ID
WHERE U.GENDER IS NOT NULL
GROUP BY EXTRACT(YEAR FROM S.SALES_DATE), EXTRACT(MONTH FROM S.SALES_DATE), U.GENDER
ORDER BY YEAR ASC, MONTH ASC, GENDER ASC