How could I join the table (shown below) to get the result (shown below)? Using SQL

Consider the following schema Customers CustomerID Product Vendors Orders OrderNumber OrderDate CustStreetAddress Vendorld WholesalePrice DaysToDeliver Order Details Vendors CustState VendorlD EmployeelD QuotedPrice RetailPrice QuantityOnHand CategorylD VendCity VendZipCode VendFaxNumber VendWebPage VendEMailAddress Categories EmployeelD CategorylD CategoryDescription MonthYear EmpStreetAddress MonthNumber MonthStart MonthEnd January February March April May June July August September October EmpState EmpZipCode EmpAreaCode ztblPu LowSpend HighSpend Sequence Figure 1: Sales Orders Database Subtask 7.2.1 Write a query that creates a listing of the value of all the sales of each employee per product to answer the question: What is the value of the total sales of each employee per product? As before, you have to resort to the QuantityOrdered and QuotedPrice columns to find the sales. Order the result by EmpLastName and ProductName. EmpFirstName Matt EmpLastName Berg ProductName TotalSolo AeroFlo ATB Wheels 10179.54