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