General Instructions

1. Please submit this homework in an ascii text file named hw1.txt, with each exercise clearly marked. For example:

   6.7 SELECT * FROM Hotel;
   
   6.9 SELECT GuestName, GuestAddress FROM Guest
          WHERE GuestAddress LIKE '%London%';
   

   We will be creating our own test data, then copying and pasting your answers into the mysql interpreter.

1. Use the Hotel.sql file that is included with this homework assignment to create the hotel tables from the Hotel Schema example at the end of Chapter 4. The Hotel.sql file also contains some sample data. You can use these tables to test your queries in part 2 of this problem.

2. The following exercises:
   • 6.8
   • 6.10
   • 6.12
   • 6.14
   • 6.16
   • 6.19-The problem description means take the sum of all currently occupied rooms in the Gransoveter Hotel. Do not hard code the Gransoveter Hotel's id into your query. It is unreasonable to expect an end user, which is what you should assume you are, to know the id of the Gransoveter Hotel. Use the name of the hotel in the query.
   • 6.22
   • 6.23
   • 6.28