See the exhibit and examine the structure of the CUSTOMERS and GRADES tables: You
need to display names and grades of customers who have the highest credit limit. Which
two SQL statements would accomplish the task? (Choose two.)
A.
SELECT custname, grade FROM customers, grades WHERE (SELECT
MAX(cust_credit_limit) FROM customers) BETWEEN startval and endval AND
cust_credit_limit BETWEEN startval AND endval;
B.
SELECT custname, grade FROM customers, grades WHERE cust_credit_limit =
(SELECT MAX(cust_credit_limit) FROM customers) AND cust_credit_limit BETWEEN
startval AND endval;
C.
SELECT custname, grade FROM customers , grades WHERE cust_credit_limit IN
(SELECT MAX(cust_credit_limit) FROM customers) AND MAX(cust_credit_limit)
BETWEEN startval AND endval;
D.
SELECT custname, grade FROM customers, grades WHERE (SELECT
MAX(cust_credit_limit) FROM customers) BETWEEN startval and endval;
Explanation: