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