17,377
社区成员
发帖
与我相关
我的任务
分享
SELECT Customer,SUM(OrderPrice) FROM Orders
GROUP BY Customer
HAVING SUM(OrderPrice)<2000
-- 这样?
select customer, sum(orderprice), count(customer)"组内数量" from orders group by customer having sum(orderprice) < 2000;