OCP-1Z0-051 第149题 子查询中ALL的应用

一、原题

View the Exhibits and examine the structures of the COSTS and PROMOTIONS tables.

Evaluate the following SQL statement:
SQL>SELECT prod_id
      FROM costs
     WHERE promo_id IN
           (SELECT promo_id
              FROM promotions
             WHERE promo_cost < ALL
             (SELECT MAX(promo_cost)
                      FROM promotions
                     GROUP BY (promo_end_date - promo_begin_date)));
What would be the outcome of the above SQL statement?
A. It displays prod IDs in the promo with the lowest cost.
B. It d