Please help me answer ALL PARTS of my homework for ITM-315-Database Systems

PLEASE WRITE THE QUIRES CODES FOR SQL USING MICROSOFT ACCESS and please write The "Select, from, where, join in, group by" in separet lines, and not all in one line so I don't get confused please. Thank you!

Instructions

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.

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?

Query 3: Which hotel (by name) has the highest rate booked

Query 4: Please list the hotel names

Query 5: for each guest(by guest no) , which is the minimum rate at which they have booked rooms?

Query 6: Which hotels (by name) have been booked by guestno 8? You must use a subquery for this question.

HOTEL SPRING 18 DATABASE

I ' room guest hotel All Access Obe.. O -booking ( hotelNo dateTo room No ratebooked Click to Add guestNo dateFrom 8/3/2016 2/1/2015 Tables 8/4/2016 2/6/2015 13/13/2016 3/15/2016 4 8/10/2014 2/8/2015 7/5/2016 3/1/2015 2/4/2015 6/4/2014 3/7/2015 23/10/2015 3/15/2015 2/6/2015 2/4/2014 9/8/2015 9/15/2015 3/9/2016 3/14/2016 2/2/2015 015 3/6/2016 3 3/26/20163/31/2016 13 5/12/2014 5/13/2014 2/8/2015 11 5/11/20145/12/2014 8 4/15/2016 4/18/2016 4/4/2015 4/4/2016 43/11/2016 3/15/2016 2/6/2015 2/7/2015 2/10/2015 9 4/15/2016 4/18/2016 33/22/2016 3/25/2016 15 2/24/2015 10 3/12/20143/13/2014 72 75 401 booking 101 guest 8/9/2014 2/3/2015 7/3/2016 12/28/2015 2/3/2015 11 5/31/2014 3/5/2015 hotel 10 room 12 101 100 100 100 100 100 110 110 2/4/2015 1/31/2014 308 401 10 2/1/2015 25/18/2015 5/23/2 219 3/4/2016 210 421 308 2/5/2015 140 4/1/2015 4/1/2016 160 160 160 214 412 2/5/2015 2/1/2015 2/6/2015 411 321 410 180 190 4 4 0 2/22/201 4 4