Part_2_Insertion.sql

insert into Theater_Company (company_id, company_name, revenues, expenditures) values (1, 'Mosciski-Blick', 229588, 485099);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (2, 'Macejkovic-Carter', 434489, 790812);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (3, 'Wilkinson Inc', 890455, 66600);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (4, 'Orn-Fadel', 516787, 791145);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (5, 'Wintheiser, Hamill and Kris', 813497, 158212);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (6, 'Macejkovic-Konopelski', 632112, 21084);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (7, 'Littel Inc', 77551, 519337);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (8, 'Batz, Leannon and Doyle', 645047, 846142);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (9, 'Hodkiewicz, Dietrich and Goldner', 409324, 217593);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (10, 'Zboncak, Purdy and Beier', 898683, 529732);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (11, 'Schmidt Group', 90057, 7386);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (12, 'Hartmann LLC', 626429, 986834);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (13, 'Ondricka, Kautzer and Leffler', 20547, 574762);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (14, 'Herzog, Wiegand and Auer', 938271, 739575);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (15, 'Pfeffer-Satterfield', 837240, 275306);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (16, 'Smith-Schowalter', 163720, 878195);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (17, 'Schmidt-Wiza', 152918, 543274);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (18, 'Sauer, Haley and Schiller', 56993, 697882);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (19, 'Renner-Streich', 256304, 869214);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (20, 'Reinger-Sipes', 941143, 541512);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (21, 'Effertz Group', 930614, 789231);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (22, 'Heaney-Dicki', 395084, 991636);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (23, 'Fisher, Barton and Kreiger', 647566, 584215);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (24, 'Hauck LLC', 377944, 786405);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (25, 'Bradtke Group', 266697, 207003);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (26, 'Collier-Lynch', 830952, 31037);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (27, 'Parker and Sons', 645947, 617901);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (28, 'Maggio, Hintz and Krajcik', 816012, 688540);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (29, 'Von and Sons', 979379, 498508);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (30, 'Kohler, Cruickshank and Conn', 500722, 125042);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (31, 'Keebler Inc', 496553, 141731);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (32, 'Bosco-Orn', 725145, 352857);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (33, 'Gulgowski-Pacocha', 425044, 274378);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (34, 'Reichert, Hand and Hammes', 909395, 867086);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (35, 'Daugherty and Sons', 613944, 214492);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (36, 'Douglas, Pouros and Christiansen', 5310, 907351);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (37, 'Labadie-Blanda', 26598, 874078);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (38, 'King-Klein', 167785, 744369);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (39, 'Mayer-Jaskolski', 817140, 794706);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (40, 'Abernathy and Sons', 753311, 883460);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (41, 'Turcotte-Grimes', 108659, 743416);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (42, 'Schneider-Rowe', 504721, 294359);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (43, 'Stroman-Kiehn', 916334, 423378);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (44, 'Hagenes LLC', 780977, 266936);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (45, 'Lockman-Konopelski', 675390, 218290);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (46, 'Kovacek-Morar', 302243, 504974);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (47, 'Marquardt-Jones', 259327, 393505);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (48, 'Hayes, Lubowitz and Kiehn', 201214, 505717);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (49, 'Fay, Kiehn and Reilly', 221327, 384452);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (50, 'Mertz, Feil and Vandervort', 93927, 108156);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (51, 'Kemmer Group', 884350, 353380);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (52, 'Harber-Trantow', 917547, 262567);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (53, 'Connelly-Feest', 373140, 47277);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (54, 'Schmidt and Sons', 31845, 114627);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (55, 'Parisian LLC', 778644, 804300);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (56, 'Emmerich, Hilpert and Moen', 226464, 329826);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (57, 'Bechtelar, Rempel and Kub', 805551, 541015);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (58, 'Hudson Inc', 847115, 408394);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (59, 'Koch LLC', 386878, 704931);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (60, 'Schuster-Maggio', 853618, 876270);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (61, 'Boyle Inc', 445966, 947037);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (62, 'Altenwerth and Sons', 200963, 311328);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (63, 'Mohr Inc', 460225, 448398);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (64, 'Schulist, Klein and Mueller', 814280, 656051);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (65, 'Johnson, Hickle and Emmerich', 71059, 563503);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (66, 'Blick LLC', 348847, 44040);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (67, 'Wiegand Group', 62058, 470865);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (68, 'Walter, Wintheiser and Hahn', 446331, 816176);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (69, 'Denesik-Rosenbaum', 283712, 272907);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (70, 'Padberg-Miller', 879341, 744412);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (71, 'Casper Group', 283190, 427416);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (72, 'Heathcote Inc', 103439, 434533);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (73, 'Mayer, Corkery and Ernser', 502687, 841954);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (74, 'McDermott-O''Hara', 986393, 195538);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (75, 'King, Schaden and Cartwright', 883202, 978963);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (76, 'Effertz-Veum', 692648, 977583);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (77, 'Blick Group', 524584, 534977);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (78, 'Ondricka LLC', 223598, 686297);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (79, 'D''Amore, Schaden and Kub', 938017, 201527);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (80, 'Mann-Zulauf', 83978, 371880);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (81, 'Bartoletti, Lind and Dicki', 196281, 815124);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (82, 'Lehner-Schmeler', 871458, 517616);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (83, 'Douglas-Cummerata', 29123, 115040);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (84, 'Reynolds-Bailey', 344238, 579057);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (85, 'Baumbach Group', 396890, 990410);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (86, 'McCullough Inc', 251190, 664505);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (87, 'Murazik, Grant and Casper', 503810, 650409);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (88, 'White and Sons', 588214, 143482);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (89, 'Hessel-Rau', 134200, 856867);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (90, 'Gutkowski, Stamm and Ward', 427848, 262851);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (91, 'Purdy-Keebler', 166546, 208784);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (92, 'Gutkowski, Jast and Champlin', 765133, 640669);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (93, 'Olson, Koepp and Pfannerstill', 928232, 593435);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (94, 'Bashirian Inc', 816056, 719573);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (95, 'Auer LLC', 419206, 422983);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (96, 'Dickens, Pfeffer and Monahan', 724099, 111525);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (97, 'Jakubowski, O''Kon and Wiza', 338923, 877556);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (98, 'Block, Welch and Maggio', 699130, 23288);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (99, 'Zboncak and Sons', 788946, 118607);
insert into Theater_Company (company_id, company_name, revenues, expenditures) values (100, 'Turner LLC', 474813, 415962);


insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (1, 'Emard-Sanford', 163, 'Mocupe', 1);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (2, 'Bosco, Green and Stamm', 253, 'Schäffern', 2);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (3, 'Little-Mertz', 295, 'Lansing', 3);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (4, 'Leffler-Gutmann', 162, 'Ústí nad Orlicí', 4);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (5, 'DuBuque-Mante', 26, 'Shāhīn Dezh', 5);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (6, 'DuBuque, Anderson and Quitzon', 326, 'Dandai', 6);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (7, 'Heller Group', 998, 'Kut Bak', 7);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (8, 'Block LLC', 821, 'Rychwał', 8);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (9, 'Paucek-Weissnat', 157, 'Samokov', 9);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (10, 'Bradtke, Volkman and Cronin', 896, 'Shazhouba', 10);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (11, 'Bechtelar-Reynolds', 873, 'Koshki', 11);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (12, 'Auer, Howe and Keeling', 4, 'Santa Cruz do Capibaribe', 12);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (13, 'Satterfield and Sons', 987, 'Mtambile', 13);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (14, 'Johns-Haley', 959, 'Owode', 14);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (15, 'Connelly Group', 263, 'Vila Pouca da Beira', 15);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (16, 'Muller-Ritchie', 984, 'Säffle', 16);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (17, 'Raynor, Feest and O''Connell', 82, 'Veles', 17);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (18, 'Wehner-Rippin', 426, 'Hedian', 18);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (19, 'Fahey-Kuhlman', 374, 'Lama', 19);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (20, 'Adams Inc', 430, 'Krupanj', 20);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (21, 'Fadel, Leannon and Daugherty', 488, 'Voloka', 21);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (22, 'Hamill, O''Connell and Powlowski', 491, 'Kaburon', 22);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (23, 'Koch-Gislason', 363, 'Zavolzh’ye', 23);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (24, 'Mann and Sons', 689, 'Yima', 24);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (25, 'Frami, Zboncak and Walsh', 473, 'Bystřice nad Pernštejnem', 25);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (26, 'Kozey, Cummings and Stoltenberg', 238, 'Birayang', 26);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (27, 'Langworth-VonRueden', 957, 'Quillabamba', 27);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (28, 'Bernhard and Sons', 499, 'Malitubog', 28);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (29, 'Stehr-Nicolas', 11, 'Ajasse Ipo', 29);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (30, 'Larson LLC', 440, 'Guamal', 30);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (31, 'Feest LLC', 767, 'Sadananya', 31);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (32, 'Pagac LLC', 336, 'Burqah', 32);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (33, 'Murphy-Bins', 865, 'Hesperange', 33);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (34, 'Langworth, Schiller and Schultz', 191, 'Fastiv', 34);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (35, 'Mraz, Yost and Mraz', 97, 'Cedynia', 35);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (36, 'Hand LLC', 504, 'Bŭka', 36);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (37, 'Connelly-Kreiger', 242, 'Gorskaya', 37);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (38, 'Little LLC', 55, 'Paitan Este', 38);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (39, 'Hamill-Mueller', 640, 'Metz', 39);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (40, 'Cummerata, Cummings and Monahan', 749, 'Tsagaan-Ovoo', 40);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (41, 'Abernathy, Brown and Adams', 951, 'Pilang', 41);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (42, 'Borer and Sons', 522, 'Shtip', 42);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (43, 'Walsh, O''Connell and Bruen', 815, 'Haveliān', 43);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (44, 'Gerhold-Jones', 563, 'Lākshām', 44);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (45, 'Bashirian, Barton and Schinner', 8, 'Växjö', 45);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (46, 'Kihn-Barton', 272, 'Huai Yot', 46);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (47, 'Rodriguez and Sons', 187, 'Saint-Jean-de-Braye', 47);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (48, 'Skiles-Wisoky', 131, 'Gaojian', 48);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (49, 'Kozey-Dicki', 443, 'Vítkov', 49);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (50, 'Hilpert and Sons', 448, 'Sel’tso', 50);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (51, 'Muller, Pouros and Kunde', 608, 'Sembakung', 51);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (52, 'Murphy, Wilkinson and Dibbert', 622, 'Calinaoan Malasin', 52);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (53, 'Lockman-Koch', 708, 'Lowayu', 53);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (54, 'Wunsch, Lowe and Hoeger', 264, 'Naagas', 54);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (55, 'Williamson, Renner and McGlynn', 703, 'Shijing', 55);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (56, 'Stracke Inc', 584, 'Saint-Maurice-l''Exil', 56);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (57, 'Anderson-Harber', 977, 'Sacramento', 57);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (58, 'Koepp LLC', 484, 'Sarrazola', 58);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (59, 'Kuvalis LLC', 575, 'Kokembang', 59);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (60, 'Zulauf and Sons', 70, 'Sunan', 60);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (61, 'Gleichner-Altenwerth', 174, 'Balzan', 61);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (62, 'Rice and Sons', 935, 'General Villegas', 62);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (63, 'Connelly-Fadel', 457, 'Kuwumkumambal', 63);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (64, 'Hane Inc', 212, 'Urambo', 64);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (65, 'Prohaska-Jast', 218, 'Kanshan', 65);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (66, 'Batz Inc', 967, 'Selkirk', 66);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (67, 'Kozey Group', 710, 'Kopparberg', 67);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (68, 'Kirlin, Shanahan and Kuvalis', 559, 'Gibbons', 68);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (69, 'Price, Harber and Stehr', 93, 'Anping', 69);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (70, 'Weimann-Abernathy', 927, 'Bagong Sikat', 70);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (71, 'Prohaska, King and Roberts', 598, 'Rojas', 71);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (72, 'Rau, Swift and Shields', 930, 'Maca', 72);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (73, 'Dibbert, Tromp and Thompson', 834, 'Sinjai', 73);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (74, 'Halvorson, Homenick and Grimes', 817, 'Jiangkouxu', 74);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (75, 'Ryan-Skiles', 379, 'La Laja', 75);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (76, 'Ward and Sons', 3, 'Nanyulinxi', 76);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (77, 'Thiel-Barton', 324, 'Goiana', 77);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (78, 'Vandervort, Will and Bartoletti', 211, 'Puputan', 78);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (79, 'Dicki-Gottlieb', 130, 'Shenzhengqiao', 79);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (80, 'Collins LLC', 440, 'Hamilton', 80);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (81, 'Schroeder, Bayer and Vandervort', 509, 'Palatine', 81);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (82, 'Wuckert, Funk and Kunde', 288, 'Tualangcut', 82);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (83, 'Murazik, Haag and Medhurst', 544, 'Uliastay', 83);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (84, 'Harber, Leannon and McDermott', 643, 'Bāgh-e Maīdān', 84);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (85, 'Swift-Hansen', 908, 'Ōtsuki', 85);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (86, 'Deckow, Hoeger and Monahan', 379, 'Barueri', 86);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (87, 'Goldner, Batz and Von', 97, 'Pagelaran', 87);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (88, 'Harvey Group', 708, 'Liyuan', 88);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (89, 'Labadie LLC', 15, 'Santa Valha', 89);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (90, 'Gutkowski-McLaughlin', 887, 'Oxelösund', 90);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (91, 'O''Keefe Group', 591, 'Shidu', 91);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (92, 'Heller, Mayert and Tillman', 745, 'Nedakonice', 92);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (93, 'McDermott, Kassulke and Nikolaus', 37, 'Umm Şalāl ‘Alī', 93);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (94, 'Beer-Murray', 106, 'Victoria', 94);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (95, 'Blanda LLC', 3, 'Alurbulu', 95);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (96, 'Hane, Cronin and Bartell', 678, 'Hua Hin', 96);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (97, 'Walker-Parker', 968, 'Nanuque', 97);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (98, 'Kshlerin, Auer and Wunsch', 984, 'Folques', 98);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (99, 'Reinger, Cormier and Beer', 714, 'Sparks', 99);
insert into Theater_Room (hall_id, room_name, capacite, localisation, company_id) values (100, 'Walker, McLaughlin and Hahn', 85, 'Lukashin', 100);

