select
  t.LOGIN_DATETIME as "FIRST_LOGIN"
 ,count(t.MEMBER_CODE) as "MEMBER_CNT"
from
(
 select
   date(datetime(LOGIN_DATETIME)) as "LOGIN_DATETIME"
  ,MEMBER_CODE
 from 
  ACCESS_LOG
 group by
  MEMBER_CODE
 having
  min(datetime(LOGIN_DATETIME))
) t
where
 t.LOGIN_DATETIME between date('2023-08-01') and date('2023-08-31')
group by
 t.LOGIN_DATETIME
order by
 "FIRST_LOGIN" desc
;