SELECT
    LOGIN_DATE  AS FIRST_LOGIN
    ,COUNT(MEMBER_CODE)  AS MEMBER_CNT

FROM
(
    SELECT 
         MEMBER_CODE
        ,MIN(substr(LOGIN_DATETIME, 1, 10)) as LOGIN_DATE
    
    FROM
        ACCESS_LOG
    
    WHERE
        LOGIN_DATETIME BETWEEN '2023-08-01' and '2023-09-01' 
    GROUP BY 
        MEMBER_CODE
) LOG_cnt

GROUP BY LOGIN_DATE

ORDER BY FIRST_LOGIN DESC