【单选题】有订单表Orders、客户表Custome,显示上海地区所有客户的详细信息,正确的SQL是()
A.
SELECT o.ID,c.Name,o.OrderDate,o.OrderAmount from Orders o right join Customer c on o.ID=c.CustomerID where c.address='上海'
B.
SELECT o.ID,c.Name,o.OrderDate,o.OrderAmount from Orders o join Customer c where c.address='上海' on o.ID=c.CustomerID
C.
SELECT o.ID,c.Name,o.OrderDate,o.OrderAmount from Orders o inner join Customer c on o.ID=c.CustomerID and c.address='上海'
D.
SELECT o.ID,c.Name,o.OrderDate,o.OrderAmount from Orders o where c.Address='上海' join Customer c on o.ID=c.CustomerID
【单选题】有订单表Orders,它们的数据如下图所示。按天计算每个客户的订单总额,正确的是()
A.
SELECT ID, OrderDate , Count(OrderAmount) from Orders Group by ID, OrderDate
B.
SELECT ID, OrderDate , sum(OrderAmount) from Orders Group by ID, OrderDate
C.
SELECT ID, sum(OrderAmount) from Orders Group by OrderDate
D.
SELECT OrderDate , ID, SUM(OrderAmount) from Orders Group by ID
【单选题】请从订单表中取得数据,其中包括三个列客户名、订单时间与订单费用。可以用下列哪个where子句查询ORDERS表,取得客户A超过2700的订单?
B.
where 客户名=‘A’and 订单费用<2700;
C.
where 客户名=‘A’or 订单费用>2700;
D.
where 客户名=‘A’and 订单费用>2700;
【单选题】假设从订单表中取得数据,包括三个列:客户名、订单时间与订单费用。可以用下列哪个 where 子句查询 ORDERS 表,取得客户 A 超过 2700 的订单 ( )。
B.
where 客户名= ‘A’ and 订单费用 < 2700;
C.
where 客户名= ‘A’ or 订单费用 > 2700;
D.
where 客户名= ‘A’ and 订单费用 > 2700;
【简答题】随着网络的增大与网络服务功能的增多,计算机网络主要向(__)化、(__)化和(__)化方向发展。
【单选题】请从订单表中取得数据,包括三个列:客户名、订单时间与订单费用。可以用下列哪个 where 子句查询 ORDERS 表,取得客户 A 超过 2700 的订单
B.
where 客户名='A' and 订单费用<2700;
C.
where 客户名='A' or 订单费用>2700;
D.
where 客户名='A' and 订单费用>2700;
【单选题】有订单表Orders,它的数据如下图所示。列出客户订单总金额大于3000的数据,正确的是()
A.
SELECT ID,SUM(OrderAmount) FROM ORDERS group by ID having sum(OrderAmount)>3000
B.
SELECT ID,SUM(OrderAmount) FROM ORDERS where sum(OrderAmount)>3000 group by ID
C.
SELECT ID,SUM(OrderAmount) FROM ORDERS where sum(OrderAmount)>3000
D.
SELECT ID,SUM(OrderAmount) FROM ORDERS group by ID where sum(OrderAmount)>3000