insert into Production (production_id, prod_description, company_id) values (1, '', 1);
insert into Production (production_id, prod_description, company_id) values (2, '', 2);
insert into Production (production_id, prod_description, company_id) values (3, '', 3);
insert into Production (production_id, prod_description, company_id) values (4, '', 4);
insert into Production (production_id, prod_description, company_id) values (5, '', 5);
insert into Production (production_id, prod_description, company_id) values (6, '', 6);
insert into Production (production_id, prod_description, company_id) values (7, '', 7);
insert into Production (production_id, prod_description, company_id) values (8, '', 8);
insert into Production (production_id, prod_description, company_id) values (9, '', 9);
insert into Production (production_id, prod_description, company_id) values (10, '', 10);
insert into Production (production_id, prod_description, company_id) values (11, '', 11);
insert into Production (production_id, prod_description, company_id) values (12, '', 12);
insert into Production (production_id, prod_description, company_id) values (13, '', 13);
insert into Production (production_id, prod_description, company_id) values (14, '', 14);
insert into Production (production_id, prod_description, company_id) values (15, '', 15);
insert into Production (production_id, prod_description, company_id) values (16, '', 16);
insert into Production (production_id, prod_description, company_id) values (17, '', 17);
insert into Production (production_id, prod_description, company_id) values (18, '', 18);
insert into Production (production_id, prod_description, company_id) values (19, '', 19);
insert into Production (production_id, prod_description, company_id) values (20, '', 20);
insert into Production (production_id, prod_description, company_id) values (21, '', 21);
insert into Production (production_id, prod_description, company_id) values (22, '', 22);
insert into Production (production_id, prod_description, company_id) values (23, '', 23);
insert into Production (production_id, prod_description, company_id) values (24, '', 24);
insert into Production (production_id, prod_description, company_id) values (25, '', 25);
insert into Production (production_id, prod_description, company_id) values (26, '', 26);
insert into Production (production_id, prod_description, company_id) values (27, '', 27);
insert into Production (production_id, prod_description, company_id) values (28, '', 28);
insert into Production (production_id, prod_description, company_id) values (29, '', 29);
insert into Production (production_id, prod_description, company_id) values (30, '', 30);
insert into Production (production_id, prod_description, company_id) values (31, '', 31);
insert into Production (production_id, prod_description, company_id) values (32, '', 32);
insert into Production (production_id, prod_description, company_id) values (33, '', 33);
insert into Production (production_id, prod_description, company_id) values (34, '', 34);
insert into Production (production_id, prod_description, company_id) values (35, '', 35);
insert into Production (production_id, prod_description, company_id) values (36, '', 36);
insert into Production (production_id, prod_description, company_id) values (37, '', 37);
insert into Production (production_id, prod_description, company_id) values (38, '', 38);
insert into Production (production_id, prod_description, company_id) values (39, '', 39);
insert into Production (production_id, prod_description, company_id) values (40, '', 40);
insert into Production (production_id, prod_description, company_id) values (41, '', 41);
insert into Production (production_id, prod_description, company_id) values (42, '', 42);
insert into Production (production_id, prod_description, company_id) values (43, '', 43);
insert into Production (production_id, prod_description, company_id) values (44, '', 44);
insert into Production (production_id, prod_description, company_id) values (45, '', 45);
insert into Production (production_id, prod_description, company_id) values (46, '', 46);
insert into Production (production_id, prod_description, company_id) values (47, '', 47);
insert into Production (production_id, prod_description, company_id) values (48, '', 48);
insert into Production (production_id, prod_description, company_id) values (49, '', 49);
insert into Production (production_id, prod_description, company_id) values (50, '', 50);
insert into Production (production_id, prod_description, company_id) values (51, '', 51);
insert into Production (production_id, prod_description, company_id) values (52, '', 52);
insert into Production (production_id, prod_description, company_id) values (53, '', 53);
insert into Production (production_id, prod_description, company_id) values (54, '', 54);
insert into Production (production_id, prod_description, company_id) values (55, '', 55);
insert into Production (production_id, prod_description, company_id) values (56, '', 56);
insert into Production (production_id, prod_description, company_id) values (57, '', 57);
insert into Production (production_id, prod_description, company_id) values (58, '', 58);
insert into Production (production_id, prod_description, company_id) values (59, '', 59);
insert into Production (production_id, prod_description, company_id) values (60, '', 60);
insert into Production (production_id, prod_description, company_id) values (61, '', 61);
insert into Production (production_id, prod_description, company_id) values (62, '', 62);
insert into Production (production_id, prod_description, company_id) values (63, '', 63);
insert into Production (production_id, prod_description, company_id) values (64, '', 64);
insert into Production (production_id, prod_description, company_id) values (65, '', 65);
insert into Production (production_id, prod_description, company_id) values (66, '', 66);
insert into Production (production_id, prod_description, company_id) values (67, '', 67);
insert into Production (production_id, prod_description, company_id) values (68, '', 68);
insert into Production (production_id, prod_description, company_id) values (69, '', 69);
insert into Production (production_id, prod_description, company_id) values (70, '', 70);
insert into Production (production_id, prod_description, company_id) values (71, '', 71);
insert into Production (production_id, prod_description, company_id) values (72, '', 72);
insert into Production (production_id, prod_description, company_id) values (73, '', 73);
insert into Production (production_id, prod_description, company_id) values (74, '', 74);
insert into Production (production_id, prod_description, company_id) values (75, '', 75);
insert into Production (production_id, prod_description, company_id) values (76, '', 76);
insert into Production (production_id, prod_description, company_id) values (77, '', 77);
insert into Production (production_id, prod_description, company_id) values (78, '', 78);
insert into Production (production_id, prod_description, company_id) values (79, '', 79);
insert into Production (production_id, prod_description, company_id) values (80, '', 80);
insert into Production (production_id, prod_description, company_id) values (81, '', 81);
insert into Production (production_id, prod_description, company_id) values (82, '', 82);
insert into Production (production_id, prod_description, company_id) values (83, '', 83);
insert into Production (production_id, prod_description, company_id) values (84, '', 84);
insert into Production (production_id, prod_description, company_id) values (85, '', 85);
insert into Production (production_id, prod_description, company_id) values (86, '', 86);
insert into Production (production_id, prod_description, company_id) values (87, '', 87);
insert into Production (production_id, prod_description, company_id) values (88, '', 88);
insert into Production (production_id, prod_description, company_id) values (89, '', 89);
insert into Production (production_id, prod_description, company_id) values (90, '', 90);
insert into Production (production_id, prod_description, company_id) values (91, '', 91);
insert into Production (production_id, prod_description, company_id) values (92, '', 92);
insert into Production (production_id, prod_description, company_id) values (93, '', 93);
insert into Production (production_id, prod_description, company_id) values (94, '', 94);
insert into Production (production_id, prod_description, company_id) values (95, '', 95);
insert into Production (production_id, prod_description, company_id) values (96, '', 96);
insert into Production (production_id, prod_description, company_id) values (97, '', 97);
insert into Production (production_id, prod_description, company_id) values (98, '', 98);
insert into Production (production_id, prod_description, company_id) values (99, '', 99);
insert into Production (production_id, prod_description, company_id) values (100, '', 100);


insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (1, 676774, 19, 645);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (2, 721485, 3, 878);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (3, 626686, 22, 531);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (4, 297286, 43, 717);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (5, 425932, 17, 959);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (6, 841067, 37, 474);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (7, 188720, 29, 888);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (8, 735069, 28, 702);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (9, 350556, 13, 591);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (10, 690771, 44, 456);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (11, 550343, 35, 401);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (12, 737415, 18, 395);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (13, 863765, 13, 750);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (14, 682946, 39, 990);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (15, 657502, 12, 861);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (16, 763220, 17, 819);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (17, 920400, 17, 509);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (18, 994152, 36, 531);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (19, 7248, 45, 521);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (20, 222430, 7, 863);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (21, 577591, 44, 740);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (22, 994647, 47, 387);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (23, 854389, 24, 956);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (24, 30025, 1, 722);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (25, 689487, 46, 510);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (26, 429406, 8, 762);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (27, 763144, 1, 686);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (28, 855473, 44, 673);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (29, 429954, 31, 672);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (30, 40913, 45, 958);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (31, 837793, 30, 790);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (32, 833487, 4, 824);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (33, 315148, 23, 647);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (34, 782452, 2, 502);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (35, 688614, 46, 416);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (36, 193366, 9, 613);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (37, 401965, 30, 889);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (38, 429545, 33, 437);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (39, 128776, 46, 671);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (40, 978464, 32, 897);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (41, 989300, 43, 601);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (42, 57824, 8, 448);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (43, 598712, 39, 504);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (44, 421002, 49, 352);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (45, 176438, 5, 791);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (46, 329732, 34, 688);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (47, 869793, 4, 716);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (48, 876152, 7, 636);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (49, 507738, 38, 960);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (50, 364756, 49, 551);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (51, 880533, 17, 598);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (52, 158624, 12, 832);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (53, 61703, 21, 429);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (54, 457476, 45, 869);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (55, 195638, 50, 590);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (56, 941126, 45, 496);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (57, 414771, 34, 710);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (58, 85923, 5, 938);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (59, 485104, 27, 818);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (60, 94041, 13, 489);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (61, 100481, 42, 532);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (62, 755559, 49, 439);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (63, 878446, 31, 950);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (64, 828703, 30, 559);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (65, 546434, 50, 310);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (66, 889623, 36, 646);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (67, 438870, 35, 620);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (68, 682692, 39, 714);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (69, 104306, 17, 948);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (70, 180370, 22, 478);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (71, 720797, 9, 836);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (72, 691091, 43, 447);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (73, 430915, 16, 415);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (74, 838949, 35, 400);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (75, 771937, 43, 316);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (76, 580150, 36, 770);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (77, 937449, 50, 576);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (78, 257467, 44, 633);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (79, 497877, 50, 875);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (80, 898579, 42, 655);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (81, 406927, 43, 841);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (82, 792544, 11, 865);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (83, 471838, 22, 633);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (84, 996947, 1, 791);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (85, 90866, 24, 746);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (86, 381351, 7, 553);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (87, 369980, 48, 348);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (88, 279755, 14, 836);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (89, 598774, 10, 381);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (90, 738474, 10, 430);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (91, 604666, 40, 529);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (92, 861417, 24, 388);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (93, 815911, 4, 718);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (94, 267308, 17, 377);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (95, 105593, 38, 764);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (96, 775665, 9, 724);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (97, 815427, 8, 546);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (98, 965353, 3, 417);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (99, 864777, 44, 763);
insert into Show (show_id, production_costs, nb_actors, capacity_tickets_available) values (100, 581932, 49, 910);

insert into performs (hall_id, show_id, production_id, date_show) values (1, 1, 1, '02-Sep-2021');
insert into performs (hall_id, show_id, production_id, date_show) values (2, 2, 2, '12-May-2021');
insert into performs (hall_id, show_id, production_id, date_show) values (3, 3, 3, '20-Sep-2021');
insert into performs (hall_id, show_id, production_id, date_show) values (4, 4, 4, '18-Feb-2021');
insert into performs (hall_id, show_id, production_id, date_show) values (5, 5, 5, '30-Nov-2021');
insert into performs (hall_id, show_id, production_id, date_show) values (6, 6, 6, '12-Oct-2021');
insert into performs (hall_id, show_id, production_id, date_show) values (7, 7, 7, '11-Aug-2021');
insert into performs (hall_id, show_id, production_id, date_show) values (8, 8, 8, '26-Dec-2021');
insert into performs (hall_id, show_id, production_id, date_show) values (9, 9, 9, '27-Aug-2021');
insert into performs (hall_id, show_id, production_id, date_show) values (10, 10, 10, '09-Jun-2021');
insert into performs (hall_id, show_id, production_id, date_show) values (11, 11, 11, '29-Apr-2021');
insert into performs (hall_id, show_id, production_id, date_show) values (12, 12, 12, '01-Jul-2021');
insert into performs (hall_id, show_id, production_id, date_show) values (13, 13, 13, '17-Oct-2021');
insert into performs (hall_id, show_id, production_id, date_show) values (14, 14, 14, '16-Mar-2021');
insert into performs (hall_id, show_id, production_id, date_show) values (15, 15, 15, '29-Mar-2021');
insert into performs (hall_id, show_id, production_id, date_show) values (16, 16, 16, '09-Feb-2021');
insert into performs (hall_id, show_id, production_id, date_show) values (17, 17, 17, '26-Mar-2021');
insert into performs (hall_id, show_id, production_id, date_show) values (18, 18, 18, '27-Jun-2021');
insert into performs (hall_id, show_id, production_id, date_show) values (19, 19, 19, '25-Mar-2021');
insert into performs (hall_id, show_id, production_id, date_show) values (20, 20, 20, '01-Jul-2021');
insert into performs (hall_id, show_id, production_id, date_show) values (21, 21, 21, '11-Feb-2021');
insert into performs (hall_id, show_id, production_id, date_show) values (22, 22, 22, '08-Apr-2021');
insert into performs (hall_id, show_id, production_id, date_show) values (23, 23, 23, '04-Dec-2021');
insert into performs (hall_id, show_id, production_id, date_show) values (24, 24, 24, '23-Apr-2021');
insert into performs (hall_id, show_id, production_id, date_show) values (25, 25, 25, '01-Mar-2021');
insert into performs (hall_id, show_id, production_id, date_show) values (26, 26, 26, '30-Aug-2021');
insert into performs (hall_id, show_id, production_id, date_show) values (27, 27, 27, '25-May-2021');
insert into performs (hall_id, show_id, production_id, date_show) values (28, 28, 28, '16-Nov-2021');
insert into performs (hall_id, show_id, production_id, date_show) values (29, 29, 29, '13-Feb-2021');
insert into performs (hall_id, show_id, production_id, date_show) values (30, 30, 30, '03-Nov-2021');
insert into performs (hall_id, show_id, production_id, date_show) values (31, 31, 31, '03-Oct-2021');
insert into performs (hall_id, show_id, production_id, date_show) values (32, 32, 32, '22-Dec-2021');
insert into performs (hall_id, show_id, production_id, date_show) values (33, 33, 33, '16-Jan-2021');
insert into performs (hall_id, show_id, production_id, date_show) values (34, 34, 34, '24-Dec-2021');
insert into performs (hall_id, show_id, production_id, date_show) values (35, 35, 35, '07-Apr-2021');
insert into performs (hall_id, show_id, production_id, date_show) values (36, 36, 36, '09-Nov-2021');
insert into performs (hall_id, show_id, production_id, date_show) values (37, 37, 37, '24-Sep-2021');
insert into performs (hall_id, show_id, production_id, date_show) values (38, 38, 38, '21-May-2021');
insert into performs (hall_id, show_id, production_id, date_show) values (39, 39, 39, '29-Jan-2021');
insert into performs (hall_id, show_id, production_id, date_show) values (40, 40, 40, '21-Dec-2021');
insert into performs (hall_id, show_id, production_id, date_show) values (41, 41, 41, '15-Jan-2021');
insert into performs (hall_id, show_id, production_id, date_show) values (42, 42, 42, '30-Oct-2021');
insert into performs (hall_id, show_id, production_id, date_show) values (43, 43, 43, '11-Sep-2021');
insert into performs (hall_id, show_id, production_id, date_show) values (44, 44, 44, '02-Apr-2021');
insert into performs (hall_id, show_id, production_id, date_show) values (45, 45, 45, '09-Aug-2021');
insert into performs (hall_id, show_id, production_id, date_show) values (46, 46, 46, '11-Jan-2021');
insert into performs (hall_id, show_id, production_id, date_show) values (47, 47, 47, '07-Jan-2022');
insert into performs (hall_id, show_id, production_id, date_show) values (48, 48, 48, '16-Aug-2021');
insert into performs (hall_id, show_id, production_id, date_show) values (49, 49, 49, '15-Dec-2021');
insert into performs (hall_id, show_id, production_id, date_show) values (50, 50, 50, '07-Nov-2021');
insert into performs (hall_id, show_id, production_id, date_show) values (51, 51, 51, '25-Dec-2021');
insert into performs (hall_id, show_id, production_id, date_show) values (52, 52, 52, '02-Jan-2022');
insert into performs (hall_id, show_id, production_id, date_show) values (53, 53, 53, '08-Feb-2021');
insert into performs (hall_id, show_id, production_id, date_show) values (54, 54, 54, '12-Feb-2021');
insert into performs (hall_id, show_id, production_id, date_show) values (55, 55, 55, '02-Mar-2021');
insert into performs (hall_id, show_id, production_id, date_show) values (56, 56, 56, '16-May-2021');
insert into performs (hall_id, show_id, production_id, date_show) values (57, 57, 57, '24-Mar-2021');
insert into performs (hall_id, show_id, production_id, date_show) values (58, 58, 58, '18-Dec-2021');
insert into performs (hall_id, show_id, production_id, date_show) values (59, 59, 59, '07-Jul-2021');
insert into performs (hall_id, show_id, production_id, date_show) values (60, 60, 60, '18-Oct-2021');
insert into performs (hall_id, show_id, production_id, date_show) values (61, 61, 61, '17-Mar-2021');
insert into performs (hall_id, show_id, production_id, date_show) values (62, 62, 62, '10-Apr-2021');
insert into performs (hall_id, show_id, production_id, date_show) values (63, 63, 63, '02-May-2021');
insert into performs (hall_id, show_id, production_id, date_show) values (64, 64, 64, '13-Jun-2021');
insert into performs (hall_id, show_id, production_id, date_show) values (65, 65, 65, '16-Mar-2021');
insert into performs (hall_id, show_id, production_id, date_show) values (66, 66, 66, '23-May-2021');
insert into performs (hall_id, show_id, production_id, date_show) values (67, 67, 67, '05-Feb-2021');
insert into performs (hall_id, show_id, production_id, date_show) values (68, 68, 68, '08-Mar-2021');
insert into performs (hall_id, show_id, production_id, date_show) values (69, 69, 69, '11-Feb-2021');
insert into performs (hall_id, show_id, production_id, date_show) values (70, 70, 70, '20-Jul-2021');
insert into performs (hall_id, show_id, production_id, date_show) values (71, 71, 71, '03-Dec-2021');
insert into performs (hall_id, show_id, production_id, date_show) values (72, 72, 72, '25-Sep-2021');
insert into performs (hall_id, show_id, production_id, date_show) values (73, 73, 73, '26-Jan-2021');
insert into performs (hall_id, show_id, production_id, date_show) values (74, 74, 74, '09-Jun-2021');
insert into performs (hall_id, show_id, production_id, date_show) values (75, 75, 75, '23-Apr-2021');
insert into performs (hall_id, show_id, production_id, date_show) values (76, 76, 76, '19-May-2021');
insert into performs (hall_id, show_id, production_id, date_show) values (77, 77, 77, '17-Sep-2021');
insert into performs (hall_id, show_id, production_id, date_show) values (78, 78, 78, '20-Nov-2021');
insert into performs (hall_id, show_id, production_id, date_show) values (79, 79, 79, '31-Mar-2021');
insert into performs (hall_id, show_id, production_id, date_show) values (80, 80, 80, '24-Jun-2021');
insert into performs (hall_id, show_id, production_id, date_show) values (81, 81, 81, '15-Jun-2021');
insert into performs (hall_id, show_id, production_id, date_show) values (82, 82, 82, '01-Oct-2021');
insert into performs (hall_id, show_id, production_id, date_show) values (83, 83, 83, '29-Mar-2021');
insert into performs (hall_id, show_id, production_id, date_show) values (84, 84, 84, '25-Oct-2021');
insert into performs (hall_id, show_id, production_id, date_show) values (85, 85, 85, '25-Feb-2021');
insert into performs (hall_id, show_id, production_id, date_show) values (86, 86, 86, '26-Feb-2021');
insert into performs (hall_id, show_id, production_id, date_show) values (87, 87, 87, '11-Mar-2021');
insert into performs (hall_id, show_id, production_id, date_show) values (88, 88, 88, '11-Apr-2021');
insert into performs (hall_id, show_id, production_id, date_show) values (89, 89, 89, '30-Apr-2021');
insert into performs (hall_id, show_id, production_id, date_show) values (90, 90, 90, '07-Aug-2021');
insert into performs (hall_id, show_id, production_id, date_show) values (91, 91, 91, '15-May-2021');
insert into performs (hall_id, show_id, production_id, date_show) values (92, 92, 92, '06-Nov-2021');
insert into performs (hall_id, show_id, production_id, date_show) values (93, 93, 93, '16-May-2021');
insert into performs (hall_id, show_id, production_id, date_show) values (94, 94, 94, '25-Jun-2021');
insert into performs (hall_id, show_id, production_id, date_show) values (95, 95, 95, '05-Oct-2021');
insert into performs (hall_id, show_id, production_id, date_show) values (96, 96, 96, '25-Dec-2021');
insert into performs (hall_id, show_id, production_id, date_show) values (97, 97, 97, '18-Apr-2021');
insert into performs (hall_id, show_id, production_id, date_show) values (98, 98, 98, '29-Sep-2021');
insert into performs (hall_id, show_id, production_id, date_show) values (99, 99, 99, '20-Feb-2021');
insert into performs (hall_id, show_id, production_id, date_show) values (100, 100, 100, '04-Jan-2022');


