View the Exhibits and examine the structure of the COSTS and PROMOTIONS tables. You want to display PROD_IDS

By | December 31, 2022

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:

Exhibit 1.

Exhibit 2.

What will be the result?

Correct Answer: C