Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Create a view named customer_addresses that show the shipping and billing addresses for each customer. This view should return the following columns: Customers table: customer_id,
Create a view named customer_addresses that show 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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started