Which statement is true regarding the outcome of the above query?

View the Exhibit and examine the structure of the promotions table.

Evaluate the following SQL statement:

Which statement is true regarding the outcome of the above query?

A.
It shows COST_REMARK for all the promos in the table.

B.
It produces an error because the SUBQUERY gives an error.

C.
It shows COST_REMARK for all the promos in the promo category ‘TV’

D.
It produces an error because SUBQUERIES cannot be used with the case expression.