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.
USE AdventureWorks2012;
GO
SELECT ProductNumber, Name, “Price Range” =
CASE
WHEN ListPrice = 0 THEN ‘Mfg item – not for resale’
WHEN ListPrice = 50 and ListPrice = 250 and ListPrice < 1000 THEN 'Under $1000'
ELSE 'Over $1000'
END
FROM Production.Product
ORDER BY ProductNumber ;
GO