SELECT 
    FIRST_LOGIN_TIME AS FIRST_LOGIN,
    COUNT(DISTINCT MEMBER_CODE) AS MEMBER_CNT
FROM
    (
        SELECT 
            DATE(LOGIN_DATETIME) AS FIRST_LOGIN_TIME,
            MEMBER_CODE
        FROM
            ACCESS_LOG
        WHERE
            LOGIN_DATETIME >= '2023-08-01' AND LOGIN_DATETIME < '2023-09-01'
        GROUP BY
            MEMBER_CODE, DATE(LOGIN_DATETIME)
    )
GROUP BY
    FIRST_LOGIN
ORDER BY
    FIRST_LOGIN DESC;