WITH
  SUB AS (
    SELECT
      MEMBER_CODE,
      MIN(strftime ('%Y-%m-%d', 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
  SUB
GROUP BY
  FIRST_LOGIN
ORDER BY
  FIRST_LOGIN desc;