SELECT
	T.FIRST_LOGIN,
	COUNT(DISTINCT T.MEMBER_CODE) AS MEMBER_CNT 
FROM
(   
    SELECT
    date(LOGIN_DATETIME) AS FIRST_LOGIN,
    MEMBER_CODE 
    FROM ACCESS_LOG
    GROUP BY FIRST_LOGIN,MEMBER_CODE
) AS T
WHERE T.FIRST_LOGIN  BETWEEN '2023-08-01' and '2023-08-31'
GROUP BY T.FIRST_LOGIN
ORDER BY T.FIRST_LOGIN DESC;