WITH FirstLoginDates AS (
    SELECT
        MEMBER_CODE,
        MIN(DATE(LOGIN_DATETIME)) AS FIRST_LOGIN
    FROM 
        ACCESS_LOG
    GROUP BY 
        MEMBER_CODE
)

SELECT
    FIRST_LOGIN,
    COUNT(DISTINCT MEMBER_CODE) AS MEMBER_CNT
FROM 
    FirstLoginDates
WHERE 
    FIRST_LOGIN LIKE '2023-08%'
GROUP BY 
    FIRST_LOGIN
ORDER BY 
    FIRST_LOGIN DESC
;