SELECT strftime('%Y-%m-%d',CONFIRMED_AT) AS REGIST_DATE
,substr('日月火水木金土', strftime("%w",CONFIRMED_AT)+1, 1) AS WK
,COUNT(*) AS TOTAL
FROM USERS
WHERE CONFIRMED_AT BETWEEN '2022-08-01 00:00:00' AND '2022-08-31 23:59:59'
AND VALID_FLG = '1'
GROUP BY strftime('%Y-%m-%d',CONFIRMED_AT)