View the Exhibits and examine the structure of the costs and PROMOTIONS tables
You want to display PROD IDS whose promotion cost is less than the highest cost PROD ID in a
Promotion time interval
Examine this SQL statement
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 will be the result?
A.It executes successfully and gives the required result. B.It gives an error because the GROUP BY clause is not valid C.It executes successfully but does not give the required result D.It gives an error because the ALL keyword is not valid正确答案C