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?

Question

Exhibit

Options

• ASELECT cust_city, cust_income_level, MAX(cust_credit_limit ) FROM customers GROUP BY
• BSELECT cust_city, cust_income_level, MAX(cust_credit_limit) FROM customers GROUP BY
• CSELECT cust_city, cust_income_level, MAX(cust_credit_limit) FROM customers GROUP BY
• DSELECT cust_city, cust_income_level, MAX(cust_credit_limit) FROM customers GROUP BY

• A
  8% (4)
• B
  73% (37)
• C
  16% (8)
• D
  4% (2)

No community discussion yet for this question.