select 
    FIRST_LOGIN
    , count(MEMBER_CODE) AS MEMBER_CNT
from 
    (
    select 
        MEMBER_CODE
        , MIN(DATE(LOGIN_DATETIME)) AS FIRST_LOGIN
    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;