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