select strftime('%Y%m%d', CONFIRMED_AT) as REGIST_DATE
from USERS
where CREATED_AT >= "2022-08-00"
and CREATED_AT <= "2022-09-00"
and VALID_FLG = 1

group by strftime('%Y%m%d', CONFIRMED_AT)
;