Count the number of current bookings at each hotel and display with the hotel name and city. List only the hotels with at least 5 current bookings.

Format: (# of bookings, hotel name, city)

database:

CREATE TABLE HOTEL

(

hotelNo INT NOT NULL,

hotelName VARCHAR(50),

City VARCHAR(50),

primary key (hotelNo)

);

CREATE TABLE ROOM

(

roomNo INT NOT NULL,

H_hotelNo INT NOT NULL,

roomType CHAR(10),

price decimal(5,2),

primary key (roomNo, H_hotelNo),

foreign key (H_hotelNo) REFERENCES HOTEL(hotelNo),

CHECK (price >= 50.00),

CHECK (price <= 500.00),

CHECK (roomType = 'Single' OR roomType = 'Double' OR roomType = 'Standard'),

CHECK (RoomNo >= 1),

CHECK (RoomNo <= 9999)

);

CREATE TABLE BOOKING

(

H_hotelNo INT NOT NULL,

G_guestNo INT NOT NULL,

dateFrom DATE NOT NULL,

dateTo DATE,

R_roomNo INT NOT NULL,

primary key (H_hotelNo, G_guestNo, dateFrom, R_roomNo),

foreign key (H_hotelNo) REFERENCES HOTEL(hotelNo),

foreign key (G_guestNo) REFERENCES GUEST(guestNo),

foreign key (R_roomNo) REFERENCES ROOM(roomNo),

CHECK (dateFrom < dateTo)

);

CREATE TABLE GUEST

(

guestNo INT NOT NULL,

guestName CHAR(100),

guestAddress VARCHAR(100),

primary key (guestNo),

unique (guestName)

);