select  distinct
        substr(LOGIN_DATETIME,1,10) as FIRST_LOGIN,
        count(distinct(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;