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