WITH
  SUB AS (
    SELECT
      MEMBER_CODE,
      MIN(strftime ('%Y-%m-%d', LOGIN_DATETIME)) AS FIRST_LOGIN
    FROM
      ACCESS_LOG
    GROUP BY
      MEMBER_CODE
  )
SELECT
  FIRST_LOGIN,
  COUNT(MEMBER_CODE) AS MEMBER_CNT
FROM
  SUB
WHERE
  FIRST_LOGIN >= "2023-08-01"
  AND FIRST_LOGIN < "2023-09-01"
GROUP BY
  FIRST_LOGIN
ORDER BY
  FIRST_LOGIN desc;