Microsoft sql Queries using Ms SQL Management studio and the adventureWorks2017

I'm looking for some help doing this assignment. Its due tomorrow Sunday 10/6/2019

 Please look at the attached file A07, for assignment instructions

HERE IS AN EXAMPLE of how the query going to look like


: 1.
 a) Least profitable
SELECT  prod.ProductID,
            prod.ProductNumber,
            prod.Name as ProductName,
            SUM(sod.OrderQty) AS QuantitySold,
            SUM(prod.StandardCost) AS TotalCost,
            SUM(sod.LineTotal) AS TotalRevenue,
            SUM(ListPrice-StandardCost) AS TotalProfit

FROM Production.Product prod
JOIN Sales.SalesOrderDetail sod
      ON prod.ProductID = sod.ProductID

GROUP BY prod.ProductID,
             prod.ProductNumber,
             prod.Name

ORDER BY TotalProfit

 




1. b) Most Profitable
SELECT  prod.ProductID,
            prod.ProductNumber,
            prod.Name as ProductName,
            SUM(sod.OrderQty) AS QuantitySold,
            SUM(prod.StandardCost) AS TotalCost,
            SUM(sod.LineTotal) AS TotalRevenue,
            SUM(ListPrice-StandardCost) AS TotalProfit

FROM Production.Product prod
JOIN Sales.SalesOrderDetail sod
      ON prod.ProductID = sod.ProductID

GROUP BY prod.ProductID,
             prod.ProductNumber,
             prod.Name

ORDER BY TotalProfit DESC
A07.docx