SELECT DATE(LOGIN_DATETIME) AS FIRST_LOGIN
     , COUNT(*) AS MEMBER_CNT
  FROM ACCESS_LOG
 WHERE (MEMBER_CODE, LOGIN_DATETIME) IN (
         SELECT MEMBER_CODE
             , MIN(LOGIN_DATETIME)
          FROM ACCESS_LOG
         WHERE DATE(LOGIN_DATETIME) BETWEEN DATE('2023-08-01') AND DATE('2023-08-31')
        GROUP BY MEMBER_CODE
        )
GROUP BY DATE(LOGIN_DATETIME)
ORDER BY FIRST_LOGIN DESC
;