The following tables form part of a database held in a relational DBMS: $-$

Hotel $($hotelNo$,$ hotelName, city$)$

Room $($roomNo$,$ hotelNo, type, price$)$

Booking $($hotelNo$,$ guestNo, dateFrom, dateTo, roomNo$)$

Guest $($guestNo$,$ guestName, guestAddress$)$

where Hotel contains hotel details and hotelNo is the primary key;

Room contains room details for each hotel and $($roomNo$,$ hotelNo$)$ forms the primary key;

Booking contains details of the bookings and $($hotelNo$,$ guestNo, dateFrom$)$ forms the primary key;

and Guest contains guest details and guestNo is the primary key.

Given the above schema, write SQL statements for the following queries:

$1)$ List the price and type of all rooms at the Grosvenor Hotel.

$2)$ List the number of rooms in each hotel in London.

$3)$ List the names of all guests who have made a room booking between $1-$Jan$-2018$ and $31-12-2018$ but eliminate duplicates in the listing. Hint: you will need to the keyword DISTINCT.

$4)$ List the names of all the guests who are currently staying at the Grosvenor Hotel.