select
    first_login_date as FIRST_LOGIN
    , COUNT(member_code) as MEMBER_CNT 
from
    ( 
        select
            member_code
            , MIN(DATE (LOGIN_DATETIME)) as first_login_date 
        from
            ACCESS_LOG 
        group by
            MEMBER_CODE
    ) as sub 
where
    first_login_date between '2023-08-01' and '2023-08-31' 
group by
    first_login_date
ORDER BY
    FIRST_LOGIN_DATE DESC;