发布网友 发布时间:2024-10-01 21:48
共2个回答
热心网友 时间:2024-11-08 10:40
select buy.cust_no,SUM(amount) from buy join customer c on buy.cust_no=c.cust_no group by buy.cust_no having SUM(amount)>=100热心网友 时间:2024-11-08 10:32
where SUM(amount)>=100改为having SUM(amount)>=100