with wk as(select
    MEMBER_CODE,DATE(LOGIN_DATETIME) as FIRST_LOGIN
from ACCESS_LOG
where FIRST_LOGIN BETWEEN '2023-08-01 00:00:00' AND '2023-08-31 23:59:59')
select 
    FIRST_LOGIN
    ,count(FIRST_LOGIN) as MEMBER_CNT
from wk
group by FIRST_LOGIN
order by FIRST_LOGIN desc;