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