WITH firstlogin AS (
    SELECT
        MEMBER_CODE,
        MIN(LOGIN_DATETIME) FL
    FROM
        ACCESS_LOG
    GROUP BY
        MEMBER_CODE
)
SELECT
    DATE(FL) FIRST_LOGIN,
    COUNT(*) MEMBER_CNT
FROM
    firstlogin
WHERE
    FIRST_LOGIN BETWEEN '2023-08-01'
    AND '2023-08-31'
GROUP BY
    FIRST_LOGIN
ORDER BY
    FIRST_LOGIN DESC