Use adventureworks ; go select productid from sales . salesorderdetail group by productid having avg orderqty 5 order by productid ; go 表中的行生成组，并消除那些未以
2.
Statement . it produces groups and summary values but does so after eliminating the products with prices over 25 and average order quantities under 5 该语句生成组和汇总值（但是组和汇总值是在消除价格超过$ 25且平均订单数量低于5的产品之后得出的） 。
