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 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 customersWHERE cust_city IN (‘WASHINGTON’,’NEW YORK’)GROUP BY cust_credit_limit, cust_city;
B. SELECT cust_city, AVG(cust_credit_limit)FROM customersWHERE cust_city IN (‘WASHINGTON’,’NEW YORK’)GROUP BY cust_city,cust_credit_limit;
C. SELECT cust_city, AVG(cust_credit_limit)FROM customersWHERE cust_city IN (‘WASHINGTON’,’NEW YORK’)GROUP BY cust_city;
D. SELECT cust_city, AVG(NVL(cust_credit_limit,0))FROM customersWHERE cust_city IN (‘WASHINGTON’,’NEW YORK’);

Download Printable PDF. VALID exam to help you PASS.

One thought on “Which SQL statement would produce the required result?

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.