-- Ticket 
insert into Ticket (pricing_id, price) values (1, 12);
insert into Ticket (pricing_id, price) values (2, 10);
insert into Ticket (pricing_id, price) values (3, 13);
insert into Ticket (pricing_id, price) values (4, 14);
insert into Ticket (pricing_id, price) values (5, 7);
insert into Ticket (pricing_id, price) values (6, 20);
insert into Ticket (pricing_id, price) values (7, 20);
insert into Ticket (pricing_id, price) values (8, 11);
insert into Ticket (pricing_id, price) values (9, 12);
insert into Ticket (pricing_id, price) values (10, 9);
insert into Ticket (pricing_id, price) values (11, 7);
insert into Ticket (pricing_id, price) values (12, 7);
insert into Ticket (pricing_id, price) values (13, 15);
insert into Ticket (pricing_id, price) values (14, 9);
insert into Ticket (pricing_id, price) values (15, 12);
insert into Ticket (pricing_id, price) values (16, 11);
insert into Ticket (pricing_id, price) values (17, 12);
insert into Ticket (pricing_id, price) values (18, 17);
insert into Ticket (pricing_id, price) values (19, 10);
insert into Ticket (pricing_id, price) values (20, 12);
insert into Ticket (pricing_id, price) values (21, 9);
insert into Ticket (pricing_id, price) values (22, 19);
insert into Ticket (pricing_id, price) values (23, 19);
insert into Ticket (pricing_id, price) values (24, 17);
insert into Ticket (pricing_id, price) values (25, 15);
insert into Ticket (pricing_id, price) values (26, 13);
insert into Ticket (pricing_id, price) values (27, 17);
insert into Ticket (pricing_id, price) values (28, 10);
insert into Ticket (pricing_id, price) values (29, 8);
insert into Ticket (pricing_id, price) values (30, 16);
insert into Ticket (pricing_id, price) values (31, 16);
insert into Ticket (pricing_id, price) values (32, 7);
insert into Ticket (pricing_id, price) values (33, 19);
insert into Ticket (pricing_id, price) values (34, 8);
insert into Ticket (pricing_id, price) values (35, 9);
insert into Ticket (pricing_id, price) values (36, 9);
insert into Ticket (pricing_id, price) values (37, 9);
insert into Ticket (pricing_id, price) values (38, 12);
insert into Ticket (pricing_id, price) values (39, 14);
insert into Ticket (pricing_id, price) values (40, 17);
insert into Ticket (pricing_id, price) values (41, 15);
insert into Ticket (pricing_id, price) values (42, 8);
insert into Ticket (pricing_id, price) values (43, 13);
insert into Ticket (pricing_id, price) values (44, 8);
insert into Ticket (pricing_id, price) values (45, 8);
insert into Ticket (pricing_id, price) values (46, 9);
insert into Ticket (pricing_id, price) values (47, 19);
insert into Ticket (pricing_id, price) values (48, 17);
insert into Ticket (pricing_id, price) values (49, 14);
insert into Ticket (pricing_id, price) values (50, 20);
insert into Ticket (pricing_id, price) values (51, 20);
insert into Ticket (pricing_id, price) values (52, 8);
insert into Ticket (pricing_id, price) values (53, 11);
insert into Ticket (pricing_id, price) values (54, 9);
insert into Ticket (pricing_id, price) values (55, 16);
insert into Ticket (pricing_id, price) values (56, 18);
insert into Ticket (pricing_id, price) values (57, 15);
insert into Ticket (pricing_id, price) values (58, 17);
insert into Ticket (pricing_id, price) values (59, 14);
insert into Ticket (pricing_id, price) values (60, 11);
insert into Ticket (pricing_id, price) values (61, 19);
insert into Ticket (pricing_id, price) values (62, 17);
insert into Ticket (pricing_id, price) values (63, 9);
insert into Ticket (pricing_id, price) values (64, 15);
insert into Ticket (pricing_id, price) values (65, 10);
insert into Ticket (pricing_id, price) values (66, 11);
insert into Ticket (pricing_id, price) values (67, 7);
insert into Ticket (pricing_id, price) values (68, 16);
insert into Ticket (pricing_id, price) values (69, 15);
insert into Ticket (pricing_id, price) values (70, 16);
insert into Ticket (pricing_id, price) values (71, 19);
insert into Ticket (pricing_id, price) values (72, 12);
insert into Ticket (pricing_id, price) values (73, 14);
insert into Ticket (pricing_id, price) values (74, 8);
insert into Ticket (pricing_id, price) values (75, 8);
insert into Ticket (pricing_id, price) values (76, 11);
insert into Ticket (pricing_id, price) values (77, 18);
insert into Ticket (pricing_id, price) values (78, 13);
insert into Ticket (pricing_id, price) values (79, 19);
insert into Ticket (pricing_id, price) values (80, 12);
insert into Ticket (pricing_id, price) values (81, 9);
insert into Ticket (pricing_id, price) values (82, 10);
insert into Ticket (pricing_id, price) values (83, 16);
insert into Ticket (pricing_id, price) values (84, 19);
insert into Ticket (pricing_id, price) values (85, 18);
insert into Ticket (pricing_id, price) values (86, 15);
insert into Ticket (pricing_id, price) values (87, 9);
insert into Ticket (pricing_id, price) values (88, 14);
insert into Ticket (pricing_id, price) values (89, 19);
insert into Ticket (pricing_id, price) values (90, 11);
insert into Ticket (pricing_id, price) values (91, 9);
insert into Ticket (pricing_id, price) values (92, 16);
insert into Ticket (pricing_id, price) values (93, 19);
insert into Ticket (pricing_id, price) values (94, 14);
insert into Ticket (pricing_id, price) values (95, 7);
insert into Ticket (pricing_id, price) values (96, 8);
insert into Ticket (pricing_id, price) values (97, 8);
insert into Ticket (pricing_id, price) values (98, 17);
insert into Ticket (pricing_id, price) values (99, 12);
insert into Ticket (pricing_id, price) values (100, 11);

-- Table sells 

