[프로그래머스] MySQL / 년, 월, 성별 별 상품 구매 회원 수 구하기

문제 링크

https://school.programmers.co.kr/learn/courses/30/lessons/131532

프로그래머스

 

문제

 

코드 

-- 코드를 입력하세요
SELECT YEAR(O.SALES_DATE) AS YEAR, MONTH(O.SALES_DATE) AS MONTH, U.GENDER, COUNT(DISTINCT O.USER_ID) AS USER
FROM USER_INFO AS U INNER JOIN ONLINE_SALE O ON U.USER_ID = O.USER_ID
WHERE NOT U.GENDER IS NULL
GROUP BY YEAR(O.SALES_DATE), MONTH(O.SALES_DATE), U.GENDER
ORDER BY YEAR(O.SALES_DATE), MONTH(O.SALES_DATE), U.GENDER;