query 6 plz correct answer asap

Query 6 What is the total order price for each order listed in Northwind's database? SELECT OrderID, SUM(UnitPrice*(1-Discount)* Quantity) as TotalOrderPrice From OrderDetails; Query 7 Add to the previous query. Include the Customer ID and Shipping Name for each order th SELECT o. ShipName, o.CustomerID, OrderID, SUM (UnitPrice*(1-Discount)* Quantity) From Orders 0 Join OrderDetails Query 8 Add to the previous query. Include the Title of Courtesy, First Name, and Last Name of EXTRA CREDIT: Edit the query so the responsible employee's information appears in one