What would be the outcome of the above statement?

View the Exhibit and examine the structure of the CUSTOMERS table.

Evaluate the query statement:

SQL> SELECT cust_last_name, cust_city, cust_credit_limit
FROM customers
WHERE cust_last_name BETWEEN ‘A’ AND ‘C’ AND cust_credit_limit BETWEEN
1000 AND 3000;

What would be the outcome of the above statement?

A.
It executes successfully.

B.
It produces an error because the condition on CUST_LAST_NAME is invalid.

C.
It executes successfully only if the CUST_CREDIT_LIMIT column does not contain any null values.

D.
It produces an error because the AND operator cannot be used to combine multiple BETWEEN clauses.