1. Create a view named customer_addresses that shows the shipping and billing addresses for each customer. This view should return the following columns: Customers table: customer_id, email_address, last_name, and first_name Append either bill_ or ship_ from the address table for the billing and shipping address such as: bill_line1, bill_line2, bill_city, bill_state, bill_zip, ship_line1, ship_line2, ship_city, ship_state, and ship_zip. The rows in the view should be sorted by the last_name and then the first_name columns