select 
    c_date as REGIST_DATE,
    case strftime('%w', c_date)
        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(1) as TOTAL
from
    (
        select DATE(CONFIRMED_AT) as c_date
        from USERS
        where CONFIRMED_AT like '2022-08%'
    )
group by c_date
;