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