WITH FIRST_LOGIN AS (
    SELECT
        MEMBER_CODE AS CODE,
        SUBSTR(MIN(LOGIN_DATETIME), 0, INSTR(MIN(LOGIN_DATETIME), " ")) AS FIRST_LOGIN_DATE
    FROM
        ACCESS_LOG
    GROUP BY
        MEMBER_CODE
)

SELECT
    FIRST_LOGIN_DATE AS FIRST_LOGIN,
    COUNT(*) AS MEMBER_CNT
FROM
    FIRST_LOGIN
WHERE
    FIRST_LOGIN_DATE BETWEEN '2023-08-01' AND '2023-08-31'
GROUP BY
    FIRST_LOGIN_DATE
ORDER BY
    FIRST_LOGIN DESC;