1. Create a view named CustomerAddresses that shows the shipping and billing addresses for each customer in the MyGuitarShop database.
This view should return these columns from the Customers table: CustomerID, EmailAddress, LastName and FirstName.
This view should return these columns from the Addresses table: BillLine1, BillLine2, BillCity, BillState, BillZip, ShipLine1, ShipLine2, ShipCity, ShipState, and ShipZip.
1. Write a SELECT statement that returns these columns from the CustomerAddresses view that you created in exercise 1: CustomerID, LastName, FirstName, BillLine1.
1. Write an UPDATE statement that updates the CustomerAddresses view you created in exercise 1 so it sets the first line of the shipping address to “1990 Westwood Blvd.” for the customer with an ID of 8.
Twin Point River Hotel at Sensation Park
Our Newest Luxury Hotel
Located across from Sensation Park at Twin Rivers, our newest hotel boasts luxury amenities and a prime location on Twin Point River.
Grand Opening Events
Opening weekend—June 1
Free park entrance with weekend stay
First month specials
Combination room and park entrance packages
Concerts and comedy acts
Daily giveaways for registered guests
June 1, 2016