select
   strftime('%Y-%m-%d', CONFIRMED_AT) as REGIST_DATE
   ,case
     when strftime('%w', CONFIRMED_AT) = '0' then '日'
     when strftime('%w', CONFIRMED_AT) = '1' then '月'
     when strftime('%w', CONFIRMED_AT) = '2' then '火'
     when strftime('%w', CONFIRMED_AT) = '3' then '水'
     when strftime('%w', CONFIRMED_AT) = '4' then '木'
     when strftime('%w', CONFIRMED_AT) = '5' then '金'
     when strftime('%w', CONFIRMED_AT) = '6' then '土'
   end as WK
   ,COUNT(*) as TOTAL
from
  USERS
where
  VALID_FLG = '1'
  and CONFIRMED_AT >= '2022-08-01 00:00:00' and CONFIRMED_AT < '2022-09-01 00:00:00'
group by strftime('%Y-%m-%d', CONFIRMED_AT)

order by REGIST_DATE