-- Create a view that returns the total qty
-- for each employee and year
-- Tables involved: Sales.Orders and Sales.OrderDetails
--创建一个视图,返回每个雇员每年处理的总订货量。
--涉及的表Sales.Orders and Sales.OrderDetails
-- 运行以下查询时:
-- SELECT * FROM Sales.VEmpOrders ORDER BY empid, orderyear
--期望的输出:
empid orderyear qty
----------- ----------- -----------
1 2006 1620
1 2007 3877
1 2008 2315
2 2006 1085
2 2007 2604
2 2008 2366
3 2006 940
3 2007 4436
3 2008 2476
4 2006 2212
4 2007 5273
4 2008 2313
5 2006 778
5 2007 1471
5 2008 787
6 2006 963
6 2007 1738
6 2008 826
7 2006 485
7 2007 2292
7 2008 1877
8 2006 923
8 2007 2843
8 2008 2147
9 2006 575
9 2007 955
9 2008 1140
(27 row(s) affected)
写成程序下.谢谢.万分感谢.在线等.人穷.也就这点金币了
收起