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
GROUP BY MEMBER_CODE
)T1
WHERE LOGIN_DATETIME BETWEEN '2023-08-01' AND '2023-08-31'
GROUP BY T1.LOGIN_DATETIME
ORDER BY FIRST_LOGIN DESC
;