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 ,
    COUNT(*) AS TOTAL
FROM
    USERS
WHERE
    CONFIRMED_AT LIKE '2022-08_%' AND
    VALID_FLG = '1'
GROUP BY REGIST_DATE
ORDER BY REGIST_DATE