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.
Option A
B.
Option B
C.
Option C
D.
Option D
C
C
SQL> select cust_city,avg(cust_credit_limit) from customers
2 where cust_city in (‘Washington’,’New Auburn’)
3 group by cust_city ;
CUST_CITY AVG(CUST_CREDIT_LIMIT)
—————————— ———————-
Washington 7258.92857
New Auburn 6583.33333
SQL>
c