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