강의로 돌아가기
kimgun95

MySQL 정답 공유

SELECT YEAR(OS.salesdate) Y, MONTH(OS.salesdate) M, UI.gender GENDER, COUNT(DISTINCT UI.userid)
FROM USER
INFO UI, ONLINESALE OS
WHERE UI.user
id = OS.user_id AND GENDER is not null
GROUP BY Y,M,GENDER
ORDER BY Y,M,GENDER

작성중인 코드―solution.sql
1
2
3
4
5
6
-- 코드를 입력하세요
SELECT YEAR(OS.sales_date) Y, MONTH(OS.sales_date) M, UI.gender GENDER, COUNT(DISTINCT UI.user_id)
FROM USER_INFO UI, ONLINE_SALE OS
WHERE UI.user_id = OS.user_id AND GENDER is not null
GROUP BY Y,M,GENDER
ORDER BY Y,M,GENDER
0 개의 답변
답변 쓰기
이 입력폼은 마크다운 문법을 지원합니다. 마크다운 가이드 를 참고하세요.