with tmp as 
(
  select 
    member_code 
    ,date(min(login_datetime)) as first_login_date
  from access_log 
  group by 1 
  having first_login_date >= '2023-08-01'
    and first_login_date < '2023-09-01'
)
select 
  first_login_date as FIRST_LOGIN 
  ,count(0) as MEMBER_CNT 
from tmp 
group by 1
order by FIRST_LOGIN desc 
;