数据库表的结构如下:
customer: custkey name comment
orders:orderkey custkey totalprice
求查询订单平均金额超过 25 万元的顾客中的中国籍顾客信息
代码如下:
SELECT *
FROM (SELECT *
FROM customer
WHERE name in(SELECT name FROM
(SELECT name,AVG(totalprice)
FROM customer join orders using(custkey) as a
GROUP BY name
HAVING AVG(totalprice)>250000)))
WHERE nationkey=40
结果报错,求问原因