Hello All..

I have a database which include those tables

Hotel(hotelno,hotelname,city)
guest(guestno,guestname,guestadress)
room(roomno,hotelno,type,price)
booking(hotelno,guestno,datefrom,dateto,roomno)

pks are underlined..

and i have to find those queries

1- find those guests who booked one room or more during this current month ?

2- find out the rooms no. with their hotels name which are empty (not booked) today (current day) ?

can anyone help me solving them ?