insert into sells (show_id, pricing_id) values (1, 1);
insert into sells (show_id, pricing_id) values (2, 2);
insert into sells (show_id, pricing_id) values (3, 3);
insert into sells (show_id, pricing_id) values (4, 4);
insert into sells (show_id, pricing_id) values (5, 5);
insert into sells (show_id, pricing_id) values (6, 6);
insert into sells (show_id, pricing_id) values (7, 7);
insert into sells (show_id, pricing_id) values (8, 8);
insert into sells (show_id, pricing_id) values (9, 9);
insert into sells (show_id, pricing_id) values (10, 10);
insert into sells (show_id, pricing_id) values (11, 11);
insert into sells (show_id, pricing_id) values (12, 12);
insert into sells (show_id, pricing_id) values (13, 13);
insert into sells (show_id, pricing_id) values (14, 14);
insert into sells (show_id, pricing_id) values (15, 15);
insert into sells (show_id, pricing_id) values (16, 16);
insert into sells (show_id, pricing_id) values (17, 17);
insert into sells (show_id, pricing_id) values (18, 18);
insert into sells (show_id, pricing_id) values (19, 19);
insert into sells (show_id, pricing_id) values (20, 20);
insert into sells (show_id, pricing_id) values (21, 21);
insert into sells (show_id, pricing_id) values (22, 22);
insert into sells (show_id, pricing_id) values (23, 23);
insert into sells (show_id, pricing_id) values (24, 24);
insert into sells (show_id, pricing_id) values (25, 25);
insert into sells (show_id, pricing_id) values (26, 26);
insert into sells (show_id, pricing_id) values (27, 27);
insert into sells (show_id, pricing_id) values (28, 28);
insert into sells (show_id, pricing_id) values (29, 29);
insert into sells (show_id, pricing_id) values (30, 30);
insert into sells (show_id, pricing_id) values (31, 31);
insert into sells (show_id, pricing_id) values (32, 32);
insert into sells (show_id, pricing_id) values (33, 33);
insert into sells (show_id, pricing_id) values (34, 34);
insert into sells (show_id, pricing_id) values (35, 35);
insert into sells (show_id, pricing_id) values (36, 36);
insert into sells (show_id, pricing_id) values (37, 37);
insert into sells (show_id, pricing_id) values (38, 38);
insert into sells (show_id, pricing_id) values (39, 39);
insert into sells (show_id, pricing_id) values (40, 40);
insert into sells (show_id, pricing_id) values (41, 41);
insert into sells (show_id, pricing_id) values (42, 42);
insert into sells (show_id, pricing_id) values (43, 43);
insert into sells (show_id, pricing_id) values (44, 44);
insert into sells (show_id, pricing_id) values (45, 45);
insert into sells (show_id, pricing_id) values (46, 46);
insert into sells (show_id, pricing_id) values (47, 47);
insert into sells (show_id, pricing_id) values (48, 48);
insert into sells (show_id, pricing_id) values (49, 49);
insert into sells (show_id, pricing_id) values (50, 50);
insert into sells (show_id, pricing_id) values (51, 51);
insert into sells (show_id, pricing_id) values (52, 52);
insert into sells (show_id, pricing_id) values (53, 53);
insert into sells (show_id, pricing_id) values (54, 54);
insert into sells (show_id, pricing_id) values (55, 55);
insert into sells (show_id, pricing_id) values (56, 56);
insert into sells (show_id, pricing_id) values (57, 57);
insert into sells (show_id, pricing_id) values (58, 58);
insert into sells (show_id, pricing_id) values (59, 59);
insert into sells (show_id, pricing_id) values (60, 60);
insert into sells (show_id, pricing_id) values (61, 61);
insert into sells (show_id, pricing_id) values (62, 62);
insert into sells (show_id, pricing_id) values (63, 63);
insert into sells (show_id, pricing_id) values (64, 64);
insert into sells (show_id, pricing_id) values (65, 65);
insert into sells (show_id, pricing_id) values (66, 66);
insert into sells (show_id, pricing_id) values (67, 67);
insert into sells (show_id, pricing_id) values (68, 68);
insert into sells (show_id, pricing_id) values (69, 69);
insert into sells (show_id, pricing_id) values (70, 70);
insert into sells (show_id, pricing_id) values (71, 71);
insert into sells (show_id, pricing_id) values (72, 72);
insert into sells (show_id, pricing_id) values (73, 73);
insert into sells (show_id, pricing_id) values (74, 74);
insert into sells (show_id, pricing_id) values (75, 75);
insert into sells (show_id, pricing_id) values (76, 76);
insert into sells (show_id, pricing_id) values (77, 77);
insert into sells (show_id, pricing_id) values (78, 78);
insert into sells (show_id, pricing_id) values (79, 79);
insert into sells (show_id, pricing_id) values (80, 80);
insert into sells (show_id, pricing_id) values (81, 81);
insert into sells (show_id, pricing_id) values (82, 82);
insert into sells (show_id, pricing_id) values (83, 83);
insert into sells (show_id, pricing_id) values (84, 84);
insert into sells (show_id, pricing_id) values (85, 85);
insert into sells (show_id, pricing_id) values (86, 86);
insert into sells (show_id, pricing_id) values (87, 87);
insert into sells (show_id, pricing_id) values (88, 88);
insert into sells (show_id, pricing_id) values (89, 89);
insert into sells (show_id, pricing_id) values (90, 90);
insert into sells (show_id, pricing_id) values (91, 91);
insert into sells (show_id, pricing_id) values (92, 92);
insert into sells (show_id, pricing_id) values (93, 93);
insert into sells (show_id, pricing_id) values (94, 94);
insert into sells (show_id, pricing_id) values (95, 95);
insert into sells (show_id, pricing_id) values (96, 96);
insert into sells (show_id, pricing_id) values (97, 97);
insert into sells (show_id, pricing_id) values (98, 98);
insert into sells (show_id, pricing_id) values (99, 99);
insert into sells (show_id, pricing_id) values (100, 100);


-- Agency 

insert into Agency (agency_id, agency_name, Nature) values (1, 'Simonis Inc', 'private donors');
insert into Agency (agency_id, agency_name, Nature) values (2, 'Murazik-Schmeler', 'NGO');
insert into Agency (agency_id, agency_name, Nature) values (3, 'Hegmann, Schowalter and Marquardt', 'private donors');
insert into Agency (agency_id, agency_name, Nature) values (4, 'VonRueden-Fadel', 'NGO');
insert into Agency (agency_id, agency_name, Nature) values (5, 'Williamson, Wehner and Orn', 'private donors');
insert into Agency (agency_id, agency_name, Nature) values (6, 'Hoeger, Upton and Lang', 'Municipality');
insert into Agency (agency_id, agency_name, Nature) values (7, 'Gaylord, Murphy and Kuhic', 'private donors');
insert into Agency (agency_id, agency_name, Nature) values (8, 'Schaden-Morar', 'Municipality');
insert into Agency (agency_id, agency_name, Nature) values (9, 'Rempel Group', 'Municipality');
insert into Agency (agency_id, agency_name, Nature) values (10, 'Marquardt LLC', 'Municipality');
insert into Agency (agency_id, agency_name, Nature) values (11, 'Farrell Group', 'NGO');
insert into Agency (agency_id, agency_name, Nature) values (12, 'Moore-Watsica', 'NGO');
insert into Agency (agency_id, agency_name, Nature) values (13, 'Hoppe-Crooks', 'Municipality');
insert into Agency (agency_id, agency_name, Nature) values (14, 'Ratke LLC', 'Municipality');
insert into Agency (agency_id, agency_name, Nature) values (15, 'Fadel-Batz', 'private donors');
insert into Agency (agency_id, agency_name, Nature) values (16, 'McClure-Witting', 'private donors');
insert into Agency (agency_id, agency_name, Nature) values (17, 'Koepp, Abshire and Von', 'private donors');
insert into Agency (agency_id, agency_name, Nature) values (18, 'Ritchie, Fadel and Kling', 'private donors');
insert into Agency (agency_id, agency_name, Nature) values (19, 'Grimes, Walsh and Franecki', 'NGO');
insert into Agency (agency_id, agency_name, Nature) values (20, 'Brakus, Heller and Collier', 'private donors');
insert into Agency (agency_id, agency_name, Nature) values (21, 'Kub-Harvey', 'private donors');
insert into Agency (agency_id, agency_name, Nature) values (22, 'Gibson and Sons', 'private donors');
insert into Agency (agency_id, agency_name, Nature) values (23, 'Christiansen-Cartwright', 'Municipality');
insert into Agency (agency_id, agency_name, Nature) values (24, 'Johnson, Ebert and Will', 'NGO');
insert into Agency (agency_id, agency_name, Nature) values (25, 'Halvorson, Ankunding and Wolff', 'private donors');
insert into Agency (agency_id, agency_name, Nature) values (26, 'Wolff, Yundt and Romaguera', 'Municipality');
insert into Agency (agency_id, agency_name, Nature) values (27, 'Fahey, Lakin and Hermiston', 'private donors');
insert into Agency (agency_id, agency_name, Nature) values (28, 'Rogahn Inc', 'NGO');
insert into Agency (agency_id, agency_name, Nature) values (29, 'Cruickshank, Ryan and Bogisich', 'private donors');
insert into Agency (agency_id, agency_name, Nature) values (30, 'Beer-White', 'NGO');
insert into Agency (agency_id, agency_name, Nature) values (31, 'Marquardt-Konopelski', 'private donors');
insert into Agency (agency_id, agency_name, Nature) values (32, 'Kovacek-Murazik', 'Municipality');
insert into Agency (agency_id, agency_name, Nature) values (33, 'Fadel, Runolfsson and Kuvalis', 'private donors');
insert into Agency (agency_id, agency_name, Nature) values (34, 'Kassulke, Gusikowski and Bayer', 'Municipality');
insert into Agency (agency_id, agency_name, Nature) values (35, 'Fahey and Sons', 'NGO');
insert into Agency (agency_id, agency_name, Nature) values (36, 'Zulauf, Jacobs and Wyman', 'private donors');
insert into Agency (agency_id, agency_name, Nature) values (37, 'Borer, Wunsch and Wiza', 'private donors');
insert into Agency (agency_id, agency_name, Nature) values (38, 'Wiza, Parker and Jaskolski', 'Municipality');
insert into Agency (agency_id, agency_name, Nature) values (39, 'Hoppe, Lueilwitz and Wiegand', 'private donors');
insert into Agency (agency_id, agency_name, Nature) values (40, 'Powlowski-Simonis', 'Municipality');
insert into Agency (agency_id, agency_name, Nature) values (41, 'Ernser, Wilkinson and Graham', 'private donors');
insert into Agency (agency_id, agency_name, Nature) values (42, 'Keebler-Dooley', 'Municipality');
insert into Agency (agency_id, agency_name, Nature) values (43, 'Hansen, Cremin and Wintheiser', 'Municipality');
insert into Agency (agency_id, agency_name, Nature) values (44, 'Haley Inc', 'NGO');
insert into Agency (agency_id, agency_name, Nature) values (45, 'Kessler, Lowe and Oberbrunner', 'Municipality');
insert into Agency (agency_id, agency_name, Nature) values (46, 'Rath Inc', 'NGO');
insert into Agency (agency_id, agency_name, Nature) values (47, 'Ondricka LLC', 'Municipality');
insert into Agency (agency_id, agency_name, Nature) values (48, 'Rohan, McLaughlin and Kihn', 'NGO');
insert into Agency (agency_id, agency_name, Nature) values (49, 'Hane LLC', 'NGO');
insert into Agency (agency_id, agency_name, Nature) values (50, 'Deckow-Osinski', 'NGO');
insert into Agency (agency_id, agency_name, Nature) values (51, 'Feest LLC', 'Municipality');
insert into Agency (agency_id, agency_name, Nature) values (52, 'Bins, Sporer and Ferry', 'NGO');
insert into Agency (agency_id, agency_name, Nature) values (53, 'Weissnat Inc', 'private donors');
insert into Agency (agency_id, agency_name, Nature) values (54, 'Balistreri LLC', 'NGO');
insert into Agency (agency_id, agency_name, Nature) values (55, 'Kulas, Hauck and Bode', 'NGO');
insert into Agency (agency_id, agency_name, Nature) values (56, 'Kassulke, Reilly and Oberbrunner', 'private donors');
insert into Agency (agency_id, agency_name, Nature) values (57, 'Green-Funk', 'NGO');
insert into Agency (agency_id, agency_name, Nature) values (58, 'Schmitt, Kulas and Flatley', 'private donors');
insert into Agency (agency_id, agency_name, Nature) values (59, 'Hane-Hane', 'NGO');
insert into Agency (agency_id, agency_name, Nature) values (60, 'Considine LLC', 'private donors');
insert into Agency (agency_id, agency_name, Nature) values (61, 'Morar-Sauer', 'private donors');
insert into Agency (agency_id, agency_name, Nature) values (62, 'Price, Jast and Paucek', 'NGO');
insert into Agency (agency_id, agency_name, Nature) values (63, 'Mertz, Schuppe and Abernathy', 'private donors');
insert into Agency (agency_id, agency_name, Nature) values (64, 'McClure, Cormier and Christiansen', 'private donors');
insert into Agency (agency_id, agency_name, Nature) values (65, 'Nicolas-Collins', 'private donors');
insert into Agency (agency_id, agency_name, Nature) values (66, 'Renner-Mertz', 'Municipality');
insert into Agency (agency_id, agency_name, Nature) values (67, 'Feest, Larkin and Rippin', 'private donors');
insert into Agency (agency_id, agency_name, Nature) values (68, 'Prosacco, Legros and Grant', 'Municipality');
insert into Agency (agency_id, agency_name, Nature) values (69, 'Stroman, Volkman and Lesch', 'Municipality');
insert into Agency (agency_id, agency_name, Nature) values (70, 'Green and Sons', 'private donors');
insert into Agency (agency_id, agency_name, Nature) values (71, 'Corkery-Brekke', 'private donors');
insert into Agency (agency_id, agency_name, Nature) values (72, 'Hartmann and Sons', 'private donors');
insert into Agency (agency_id, agency_name, Nature) values (73, 'Boehm and Sons', 'NGO');
insert into Agency (agency_id, agency_name, Nature) values (74, 'Parker, Hettinger and Collier', 'NGO');
insert into Agency (agency_id, agency_name, Nature) values (75, 'Streich Group', 'private donors');
insert into Agency (agency_id, agency_name, Nature) values (76, 'Greenholt Group', 'NGO');
insert into Agency (agency_id, agency_name, Nature) values (77, 'Rutherford Inc', 'Municipality');
insert into Agency (agency_id, agency_name, Nature) values (78, 'Metz-Schoen', 'Municipality');
insert into Agency (agency_id, agency_name, Nature) values (79, 'Morissette LLC', 'Municipality');
insert into Agency (agency_id, agency_name, Nature) values (80, 'Wunsch-Roob', 'private donors');
insert into Agency (agency_id, agency_name, Nature) values (81, 'Hackett Inc', 'private donors');
insert into Agency (agency_id, agency_name, Nature) values (82, 'Jaskolski, Greenfelder and Kirlin', 'Municipality');
insert into Agency (agency_id, agency_name, Nature) values (83, 'Walter, Wiza and McClure', 'private donors');
insert into Agency (agency_id, agency_name, Nature) values (84, 'Ward-Walsh', 'NGO');
insert into Agency (agency_id, agency_name, Nature) values (85, 'Corwin-Erdman', 'NGO');
insert into Agency (agency_id, agency_name, Nature) values (86, 'Zboncak and Sons', 'NGO');
insert into Agency (agency_id, agency_name, Nature) values (87, 'Weissnat Inc', 'NGO');
insert into Agency (agency_id, agency_name, Nature) values (88, 'Kshlerin LLC', 'private donors');
insert into Agency (agency_id, agency_name, Nature) values (89, 'O''Reilly-Hayes', 'private donors');
insert into Agency (agency_id, agency_name, Nature) values (90, 'Adams-Hayes', 'Municipality');
insert into Agency (agency_id, agency_name, Nature) values (91, 'Bahringer Inc', 'private donors');
insert into Agency (agency_id, agency_name, Nature) values (92, 'Upton-Wolf', 'Municipality');
insert into Agency (agency_id, agency_name, Nature) values (93, 'Breitenberg and Sons', 'NGO');
insert into Agency (agency_id, agency_name, Nature) values (94, 'Rodriguez, Gleichner and Auer', 'private donors');
insert into Agency (agency_id, agency_name, Nature) values (95, 'Rogahn, Ritchie and Hamill', 'Municipality');
insert into Agency (agency_id, agency_name, Nature) values (96, 'Mueller, Homenick and Dach', 'Municipality');
insert into Agency (agency_id, agency_name, Nature) values (97, 'Hartmann-Frami', 'NGO');
insert into Agency (agency_id, agency_name, Nature) values (98, 'Baumbach, Kuhic and Kuphal', 'private donors');
insert into Agency (agency_id, agency_name, Nature) values (99, 'O''Connell and Sons', 'NGO');
insert into Agency (agency_id, agency_name, Nature) values (100, 'Cruickshank Inc', 'private donors');

