select
  FIRST_LOGIN_DATE AS FIRST_LOGIN
  , COUNT(MEMBER_CODE) AS MEMBER_CNT
from
  (
    select
      MEMBER_CODE
      , MIN(DATE(LOGIN_DATETIME)) AS FIRST_LOGIN_DATE
    from
      ACCESS_LOG
    group by
      MEMBER_CODE
  ) AS SUB
where
  FIRST_LOGIN_DATE BETWEEN '2023-08-01' AND '2023-08-31'
group by
  FIRST_LOGIN_DATE
order by
  FIRST_LOGIN_DATE DESC
;