select SUBSTR(CONFIRMED_AT,1,10) as REGIST_DATE,
       substr('日月火水木金土', strftime("%w",SUBSTR(CONFIRMED_AT,1,10))+1, 1) as WK,
       count(USER_CODE or null) as TOTAL
from USERS 
where SUBSTR(CONFIRMED_AT,1,7) = '2022-08'
and VALID_FLG = '1' 
group by SUBSTR(CONFIRMED_AT,1,10)
order by REGIST_DATE asc