皮皮学，免费搜题
登录
搜题
【简答题】
阅读下面的短文，然后将划线部分的句子译成汉语或英语。 Do you know Greenwood Park? 小题1:. It is the best place to go on weekends. I always finish my breakfast quickly on Saturdays. 小题2:. 因为我想去那里跟朋友见面。小题3:. The park is a crowded place on weekend. Because almost everyone goes there to see the street performers. 小题4:. 有些人认为他们很无聊。But I think they are creative people. However, the place where you can enjoy your time quietly is at one of the small coffee shops near the park. 小题5:. 你可以在那里阅读或放松。There is something for everyone at Greenwood Park.
拍照语音搜题，微信中搜索"皮皮学"使用
参考答案：
参考解析：
知识点：
皮皮学刷刷变学霸
举一反三
【单选题】有订单表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的订单?
A.
where 客户名=‘A’;
B.
where 客户名=‘A’and 订单费用<2700;< /div>
C.
where 客户名=‘A’or 订单费用>2700;
D.
where 客户名=‘A’and 订单费用>2700;
【单选题】假设从订单表中取得数据,包括三个列:客户名、订单时间与订单费用。可以用下列哪个 where 子句查询 ORDERS 表,取得客户 A 超过 2700 的订单 ( )。
A.
here 客户名= ‘A’;
B.
where 客户名= ‘A’ and 订单费用 < 2700;
C.
where 客户名= ‘A’ or 订单费用 > 2700;
D.
where 客户名= ‘A’ and 订单费用 > 2700;
【简答题】随着网络的增大与网络服务功能的增多,计算机网络主要向(__)化、(__)化和(__)化方向发展。
【单选题】请从订单表中取得数据,包括三个列:客户名、订单时间与订单费用。可以用下列哪个 where 子句查询 ORDERS 表,取得客户 A 超过 2700 的订单
A.
where 客户名='A'
B.
where 客户名='A' and 订单费用<2700;< /div>
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
相关题目：
【单选题】请从订单表中取得数据,其中包括三个列客户名、订单时间与订单费用。可以用下列哪个where子句查询ORDERS表,取得客户A超过2700的订单?
A.
where 客户名=‘A’;
B.
where 客户名=‘A’and 订单费用<2700;< /div>
C.
where 客户名=‘A’or 订单费用>2700;
D.
where 客户名=‘A’and 订单费用>2700;
【单选题】请从订单表中取得数据,包括三个列:客户名、订单时间与订单费用。可以用下列哪个 where 子句查询 ORDERS 表,取得客户 A 超过 2700 的订单
A.
where 客户名='A'
B.
where 客户名='A' and 订单费用<2700;< /div>
C.
where 客户名='A' or 订单费用>2700;
D.
where 客户名='A' and 订单费用>2700;