Evaluate the following query:

SELECT prod_name

FROM products

WHERE prod_id IN (SELECT prod_id FROM products

WHERE prod_list_price =

(SELECT MAX(prod_list_price)FROM products

WHERE prod_list_price

Question

Evaluate the following query:

SELECT prod_name 
 
FROM products

WHERE prod_id IN (SELECT prod_id FROM products

WHERE prod_list_price = 
 
(SELECT MAX(prod_list_price)FROM products 
 
WHERE prod_list_price < 
 
(SELECT MAX(prod_list_price)FROM products)));

What would be the outcome of executing the above SQL statement?

Answer

It shows
the names of all products in the table.

Answer

It produces
an error.

Answer

It shows the names of products whose list price is
the second highest in the table.

Answer

It
shows the names of all products whose list price is less than the maximum list
price.

Crowdly