hello can use the code to solve this Queries 5.How many different guests have made bookings for August? 6.List the rooms

[answerhappygod]

hello can use the code to solve this Queries
5.How many different guests have made bookings for August?
6.List the rooms that are currently unoccupied at the Grosvenor
Hotel.
CREATE TABLE Hotel (
hotelNo VARCHAR(5) NOT NULL PRIMARY KEY,
hotelName VARCHAR(30),
city VARCHAR(40)
);
INSERT INTO Hotel (hotelNo, hotelName, city)
VALUES ('H1', 'Hyatt','Paris');
INSERT INTO Hotel (hotelNo, hotelName, city)
VALUES ('H2', 'Hilton','Paris');
INSERT INTO Hotel (hotelNo, hotelName, city)
VALUES ('H3', 'Grosvenor','London');
INSERT INTO Hotel (hotelNo, hotelName, city)
VALUES ('H4', 'Renaissance','London');
INSERT INTO Hotel (hotelNo, hotelName, city)
VALUES ('H5', 'Ritz-Carlton','seoul');
CREATE TABLE Room (
roomNo VARCHAR(5) NOT NULL,
hotelNo VARCHAR(5) NOT NULL,
roomType VARCHAR(20),
price INT,
PRIMARY KEY (roomNo, hotelNo),
FOREIGN KEY (hotelNo) REFERENCES Hotel (hotelNo)
);
INSERT INTO Room (roomNo, hotelNo, roomType, price)
VALUES ('R1', 'H4', 'Single', 40);
INSERT INTO Room (roomNo, hotelNo, roomType, price)
VALUES ('R2', 'H1', 'Double', 45);
INSERT INTO Room (roomNo, hotelNo, roomType, price)
VALUES ('R3', 'H2', 'Queen', 52);
INSERT INTO Room (roomNo, hotelNo, roomType, price)
VALUES ('R4', 'H3', 'King', 50);
INSERT INTO Room (roomNo, hotelNo, roomType, price)
VALUES ('R5', 'H3', 'Quad', 42);
INSERT INTO Room (roomNo, hotelNo, roomType, price)
VALUES ('R6', 'H2', 'Single', 20);
INSERT INTO Room (roomNo, hotelNo, roomType, price)
VALUES ('R7', 'H2', 'Double', 25);
INSERT INTO Room (roomNo, hotelNo, roomType, price)
VALUES ('R8', 'H1', 'King', 60);
INSERT INTO Room (roomNo, hotelNo, roomType, price)
VALUES ('R9', 'H2', 'king', 55);
CREATE TABLE Guest (
guestNo VARCHAR(5) NOT NULL PRIMARY KEY,
guestName VARCHAR(30),
guestAddress VARCHAR(100)
);
INSERT INTO Guest (guestNo, guestName, guestAddress)
VALUES ('G1', 'John Smith', '111 Perthshire Rd.London');
INSERT INTO Guest (guestNo, guestName, guestAddress)
VALUES ('G2', 'Mary Kim', '456 Main St.Houston');
INSERT INTO Guest (guestNo, guestName, guestAddress)
VALUES ('G3', 'Terry Brown', '235 Holleman Dr.Paris');
INSERT INTO Guest (guestNo, guestName, guestAddress)
VALUES ('G4', 'Michael Johnson', '980 Ball St.New York');
CREATE TABLE Booking (
hotelNo VARCHAR(5) NOT NULL,
guestNo VARCHAR(5) NOT NULL,
dateFrom DATE NOT NULL,
dateTo DATE,
roomNo VARCHAR(5) NOT NULL,
PRIMARY KEY (hotelNo, guestNo, dateFrom),
FOREIGN KEY (hotelNo) REFERENCES Hotel (hotelNo),
FOREIGN KEY (guestNo) REFERENCES Guest (guestNo),
FOREIGN KEY (roomNo) REFERENCES Room (roomNo)
);
INSERT INTO Booking (hotelNo, guestNo, dateFrom, dateTo,
roomNo)
VALUES ('H3', 'G1', '2016-1-1', '2016-1-7', 'R4');
INSERT INTO Booking (hotelNo, guestNo, dateFrom, dateTo,
roomNo)
VALUES ('H2', 'G2', '2018-7-25', '2018-8-2', 'R6');
INSERT INTO Booking (hotelNo, guestNo, dateFrom, dateTo,
roomNo)
VALUES ('H3', 'G2', '2017-5-1', '2017-5-10', 'R5');
INSERT INTO Booking (hotelNo, guestNo, dateFrom, dateTo,
roomNo)
VALUES ('H4', 'G1', '2016-12-10', '2016-12-15', 'R1');