SELECT SUBSTR(CONFIRMED_AT, 0, 11) AS REGIST_DATE,
    CASE STRFTIME('%w', SUBSTR(CONFIRMED_AT, 0, 11))
        WHEN '0' THEN '日'
        WHEN '1' THEN '月'
        WHEN '2' THEN '火'
        WHEN '3' THEN '水'
        WHEN '4' THEN '木'
        WHEN '5' THEN '金'
        WHEN '6' THEN '土'
        END AS WK,
    SUM(SUBSTR(CONFIRMED_AT, 0, 11)) AS TOTAL
FROM USERS
GROUP BY SUBSTR(CONFIRMED_AT, 0, 11)
HAVING SUBSTR(CONFIRMED_AT, 0, 8) = '2022-08' AND VALID_FLG = '1'