1) Use the database my_guitar_shop.

Write a SELECT statement that joins the customers table to the addresses table.

Use explicit inner join syntax.

Do not use table aliases.

Filter the results using only the customer's email address.

Return a resultset that matches the results shown below.

!b)

Use the database my_guitar_shop.

Write a SELECT statement that joins the customers table to the addresses table.

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

Use explicit inner join syntax.

Do not use table aliases.

Return a resultset that matches the results shown below.

1C)

Use the database my_guitar_shop.

Write a SELECT statement that returns the product_name and list_price columns from the Products table.

Return one row for each product that has the same list price as another product.

Use a self-join to check that the product_id columns arent equal and the list_price columns are equal.

Use explicit inner join syntax.

Return a resultset that matches the results shown below.

1D)

Use the database my_guitar_shop.

Write a SELECT statement that joins the categories table to the products table.

Return one row for each category that has never been used.

Use an outer join and only return rows where the product_id column contains a null value.

Use explicit outer join syntax.

Do not use table aliases.

Return a resultset that matches the results shown below.