select CONFIRMED_AT as REGIST_DATE, count(*)
from USERS 
where CONFIRMED_AT between '2022-08-01' and '2022-08-31' and VALID_FLG = '1'
group by CONFIRMED_AT
order by REGIST_DATE;