select day as REGIST_DATE
	,case
		when strftime('%w', day) = '0' then '日'
		when strftime('%w', day) = '1' then '月'
		when strftime('%w', day) = '2' then '火'
		when strftime('%w', day) = '3' then '水'
		when strftime('%w', day) = '4' then '木'
		when strftime('%w', day) = '5' then '金'
		when strftime('%w', day) = '6' then '土'
	 end as WK
	,count(USER_CODE) as TOTAL
from 
	(select '2022-08-01' as day UNION
	select '2022-08-02' UNION
	select '2022-08-03' UNION
	select '2022-08-04' UNION
	select '2022-08-05' UNION
	select '2022-08-06' UNION
	select '2022-08-07' UNION
	select '2022-08-08' UNION
	select '2022-08-09' UNION
	select '2022-08-10' UNION
	select '2022-08-11' UNION
	select '2022-08-12' UNION
	select '2022-08-13' UNION
	select '2022-08-14' UNION
	select '2022-08-15' UNION
	select '2022-08-16' UNION
	select '2022-08-17' UNION
	select '2022-08-18' UNION
	select '2022-08-19' UNION
	select '2022-08-20' UNION
	select '2022-08-21' UNION
	select '2022-08-22' UNION
	select '2022-08-23' UNION
	select '2022-08-24' UNION
	select '2022-08-25' UNION
	select '2022-08-26' UNION
	select '2022-08-27' UNION
	select '2022-08-28' UNION
	select '2022-08-29' UNION
	select '2022-08-30' UNION
	select '2022-08-31')  month_8
	left outer join USERS
	on day = strftime('%Y-%m-%d', CONFIRMED_AT)
    and VALID_FLG='1'
where REGIST_DATE between '2022-08-01' and '2022-08-31'
group by REGIST_DATE