SELECT
    strftime("%Y-%M-%D", CONFIRMED_AT) as REGIST_DATE,
    CASE strftime("%w", CONFIRMED_AT)
		WHEN 1 THEN '日' 
		WHEN 2 THEN '月' 
		WHEN 3 THEN '火' 
		WHEN 4 THEN '水' 
		WHEN 5 THEN '木' 
		WHEN 6 THEN '金' 
		WHEN 7 THEN '土' 
	END as WK,
    COUNT(CONFIRMED_AT) as TOTAL
FROM
    USERS
WHERE
    VALID_FLG = 1
GROUP BY
    strftime("%Y-%m-%d", CONFIRMED_AT)
ORDER BY
    REGIST_DATE ASC