SELECT
     DATE (LOGIN_DATETIME)       AS FIRST_LOGIN
   , COUNT(DISTINCT MEMBER_CODE) AS MEMBER_CNT 
FROM
   ACCESS_LOG 
WHERE
   FIRST_LOGIN BETWEEN '2023-08-01 00:00:00' AND '2023-08-31 23:59:59' 
GROUP BY
   FIRST_LOGIN 
ORDER BY
   FIRST_LOGIN DESC