Assignment: Please post the following in the class dropbox NLT $11$:$30$ pm$,04$ Dec.:

Create one $.$sql 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 sqI 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.