SELECT 
 date(LOGIN_DATETIME)AS FIRST_LOGIN,
 COUNT(DISTINCT MEMBER_CODE) AS MEMBER_COUNT
FROM ACCESS_LOG
WHERE LOGIN_DATETIME  BETWEEN '2023-08-01 00:00:00' and '2023-08-31 23:59:59'
GROUP BY FIRST_LOGIN
HAVING MIN(LOGIN_DATETIME)
ORDER BY FIRST_LOGIN DESC;