SELECT MIN AS FIRST_LOGIN
,COUNT(*) AS MEMBER_CNT
FROM (
SELECT  MEMBER_CODE,MIN(DATE(LOGIN_DATETIME)) MIN FROM ACCESS_LOG
GROUP BY MEMBER_CODE
 )
WHERE MIN >date('2023-08-01')
AND MIN <date('2023-09-01')
GROUP BY MIN
order BY 1 DESC