select date(CONFIRMED_AT) as REGIST_DATE
,substr('日月火水木金土', strftime("%w", date(CONFIRMED_AT), 'localtime')+1, 1) as WK
,count(1) as TOTAL
from USERS 
where CONFIRMED_AT >= '2022-08-01' 
and CONFIRMED_AT <= '2022-08-31'  
and VALID_FLG = '1'
group by date(CONFIRMED_AT)
order by CONFIRMED_AT
--0件の日を表示する処理を各時間が無かった。無念