Question

Which statement would display the highest credit limit available in each income level in each city in
the Customers table?
Select one:
O SELECT cust_city, cust_income_level, MAX(cust_credit_limit)
FROM customers
GROUP BY cust_city, cust_income_level;
O SELECT cust_city, cust_income_level, MAX(cust_credit_limit)
FROM customers
GROUP BY cust_credit_limit, cust_income_level, cust_city;
O SELECT cust_city, cust_income_level, MAX(cust_credit_limit)
FROM customers
GROUP BY cust_city,, cust_income level , MAX(cust_credit_limit);
SELECT cust_city, cust_income_level, MAX(cust_credit_limit)
FROM customers
GROUP BY cust_city, cust income_level,cust_credit_limit;​

Answer 1

Answer: 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);