View the Exhibit and examine the structure of the CUSTOMERS table .Which statement would
display the highest credit limit available in each income level in each city in the CUSTOMERS
table?
A.
SELECT cust_city, cust_income_level, MAX(cust_credit_limit ) FROM customers GROUP BY cust_city,
cust_income_level, cust_credit_limit;
B.
SELECT cust_city, cust_income_level, MAX(cust_credit_limit) FROM customers GROUP BY cust_city,
cust_income_level;
C.
SELECT cust_city, cust_income_level, MAX(cust_credit_limit) FROM customers GROUP BY
cust_credit_limit, cust_income_level, cust_city ;
D.
SELECT cust_city, cust_income_level, MAX(cust_credit_limit) FROM customers GROUP BY cust_city,
cust_income_level, MAX(cust_credit_limit);