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