SELECT
    DAY AS FIRST_LOGIN,
    COUNT(MEMBER_CODE) AS MEMBER_CNT
FROM
    (SELECT
        MEMBER_CODE,
        MIN(DATE(LOGIN_DATETIME)) AS DAY
    FROM
        ACCESS_LOG
    GROUP BY
        MEMBER_CODE
    HAVING
        LOGIN_DATETIME BETWEEN '2023-08-01' AND '2023-08-31'
    )
GROUP BY
    DAY
ORDER BY
    FIRST_LOGIN DESC
;