SQLServer选择题答案

.

分析上述两个表，回答下列问题。

1.计算每个客户的订单总额，正确的SQL是（）

A.SELECT_ID,COUNT(OrderAmount)FROM Orders GROUP BY C_ID B.SELECT_ID,SUM(OrderAmount)FROM Orders GROUP BY C_ID C.SELECT_ID,SUM(OrderAmount)FROMOrders D.SELECT

D.SELECT OrderDate,C_ID,SUM(OrderAmount)FROM Order GROUP BY C_ID

2.按天计算每个客户的订单总金额，正确的SQL是（） A.SELECT_ID,COUNT(OrderPrice)FROM C_ID,OrederDate

B.SELECT_ID,SUM(OrderPrice)FROM Orders GROUP BY OrderDate, C_ID

C.SELECT_ID,SUM(OrderPrice)FROM Orders GROUP BY OrderDate D.SELECT_ID,SUM(OrderAmount)FROM Orders GROUP BY C_ID,C_ID 3.列出客户订单总金额大于3000的数据，正确的SQL是（） A.SELECT C_ID ,SUM(OrderAmount)FROM Orders GROUP BY C_ID HAVVING SUM(OrderAmount)>3000

B.SELECT C_ID ,SUM(OrderAmount) FROM Orders WHERE SUM (OrderAmoount)>3000 GROUP BY C_ID

C.SELECT C_ID ,SUM(OrderAmount) FROM Orders WHERE SUM (OrderAmoount)>3000

.

Orders GROUP BY

.

D.SELECT C_ID ,SUM(OrderAmount)FROM Orders GROUP BY C_ID WHERE SUM(OrderAmount)>3000

4.按天计算客户“张震东”的订单总金额，正确的SQL是（） A. SELECT SUM (OrderAmount) FROM Orders o JOIN Customer c ON o.c_Id=c.CustomerID WHERE c.Name=’张震东’ GROUP BY CustomerID B. SELECT SUM (OrderAmount) FROM Orders o JOIN Customer c ON o.c_Id=c.CustomerID WHERE c.Name=’张震东’ GROUP BY OrderDate C. SELECT SUM (OrderAmount) FROM Orders o INNER JOIN Customer c ON o.c_Id=c.CustomerIDWHERE c.Name=’张震东’ GROUP BY D. SELECT SUM (OrderAmount) FROM Orders o JOIN Customer c WHERE c.Name=’张震东’ GROUP BY ON o.c_Id=c.CustomerID GROUP BY OrderDate

5.显示上海地区客户的详细信息，正确的SQL是（）

A.SELECT o.C_Id,c.Name,o.OrderDate,o.OrderAmount FROM Orders o JOIN Customer c ON o.C_Id=c.CustomerID WHERE c.Address=’上海’

B.SELECT o.C_Id,c.Name,o.OrderDate,o.OrderAmount FROM Orders o JOIN Customer c WHERE c.Address=’上海’ ON o.C_Id=c.CustomerID C.SELECT o.C_Id,c.Name,o.OrderDate,o.OrderAmount FROM Orders o JNNER JOIN Customer c ON o.C_Id=c.CustomerID AND c.Address=’上海’

D.SELECT o.C_Id,c.Name,o.OrderDate,o.OrderAmount FROM Orders

.

.

o WHERE c.Address=’上海’JOIN Customer c ON o.C_Id=c.CustomerID

单纯的课本内容，并不能满足学生的需要，通过补充，达到内容的完善 教育之通病是教用脑的人不用手，不教用手的人用脑，所以一无所能。教育革命的对策是手脑联盟，结果是手与脑的力量都可以大到不可思议。

.