Using the previously created tables Guest and Room populate your table with the

Using the previously created tables guest and room

This preview shows page 2 - 4 out of 4 pages.

Using the previously created tables : Guest and Room, populate your table with the following information : Guest GuestID FName LName Phone CheckInDate Duration RoomNumber 1001 Homer Simpson 409-441- 1234 10/15/2018 5 days 202 1002 Marge Simpson 409-441- 4321 10/15/2018 5 days 202 1005 Jane Doe 800-000- 0001 10/01/2018 20 days 101 Room RoomNumber Floor Description 101 1 Single King Bed 202 2 Two Double Bed 203 2 Suite 3. A mistake was made. Ms. Doe first name is Janet, not Jane. Update your record. 4. Using the Guest tables, list the first and last name of all the guests staying more than 10 days.
Image of page 2