SELECT 
    DATE(LOGIN_DATETIME) AS 'FIRST_LOGIN',
    count(*) AS 'MEMBER_CNT'
  FROM ACCESS_LOG
　WHERE LOGIN_DATETIME >= '2023/08/01 00:00:00' AND
　      LOGIN_DATETIME <= '2023/08/31 23:59:59'
  GROUP BY MEMBER_CODE
  ORDER BY 
	LOGIN_DATETIME DESC;