generate the exact same output $($including headers$)$ as shown below.

$1$

Note: Required output noted below may not have all rows shown. Note: all rows may not be seen in the required output below.How to solve

$\backslash$table$[[$Name$,$City,State,PhoneNumber$],[$Sam Abolrous,Palm Springs,CA$,555-2611$ASSignment J

BUSA $326$ Data and Information Management

Fall $2024$

Instructor: Prof. Brodnax

Assignment: Please post the following in the class dropbox NLT midnight, $08$ Oct.:

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$)$

Use the salesordersDB database schema.

Translate the requirements below into a SQL query that accomplishes the following:

$-$a$.$ "Management requested a list of all customers". Make sure it looks exactly like the

example output $($at the back of this assignment$).$ Hint: $28$ rows returned.

$-$b$.$ "Management received a complaint from customer $1002.$ The customer complained of a

shipping error on $18$ Jan $2013.$ We need to display all shipments for the customer on that

date". Make sure it looks exactly like the example output $($at the back of this assignment$).$

Hint: $3$ 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. Note that

the one $(1)$ sql file will have both queries $($sql$)$ contained in it$.$ There should not be more than

one sql file posted. Only one sql file will be graded. Any other sql files will not be reviewed.

Outputs for each requirement $($request$)$ is shown below. Remember, your query should