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. Ex

Question

Exhibit

Options

• AIt gives an error because the GROUP BY clause is not valid
• BIt executes successfully but does not give the required result
• CIt executes successfully and gives the required result
• DIt gives an error because the ALL keyword is not valid

• A
  12% (4)
• B
  6% (2)
• C
  79% (27)
• D
  3% (1)

Explanation

Explanation/Reference:

No community discussion yet for this question.