Using Joins

Using the My Guitar Shop database you installed in Module $1,$ develop the following queries.

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. Execute the query and take a screenshot of the query and the results.

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. Execute the query and take a screenshot of the query and the results.

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. Execute the query and take a screenshot of the query and the results.

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. Execute the query and take a screenshot of the query and the results.

All the screenshots should show current date. Example of screenshot.