SELECT FIRST_LOGIN AS FIRST_LOGIN,
       COUNT(*) AS MEMBER_CNT
  FROM (SELECT MEMBER_CODE,
               MIN(DATE(LOGIN_DATETIME)) AS FIRST_LOGIN
          FROM ACCESS_LOG
         GROUP BY MEMBER_CODE
         HAVING MIN(DATE(LOGIN_DATETIME)) BETWEEN '2023-08-01' AND '2023-08-31'
       )
 GROUP BY FIRST_LOGIN
 ORDER BY FIRST_LOGIN DESC