QuestionQ86
VerifiedPrepare dataYou have a Fabric warehouse containing a table named Sales.Orders. Sales.Orders has the following columns.

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

How should you complete the code?
Select
SELECT OrderID, CustomerID, (month, OrderDate) AS PeriodDate, DATENAME(, OrderDate) AS DayName FROM Sales.Orders;
Community Discussion