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.
Simple if-then-else. If promo_cost >=... avg(promo_cost)... then 'HIGH' else 'LOW'. it's testing all promotions.
upvoted 1 times
...
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
cnyce
5 years, 7 months agoturtle
5 years, 3 months ago