SELECT
    DATE(CONFIRMED_AT) AS REGIST_DATE,
    substr('日月火水木金土', strftime("%w", DATE(CONFIRMED_AT))*1 +1, 1) AS WK,
    COUNT(DISTINCT USER_CODE) AS TOTAL
FROM USERS
WHERE DATE(CONFIRMED_AT)>= "2022-08-01" AND DATE(CONFIRMED_AT)<= "2022-08-31" AND VALID_FLG='1'
GROUP BY DATE(CONFIRMED_AT), substr('日月火水木金土', strftime("%w", DATE(CONFIRMED_AT))*1 +1, 1)
ORDER BY REGIST_DATE