SELECT
    FIRST_LOGIN
    ,COUNT(MEMBER_CODE)  AS MEMBER_CNT
FROM
(
    SELECT 
         MEMBER_CODE
        ,MIN(substr(LOGIN_DATETIME, 1, 10)) as FIRST_LOGIN
    
    FROM
        ACCESS_LOG
    
    WHERE
        LOGIN_DATETIME BETWEEN '2023-08-01' and '2023-09-01' 
    GROUP BY 
        MEMBER_CODE
) ACCESS_LOG
GROUP BY FIRST_LOGIN
ORDER BY FIRST_LOGIN DESC