SELECT 
date(LOGIN_DATETIME) AS FIRST_LOGIN
-- ,MEMBER_CODE
,COUNT(MEMBER_CODE) AS MEMBER_CNT
FROM ACCESS_LOG
WHERE LOGIN_DATETIME >= '2023-08-01' 
  AND  LOGIN_DATETIME < '2023-09-01' 
GROUP BY date(FIRST_LOGIN)
ORDER BY FIRST_LOGIN desc;