DELETE FROM reservation;
DELETE FROM sailor;
DELETE FROM boat;

INSERT INTO sailor (sname,rating) VALUES ('Leandra','12');
INSERT INTO sailor (sname,rating) VALUES ('Ross','14');
INSERT INTO sailor (sname,rating) VALUES ('Hedwig','6');
INSERT INTO sailor (sname,rating) VALUES ('Alika','17');
INSERT INTO sailor (sname,rating) VALUES ('Alexis','18');
INSERT INTO sailor (sname,rating) VALUES ('Macon','3');
INSERT INTO sailor (sname,rating) VALUES ('Rogan','20');
INSERT INTO sailor (sname,rating) VALUES ('Jenna','21');
INSERT INTO sailor (sname,rating) VALUES ('Wallace','19');
INSERT INTO sailor (sname,rating) VALUES ('Galena','17');
INSERT INTO sailor (sname,rating) VALUES ('Aurelia','22');
INSERT INTO sailor (sname,rating) VALUES ('Buffy','17');
INSERT INTO sailor (sname,rating) VALUES ('Hanae','27');
INSERT INTO sailor (sname,rating) VALUES ('Aristotle','8');
INSERT INTO sailor (sname,rating) VALUES ('Michelle','20');
INSERT INTO sailor (sname,rating) VALUES ('Abel','17');
INSERT INTO sailor (sname,rating) VALUES ('Benjamin','11');
INSERT INTO sailor (sname,rating) VALUES ('Alec','21');
INSERT INTO sailor (sname,rating) VALUES ('Claire','14');
INSERT INTO sailor (sname,rating) VALUES ('James','30');
INSERT INTO sailor (sname,rating) VALUES ('Basil','16');
INSERT INTO sailor (sname,rating) VALUES ('Caleb','12');
INSERT INTO sailor (sname,rating) VALUES ('Forrest','23');
INSERT INTO sailor (sname,rating) VALUES ('Cairo','18');
INSERT INTO sailor (sname,rating) VALUES ('Silas','21');
INSERT INTO sailor (sname,rating) VALUES ('Dylan','26');
INSERT INTO sailor (sname,rating) VALUES ('Vaughan','20');
INSERT INTO sailor (sname,rating) VALUES ('Vernon','1');
INSERT INTO sailor (sname,rating) VALUES ('Chelsea','13');
INSERT INTO sailor (sname,rating) VALUES ('Leo','11');

INSERT INTO boat VALUES ('Virginia','blue','10');
INSERT INTO boat VALUES ('North Carolina','violet','10');
INSERT INTO boat VALUES ('Massachusetts','green','13');
INSERT INTO boat VALUES ('Hawaii','green','27');
INSERT INTO boat VALUES ('Vermont','indigo','10');
INSERT INTO boat VALUES ('New Hampshire','yellow','10');
INSERT INTO boat VALUES ('Nevada','blue','19');
INSERT INTO boat VALUES ('Texas','indigo','21');
INSERT INTO boat VALUES ('Colorado','indigo','23');
INSERT INTO boat VALUES ('Kentucky','indigo','12');
INSERT INTO boat VALUES ('Alaska','yellow','24');
INSERT INTO boat VALUES ('Pennsylvania','yellow','15');
INSERT INTO boat VALUES ('South Dakota','red','28');
INSERT INTO boat VALUES ('Iowa','orange','17');
INSERT INTO boat VALUES ('Utah','green','14');
INSERT INTO boat VALUES ('Indiana','orange','19');
INSERT INTO boat VALUES ('New Jersey','yellow','24');
INSERT INTO boat VALUES ('Georgia','red','30');
INSERT INTO boat VALUES ('Louisiana','violet','10');
INSERT INTO boat VALUES ('Oregon','violet','27');
INSERT INTO boat VALUES ('Alabama','blue','29');
INSERT INTO boat VALUES ('Idaho','green','12');
INSERT INTO boat VALUES ('Maryland','indigo','10');
INSERT INTO boat VALUES ('Minnesota','blue','8');

