SELECT DATE(LOGIN_DATETIME) AS FIRST_LOGIN,COUNT(MEMBER_CODE) 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 FIRST_LOGIN
ORDER BY FIRST_LOGIN DESC