create one .sol file with SQL queries that executes the requirements noted below. Make sure you have comments in your sql in the beginning providing your name, course/course section, and CWID. (points deducted for not having this comment) NOTE: DO YOUR OWN WORK! 1. Use the salesordersDB database schema. 2. Translate the requirements below into a SQL query that accomplishes the following: -a. Management is requesting a list of all customers with their total dollar amount of orders to date. Make sure it looks exactly like the example output (at the back of this assignment). Hint: 27 rows returned. Required sql constructs: Table JOINs. 3. Apply the SELECT statements to the MySQL Workbench to accomplish the requests noted. 4. Be sure and meet both explicit requirements as noted in the requirements statement as well as implicit requirements that are provided in the output grid. 5. As noted above, post the SQL (sql) file that executes the required query. The sql file (only 1 file submitted) must be posted in the dropbox by the due date to receive full credit. 6. Output for the requirement (request) is shown below. Remember, your query should generate the exact same output (including headers) as shown below. Note: Required output noted above may not have all rows shown.

Note: Required output noted above may not have all rows shown