SELECT
     LOGIN_DATE AS FIRST_LOGIN
    ,COUNT(MEMBER_CODE) AS  MEMBER_CNT

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

group by LOGIN_DATE

ORDER BY FIRST_LOGIN DESC