--Customer
insert into Customer (Customer_id, Customer_name, social_state) values (1, 'Sayre', 'Retired');
insert into Customer (Customer_id, Customer_name, social_state) values (2, 'Alicea', 'Employee');
insert into Customer (Customer_id, Customer_name, social_state) values (3, 'Franklyn', 'unemployed');
insert into Customer (Customer_id, Customer_name, social_state) values (4, 'Connie', 'Retired');
insert into Customer (Customer_id, Customer_name, social_state) values (5, 'Phillie', 'Employee');
insert into Customer (Customer_id, Customer_name, social_state) values (6, 'Wiley', 'Employee');
insert into Customer (Customer_id, Customer_name, social_state) values (7, 'Arney', 'Employee');
insert into Customer (Customer_id, Customer_name, social_state) values (8, 'Ceciley', 'Student');
insert into Customer (Customer_id, Customer_name, social_state) values (9, 'Reed', 'unemployed');
insert into Customer (Customer_id, Customer_name, social_state) values (10, 'Star', 'unemployed');
insert into Customer (Customer_id, Customer_name, social_state) values (11, 'Sheffy', 'Retired');
insert into Customer (Customer_id, Customer_name, social_state) values (12, 'Zulema', 'Student');
insert into Customer (Customer_id, Customer_name, social_state) values (13, 'Wallis', 'Student');
insert into Customer (Customer_id, Customer_name, social_state) values (14, 'Wenonah', 'unemployed');
insert into Customer (Customer_id, Customer_name, social_state) values (15, 'Bernardina', 'Employee');
insert into Customer (Customer_id, Customer_name, social_state) values (16, 'Ring', 'Employee');
insert into Customer (Customer_id, Customer_name, social_state) values (17, 'Nerissa', 'unemployed');
insert into Customer (Customer_id, Customer_name, social_state) values (18, 'Naoma', 'Retired');
insert into Customer (Customer_id, Customer_name, social_state) values (19, 'Jerrine', 'Employee');
insert into Customer (Customer_id, Customer_name, social_state) values (20, 'Homere', 'Retired');
insert into Customer (Customer_id, Customer_name, social_state) values (21, 'Regine', 'unemployed');
insert into Customer (Customer_id, Customer_name, social_state) values (22, 'Nev', 'Employee');
insert into Customer (Customer_id, Customer_name, social_state) values (23, 'Frazer', 'Employee');
insert into Customer (Customer_id, Customer_name, social_state) values (24, 'Kally', 'Retired');
insert into Customer (Customer_id, Customer_name, social_state) values (25, 'Tim', 'Employee');
insert into Customer (Customer_id, Customer_name, social_state) values (26, 'Zerk', 'unemployed');
insert into Customer (Customer_id, Customer_name, social_state) values (27, 'Lorrie', 'unemployed');
insert into Customer (Customer_id, Customer_name, social_state) values (28, 'Markus', 'unemployed');
insert into Customer (Customer_id, Customer_name, social_state) values (29, 'Christiane', 'Employee');
insert into Customer (Customer_id, Customer_name, social_state) values (30, 'Charissa', 'Student');
insert into Customer (Customer_id, Customer_name, social_state) values (31, 'Julietta', 'Retired');
insert into Customer (Customer_id, Customer_name, social_state) values (32, 'Manda', 'Employee');
insert into Customer (Customer_id, Customer_name, social_state) values (33, 'Aubine', 'unemployed');
insert into Customer (Customer_id, Customer_name, social_state) values (34, 'Allyce', 'Student');
insert into Customer (Customer_id, Customer_name, social_state) values (35, 'Hallie', 'unemployed');
insert into Customer (Customer_id, Customer_name, social_state) values (36, 'Krista', 'Student');
insert into Customer (Customer_id, Customer_name, social_state) values (37, 'Silvain', 'unemployed');
insert into Customer (Customer_id, Customer_name, social_state) values (38, 'Milena', 'Employee');
insert into Customer (Customer_id, Customer_name, social_state) values (39, 'Terrill', 'Student');
insert into Customer (Customer_id, Customer_name, social_state) values (40, 'Johna', 'unemployed');
insert into Customer (Customer_id, Customer_name, social_state) values (41, 'Nikolos', 'Employee');
insert into Customer (Customer_id, Customer_name, social_state) values (42, 'Ashlin', 'unemployed');
insert into Customer (Customer_id, Customer_name, social_state) values (43, 'Tab', 'Employee');
insert into Customer (Customer_id, Customer_name, social_state) values (44, 'Cleveland', 'unemployed');
insert into Customer (Customer_id, Customer_name, social_state) values (45, 'Flin', 'Student');
insert into Customer (Customer_id, Customer_name, social_state) values (46, 'Clive', 'Retired');
insert into Customer (Customer_id, Customer_name, social_state) values (47, 'Bryn', 'Retired');
insert into Customer (Customer_id, Customer_name, social_state) values (48, 'Sheffy', 'Retired');
insert into Customer (Customer_id, Customer_name, social_state) values (49, 'Camala', 'Employee');
insert into Customer (Customer_id, Customer_name, social_state) values (50, 'Nariko', 'Retired');
insert into Customer (Customer_id, Customer_name, social_state) values (51, 'Desmund', 'Student');
insert into Customer (Customer_id, Customer_name, social_state) values (52, 'Chelsea', 'unemployed');
insert into Customer (Customer_id, Customer_name, social_state) values (53, 'Dewie', 'unemployed');
insert into Customer (Customer_id, Customer_name, social_state) values (54, 'Hermia', 'unemployed');
insert into Customer (Customer_id, Customer_name, social_state) values (55, 'Jeralee', 'Student');
insert into Customer (Customer_id, Customer_name, social_state) values (56, 'Vick', 'Retired');
insert into Customer (Customer_id, Customer_name, social_state) values (57, 'Cindee', 'Student');
insert into Customer (Customer_id, Customer_name, social_state) values (58, 'Billy', 'Student');
insert into Customer (Customer_id, Customer_name, social_state) values (59, 'Yurik', 'Student');
insert into Customer (Customer_id, Customer_name, social_state) values (60, 'Kyrstin', 'Employee');
insert into Customer (Customer_id, Customer_name, social_state) values (61, 'Joly', 'Employee');
insert into Customer (Customer_id, Customer_name, social_state) values (62, 'Dannie', 'Employee');
insert into Customer (Customer_id, Customer_name, social_state) values (63, 'Charmion', 'unemployed');
insert into Customer (Customer_id, Customer_name, social_state) values (64, 'Hanna', 'unemployed');
insert into Customer (Customer_id, Customer_name, social_state) values (65, 'Gerek', 'unemployed');
insert into Customer (Customer_id, Customer_name, social_state) values (66, 'Naomi', 'Retired');
insert into Customer (Customer_id, Customer_name, social_state) values (67, 'Mateo', 'Employee');
insert into Customer (Customer_id, Customer_name, social_state) values (68, 'Buffy', 'Employee');
insert into Customer (Customer_id, Customer_name, social_state) values (69, 'Ulysses', 'unemployed');
insert into Customer (Customer_id, Customer_name, social_state) values (70, 'Lorna', 'Employee');
insert into Customer (Customer_id, Customer_name, social_state) values (71, 'Allyn', 'Student');
insert into Customer (Customer_id, Customer_name, social_state) values (72, 'Liza', 'Retired');
insert into Customer (Customer_id, Customer_name, social_state) values (73, 'Regine', 'Retired');
insert into Customer (Customer_id, Customer_name, social_state) values (74, 'Bobbette', 'Student');
insert into Customer (Customer_id, Customer_name, social_state) values (75, 'Lenna', 'Retired');
insert into Customer (Customer_id, Customer_name, social_state) values (76, 'Griz', 'Employee');
insert into Customer (Customer_id, Customer_name, social_state) values (77, 'Steffen', 'unemployed');
insert into Customer (Customer_id, Customer_name, social_state) values (78, 'Junette', 'Retired');
insert into Customer (Customer_id, Customer_name, social_state) values (79, 'Janka', 'Student');
insert into Customer (Customer_id, Customer_name, social_state) values (80, 'Alicia', 'unemployed');
insert into Customer (Customer_id, Customer_name, social_state) values (81, 'Fancie', 'Employee');
insert into Customer (Customer_id, Customer_name, social_state) values (82, 'Rosalind', 'Employee');
insert into Customer (Customer_id, Customer_name, social_state) values (83, 'Manon', 'Retired');
insert into Customer (Customer_id, Customer_name, social_state) values (84, 'Valle', 'Employee');
insert into Customer (Customer_id, Customer_name, social_state) values (85, 'Audry', 'unemployed');
insert into Customer (Customer_id, Customer_name, social_state) values (86, 'Kerri', 'Employee');
insert into Customer (Customer_id, Customer_name, social_state) values (87, 'Dar', 'Student');
insert into Customer (Customer_id, Customer_name, social_state) values (88, 'Kirbie', 'Student');
insert into Customer (Customer_id, Customer_name, social_state) values (89, 'Eb', 'Student');
insert into Customer (Customer_id, Customer_name, social_state) values (90, 'Hervey', 'unemployed');
insert into Customer (Customer_id, Customer_name, social_state) values (91, 'Malcolm', 'unemployed');
insert into Customer (Customer_id, Customer_name, social_state) values (92, 'Shawna', 'unemployed');
insert into Customer (Customer_id, Customer_name, social_state) values (93, 'Richmound', 'Retired');
insert into Customer (Customer_id, Customer_name, social_state) values (94, 'Glynn', 'Employee');
insert into Customer (Customer_id, Customer_name, social_state) values (95, 'Stanislaus', 'Student');
insert into Customer (Customer_id, Customer_name, social_state) values (96, 'Sara-ann', 'Student');
insert into Customer (Customer_id, Customer_name, social_state) values (97, 'Carlo', 'Retired');
insert into Customer (Customer_id, Customer_name, social_state) values (98, 'Leigh', 'unemployed');
insert into Customer (Customer_id, Customer_name, social_state) values (99, 'Thoma', 'Employee');
insert into Customer (Customer_id, Customer_name, social_state) values (100, 'Maible', 'Student');

