WITH ACCESS_LOG_BY_DATE AS
(
  SELECT
    MEMBER_CODE,
    SUBSTR(MIN(LOGIN_DATETIME), 1, 10) AS FIRST_LOGIN
  FROM
    ACCESS_LOG
  WHERE
    LOGIN_DATETIME BETWEEN '2023-08-01 00:00:00' AND '2023-08-31 23:59:59'
  GROUP BY
    MEMBER_CODE
)
SELECT
  MIN(FIRST_LOGIN) AS FIRST_LOGIN,
  COUNT(MEMBER_CODE) AS MEMBER_CNT
FROM
  ACCESS_LOG_BY_DATE
GROUP BY
  FIRST_LOGIN
ORDER BY
  FIRST_LOGIN DESC