OCP-1Z0-051-V9.02-110题

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');

Answer: C

答案解析：

A答案：此处是按照cust_credit_limit, cust_city;这两个一起分组的。此处换另外两个城市来测试。