contestada

Consider database Products (ProductName, Price, CategoryID)
Output - Each product name with its price in cents
Also mark the products with price >10$ and category='beverage' as 'expensive' and others as 'reasonable'.
a) SELECT ProductName, Price100, CASE WHEN Price>10 AND CategoryID='beverage' THEN 'expensive' ELSE 'reasonable' END FROM Products
b) SELECT ProductName, Price100, IF Price>10 AND CategoryID='beverage' THEN 'expensive' ELSE 'reasonable' END FROM Products
c) SELECT ProductName, Price100, IF Price>100 AND CategoryID='beverage' THEN 'expensive' ELSE 'reasonable' END FROM Products
d) SELECT ProductName, Price100, CASE WHEN Price>100 AND CategoryID='beverage' THEN 'expensive' ELSE 'reasonable' END FROM Products

Respuesta :

Otras preguntas