WITH temp AS (
    SELECT 
        MEMBER_CODE,
        MIN(SUBSTR(LOGIN_DATETIME,1,10)) AS FIRST_LOGIN
    FROM
        ACCESS_LOG
    WHERE
        LOGIN_DATETIME BETWEEN '2023-08-01 00:00:00' AND '2023-08-31 23:59:59'
    GROUP BY
        MEMBER_CODE
)

SELECT
    FIRST_LOGIN,
    COUNT(MEMBER_CODE) AS MEMBER_CNT
FROM
    temp
GROUP BY
    FIRST_LOGIN
ORDER BY
    FIRST_LOGIN DESC