Question: 13. Write a query that inserts the following booking: guest 10074, hotel 114, room number 303, on startdateAugust 17, 2017 going through August 20, 2017.
13. Write a query that inserts the following booking: guest 10074, hotel 114, room number 303, on startdateAugust 17, 2017 going through August 20, 2017. Will your insert statement enter the data in the Bookings table successfully? Why or why not? 14. Write a query that adds ten dollars (10.00) to the rates for all of the single rooms in hotels in the state of New Hampshire. 15. Write query that removes the information on hotel 105 from the Hotel table. Will your delete statement remove the information successfully? Why or why not
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
