SQLite的子查询语法错误附近“（”

Question

所以我想在我的数据库中执行此查询：

select 
    count(*) 
from (select 
     userID 
     from users 
     where rating> 1000 
     except (select 
        userID 
       from users 
       where rating > 1000 
        except select sellerID from auctions)); 

而且正在此错误： “错误：近线1：近‘（’：语法错误”

任何帮助表示赞赏

Answer 1

如何使用这个代替？这是逻辑等价？

SELECT COUNT(*) FROM Users 
WHERE Rating > 1000 
AND UserID NOT IN (SELECT SellerID FROM Auctions)