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