1. Use the salesordersdb326 database schema 2. Copy this assignment into a Word Document and provide the Translation, Cleanup, and SQL that accomplishes the following requirements: - Requirement a. Shall provide a display which includes total sales for each product in inventory.. Make sure it looks exactly like the example output (at the end of this assignment document. Required sql construct: INNER JOIN. Hint: 38 rows generated. - Requirement b. Shall provide a display which includes all customers and their respective state.. Make sure it looks exactly like the example output (at the end of this assignment document. Required sql construct: CASE. Hint: 28 rows generated. 4. Apply the SELECT statements to the MySQL Workbench to accomplish the requests noted. 5. Be sure and meet both explicit requirements as noted in the requirements statement as well as implicit requirement that are provided in the output grid. 6. As noted above, post both the Word document with the translation statements and the SQL (sql) file that executes the required query. Both files (only 2 files submitted) must be submitted into the dropbox by the due date to receive full credit. Note that the one (1) sql file will have all queries (sql) contained in it. There should not be more than one sql file posted. 7. Outputs for each requirement (request) is shown below. Remember, your query should generate the exact same output (including headers) as shown below. TotalSales Result Grid . Filter Rows: ProductName AeroFlo ATB Wheels Clear Shade 85-T Glasses Cosmic Elite Road Warrior Wheels Cydle-Doc Pro Repair Stand Dog Ear Aero-Flow Floor Pump Dog Ear Cyclecomputer Dog Ear Helmet Mount Mirrors Dog Ear Monster Grip Gloves 75458.25 14581.35 63803.85 62157.04 36029.40 2238.75 767.73 2779.50 E Result Grid Filter Rows: CustFirstName CustLastName CustStateName Sam Abolrous California Zachary Ehrlich California Darren Gehring California Neil Patterson California Rachel Patterson California David Smith California Caleb Viescas California Luke Patterson Oregon Manuela Seidel Oregon Mariya Sergienko Oregon Customers * Customer CustFirstName CustLastName CustStreetAddress CustCity CustState CustZip Code CustAreaCode CustPhone Number Orders Order Number OrderDate ShipDate Customer Employee Product Vendors Product Number 7 Vendorld Wholesale Price DaysToDeliver Order Details Order Number Product Number QuotedPrice QuantityOrdered Products 7 Product Number Product Name Product Description Retail Price QuantityOn Hand Category Vendors Y VendorID VendName VendStreetAddress VendCity VendState VendZip Code VendPhone Number VendFaxNumber VendWebPage VendEMailAddress Categories CategoryID CategoryDescription Employees Employeeld EmpFirst Name EmplastName EmpStreetAddress EmpCity EmpState EmpZipCode EmpAreaCode EmpPhone Number EmpBirthDate ztblPurchaseCoupons LowSpend HighSpend NumCoupons ztblSeqNumbers Sequence ztblPriceRanges PriceCategory Low Price High Price ztb Months MonthYear Yearumber Month Number MonthStart MonthEnd January February March April May June July August September October November December