SELECT
    date(CONFIRMED_AT) AS REGIST_DATE
    , substr('火水木金土日月', strftime("%w", 'now', 'localtime')+1, 1)  AS WK 
    , COUNT(USER_CODE) AS TOTAL
FROM
    USERS 
WHERE
    VALID_FLG='1' aND CONFIRMED_AT IS NOT NULL
    AND CONFIRMED_AT > "2022-07-31 23:59:59" AND CONFIRMED_AT < "2022-09-01 00:00:00"
GROUP BY date(CONFIRMED_AT)
ORDER BY
    REGIST_DATE ASC;