Which SQL statement would produce the required result?

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: