WITH FirstLoginDates AS (
    SELECT
        MEMBER_CODE,
        MIN(DATE(LOGIN_DATETIME)) AS FIRST_LOGIN
    FROM 
        ACCESS_LOG
    WHERE 
        LOGIN_DATETIME LIKE '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
;