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 18Fuller) 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.
Attachment:- Hotel Database.rar