DP-600: Implementing Analytics Solutions Using Microsoft FabricDemo

Question

You have a Fabric warehouse containing a table named Sales.Products. Sales.Products contains the following columns.

Question Image

You need to write a T-SQL query that returns the following columns.

Question Image

How should you complete the code?

Select

SELECT ProductID,
(ListPrice, WholesalePrice, AgentPrice) AS HighestSellingPrice,
(ListPrice, WholesalePrice, AgentPrice) AS TradePrice
FROM Sales.Products;

Explanation

GREATEST returns the largest supplied scalar value. COALESCE is the T-SQL function used to return the first non-NULL value for prioritized fallback logic. To actually implement AgentPrice-first priority, its arguments must be ordered AgentPrice, WholesalePrice, ListPrice; the shown argument order would always select the non-null ListPrice.

DP-600: Implementing Analytics Solutions Using Microsoft FabricDemo

AstroTutor

Notes

Readiness

QuestionQ11

Community Discussion