SELECT 
    FIRST_LOGIN, 
    COUNT(*) AS MEMBER_CNT
FROM
    (
        SELECT 
            MEMBER_CODE,
            date(MIN(LOGIN_DATETIME)) AS FIRST_LOGIN
        FROM
            ACCESS_LOG
        WHERE
            LOGIN_DATETIME BETWEEN "2023-08-01" AND "2023-08-31 23:59:59"
        GROUP BY
            MEMBER_CODE
    )
GROUP BY
    FIRST_LOGIN
ORDER BY 
    FIRST_LOGIN DESC
;