Information Technology Management
ITM 315 Homework 2 Spring 18 Due Friday, February 23, 1pm.
10 Points possible. Please submit via blackboard by the due date/time. Please remember that this is an individual assignment.
Using Access and the hotel spring 18, code the SQL for the following queries. Do not change any of the data in the database. Name the queries Query 1 through Query 6. Rename this database to include your last name (e.g., hotel spring 18 Fuller) and submit via blackboard.
Query 1: List the number of rooms in each hotel. You should display the name of the hotel and the count. Only display the hotels that have at least 5 rooms.
Query 2:Which guests (by first and last name and guest no) have booked rooms at the Hyatt for more than $90?
Q3: Which hotel (by name) has the highest rate booked?
Q4: Which hotels do not have rooms with standard rates less than $150
Q5: for each guest(by guest no) , which is the minimum rate at which they have booked rooms?
Q6: Which hotels (by name) have been booked by guestno 8? You must use a subquery for this question.