select
  LOGIN_DATE as FIRST_LOGIN,
  COUNT(MEMBER_CODE) as MEMBER_CNT
from
  (select DATE(MIN(LOGIN_DATETIME)) as LOGIN_DATE, MEMBER_CODE from ACCESS_LOG group by MEMBER_CODE)
where
  LOGIN_DATE between '2023-08-01' and '2023-08-31'
group by
  LOGIN_DATE
order by
  FIRST_LOGIN desc
;