Here is a database:
Hotel (hotelNO, hotelName, city)
Room (roomNO, hotelNO, type, price)
Booking (hotelNO, guestNO, DateFrom, DateTo, roomNO)
Guest (guestNO, guestName, guestAddress)
Question: How do I write an SQL Query (mysql) that would give me "the average number of bookings for each type of room?"