SELECT
　CAST(LOGIN_DATETIME AS DATE) AS FIRST_LOGIN,
　COUNT(MEMBER_CODE) AS MEMBER_CNT

FROM
 (SELECT
   MAMBER_CODE,
   MIN(DATE(LOGIN_DATETIME)) AS FIRST_LOGIN_DATE 
  FROM
   ACCESS_LOG
  GROUP BY
   MEMBER_CODE
 ) AS SUB

WHERE 
 LOGIN_DATETIME BETWEEN '2023-08-01' AND '2023-08-31'

GROUP BY  
 FIRST_LOGIN_DATE

ORDER BY 
 FIRST_LOGIN_DATEb DESC;