CREATE TABLE Game
(Name CHAR (20) PRIMARY KEY, MinPlayers INT, MaxPlayers INT, LengthOfGame INT, Complexity FLOAT);

CREATE TABLE Booking
(GameTableID INT, Name CHAR (20), BookedDate CHAR (8), StartTime INT, Customer CHAR (20), Hours INT);

INSERT INTO Game VALUES('Friday', 1, 1, 25, 2.12);
INSERT INTO Game VALUES('Scythe', 1, 5, 90, 3.37);
INSERT INTO Game VALUES('Terra Mystica', 2, 5, 100, 3.95);
INSERT INTO Game VALUES('Agricola', 1, 4, 90, 3.31);
INSERT INTO Game VALUES('Pandemic', 2, 4, 45, 2.42);

INSERT INTO Booking VALUES(1, 'Friday', '28/05/19', 11, 'Hawkins', 1);
INSERT INTO Booking VALUES(2, 'Scythe', '28/05/19', 11, 'Jemisin', 1);
INSERT INTO Booking VALUES(3, 'Pandemic', '28/05/19', 15, 'Gormally', 1);
INSERT INTO Booking VALUES(1, 'Pandemic', '28/05/19', 13, 'Van Perlo', 2);
INSERT INTO Booking VALUES(1, 'Terra Mystica', '29/05/19', 15, 'Hawkins', 2);