View the Exhibit and examine the structure of the CUSTOMERS table. Exhibit: you issue
the following SQL statement on the CUSTOMERS table to display the customers who are in
the same country as customers with the last name ‘king’ and whose credit limit is less than
the maximum credit limit in countries that have customers with the last name ‘king’. Which
statement is true regarding the outcome of the above query?
A.
It produces an error and the < operator should be replaced by < ALL to get the required
output
B.
It executes and shows the required result
C.
It produces an error and the IN operator should be replaced by = in the WHERE clause
of the main query to get the required output
D.
It produces an error and the < operator should be replaced by < ANY to get the required
output