SELECT
    LOGIN_DATETIME AS FIRST_LOGIN
    ,COUNT(MEMBER_CODE) AS MEMBER_CNT
FROM 
(SELECT
	DATE(MIN(LOGIN_DATETIME)) AS LOGIN_DATETIME
	,MEMBER_CODE
FROM ACCESS_LOG
WHERE LOGIN_DATETIME BETWEEN '2023-08-01 00:00:00' AND '2023-08-31 23:59:59'
GROUP BY MEMBER_CODE
)T1
GROUP BY T1.LOGIN_DATETIME
ORDER BY FIRST_LOGIN DESC
;