SELECT 
date(a2.LOGIN_DATETIME) AS FIRST_LOGIN
-- ,a1.MEMBER_CODE
,COUNT(a1.MEMBER_CODE) AS MEMBER_CNT
FROM ACCESS_LOG as a1
INNER JOIN (SELECT MIN(LOGIN_DATETIME) AS LOGIN_DATETIME,MEMBER_CODE FROM ACCESS_LOG WHERE   LOGIN_DATETIME >= '2023-08-01'   AND  LOGIN_DATETIME < '2023-09-01' GROUP BY MEMBER_CODE) as a2
  ON a1.MEMBER_CODE = a2.MEMBER_CODE AND a1.LOGIN_DATETIME = a2.LOGIN_DATETIME
WHERE a1.LOGIN_DATETIME >= '2023-08-01' 
  AND  a1.LOGIN_DATETIME < '2023-09-01' 
GROUP BY date(FIRST_LOGIN)


ORDER BY FIRST_LOGIN desc;