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