create table Project (
	projectID INT,
	name TEXT,
	startDate DATE,
	endDate DATE,
	customerID INT,
	monthlyBudget INT,
	totalBudget INT,
	managerID INT
);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (1, 'sed', '10/9/2014', '8/25/2017', 38, 49820, 792647, 19);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (2, 'in', '1/17/2010', '11/11/2025', 76, 24859, 998271, 60);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (3, 'viverra pede', '4/9/2006', '9/5/2028', 54, 33895, 34589, 64);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (4, 'vestibulum velit', '8/7/2010', '12/9/2015', 32, 1801, 509569, 20);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (5, 'nulla', '3/24/2014', '2/24/2022', 73, 41551, 626713, 59);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (6, 'orci nullam', '11/29/2009', '10/25/2017', 85, 1540, 148181, 15);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (7, 'etiam', '12/1/2009', '10/3/2013', 82, 11655, 887742, 78);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (8, 'leo', '12/7/2009', '5/1/2007', 23, 43234, 914505, 91);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (9, 'in', '7/10/2008', '7/12/2006', 81, 34383, 469691, 69);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (10, 'ac', '4/19/2016', '12/22/2028', 17, 35618, 939504, 59);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (11, 'sodales', '5/26/2010', '9/11/2003', 44, 28009, 46144, 55);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (12, 'ac lobortis', '12/2/2016', '11/28/2023', 69, 7161, 797671, 57);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (13, 'maecenas tristique', '3/24/2005', '4/30/2012', 77, 18132, 24301, 3);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (14, 'in hac', '9/15/2018', '10/23/2027', 84, 36678, 903282, 32);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (15, 'bibendum', '6/19/2000', '10/31/2025', 92, 9436, 306957, 84);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (16, 'donec', '1/1/2004', '9/16/2003', 56, 34049, 159288, 66);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (17, 'est', '4/16/2006', '11/4/2026', 34, 10916, 455092, 28);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (18, 'primis', '6/25/2005', '7/29/2005', 98, 47379, 33546, 93);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (19, 'maecenas', '11/1/2018', '7/17/2019', 16, 11861, 605178, 96);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (20, 'enim', '7/14/2000', '10/19/2020', 100, 43178, 765182, 4);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (21, 'felis', '8/22/2016', '10/13/2005', 47, 21311, 760243, 63);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (22, 'ultrices', '6/27/2015', '5/29/2021', 74, 37510, 558397, 84);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (23, 'felis fusce', '6/2/2012', '11/17/2001', 41, 37384, 830354, 24);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (24, 'platea', '9/29/2017', '10/4/2003', 17, 40902, 643907, 6);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (25, 'nibh', '7/10/2019', '9/26/2023', 27, 23122, 913669, 14);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (26, 'odio', '6/7/2016', '8/2/2026', 22, 15929, 657794, 67);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (27, 'et', '8/26/2015', '8/11/2020', 99, 41236, 963359, 75);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (28, 'dui', '2/15/2013', '5/28/2021', 11, 45720, 795437, 7);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (29, 'montes nascetur', '11/29/2004', '6/4/2018', 6, 12535, 378336, 89);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (30, 'quis', '12/30/2014', '3/26/2000', 51, 41435, 955909, 70);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (31, 'vestibulum quam', '11/11/2001', '12/10/2019', 2, 14725, 468337, 15);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (32, 'tempus vivamus', '6/12/2011', '9/1/2020', 71, 22236, 914982, 6);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (33, 'ipsum aliquam', '2/16/2010', '5/27/2017', 65, 13426, 205781, 46);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (34, 'donec', '1/30/2001', '2/27/2010', 90, 13096, 867329, 96);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (35, 'ut at', '6/28/2004', '1/13/2005', 51, 36947, 714992, 59);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (36, 'nam', '2/13/2008', '8/10/2015', 80, 39665, 217948, 75);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (37, 'sapien arcu', '1/26/2013', '2/29/2016', 38, 11935, 743504, 93);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (38, 'pede', '6/25/2018', '11/27/2004', 43, 22964, 205731, 66);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (39, 'erat', '10/24/2007', '10/9/2013', 98, 45470, 771842, 44);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (40, 'augue', '2/14/2015', '1/14/2006', 43, 21221, 473730, 81);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (41, 'platea', '10/8/2003', '9/25/2023', 95, 1809, 720892, 9);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (42, 'integer a', '8/2/2007', '9/26/2007', 89, 21192, 924717, 100);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (43, 'eu interdum', '4/28/2011', '3/17/2019', 34, 46617, 419711, 90);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (44, 'vel nulla', '2/12/2004', '11/18/2014', 66, 20857, 499666, 9);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (45, 'eget massa', '12/23/2012', '10/26/2027', 95, 1970, 769011, 1);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (46, 'sapien a', '6/27/2006', '2/3/2010', 47, 17786, 640444, 62);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (47, 'felis eu', '1/19/2020', '7/17/2022', 81, 35454, 68161, 17);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (48, 'fusce lacus', '10/15/2001', '11/27/2007', 84, 13248, 88160, 64);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (49, 'id', '10/1/2013', '2/28/2014', 9, 20743, 507719, 2);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (50, 'laoreet', '9/4/2002', '9/25/2011', 84, 3108, 208853, 9);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (51, 'justo in', '5/6/2006', '10/15/2014', 26, 8682, 208463, 67);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (52, 'ac', '11/30/2019', '9/28/2028', 3, 19283, 50102, 25);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (53, 'tortor quis', '7/29/2013', '1/28/2022', 38, 36322, 88884, 82);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (54, 'turpis a', '5/8/2011', '1/29/2028', 95, 11467, 533027, 56);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (55, 'lectus', '7/2/2019', '5/27/2014', 28, 23980, 29179, 75);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (56, 'odio elementum', '6/26/2013', '3/15/2027', 67, 40995, 405915, 87);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (57, 'nec', '12/2/2008', '10/23/2003', 54, 49750, 231405, 61);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (58, 'eget', '9/11/2003', '11/18/2012', 84, 43786, 909128, 88);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (59, 'dui', '1/21/2006', '2/25/2005', 99, 14658, 149709, 85);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (60, 'integer', '11/15/2013', '5/2/2023', 87, 22905, 182578, 53);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (61, 'accumsan', '10/24/2009', '3/16/2011', 16, 18392, 409046, 50);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (62, 'primis', '3/4/2000', '7/29/2019', 40, 23556, 894981, 46);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (63, 'congue diam', '8/8/2007', '2/28/2014', 28, 11132, 793958, 27);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (64, 'morbi', '12/11/2006', '9/20/2006', 16, 38760, 313120, 67);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (65, 'vulputate vitae', '6/30/2018', '9/1/2015', 4, 11967, 637930, 34);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (66, 'hac habitasse', '6/13/2008', '11/25/2006', 89, 22862, 791129, 55);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (67, 'amet', '11/17/2016', '12/1/2009', 77, 43450, 674684, 89);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (68, 'morbi', '10/20/2017', '8/16/2028', 64, 21558, 107216, 94);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (69, 'sapien', '1/10/2012', '2/15/2015', 14, 48215, 671939, 74);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (70, 'justo', '3/16/2007', '10/10/2008', 88, 32243, 987563, 49);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (71, 'sagittis dui', '11/23/2004', '7/10/2001', 34, 2496, 875174, 17);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (72, 'in', '12/17/2014', '8/4/2001', 82, 46048, 593155, 39);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (73, 'maecenas', '11/14/2007', '6/15/2001', 45, 16717, 378654, 81);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (74, 'primis in', '12/16/2002', '5/31/2001', 100, 15993, 161287, 42);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (75, 'sodales', '10/26/2016', '11/15/2017', 66, 47543, 95712, 14);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (76, 'morbi non', '5/30/2003', '10/8/2006', 46, 36047, 852815, 21);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (77, 'eu', '1/1/2019', '5/29/2017', 63, 21814, 700298, 97);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (78, 'lobortis convallis', '10/1/2014', '8/19/2001', 29, 22450, 732375, 52);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (79, 'auctor sed', '2/21/2004', '6/21/2010', 63, 15352, 140458, 59);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (80, 'donec', '6/27/2013', '5/11/2007', 44, 17883, 937935, 26);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (81, 'cursus', '9/11/2018', '3/3/2016', 55, 38581, 916144, 18);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (82, 'morbi', '9/8/2013', '5/31/2027', 54, 44887, 396955, 78);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (83, 'blandit', '11/20/2012', '6/7/2008', 23, 34516, 431251, 59);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (84, 'elementum eu', '1/29/2008', '11/18/2016', 6, 6586, 951908, 92);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (85, 'donec dapibus', '8/7/2009', '9/22/2024', 47, 32168, 538024, 71);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (86, 'orci', '7/1/2012', '12/23/2006', 21, 36739, 831801, 13);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (87, 'dictumst', '2/4/2010', '3/8/2007', 87, 10291, 803270, 48);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (88, 'quam pede', '6/4/2007', '12/28/2012', 11, 11958, 890977, 54);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (89, 'non mattis', '2/18/2010', '8/18/2001', 7, 40677, 287246, 51);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (90, 'eget', '4/2/2005', '1/14/2021', 70, 2013, 592789, 48);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (91, 'in', '8/16/2010', '5/13/2027', 68, 27297, 872985, 39);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (92, 'eu magna', '6/12/2019', '11/5/2019', 52, 20205, 110090, 49);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (93, 'pede', '1/26/2011', '2/25/2018', 71, 11605, 744313, 47);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (94, 'quisque id', '10/18/2013', '3/6/2020', 42, 6486, 915441, 23);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (95, 'eget', '6/18/2008', '6/21/2023', 49, 5198, 536532, 56);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (96, 'ipsum praesent', '8/7/2017', '6/3/2008', 73, 2632, 120185, 53);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (97, 'sit', '4/28/2001', '12/14/2013', 25, 7757, 627441, 51);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (98, 'justo', '3/19/2010', '3/28/2026', 78, 22911, 243030, 30);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (99, 'lectus', '4/27/2013', '11/3/2021', 75, 10552, 971120, 44);
insert into Project (projectID, name, startDate, endDate, customerID, monthlyBudget, totalBudget, managerID) values (100, 'volutpat convallis', '8/18/2017', '9/8/2028', 81, 13311, 853269, 7);
