select
STRFTIME('%Y/%m/%d',LOGIN_DATETIME) as FIRST_LOGIN
,count(*) as MEMBER_CNT
from
ACCESS_LOG
where
LOGIN_DATETIME between '2023-08-01 00:00:00' and '2023-08-31 23:59:59'
group by STRFTIME('%Y/%m/%d',LOGIN_DATETIME)
order by FIRST_LOGIN desc;