110.View the Exhibit and examine the structure of the CUSTOMERS table.

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

customers in WASHINGTON and NEW YORK.

Which SQL statement would produce the required result?

A.SELECT cust_city, AVG(cust_credit_limit) FROM customers
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非聚合