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, MAX(cust_credit_limit);
B.
SELECT cust_city, cust_income_level, MAX(cust_credit_limit ) FROM customers
GROUP BY cust_city, cust_income_level, cust_credit_limit;
C.
SELECT cust_city, cust_income_level, MAX(cust_credit_limit) FROM customers GROUP
BY cust_city, cust_income_level;
D.
SELECT cust_city, cust_income_level, MAX(cust_credit_limit) FROM customers GROUP
BY cust_credit_limit, cust_income_level, cust_city ;
Explanation: