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