WITH
  FirstLoginDates AS (
    SELECT
      MEMBER_CODE
    , MIN(DATE (LOGIN_DATETIME)) AS FIRST_LOGIN
    FROM
      ACCESS_LOG
    WHERE
      LOGIN_DATETIME >= '2023-08-01'
      AND LOGIN_DATETIME < '2023-09-01'
    GROUP BY
      MEMBER_CODE
  )
SELECT
  FIRST_LOGIN
, COUNT(MEMBER_CODE) AS MEMBER_CNT
FROM
  FirstLoginDates
GROUP BY
  FIRST_LOGIN
ORDER BY
  FIRST_LOGIN DESC;