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.
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.
The following exercises:
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.