$1.$ Write a SELECT statement that joins the Categories table to the Products table and

returns these columns: category$\_$name, product$\_$name, list$\_$price.

Sort the result set by the category$\_$name column and then by the product$\_$name column in

ascending sequence.

$2.$ Write a SELECT statement that joins the Customers table to the Addresses table and

returns these columns: first$\_$name, last$\_$name, line$1,$ city, state, zip$\_$code.

Return one row for each address for the customer with an email address of

allan.sherwood@yahoo.com

Sort the result set by the zip$\_$code column in ascending sequence.

$.$

$3.$ Write a SELECT statement that joins the Customers table to the Addresses table and

returns these columns: first$\_$name, last$\_$name, line$1,$ city, state, zip$\_$code.

Return one row for each customer, but only return addresses that are the shipping address

for a customer.

Sort the result set by the zip$\_$code column in ascending sequence.

$4.$ Write a SELECT statement that joins the Customers, Orders, Order$\_$Items, and

Products tables. This statement should return these columns: last$\_$name, first$\_$name,

order$\_$date, product$\_$name, item$\_$price, discount$\_$amount, and quantity.

Use aliases for the tables.

Sort the final result set by the last$\_$name, order$\_$date, and product$\_$name columns.

$5.$ Use the UNION operator to generate a result set consisting of three columns from the

Orders table:

ship$\_$status A calculated column that contains a value of

SHIPPED or NOT SHIPPED

order$\_$id The order$\_$id column

order$\_$date The order$\_$date column

If the order has a value in the ship$\_$date column, the ship$\_$status column should contain a

value of SHIPPED. Otherwise, it should contain a value of NOT SHIPPED.

Sort the final result set by the order$\_$date column.