Use the salesordersDB database schema.

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.

Apply the SELECT statements to the MySQL Workbench to accomplish the requests noted.

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.

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.

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.