select  substr(LOGIN_DATETIME,1,10) as FIRST_LOGIN,
        sum(MEMBER_CODE) as MEMBER_CNT
from    ACCESS_LOG
where   FIRST_LOGIN > '2023-07-31' and FIRST_LOGIN < '2023-09-01'
group by FIRST_LOGIN
order by FIRST_LOGIN desc;