麻烦大神帮忙看一下

WITH company_top3 AS（
SELECT c.CompanyName c_name,c.CustomerID c_id,
SUM(od.UnitPrice*od.Quantity*(1-Discount)) sum_cus
FROM OrderDetails od
JOIN Orders o
ON o.OrderId = od.OrderId
JOIN Customers c
ON c.CustomerID = o.CustomerID
GROUP BY 1,2
ORDER BY 3 DESC
LIMIT 3）,
SELECT c.CompanyName c_name,c.CustomerID c_id,
p.ProductName,od.UnitPrice,od.Quantity
FROM OrderDetails od
JOIN Orders o
ON o.OrderId = od.OrderId
JOIN Customers c
ON c.CustomerID = o.CustomerID
JOIN Products p
ON p.ProductID = od.ProductID
HAVING c.CustomerID = company_top3.c_id

在with前加个;试试

而且在cte第一个括号后不需要加，