select substr(CONFIRMED_AT,1,10) as REGIST_DATE
--,trftime("%w", test_date) as weeknumber
 , substr('日月火水木金土', strftime("%w", substr(CONFIRMED_AT,1,10)) + 1, 1) as WK
,count(substr(CONFIRMED_AT,1,10)) as TOTAL
from USERS
where CONFIRMED_AT like '2022-08%'
and valid_flg = '1'
group by substr(CONFIRMED_AT,1,10)
order by CONFIRMED_AT