The following question is a T-SQL question.

Rewrite the following derived table in CTE.

--The following is a derived table (Subquery) Use Adventure Works 2012; SELECT Orders. CustomerID, SalesOrderID, Order Date, TotalDue, CustTotal, AvgSale, MinSale FROM Sales Sales OrderHeader AS Orders JOIN SELECT SUM(TotalDue) AS CustTotal, AVG(TotalDue) AS AvgSale, MIN(TotalDue) AS MinSale, MAX(TotalDue AS MaxSale, CustomerID FROM Sales SalesOrderHeader GROUP BY CustomerID) AS Sales ON Orders. CustomerID = Sales. CustomerID; --- 31465 records --Re-write the above derived table as a CTE