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