Which statement is true regarding the outcome of the above query?
A. It executes and shows the required result
B. It produces an error and the < operator should be replaced by < ANY to get the required output
C. It produces an error and the < operator should be replaced by < ALL to get the required output
D. 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
Answer:A
Which statement is true regarding the outcome of the above query?
A. It executes and shows the required result B. It produces an error and the < operator should be replaced by < ANY to get the required output C. It produces an error and the < operator should be replaced by < ALL to get the required output D. 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