My answer for exercise 1: CREATE VIEW customer_addresses AS SELECT (customer_id,

Question

My answer for exercise 1:

CREATE VIEW customer_addresses AS
SELECT (customer_id, email_address, last_name, first_name, bill_line1, bill_line2, bill_city, bill_state, bill_zip, ship_line1, ship_line2, ship_city, ship_state, ship_zip) FROM Customers, Addresses WHERECustomers. customer_id = Addresses.customer_id ORDER BY last_name, firstname;

2) Write a SELECT statement that returns these columns from the customer_addresses view that you created in exercise 1: customer_id, last_name, first_name, bill_line1.

3) Write an UPDATE statement that updates the addresses table. Set the line 1 address to “1990 Westwood Blvd.” for the customer with an ID of 8. Then check that the update is shown in the view.

thank you i apprecite your time and help

Explanation / Answer

2) SELECT customer_id, last_name, first_name, bill_line1 FROM customer_addresses;

3) UPDATE customer_addresses SET bill_line1 = '1990 Westwood Blvd' WHERE customer_id=8;

Related Questions

Navigate

• Browse (All)
• Browse M
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.