110.View the Exhibit and examine the structure of the CUSTOMERS table.
来源:互联网 发布:dive into python pdf 编辑:程序博客网 时间:2024/05/25 16:38
110.View the Exhibit and examine the structure of the CUSTOMERS table.
Using the CUSTOMERS table, you need to generate a report that shows the average credit limit for
WHERE cust_city IN ('WASHINGTON','NEW YORK')
GROUP BY cust_credit_limit, cust_city;
B.SELECT cust_city, AVG(cust_credit_limit) FROM customers
WHERE cust_city IN ('WASHINGTON','NEW YORK')
GROUP BY cust_city,cust_credit_limit;
C.SELECT cust_city, AVG(cust_credit_limit) FROM customers
WHERE cust_city IN ('WASHINGTON','NEW YORK')
GROUP BY cust_city;
D.SELECT cust_city, AVG(NVL(cust_credit_limit,0)) FROM customers
WHERE cust_city IN ('WASHINGTON','NEW YORK');
答案:C
解析:题目说需要生成一个报告显示在WASHINGTON and NEW YORK的平均credit limit,这里到底是说,每个城市
的平均,还是这两个城市一共的平均,如果两个城市的平均,那么不需要group by,如果是每个城市的平均
那么group by的字段应该是城市,因此排除AB
A:错误
B:错误
C:正确,这里是按照每个城市进行平均
D:错误,如果这里是计算两个城市的总的平均,那么select cust_city,这里是有问题的,cust_city这个应该归属
算哪个城市,这个sql语句本身有问题,avg是聚合,cust_city非聚合
Using the CUSTOMERS table, you need to generate a report that shows the average credit limit for
customers in WASHINGTON and NEW YORK.
Which SQL statement would produce the required result?
WHERE cust_city IN ('WASHINGTON','NEW YORK')
GROUP BY cust_credit_limit, cust_city;
B.SELECT cust_city, AVG(cust_credit_limit) FROM customers
WHERE cust_city IN ('WASHINGTON','NEW YORK')
GROUP BY cust_city,cust_credit_limit;
C.SELECT cust_city, AVG(cust_credit_limit) FROM customers
WHERE cust_city IN ('WASHINGTON','NEW YORK')
GROUP BY cust_city;
D.SELECT cust_city, AVG(NVL(cust_credit_limit,0)) FROM customers
WHERE cust_city IN ('WASHINGTON','NEW YORK');
答案:C
解析:题目说需要生成一个报告显示在WASHINGTON and NEW YORK的平均credit limit,这里到底是说,每个城市
的平均,还是这两个城市一共的平均,如果两个城市的平均,那么不需要group by,如果是每个城市的平均
那么group by的字段应该是城市,因此排除AB
A:错误
B:错误
C:正确,这里是按照每个城市进行平均
D:错误,如果这里是计算两个城市的总的平均,那么select cust_city,这里是有问题的,cust_city这个应该归属
算哪个城市,这个sql语句本身有问题,avg是聚合,cust_city非聚合
0 0
- 110.View the Exhibit and examine the structure of the CUSTOMERS table.
- 79.View the Exhibit and examine the structure of the CUSTOMERS table. In the CUSTOMERS table, the CU
- 8.View the Exhibit and examine the structure of the CUSTOMERS table.
- 54.View the Exhibit and examine the structure of the CUSTOMERS table.
- 65.View the Exhibit and examine the structure of the CUSTOMERS table.
- 111.View the Exhibit and examine the structure of the CUSTOMERS table.
- 115.View the Exhibit and examine the structure of the CUSTOMERS table.
- 145.View the Exhibit and examine the structure of the CUSTOMERS table.
- 159.View the Exhibit and examine the structure of the CUSTOMERS table.
- 93.View the Exhibit and examine the structure of the CUSTOMERS table. Using the CUSTOMERS table, y o
- 60.View the Exhibit and examine the structure of CUSTOMERS table.
- 1.View the Exhibit and examine the structure of the SALES, CUSTOMERS, PRODUCTS, and TIMES tables.
- 151.View the Exhibit and examine the structure of the CUSTOMERS and CUST_HISTORY tables.
- 157.View the Exhibit and examine the structure of the ORDERS and CUSTOMERS tables.
- 141.View the Exhibit and examine the structure of CUSTOMERS and GRADES tables.
- 160.View the Exhibit and examine the structure of ORDERS and CUSTOMERS tables.
- 164.View the Exhibit and examine the structure of CUSTOMERS and SALES tables.
- 11.View the Exhibit and examine the structure of the PRODUCTS table.
- 聚类算法总结
- Hadoop2.6.0单机/伪分布式安装
- 动态顺序表
- 如何提取PDF文件中的部分页面内容
- 卡车图像分离车头、车厢、车轮
- 110.View the Exhibit and examine the structure of the CUSTOMERS table.
- 世界领先的跨平台开发技术Qt Enterprise 5.6 新功能预览
- Binlog_cache_size
- iOS微信支付
- 2. PSR-2 --- 代码风格指南
- ffmpeg解码流程
- 学习笔记_Git之分支创建策略
- 3. PSR-3 --- 日志接口
- 设计模式必须通过面向对象来实现吗?