--Discount
insert into Discount (Discount_id, Discount_rate) values (1, 0.2);
insert into Discount (Discount_id, Discount_rate) values (2, 0.3);
insert into Discount (Discount_id, Discount_rate) values (3, 0.5);


-- no need for proposes table insertion, made automatically by a trigger at insertion of paies


-- Paies
insert into paies (pricing_id, customer_id, payment_date) values (1, 1, '07-Dec-2021');
insert into paies (pricing_id, customer_id, payment_date) values (2, 2, '18-May-2021');
insert into paies (pricing_id, customer_id, payment_date) values (3, 3, '25-Dec-2021');
insert into paies (pricing_id, customer_id, payment_date) values (4, 4, '26-Apr-2021');
insert into paies (pricing_id, customer_id, payment_date) values (5, 5, '05-Oct-2021');
insert into paies (pricing_id, customer_id, payment_date) values (6, 6, '31-Dec-2021');
insert into paies (pricing_id, customer_id, payment_date) values (7, 7, '02-Nov-2021');
insert into paies (pricing_id, customer_id, payment_date) values (8, 8, '19-May-2021');
insert into paies (pricing_id, customer_id, payment_date) values (9, 9, '26-Jul-2021');
insert into paies (pricing_id, customer_id, payment_date) values (10, 10, '21-Sep-2021');
insert into paies (pricing_id, customer_id, payment_date) values (11, 11, '11-Feb-2021');
insert into paies (pricing_id, customer_id, payment_date) values (12, 12, '07-May-2021');
insert into paies (pricing_id, customer_id, payment_date) values (13, 13, '14-Mar-2021');
insert into paies (pricing_id, customer_id, payment_date) values (14, 14, '22-Aug-2021');
insert into paies (pricing_id, customer_id, payment_date) values (15, 15, '17-Dec-2021');
insert into paies (pricing_id, customer_id, payment_date) values (16, 16, '15-May-2021');
insert into paies (pricing_id, customer_id, payment_date) values (17, 17, '09-Aug-2021');
insert into paies (pricing_id, customer_id, payment_date) values (18, 18, '14-Feb-2021');
insert into paies (pricing_id, customer_id, payment_date) values (19, 19, '13-Mar-2021');
insert into paies (pricing_id, customer_id, payment_date) values (20, 20, '07-Mar-2021');
insert into paies (pricing_id, customer_id, payment_date) values (21, 21, '01-Apr-2021');
insert into paies (pricing_id, customer_id, payment_date) values (22, 22, '24-Feb-2021');
insert into paies (pricing_id, customer_id, payment_date) values (23, 23, '07-Apr-2021');
insert into paies (pricing_id, customer_id, payment_date) values (24, 24, '30-Dec-2021');
insert into paies (pricing_id, customer_id, payment_date) values (25, 25, '28-Oct-2021');
insert into paies (pricing_id, customer_id, payment_date) values (26, 26, '14-Nov-2021');
insert into paies (pricing_id, customer_id, payment_date) values (27, 27, '25-Sep-2021');
insert into paies (pricing_id, customer_id, payment_date) values (28, 28, '14-Mar-2021');
insert into paies (pricing_id, customer_id, payment_date) values (29, 29, '29-Apr-2021');
insert into paies (pricing_id, customer_id, payment_date) values (30, 30, '24-Mar-2021');
insert into paies (pricing_id, customer_id, payment_date) values (31, 31, '11-Mar-2021');
insert into paies (pricing_id, customer_id, payment_date) values (32, 32, '10-Sep-2021');
insert into paies (pricing_id, customer_id, payment_date) values (33, 33, '19-Nov-2021');
insert into paies (pricing_id, customer_id, payment_date) values (34, 34, '17-Dec-2021');
insert into paies (pricing_id, customer_id, payment_date) values (35, 35, '24-Nov-2021');
insert into paies (pricing_id, customer_id, payment_date) values (36, 36, '01-Dec-2021');
insert into paies (pricing_id, customer_id, payment_date) values (37, 37, '05-Oct-2021');
insert into paies (pricing_id, customer_id, payment_date) values (38, 38, '30-Jul-2021');
insert into paies (pricing_id, customer_id, payment_date) values (39, 39, '15-Oct-2021');
insert into paies (pricing_id, customer_id, payment_date) values (40, 40, '14-Jul-2021');
insert into paies (pricing_id, customer_id, payment_date) values (41, 41, '18-Dec-2021');
insert into paies (pricing_id, customer_id, payment_date) values (42, 42, '07-Sep-2021');
insert into paies (pricing_id, customer_id, payment_date) values (43, 43, '01-Apr-2021');
insert into paies (pricing_id, customer_id, payment_date) values (44, 44, '11-Dec-2021');
insert into paies (pricing_id, customer_id, payment_date) values (45, 45, '22-Oct-2021');
insert into paies (pricing_id, customer_id, payment_date) values (46, 46, '16-Feb-2021');
insert into paies (pricing_id, customer_id, payment_date) values (47, 47, '07-Feb-2021');
insert into paies (pricing_id, customer_id, payment_date) values (48, 48, '27-Feb-2021');
insert into paies (pricing_id, customer_id, payment_date) values (49, 49, '09-Sep-2021');
insert into paies (pricing_id, customer_id, payment_date) values (50, 50, '28-Jun-2021');
insert into paies (pricing_id, customer_id, payment_date) values (51, 51, '25-Jan-2021');
insert into paies (pricing_id, customer_id, payment_date) values (52, 52, '01-Dec-2021');
insert into paies (pricing_id, customer_id, payment_date) values (53, 53, '12-Mar-2021');
insert into paies (pricing_id, customer_id, payment_date) values (54, 54, '05-Apr-2021');
insert into paies (pricing_id, customer_id, payment_date) values (55, 55, '19-Apr-2021');
insert into paies (pricing_id, customer_id, payment_date) values (56, 56, '20-Jul-2021');
insert into paies (pricing_id, customer_id, payment_date) values (57, 57, '20-Apr-2021');
insert into paies (pricing_id, customer_id, payment_date) values (58, 58, '07-May-2021');
insert into paies (pricing_id, customer_id, payment_date) values (59, 59, '26-Jun-2021');
insert into paies (pricing_id, customer_id, payment_date) values (60, 60, '07-Jan-2022');
insert into paies (pricing_id, customer_id, payment_date) values (61, 61, '19-Oct-2021');
insert into paies (pricing_id, customer_id, payment_date) values (62, 62, '29-Mar-2021');
insert into paies (pricing_id, customer_id, payment_date) values (63, 63, '04-Mar-2021');
insert into paies (pricing_id, customer_id, payment_date) values (64, 64, '13-Jan-2022');
insert into paies (pricing_id, customer_id, payment_date) values (65, 65, '29-Jun-2021');
insert into paies (pricing_id, customer_id, payment_date) values (66, 66, '17-Aug-2021');
insert into paies (pricing_id, customer_id, payment_date) values (67, 67, '18-Jul-2021');
insert into paies (pricing_id, customer_id, payment_date) values (68, 68, '16-Mar-2021');
insert into paies (pricing_id, customer_id, payment_date) values (69, 69, '20-Dec-2021');
insert into paies (pricing_id, customer_id, payment_date) values (70, 70, '28-Jan-2021');
insert into paies (pricing_id, customer_id, payment_date) values (71, 71, '24-Dec-2021');
insert into paies (pricing_id, customer_id, payment_date) values (72, 72, '10-Apr-2021');
insert into paies (pricing_id, customer_id, payment_date) values (73, 73, '25-Jul-2021');
insert into paies (pricing_id, customer_id, payment_date) values (74, 74, '04-Sep-2021');
insert into paies (pricing_id, customer_id, payment_date) values (75, 75, '24-Nov-2021');
insert into paies (pricing_id, customer_id, payment_date) values (76, 76, '05-Aug-2021');
insert into paies (pricing_id, customer_id, payment_date) values (77, 77, '09-Jan-2022');
insert into paies (pricing_id, customer_id, payment_date) values (78, 78, '07-May-2021');
insert into paies (pricing_id, customer_id, payment_date) values (79, 79, '19-Jul-2021');
insert into paies (pricing_id, customer_id, payment_date) values (80, 80, '02-Oct-2021');
insert into paies (pricing_id, customer_id, payment_date) values (81, 81, '01-Mar-2021');
insert into paies (pricing_id, customer_id, payment_date) values (82, 82, '26-Jan-2021');
insert into paies (pricing_id, customer_id, payment_date) values (83, 83, '24-Feb-2021');
insert into paies (pricing_id, customer_id, payment_date) values (84, 84, '27-Jun-2021');
insert into paies (pricing_id, customer_id, payment_date) values (85, 85, '20-Dec-2021');
insert into paies (pricing_id, customer_id, payment_date) values (86, 86, '06-Dec-2021');
insert into paies (pricing_id, customer_id, payment_date) values (87, 87, '06-Dec-2021');
insert into paies (pricing_id, customer_id, payment_date) values (88, 88, '17-Mar-2021');
insert into paies (pricing_id, customer_id, payment_date) values (89, 89, '19-May-2021');
insert into paies (pricing_id, customer_id, payment_date) values (90, 90, '17-Aug-2021');
insert into paies (pricing_id, customer_id, payment_date) values (91, 91, '12-Feb-2021');
insert into paies (pricing_id, customer_id, payment_date) values (92, 92, '15-Mar-2021');
insert into paies (pricing_id, customer_id, payment_date) values (93, 93, '13-Aug-2021');
insert into paies (pricing_id, customer_id, payment_date) values (94, 94, '22-Oct-2021');
insert into paies (pricing_id, customer_id, payment_date) values (95, 95, '25-Jan-2021');
insert into paies (pricing_id, customer_id, payment_date) values (96, 96, '30-Aug-2021');
insert into paies (pricing_id, customer_id, payment_date) values (97, 97, '08-Aug-2021');
insert into paies (pricing_id, customer_id, payment_date) values (98, 98, '25-Mar-2021');
insert into paies (pricing_id, customer_id, payment_date) values (99, 99, '09-Apr-2021');
insert into paies (pricing_id, customer_id, payment_date) values (100, 100, '22-Dec-2021');


