select 
	v.dt as REGIST_DATE,
	case
		when STRFTIME('%w' , dt) = '0' then '日'
		when STRFTIME('%w' , dt) = '1' then '月'
		when STRFTIME('%w' , dt) = '2' then '火'
		when STRFTIME('%w' , dt) = '3' then '水'
		when STRFTIME('%w' , dt) = '4' then '木'
		when STRFTIME('%w' , dt) = '5' then '金'
		when STRFTIME('%w' , dt) = '6' then '土'
	end as WK,
	COUNT(*) as TOTAL
from
(
	select 
		DATE(SUBSTR(USERS.CONFIRMED_AT, 0, 11)) as dt, 
		USERS.VALID_FLG
	from	
		USERS
	where
		CONFIRMED_AT between '2022-08-01 00:00:00' and '2022-08-31 23:59:59'
		and VALID_FLG = '1'

) V
group by 
	v.dt
order by 
	REGIST_DATE