See the Exhibit and examine the structure of the CUSTOMERS table: Using the
CUSTOMERS table, you need to generate a report that shown 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’);
Explanation: