주별 가입자 수 파악하기

#회원별(리더)주별가입자수
SELECT WEEK(join_date) AS join_week
	, category
    , CONCAT(
    DATE_FORMAT(DATE_ADD(join_date, INTERVAL(1-DAYOFWEEK(join_date)) DAY),'%Y-%m-%e'),
    ' TO ',   
    DATE_FORMAT(DATE_ADD(join_date, INTERVAL(7-DAYOFWEEK(join_date)) DAY),'%Y-%m-%e')
	) AS DateRange
    , COUNT(*) AS cnt
FROM haram_join
WHERE category = 'leader'
GROUP BY join_week, DateRange
ORDER BY cnt DESC;