-- Grants

insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (1, 1, 7296, '04-Jul-2021', '04-Jul-2021');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (2, 2, 2645, '21-Feb-2021', '14-Sep-2021');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (3, 3, 1145, '10-Jan-2022', '29-Jun-2021');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (4, 4, 2871, '23-Mar-2021', '19-Nov-2021');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (5, 5, 5966, '27-Nov-2021', '30-Oct-2021');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (6, 6, 4943, '30-Mar-2021', '23-Aug-2021');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (7, 7, 526, '05-Sep-2021', '26-Apr-2021');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (8, 8, 3085, '15-Apr-2021', '26-May-2021');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (9, 9, 6758, '14-Sep-2021', '07-Jul-2021');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (10, 10, 4633, '22-Oct-2021', '27-Mar-2021');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (11, 11, 8966, '24-Sep-2021', '07-Jun-2021');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (12, 12, 3910, '30-Oct-2021', '11-May-2021');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (13, 13, 6011, '29-Apr-2021', '20-Oct-2021');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (14, 14, 8004, '18-Feb-2021', '28-Sep-2021');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (15, 15, 2211, '08-Jan-2022', '05-Feb-2021');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (16, 16, 9874, '22-Nov-2021', '16-May-2021');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (17, 17, 9283, '13-Jul-2021', '12-Mar-2021');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (18, 18, 3815, '20-Jan-2021', '11-Nov-2021');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (19, 19, 9180, '06-Mar-2021', '25-Nov-2021');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (20, 20, 4033, '10-Sep-2021', '25-Oct-2021');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (21, 21, 701, '23-Nov-2021', '05-May-2021');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (22, 22, 3622, '14-Dec-2021', '09-Mar-2021');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (23, 23, 6649, '24-Nov-2021', '09-Sep-2021');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (24, 24, 5977, '10-May-2021', '17-Dec-2021');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (25, 25, 7841, '23-Dec-2021', '12-Jul-2021');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (26, 26, 6308, '20-Dec-2021', '21-Jun-2021');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (27, 27, 690, '02-Feb-2021', '03-Apr-2021');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (28, 28, 2556, '23-Jul-2021', '26-Dec-2021');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (29, 29, 5223, '17-Aug-2021', '23-Dec-2021');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (30, 30, 1745, '07-Dec-2021', '08-Jun-2021');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (31, 31, 116, '13-Nov-2021', '05-Jan-2022');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (32, 32, 5587, '14-Jun-2021', '28-Sep-2021');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (33, 33, 2069, '18-Nov-2021', '03-Oct-2021');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (34, 34, 681, '04-Nov-2021', '08-May-2021');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (35, 35, 3744, '05-Jan-2022', '25-Nov-2021');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (36, 36, 1306, '14-Apr-2021', '31-Oct-2021');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (37, 37, 5393, '10-Nov-2021', '28-Apr-2021');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (38, 38, 1532, '04-May-2021', '06-Jan-2022');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (39, 39, 1252, '22-Jul-2021', '18-Jan-2021');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (40, 40, 6309, '19-Jan-2021', '08-Jan-2022');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (41, 41, 4600, '23-Jul-2021', '02-Nov-2021');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (42, 42, 477, '26-Sep-2021', '27-Nov-2021');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (43, 43, 2934, '18-May-2021', '03-Jun-2021');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (44, 44, 1489, '02-Aug-2021', '24-Jan-2021');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (45, 45, 5943, '14-Nov-2021', '05-May-2021');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (46, 46, 3596, '10-Nov-2021', '16-Mar-2021');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (47, 47, 8074, '19-Sep-2021', '30-Jun-2021');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (48, 48, 8495, '31-Aug-2021', '29-Mar-2021');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (49, 49, 9097, '30-May-2021', '24-Jun-2021');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (50, 50, 8584, '14-Nov-2021', '06-Feb-2021');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (51, 51, 1357, '01-Mar-2021', '28-Sep-2021');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (52, 52, 8805, '12-Oct-2021', '07-Mar-2021');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (53, 53, 1813, '07-Nov-2021', '07-Jan-2022');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (54, 54, 8749, '31-Jul-2021', '18-Sep-2021');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (55, 55, 1943, '31-Dec-2021', '30-Sep-2021');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (56, 56, 3318, '22-Sep-2021', '13-Oct-2021');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (57, 57, 4125, '18-Mar-2021', '23-Aug-2021');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (58, 58, 4079, '20-Jul-2021', '18-Apr-2021');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (59, 59, 557, '16-Jun-2021', '20-Jul-2021');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (60, 60, 9288, '08-Aug-2021', '29-Aug-2021');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (61, 61, 7003, '26-Apr-2021', '21-Sep-2021');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (62, 62, 7323, '24-Nov-2021', '23-Apr-2021');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (63, 63, 799, '24-Oct-2021', '28-Apr-2021');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (64, 64, 1661, '03-Apr-2021', '16-Aug-2021');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (65, 65, 3213, '07-Aug-2021', '13-Feb-2021');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (66, 66, 7813, '10-Jan-2022', '27-Jun-2021');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (67, 67, 5076, '14-Mar-2021', '28-Mar-2021');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (68, 68, 1180, '20-May-2021', '05-Apr-2021');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (69, 69, 1928, '14-Feb-2021', '23-Sep-2021');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (70, 70, 6591, '24-Nov-2021', '10-Nov-2021');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (71, 71, 7690, '15-Jan-2022', '06-Oct-2021');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (72, 72, 8904, '16-Jan-2022', '11-Mar-2021');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (73, 73, 668, '26-Aug-2021', '22-May-2021');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (74, 74, 4128, '06-Sep-2021', '23-Feb-2021');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (75, 75, 4146, '30-Nov-2021', '03-May-2021');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (76, 76, 4625, '13-Sep-2021', '29-Jun-2021');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (77, 77, 7601, '05-Dec-2021', '12-Nov-2021');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (78, 78, 6147, '02-Mar-2021', '17-Jan-2022');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (79, 79, 7935, '11-Aug-2021', '28-Apr-2021');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (80, 80, 9407, '16-Feb-2021', '17-Sep-2021');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (81, 81, 9627, '13-Mar-2021', '18-Dec-2021');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (82, 82, 5620, '02-Feb-2021', '19-Oct-2021');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (83, 83, 8192, '15-Apr-2021', '27-Oct-2021');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (84, 84, 5943, '20-Jun-2021', '09-Oct-2021');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (85, 85, 3524, '23-Jul-2021', '25-Dec-2021');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (86, 86, 7180, '08-Dec-2021', '29-Sep-2021');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (87, 87, 1545, '25-Feb-2021', '08-Feb-2021');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (88, 88, 9917, '30-Oct-2021', '12-Jan-2022');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (89, 89, 9788, '11-Apr-2021', '28-Oct-2021');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (90, 90, 8458, '31-Mar-2021', '08-Aug-2021');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (91, 91, 5515, '27-Sep-2021', '04-Feb-2021');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (92, 92, 7617, '17-Jan-2022', '08-Apr-2021');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (93, 93, 8287, '03-Sep-2021', '24-May-2021');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (94, 94, 6713, '28-May-2021', '01-Aug-2021');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (95, 95, 3426, '15-Mar-2021', '16-Dec-2021');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (96, 96, 3247, '05-Oct-2021', '10-Nov-2021');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (97, 97, 9753, '02-Aug-2021', '07-Mar-2021');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (98, 98, 9845, '12-Aug-2021', '20-Jan-2021');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (99, 99, 7221, '29-Aug-2021', '15-Oct-2021');
insert into grants (company_id, agency_id, subsidies, begin_date, end_date) values (100, 100, 5829, '14-Jul-2021', '15-Sep-2021');