OCP-1Z0-051 第142题 嵌套子查询的应用

一、原题

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

Evaluate the following query:
SQL> 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?
A. I