SELECT
  LOGIN_DATETIME AS FIRST_LOGIN,
  COUNT(*)
FROM
(SELECT
  MEMBER_CODE,
  DATE(MIN(LOGIN_DATETIME)) AS LOGIN_DATETIME
FROM
  ACCESS_LOG AS AL
WHERE
 LOGIN_DATETIME BETWEEN '2023-08-01' AND '2023-09-01'
GROUP BY 
  MEMBER_CODE) AS DATA
GROUP BY LOGIN_DATETIME
ORDER BY LOGIN_DATETIME DESC