help in SQL simple queries ?

[GaryMazzone]

This was my go at it in SQL Server:

1:

SELECT 
    GuestName,Count(Booking.*)
FROM 
    Guest 
INNER JOIN Booking 
    ON Booking.Guestno = Guest.GuestNo
WHERE 
    (MONTH(Booking.DateFrom) = MONTH(GETDATE()) AND YEAR(Booking.DateFrom) = YEAR(GETDATE())
    OR 
    (MONTH(Booking.DateTo) = MONTH(GETDATE()) AND YEAR(Booking.DateTo) = YEAR(GETDATE())

2:

SELECT 
    Hotel.HotelName,
    Hotel.City,
    Room.RoomNo,
    Room.Type
FROM HOTEL
INNER JOIN ROOM
    ON HOTEL.HotelNo = Room.HotelNo
LEFT OUTER JOIN BOOKING
    ON Room.RoomNo = Booking.RoomNo
WHERE 
    GETDATE() BETWEEN Booking.DateFrom AND Booking.DateTo
    AND Booking.RoomNo IS NULL