DP-600: Implementing Analytics Solutions Using Microsoft FabricDemo

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

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

How should you complete the code?

SELECT OrderID, CustomerID, ProductID,
    Select… (Weight, Quantity, 1) AS ChargedQuantity,
    Select… (ListPrice, SalePrice) AS OrderPrice
FROM Sales.Orders;