Scenario 2 You and soft need to write SQL statements to get the answers to these questions. F9 are a newly hired analyst at OEC Computers, a distributor of computer equipment, printers ware. The manager of your department has asked you a number of questions. You will 1. How many manufacturers does OEC Computers have in their Manufacturers table? 2. What is the total discount for Business Partner Leads (BP Type - L)? 3. How many Business Partners have a discount greater than 10%? 4. Which Business Partners (show BP Name and State) have a bill-to address in California? 5. What is the Document Total (not number) of all sales orders with a Due Date between March 10, 2017 and March 20, 2017 inclusive? 6. What is the business partner name, address (Street, City, State, zip code) and contact names for BP Code C40003? 7. What is the name and dollar value of the item that has generated the third most dollar value of sales (limit 3)? Points will be awarded as follows: Creating and loading the eight (8) tables is worth 7 points. If a question is answered accurately with one (1) SQL statement, that will be worth 4 points. However, if a question is answered accurately with two (2) or more SQL statements that is worth only 2 points. Please use the TEE command in MySQL and email me the TEE file. Include ONLY the ments and results. Include your name, scenario # and section # at the top of the TEE file! lease number and put around your answers in the TEE file