SELECT
  LOGIN_DATE AS 'FIRST_LOGIN'
 ,COUNT(MC) AS 'MEMBER_CNT'
FROM (
  SELECT DISTINCT 
   MEMBER_CODE AS MC
   ,DATE(LOGIN_DATETIME) AS LOGIN_DATE
  FROM ACCESS_LOG
  WHERE LOGIN_DATETIME > '2023-07-31 23:59:59' and LOGIN_DATETIME < '2023-09-01'
  and ACCESS_ID in (
    SELECT ACCESS_ID
    FROM ACCESS_LOG
    WHERE
      MEMBER_CODE = MC and
      LOGIN_DATETIME > '2023-07-31 23:59:59' and LOGIN_DATETIME < '2023-09-01'
    ORDER BY ACCESS_ID ASC
    LIMIT 1
  )
)
GROUP BY LOGIN_DATE
ORDER BY LOGIN_DATE DESC