년, 월, 성별 별 상품 구매 회원 수 구하기

[ji-0630]

문제 설명

[ji-0630]

나의 풀이

SELECT year(SALES_DATE) as "YEAR", month(SALES_DATE) as "MONTH", gender, count(distinct u.USER_ID) as "USERS"
from USER_INFO u join ONLINE_SALE o
on u.USER_ID = o.USER_ID
where gender is not null
group by year(SALES_DATE), month(SALES_DATE), gender
order by year(SALES_DATE), month(SALES_DATE), gender

• distinct 확인할 것!