select
    strftime('%Y-%m-%d',login_datetime) as FIRST_LOGIN,
    COUNT(member_code) as MEMBER_CNT
from
    access_log
where
    login_datetime between '2023-08-01' and '2023-09-01'
group by
    FIRST_LOGIN
order by
    FIRST_LOGIN desc
;