WITH tmp as
        (SELECT
        date(min(LOGIN_DATETIME)) AS FIRST_LOGIN,
        MEMBER_CODE
        FROM ACCESS_LOG
        where LOGIN_DATETIME between '2023-08-01 00:00:00' and '2023-08-31 23:59:59'
        group by MEMBER_CODE)
        
     
        SELECT 
        FIRST_LOGIN,
        count(*) as MEMBER_CNT
        from tmp
        group by FIRST_LOGIN
        order by FIRST_LOGIN desc;