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