select
strftime('%Y-%m-%d', confirmed_at) as "REGIST_DATE",
substr('日月火水木金土', strftime('%w', confirmed_at) + 1, 1) as "WK",
count(*) as "TOTAL"
from
users
where
valid_flg = '1'
and 
confirmed_at between '2022-08-01' and '2022-08-31'
group by
strftime('%Y-%m-%d', confirmed_at), substr('日月火水木金土', strftime('%w', confirmed_at) + 1, 1)
order by
confirmed_at