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

By | January 1, 2023

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: D