$1.$ Using the om database, write a SQL statement that returns three columns.

$1\mathrm{.}1.$ The first column should contain the customer$$s first name and last name with a space between

them. Order the results by the customer$$s last name then first name.

$1\mathrm{.}1\mathrm{.}1.$ Make the heading at the top of the column: name.

$1\mathrm{.}2.$ The second column should contain the customer$$s address.

$1\mathrm{.}2\mathrm{.}1.$ Make the heading at the top of the column: street address.

$1\mathrm{.}3.$ The third column should contain the customer$$s city, state, and zip code. There should be a

comma and a space after the city and a space after the state.

$1\mathrm{.}3\mathrm{.}1.$ Make the heading at the top of the column: city, state zip.

$2.$ Using the om database, write a SQL statement that returns the customer id and the difference in

days from the date the order shipped and the date the customer placed the order.

$2\mathrm{.}1.$ Make the heading for the difference in days column: days to ship.

$2\mathrm{.}2.$ List the results with the longest time to ship at the top.

$3.$ Using the om database, write a SQL statement that returns the artist$$s name, title, and price of

each title.

$3\mathrm{.}1.$ Make the heading for the price column: price.

$3\mathrm{.}2.$ Sort the results by artist, then title.

$4.$ Using the ap database, write a SQL statement that returns three columns.

$4\mathrm{.}1.$ The first column should contain the invoice date.

$4\mathrm{.}2.$ The second column should contain the result of invoice total $$ payment total $$ credit total.

$4\mathrm{.}2\mathrm{.}1.$ Make the heading for the second column: amount due.

$4\mathrm{.}3.$ The third column should contain the invoice due date.

$4\mathrm{.}4.$ Return only the invoices where the invoice due date is in the month of August $2022$ and where

the amount due is greater than zero.

$5.$ Using the ap database, write a SQL statement that returns the invoice id$,$ invoice due date, and the

payment date for all invoices paid after the due date.

$5\mathrm{.}1.$ Format all dates as two$-$digit day of the month, three$-$letter month, and four digit year $$ for

example: $04$ May $2024.$

$5\mathrm{.}2.$ Order the results by the invoice due date