with tmp AS(
select user_code, DATE(SUBSTRING(CONFIRMED_AT,1,10)) as REGIST_DATE from users where valid_flg='1'
)
select REGIST_DATE, count(*) from tmp where REGIST_DATE between '2022-08-01' AND '2022-08-31' group by REGIST_DATE