4. Rewrite the following derived table in CTE(7 points). --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 Sales OrderHeader GROUP BY CustomerID) AS Sales ON Orders. CustomerID = Sales. CustomerID -- 31465 records --Re-write the above derived table as a CTE