select
    strftime('%Y-%m-%d', CONFIRMED_AT) as REGIST_DATE
    ,substr('日月火水木金土', strftime("%w", CONFIRMED_AT, 'localtime')+1, 1) as WK
    ,count(*) as TOTAL
from
    USERS
where 
    VALID_FLG='1'
and
    strftime('%Y-%m', CONFIRMED_AT) = '2022-08'
group by 
    strftime('%Y-%m-%d', CONFIRMED_AT)
order by
   REGIST_DATE