HOTSPOT
-
You have a Fabric warehouse that contains a table named Sales.Products. Sales.Products contains the following columns.
You need to write a T-SQL query that will return the following columns.
How should you complete the code? To answer, select the appropriate options in the answer area.
NOTE: Each correct answer is worth one point.
GREATEST, COALESCE
Greatest is ok; however, if we have all of them present, list price will return first if you use coalesce, which is not what the question requests. The question requests AgentPrice first. I am not sure about Coalesce.
Yes, it seems like there is no correct answer for the second box
answer is correct
I believe that the 2nd box should be COALESCE, but if you read requirements for TradePrice column, you will realize that actually, COALESCE will not work here. Clearly there's a mistake somewhere.
MAX COALESCE
correct - GREATEST and COALESCE
MAX() accepts one argument; GREATEST() accepts multiple arguments
SELECT ProductID, GREATEST(ListPrice, WholesalePrice, AgentPrice) AS HighestSellingPrice, COALESCE(AgentPrice, WholesalePrice, ListPrice) AS TradePrice FROM Sales.Products;
Correct Answer GREATEST, COALESCE