INSERT INTO reservation (sname,bname,weekday,start,finish) VALUES ('Buffy','Idaho','Friday','0','15');
INSERT INTO reservation (sname,bname,weekday,start,finish) VALUES ('Leandra','Minnesota','Wednesday','4','11');
INSERT INTO reservation (sname,bname,weekday,start,finish) VALUES ('Abel','Nevada','Wednesday','6','2');
INSERT INTO reservation (sname,bname,weekday,start,finish) VALUES ('Hanae','South Dakota','Tuesday','14','16');
INSERT INTO reservation (sname,bname,weekday,start,finish) VALUES ('Vaughan','Hawaii','Wednesday','19','19');
INSERT INTO reservation (sname,bname,weekday,start,finish) VALUES ('Alec','Alabama','Saturday','0','13');
INSERT INTO reservation (sname,bname,weekday,start,finish) VALUES ('Leandra','Idaho','Saturday','3','6');
INSERT INTO reservation (sname,bname,weekday,start,finish) VALUES ('Vaughan','Idaho','Friday','22','12');
INSERT INTO reservation (sname,bname,weekday,start,finish) VALUES ('Basil','Pennsylvania','Sunday','15','22');
INSERT INTO reservation (sname,bname,weekday,start,finish) VALUES ('Rogan','Louisiana','Saturday','10','22');
INSERT INTO reservation (sname,bname,weekday,start,finish) VALUES ('Aristotle','Hawaii','Wednesday','3','13');
INSERT INTO reservation (sname,bname,weekday,start,finish) VALUES ('Macon','Kentucky','Wednesday','19','1');
INSERT INTO reservation (sname,bname,weekday,start,finish) VALUES ('Alika','North Carolina','Saturday','24','11');
INSERT INTO reservation (sname,bname,weekday,start,finish) VALUES ('Benjamin','Utah','Monday','24','14');
INSERT INTO reservation (sname,bname,weekday,start,finish) VALUES ('Basil','Louisiana','Wednesday','21','1');
INSERT INTO reservation (sname,bname,weekday,start,finish) VALUES ('Alika','Idaho','Wednesday','17','16');
INSERT INTO reservation (sname,bname,weekday,start,finish) VALUES ('Vaughan','Louisiana','Sunday','22','9');
INSERT INTO reservation (sname,bname,weekday,start,finish) VALUES ('Wallace','Texas','Sunday','11','17');
INSERT INTO reservation (sname,bname,weekday,start,finish) VALUES ('Forrest','Louisiana','Saturday','10','20');
INSERT INTO reservation (sname,bname,weekday,start,finish) VALUES ('Silas','North Carolina','Sunday','2','17');
INSERT INTO reservation (sname,bname,weekday,start,finish) VALUES ('Michelle','Nevada','Friday','5','1');
INSERT INTO reservation (sname,bname,weekday,start,finish) VALUES ('Macon','North Carolina','Friday','22','14');
INSERT INTO reservation (sname,bname,weekday,start,finish) VALUES ('Jenna','South Dakota','Friday','15','1');
INSERT INTO reservation (sname,bname,weekday,start,finish) VALUES ('Vaughan','South Dakota','Wednesday','18','4');
INSERT INTO reservation (sname,bname,weekday,start,finish) VALUES ('Michelle','South Dakota','Saturday','1','14');
INSERT INTO reservation (sname,bname,weekday,start,finish) VALUES ('Rogan','Kentucky','Tuesday','10','4');
INSERT INTO reservation (sname,bname,weekday,start,finish) VALUES ('Macon','Alaska','Friday','12','20');
INSERT INTO reservation (sname,bname,weekday,start,finish) VALUES ('Abel','Kentucky','Tuesday','13','24');
INSERT INTO reservation (sname,bname,weekday,start,finish) VALUES ('Alexis','Nevada','Monday','7','23');
INSERT INTO reservation (sname,bname,weekday,start,finish) VALUES ('Abel','Indiana','Wednesday','22','21');
INSERT INTO reservation (sname,bname,weekday,start,finish) VALUES ('Alexis','Pennsylvania','Saturday','9','21');
INSERT INTO reservation (sname,bname,weekday,start,finish) VALUES ('Galena','Pennsylvania','Wednesday','15','17');
INSERT INTO reservation (sname,bname,weekday,start,finish) VALUES ('Leandra','Alabama','Monday','9','8');
INSERT INTO reservation (sname,bname,weekday,start,finish) VALUES ('Leandra','North Carolina','Monday','15','18');
INSERT INTO reservation (sname,bname,weekday,start,finish) VALUES ('Abel','Oregon','Tuesday','3','11');
INSERT INTO reservation (sname,bname,weekday,start,finish) VALUES ('Vaughan','Oregon','Saturday','12','5');
INSERT INTO reservation (sname,bname,weekday,start,finish) VALUES ('Abel','Oregon','Friday','13','5');
INSERT INTO reservation (sname,bname,weekday,start,finish) VALUES ('Caleb','Virginia','Friday','23','14');
INSERT INTO reservation (sname,bname,weekday,start,finish) VALUES ('Forrest','Maryland','Thursday','20','16');
INSERT INTO reservation (sname,bname,weekday,start,finish) VALUES ('Abel','Colorado','Monday','10','17');
INSERT INTO reservation (sname,bname,weekday,start,finish) VALUES ('Chelsea','Utah','Sunday','1','23');
INSERT INTO reservation (sname,bname,weekday,start,finish) VALUES ('Caleb','Massachusetts','Tuesday','2','2');
INSERT INTO reservation (sname,bname,weekday,start,finish) VALUES ('Leandra','Maryland','Sunday','22','3');
INSERT INTO reservation (sname,bname,weekday,start,finish) VALUES ('Forrest','Virginia','Sunday','19','20');
INSERT INTO reservation (sname,bname,weekday,start,finish) VALUES ('Alec','Texas','Friday','8','1');
INSERT INTO reservation (sname,bname,weekday,start,finish) VALUES ('Alexis','Iowa','Thursday','6','14');
INSERT INTO reservation (sname,bname,weekday,start,finish) VALUES ('Abel','Iowa','Thursday','1','19');
INSERT INTO reservation (sname,bname,weekday,start,finish) VALUES ('Forrest','Oregon','Friday','17','19');
INSERT INTO reservation (sname,bname,weekday,start,finish) VALUES ('Hedwig','North Carolina','Saturday','23','17');
INSERT INTO reservation (sname,bname,weekday,start,finish) VALUES ('Hedwig','Pennsylvania','Wednesday','12','17');
INSERT INTO reservation (sname,bname,weekday,start,finish) VALUES ('Jenna','Kentucky','Sunday','7','21');
INSERT INTO reservation (sname,bname,weekday,start,finish) VALUES ('James','Idaho','Sunday','10','13');
INSERT INTO reservation (sname,bname,weekday,start,finish) VALUES ('James','Iowa','Wednesday','23','11');
INSERT INTO reservation (sname,bname,weekday,start,finish) VALUES ('Caleb','Oregon','Saturday','16','3');
INSERT INTO reservation (sname,bname,weekday,start,finish) VALUES ('Alec','Virginia','Friday','11','12');
INSERT INTO reservation (sname,bname,weekday,start,finish) VALUES ('Ross','Pennsylvania','Monday','8','7');
INSERT INTO reservation (sname,bname,weekday,start,finish) VALUES ('Vernon','Utah','Thursday','23','15');
INSERT INTO reservation (sname,bname,weekday,start,finish) VALUES ('Alexis','Georgia','Tuesday','4','22');
INSERT INTO reservation (sname,bname,weekday,start,finish) VALUES ('Basil','Louisiana','Wednesday','6','9');
INSERT INTO reservation (sname,bname,weekday,start,finish) VALUES ('Galena','Pennsylvania','Saturday','8','9');