SELECT 
    FIRST_LOGIN_TIME AS FIRST_LOGIN
    , COUNT(DISTINCT MEMBER_CODE) AS MEMBER_CNT
FROM
    (
        SELECT 
            MIN(DATE(LOGIN_DATETIME)) AS FIRST_LOGIN_TIME
            , MEMBER_CODE
        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;