select strftime('%Y-%m-%d', date(LOGIN_DATETIME)) FIRST_LOGIN
     , count(*)  MEMBER_CNT

from ACCESS_LOG L
where LOGIN_DATETIME = (select min(LOGIN_DATETIME) from ACCESS_LOG where L.MEMBER_CODE = ACCESS_LOG.MEMBER_CODE)
and LOGIN_DATETIME between '2023-08-01' and '2023-09-00'
group by strftime('%Y-%m-%d', date(LOGIN_DATETIME))
order by 1 desc;