WITH FirstLoginDates AS (
    SELECT 
        MEMBER_CODE,
        strftime('%Y-%m-%d', MIN(LOGIN_DATETIME)) AS FIRST_LOGIN
    FROM ACCESS_LOG
    WHERE strftime('%Y-%m', LOGIN_DATETIME) = '2023-08'
    GROUP BY MEMBER_CODE
)
SELECT 
    FIRST_LOGIN,
    COUNT(MEMBER_CODE) AS MEMBER_CNT
FROM FirstLoginDates
GROUP BY FIRST_LOGIN
ORDER BY FIRST_LOGIN DESC;