SELECT
  FIRST_LOGIN
  , COUNT(MEMBER_CNT) 
FROM
  ( 
    SELECT
      DATE (DATETIME(LOGIN_DATETIME)) AS 'FIRST_LOGIN'
      , MEMBER_CODE AS 'MEMBER_CNT' 
    FROM
      ACCESS_LOG 
    WHERE
      LOGIN_DATETIME >= '2023-07-01' 
      AND LOGIN_DATETIME < '2023-09-01' 
    GROUP BY
      MEMBER_CODE 
    ORDER BY
      FIRST_LOGIN ASC
  ) 
WHERE
  FIRST_LOGIN >= '2023-08-01' 
  AND FIRST_LOGIN < '2023-09-01' 
GROUP BY
  FIRST_LOGIN 
ORDER BY
  FIRST_LOGIN DESC;