select
    fl as FIRST_LOGIN,
    count(MEMBER_CODE) as MEMBER_CNT
from    (select
            MEMBER_CODE,
            min(date(LOGIN_DATETIME)) as fl
        from ACCESS_LOG
        group by
            MEMBER_CODE
        )
where 
    FIRST_LOGIN between '2023-08-01' and '2023-08-31'
group by
    FIRST_LOGIN
order by
    FIRST_LOGIN desc;