SELECT
  LOGIN_DATE AS 'FIRST_LOGIN'
 ,COUNT(MEMBER_CODE) AS 'MEMBER_CNT'
FROM (
  SELECT DISTINCT DATE(LOGIN_DATETIME) AS LOGIN_DATE, MEMBER_CODE FROM ACCESS_LOG WHERE LOGIN_DATETIME > '2023-07-31' and LOGIN_DATETIME < '2023-09-01'
) AS A
GROUP BY LOGIN_DATE
ORDER BY LOGIN_DATE DESC