text: INSERT IGNORE INTO Indirizzo(codInd, citta, via, civico, CAP) VALUES 
  (98327, "Vigorelli nell'emilia", 'Stretto Dionigi', '7', 39359),
  (69945, 'Michelangeli umbro', 'Viale Valentina', '8', 35176),
  (85162, 'Borgo Ida lido', 'Via Gottardi', '37', 14932),
  (44112, "Sesto Cecilia nell'emilia", 'Viale Amico', '72', 84048),
  (29937, 'Ricciardi laziale', 'Via Zoppetto', '06', 79966),
  (47010, 'Einaudi salentino', 'Contrada Marcella', '705', 60019),
  (92630, 'Venancio ligure', 'Stretto Fulvio', '677', 29665),
  (16003, "Paola nell'emilia", 'Borgo Milo', '7', 43132),
  (93591, 'Borgo Danilo', 'Rotonda Maglio', '641', 70134),
  (11067, 'Iannuzzi ligure', 'Canale Vittadello', '64', 18971),
  (57136, 'San Tiziana', 'Strada Lucarelli', '862', 15006),
  (58821, 'Ubaldo calabro', 'Strada Germano', '72', 44254),
  (95380, 'Quarto Laura', 'Rotonda Dossi', '68', 23818),
  (83665, 'Gioacchino salentino', 'Strada Pier', '951', 49568),
  (18616, 'Sesto Antonino', 'Incrocio Travaglio', '337', 97326),
  (83381, 'Borgo Napoleone', 'Stretto Venditti', '4', 86937),
  (22888, 'San Etta', 'Stretto Stefani', '196', 35816),
  (18546, 'San Gelsomina veneto', 'Contrada Gilberto', '676', 9225),
  (11140, 'Settimo Michelangelo laziale', 'Borgo Trincavelli', '1', 91374),
  (28095, 'Settimo Amico', 'Stretto Nievo', '68', 29795),
  (92161, 'Sesto Gioele umbro', 'Incrocio Favata', '3', 30431),
  (46624, 'Treves laziale', 'Viale Pierpaolo', '9', 56716),
  (56098, 'Laureano laziale', 'Piazza Silvia', '007', 51933);
  INSERT IGNORE INTO MembroTroupe(CF, nome, cognome, iban, dataNascita, telefono, codInd) VALUES 
  ('TMBGRC22P01L219M', 'Tamburi', 'Greca', 'IT90W6108903405108575323320', '2022-01-09', '+39 908 5567721', 98327),
  ('TSSRNN22A21L219M', 'Tasso', 'Ermanno', 'IT65A0996757568146002468489', '2022-01-21', '+39 198 04330656', 69945),
  ('RCLLRT22A01L219U', 'Ricolfi', 'Alberto', 'IT22O9145714635668856599748', '2022-01-01', '+39 66 1712201', 85162),
  ('CBRMLE22E01L219K', 'Cabrini', 'Emilio', 'IT56T9770528282270388129489', '2022-01-05', '+39 89 05997768', 44112),
  ('FLLGLN22S01L219E', 'Folliero', 'Giuliana', 'IT42Q3329023640342886173725', '2022-01-11', '+39 1103 7374866', 29937),
  ('PNNDNN22A14L219Y', 'Pennetta', 'Donna', 'IT82U4285445217448934448734', '2022-01-14', '+39 867 0758579', 47010),
  ('RGRCLD21T26L219C', 'Argurio', 'Claudia', 'IT89X8858307517582735101172', '2021-12-26', '+39 01 05491237', 92630),
  ('CMRTTR21T29L219A', 'Cimarosa', 'Ettore', 'IT35F9200154629437295564096', '2021-12-29', '+39 2299 37354621', 16003),
  ('LNGRML21T26L219X', 'Longhena', 'Romolo', 'IT44U2875487326126475907420', '2021-12-26', '+39 53 75192347', 93591),
  ('RCCCSN22L01L219N', 'Riccati', 'Cassandra', 'IT63F6977328144818962228334', '2022-01-07', '+39 07 07478991', 11067),
  ('STNCTN22A01L219W', 'Ostinelli', 'Costanzo', 'IT60A6863033848810640923227', '2022-01-01', '+39 43 33753965', 57136),
  ('GNNNNL21T30L219Y', 'Giannuzzi', 'Antonello', 'IT58H4036030490325479664349', '2021-12-30', '+39 01 00245250', 58821),
  ('TRRGRC22A17L219P', 'Turrini', 'Greca', 'IT64D9827962572772805046504', '2022-01-17', '+39 01 0425310', 95380),
  ('MRSRNN22D01L219T', 'Merisi', 'Ermanno', 'IT52J5044892311081227044594', '2022-01-04', '+39 733 58 49 4692', 83665),
  ('BNDRRA22L01L219Q', 'Bandello', 'Aurora', 'IT84K0655447829156267519199', '2022-01-07', '+39 7977 88812278', 18616),
  ('GZZFLV22A18L219D', 'Gozzano', 'Flavio', 'IT35E7033460969837147286706', '2022-01-18', '+39 3841 91346612', 83381),
  ('STNDNI22S01L219J', 'Stein', 'Diana', 'IT55M5065105172278580467111', '2022-01-11', '+39 67 1378913', 22888),
  ('CZZGZL22A19L219F', 'Cuzzocrea', 'Graziella', 'IT86K4859069057897172288859', '2022-01-19', '+39 7323 90854907', 18546),
  ('GRSCLD22A18L219P', 'Grasso', 'Claudio', 'IT65N7560745360326835304058', '2022-01-18', '+39 7331 1162174', 11140);
  INSERT IGNORE INTO RuoloMembroTroupe(CF, nomeRuolo) VALUES 
  ('TMBGRC22P01L219M', 'sceneggiatore'),
  ('TSSRNN22A21L219M', 'capo regista'),
  ('RCLLRT22A01L219U', 'produttore esecutivo'),
  ('CBRMLE22E01L219K', 'sceneggiatore'),
  ('FLLGLN22S01L219E', 'operatore fotografico'),
  ('PNNDNN22A14L219Y', 'operatore fotografico'),
  ('RGRCLD21T26L219C', 'regista'),
  ('CMRTTR21T29L219A', 'regista'),
  ('LNGRML21T26L219X', 'capo regista'),
  ('RCCCSN22L01L219N', 'operatore fotografico'),
  ('STNCTN22A01L219W', 'produttore esecutivo'),
  ('GNNNNL21T30L219Y', 'capo regista'),
  ('TRRGRC22A17L219P', 'produttore esecutivo'),
  ('MRSRNN22D01L219T', 'operatore fotografico'),
  ('BNDRRA22L01L219Q', 'regista'),
  ('GZZFLV22A18L219D', 'aiuto regista'),
  ('STNDNI22S01L219J', 'capo regista'),
  ('CZZGZL22A19L219F', 'operatore fotografico'),
  ('GRSCLD22A18L219P', 'produttore');
  INSERT IGNORE INTO Film_Membro_Troupe(codF, CF) VALUES 
  (4, 'TMBGRC22P01L219M'),
  (4, 'TSSRNN22A21L219M'),
  (4, 'RCLLRT22A01L219U'),
  (4, 'CBRMLE22E01L219K'),
  (4, 'FLLGLN22S01L219E'),
  (4, 'PNNDNN22A14L219Y'),
  (4, 'RGRCLD21T26L219C'),
  (4, 'CMRTTR21T29L219A'),
  (4, 'LNGRML21T26L219X'),
  (4, 'RCCCSN22L01L219N'),
  (4, 'STNCTN22A01L219W'),
  (4, 'GNNNNL21T30L219Y'),
  (4, 'TRRGRC22A17L219P'),
  (4, 'MRSRNN22D01L219T'),
  (4, 'BNDRRA22L01L219Q'),
  (4, 'GZZFLV22A18L219D'),
  (4, 'STNDNI22S01L219J'),
  (4, 'CZZGZL22A19L219F'),
  (4, 'GRSCLD22A18L219P');
  INSERT IGNORE INTO ScenaCiak(codScena, noteDiProduzione, rullo, numRiprese, durataOre, costoAffittoGiornaliero, codF) VALUES
   (37965, 'Scena n. 0', 72, 57, 67, 95, 4),
   (49686, 'Scena n. 1', 80, 81, 35, 97, 4),
   (89398, 'Scena n. 2', 82, 86, 48, 17, 4),
   (31009, 'Scena n. 3', 47, 24, 58, 83, 4),
   (53236, 'Scena n. 4', 85, 90, 71, 93, 4),
   (87614, 'Scena n. 5', 98, 36, 29, 41, 4),
   (60807, 'Scena n. 6', 44, 90, 13, 38, 4),
   (47701, 'Scena n. 7', 33, 45, 49, 38, 4),
   (97231, 'Scena n. 8', 39, 18, 20, 55, 4),
   (74134, 'Scena n. 9', 53, 27, 92, 17, 4),
   (79312, 'Scena n. 10', 31, 26, 71, 28, 4),
   (73982, 'Scena n. 11', 74, 70, 61, 71, 4),
   (63366, 'Scena n. 12', 24, 54, 29, 43, 4),
   (40518, 'Scena n. 13', 40, 97, 58, 69, 4),
   (10187, 'Scena n. 14', 51, 65, 81, 50, 4),
   (40634, 'Scena n. 15', 77, 23, 27, 73, 4),
   (95138, 'Scena n. 16', 19, 87, 78, 85, 4),
   (67234, 'Scena n. 17', 61, 90, 33, 64, 4),
   (71412, 'Scena n. 18', 26, 33, 83, 99, 4);
  INSERT IGNORE INTO PosizioneMagazzino(codP, numMagazzino, scaffale, percorso) VALUES
   (69582, 1, 1, 'I'),
   (74129, 1, 4, 'T'),
   (44471, 1, 3, 'G'),
   (68679, 1, 6, 'E'),
   (62058, 1, 8, 'I'),
   (30943, 1, 2, 'F'),
   (10588, 1, 8, 'J'),
   (85869, 1, 7, 'F'),
   (89893, 1, 4, 'B'),
   (38376, 1, 8, 'V'),
   (41077, 1, 7, 'Y'),
   (78617, 1, 6, 'E'),
   (72025, 1, 1, 'W'),
   (57231, 1, 3, 'E'),
   (32563, 1, 5, 'L'),
   (30087, 1, 5, 'P'),
   (61579, 1, 2, 'D'),
   (44259, 1, 2, 'P'),
   (56766, 1, 6, 'S');
  INSERT IGNORE INTO Costume(codC, tipo, descrizione, CF, codP) VALUES 
   (53543, 'epoca', 'costume di scena n.1', 'TSSRNN22A21L219M', 69582),
   (86233, 'epoca', 'costume di scena n.2', 'CMRTTR21T29L219A', 74129),
   (41098, 'fantasia', 'costume di scena n.3', 'GZZFLV22A18L219D', 44471),
   (87399, 'contemporaneo', 'costume di scena n.4', 'STNDNI22S01L219J', 68679),
   (42220, 'epoca', 'costume di scena n.5', 'STNDNI22S01L219J', 62058),
   (29544, 'contemporaneo', 'costume di scena n.6', 'STNDNI22S01L219J', 30943),
   (89786, 'fantasia', 'costume di scena n.7', 'MRSRNN22D01L219T', 10588),
   (49912, 'epoca', 'costume di scena n.8', 'CBRMLE22E01L219K', 85869),
   (89195, 'epoca', 'costume di scena n.9', 'GRSCLD22A18L219P', 89893),
   (58378, 'epoca', 'costume di scena n.10', 'RGRCLD21T26L219C', 38376),
   (25804, 'contemporaneo', 'costume di scena n.11', 'CZZGZL22A19L219F', 41077),
   (38777, 'fantasia', 'costume di scena n.12', 'MRSRNN22D01L219T', 78617),
   (63681, 'fantasia', 'costume di scena n.13', 'RCCCSN22L01L219N', 72025),
   (35661, 'epoca', 'costume di scena n.14', 'PNNDNN22A14L219Y', 57231),
   (61569, 'contemporaneo', 'costume di scena n.15', 'GZZFLV22A18L219D', 32563),
   (51033, 'contemporaneo', 'costume di scena n.16', 'GRSCLD22A18L219P', 30087),
   (80541, 'epoca', 'costume di scena n.17', 'GZZFLV22A18L219D', 61579),
   (73292, 'epoca', 'costume di scena n.18', 'BNDRRA22L01L219Q', 44259),
   (26378, 'fantasia', 'costume di scena n.19', 'STNDNI22S01L219J', 56766);
  INSERT IGNORE INTO CostumeScena(codC, codScena) VALUES 
  (29544, 63366),
  (63681, 73982),
  (61569, 73982),
  (51033, 60807),
  (49912, 71412),
  (42220, 63366),
  (42220, 40634),
  (49912, 40634),
  (49912, 97231),
  (73292, 97231),
  (58378, 31009),
  (89195, 79312),
  (38777, 40634),
  (63681, 97231),
  (26378, 97231),
  (38777, 74134),
  (38777, 87614),
  (89786, 47701),
  (35661, 60807),
  (38777, 49686),
  (53543, 63366),
  (89786, 89398),
  (58378, 49686),
  (86233, 63366),
  (61569, 37965),
  (26378, 87614),
  (26378, 87614),
  (87399, 63366),
  (89786, 73982),
  (80541, 40518),
  (58378, 31009),
  (29544, 73982),
  (87399, 87614),
  (35661, 79312),
  (61569, 97231),
  (61569, 60807),
  (61569, 67234),
  (80541, 47701),
  (80541, 60807),
  (29544, 53236),
  (61569, 79312),
  (58378, 10187),
  (61569, 67234),
  (41098, 63366),
  (26378, 95138),
  (87399, 60807),
  (53543, 60807),
  (73292, 87614),
  (61569, 95138),
  (61569, 63366),
  (58378, 95138),
  (89786, 40518),
  (51033, 95138),
  (80541, 71412),
  (41098, 67234),
  (61569, 53236),
  (86233, 87614);
  INSERT IGNORE INTO OggettiDiScena(codO, tipo, descrizione, codP) VALUES 
   (39033, 'mobili', 'oggetto di scena n.1', 69582),
   (45687, 'strumentoMusicale', 'oggetto di scena n.2', 74129),
   (56400, 'arredo', 'oggetto di scena n.3', 44471),
   (67020, 'arredo', 'oggetto di scena n.4', 68679),
   (11443, 'motori', 'oggetto di scena n.5', 62058),
   (18588, 'arredo', 'oggetto di scena n.6', 30943),
   (84151, 'armi', 'oggetto di scena n.7', 10588),
   (12619, 'mobili', 'oggetto di scena n.8', 85869),
   (93671, 'mobili', 'oggetto di scena n.9', 89893),
   (47862, 'arredo', 'oggetto di scena n.10', 38376),
   (53051, 'armi', 'oggetto di scena n.11', 41077),
   (99618, 'maschere', 'oggetto di scena n.12', 78617),
   (36416, 'maschere', 'oggetto di scena n.13', 72025),
   (67597, 'strumentoMusicale', 'oggetto di scena n.14', 57231),
   (18646, 'strumentoMusicale', 'oggetto di scena n.15', 32563),
   (88157, 'motori', 'oggetto di scena n.16', 30087),
   (50635, 'mobili', 'oggetto di scena n.17', 61579),
   (69972, 'maschere', 'oggetto di scena n.18', 44259),
   (72299, 'arredo', 'oggetto di scena n.19', 56766);
  INSERT IGNORE INTO OggettoScena(codO,codScena) VALUES
  (84151, 87614),
  (93671, 63366),
  (67597, 87614),
  (56400, 49686),
  (18646, 37965),
  (67597, 87614),
  (56400, 71412),
  (56400, 79312),
  (45687, 31009),
  (56400, 97231),
  (88157, 74134),
  (11443, 47701),
  (18646, 49686),
  (84151, 89398),
  (99618, 97231),
  (72299, 89398),
  (47862, 10187),
  (67597, 10187),
  (36416, 47701),
  (45687, 40518),
  (39033, 40518),
  (84151, 97231),
  (11443, 79312),
  (12619, 74134),
  (47862, 97231),
  (53051, 31009),
  (84151, 95138),
  (67597, 95138),
  (93671, 74134),
  (72299, 60807),
  (84151, 60807),
  (72299, 47701),
  (45687, 73982),
  (84151, 63366),
  (88157, 71412),
  (39033, 89398),
  (67597, 67234),
  (11443, 10187),
  (72299, 49686),
  (36416, 31009),
  (11443, 49686),
  (45687, 63366),
  (67020, 67234),
  (67020, 37965),
  (69972, 40518),
  (67020, 31009),
  (67597, 95138),
  (56400, 47701),
  (99618, 31009),
  (18646, 40518),
  (93671, 71412),
  (84151, 40518),
  (99618, 60807),
  (72299, 40518),
  (67020, 63366),
  (18646, 40634),
  (72299, 97231);
  INSERT IGNORE INTO MembroTroupeScena(codScena ,CF) VALUES 
  (37965, 'CMRTTR21T29L219A'),
  (37965, 'GNNNNL21T30L219Y'),
  (37965, 'CZZGZL22A19L219F'),
  (37965, 'GRSCLD22A18L219P'),
  (49686, 'TRRGRC22A17L219P'),
  (49686, 'RCLLRT22A01L219U'),
  (49686, 'CBRMLE22E01L219K'),
  (49686, 'RGRCLD21T26L219C'),
  (89398, 'GNNNNL21T30L219Y'),
  (89398, 'MRSRNN22D01L219T'),
  (89398, 'FLLGLN22S01L219E'),
  (89398, 'GRSCLD22A18L219P'),
  (31009, 'CBRMLE22E01L219K'),
  (31009, 'STNDNI22S01L219J'),
  (31009, 'GZZFLV22A18L219D'),
  (31009, 'BNDRRA22L01L219Q'),
  (53236, 'TRRGRC22A17L219P'),
  (53236, 'BNDRRA22L01L219Q'),
  (53236, 'CBRMLE22E01L219K'),
  (53236, 'BNDRRA22L01L219Q'),
  (87614, 'STNDNI22S01L219J'),
  (87614, 'BNDRRA22L01L219Q'),
  (87614, 'CZZGZL22A19L219F'),
  (87614, 'GRSCLD22A18L219P'),
  (60807, 'TSSRNN22A21L219M'),
  (60807, 'GRSCLD22A18L219P'),
  (60807, 'CMRTTR21T29L219A'),
  (60807, 'BNDRRA22L01L219Q'),
  (47701, 'STNCTN22A01L219W'),
  (47701, 'GNNNNL21T30L219Y'),
  (47701, 'RCCCSN22L01L219N'),
  (47701, 'LNGRML21T26L219X'),
  (97231, 'TSSRNN22A21L219M'),
  (97231, 'GNNNNL21T30L219Y'),
  (97231, 'PNNDNN22A14L219Y'),
  (97231, 'LNGRML21T26L219X'),
  (74134, 'RGRCLD21T26L219C'),
  (74134, 'PNNDNN22A14L219Y'),
  (74134, 'MRSRNN22D01L219T'),
  (74134, 'GZZFLV22A18L219D'),
  (79312, 'STNCTN22A01L219W'),
  (79312, 'TMBGRC22P01L219M'),
  (79312, 'CMRTTR21T29L219A'),
  (79312, 'STNDNI22S01L219J'),
  (73982, 'CZZGZL22A19L219F'),
  (73982, 'GRSCLD22A18L219P'),
  (73982, 'LNGRML21T26L219X'),
  (73982, 'RGRCLD21T26L219C'),
  (63366, 'STNCTN22A01L219W'),
  (63366, 'CMRTTR21T29L219A'),
  (63366, 'GZZFLV22A18L219D'),
  (63366, 'CMRTTR21T29L219A'),
  (40518, 'RGRCLD21T26L219C'),
  (40518, 'STNDNI22S01L219J'),
  (40518, 'GNNNNL21T30L219Y'),
  (40518, 'STNDNI22S01L219J'),
  (10187, 'PNNDNN22A14L219Y'),
  (10187, 'CMRTTR21T29L219A'),
  (10187, 'STNCTN22A01L219W'),
  (10187, 'STNDNI22S01L219J'),
  (40634, 'TSSRNN22A21L219M'),
  (40634, 'TMBGRC22P01L219M'),
  (40634, 'STNDNI22S01L219J'),
  (40634, 'RCLLRT22A01L219U'),
  (95138, 'TMBGRC22P01L219M'),
  (95138, 'TRRGRC22A17L219P'),
  (95138, 'GZZFLV22A18L219D'),
  (95138, 'CZZGZL22A19L219F'),
  (67234, 'CMRTTR21T29L219A'),
  (67234, 'CZZGZL22A19L219F'),
  (67234, 'LNGRML21T26L219X'),
  (67234, 'CZZGZL22A19L219F'),
  (71412, 'FLLGLN22S01L219E'),
  (71412, 'CMRTTR21T29L219A'),
  (71412, 'PNNDNN22A14L219Y'),
  (71412, 'BNDRRA22L01L219Q');
  INSERT IGNORE INTO Sponsor(P_IVA_SPONSOR, nome) VALUES 
  ('IT58Z1477671024737594439379', 'Walmart');
  INSERT IGNORE INTO Finanziatore(P_IVA_FINANZIATORE, nome,codInd ,percentualeGuadagno) VALUES
   ('IT79N4082928079145569369629', 'The Home Depot', 28095, 0.4508550581846815),
   ('IT42H7480979265195948232578', 'Boeing', 92161, 0.6212698003740285),
   ('IT08Q9132917710803078503855', 'Adobe', 46624, 0.8651323757747733),
   ('IT06P0958587199413847742633', 'Merck & Co.', 56098, 0.37233660234524957);
  INSERT IGNORE INTO Incasso(dataInizio, dataFine, incasso, codF, codInd) VALUES 
   ('1973-03-25', '1973-04-01', 1304362, 4, 16395),
   ('1973-04-01', '1973-04-08', 2269085, 4, 16395),
   ('1973-04-08', '1973-04-15', 7297643, 4, 16395),
   ('1973-04-15', '1973-04-22', 4065950, 4, 16395),
   ('1973-04-22', '1973-04-29', 9335651, 4, 16395),
   ('1973-04-29', '1973-05-06', 1401267, 4, 16395),
   ('1973-05-06', '1973-05-13', 2777027, 4, 16395),
   ('1973-05-13', '1973-05-20', 2655029, 4, 16395);
  INSERT IGNORE INTO Fondo(codFondo, dataAccredito, patrimonio, P_IVA_SPONSOR, P_IVA_FINANZIATORE, codF) VALUES 
   (66022, '1982-03-19', 449350, null, 'IT79N4082928079145569369629', 4),
   (84814, '2013-04-15', 361285, null, 'IT42H7480979265195948232578', 4),
   (90149, '1989-09-26', 502535, null, 'IT08Q9132917710803078503855', 4),
   (41920, '2012-07-20', 987735, null, 'IT06P0958587199413847742633', 4);
  INSERT IGNORE INTO Fondo(codFondo, dataAccredito, patrimonio, P_IVA_SPONSOR, P_IVA_FINANZIATORE, codF) VALUES 
   (47670, '2014-07-13', 778535, 'IT58Z1477671024737594439379', null, 4);
  INSERT IGNORE INTO MembroTroupeScena(codScena ,CF) VALUES 
   (37965, 'CMRTTR21T29L219A'),
   (37965, 'GNNNNL21T30L219Y'),
   (37965, 'GNNNNL21T30L219Y'),
   (37965, 'CMRTTR21T29L219A'),
   (37965, 'CMRTTR21T29L219A'),
   (49686, 'PNNDNN22A14L219Y'),
   (49686, 'STNCTN22A01L219W'),
   (49686, 'FLLGLN22S01L219E'),
   (49686, 'STNDNI22S01L219J'),
   (49686, 'CMRTTR21T29L219A'),
   (89398, 'RGRCLD21T26L219C'),
   (89398, 'LNGRML21T26L219X'),
   (89398, 'GZZFLV22A18L219D'),
   (89398, 'STNCTN22A01L219W'),
   (89398, 'RGRCLD21T26L219C'),
   (31009, 'FLLGLN22S01L219E'),
   (31009, 'CMRTTR21T29L219A'),
   (31009, 'RCLLRT22A01L219U'),
   (31009, 'GZZFLV22A18L219D'),
   (31009, 'LNGRML21T26L219X'),
   (53236, 'TRRGRC22A17L219P'),
   (53236, 'GZZFLV22A18L219D'),
   (53236, 'LNGRML21T26L219X'),
   (53236, 'CZZGZL22A19L219F'),
   (53236, 'GZZFLV22A18L219D'),
   (87614, 'RCCCSN22L01L219N'),
   (87614, 'FLLGLN22S01L219E'),
   (87614, 'TRRGRC22A17L219P'),
   (87614, 'GRSCLD22A18L219P'),
   (87614, 'GRSCLD22A18L219P'),
   (60807, 'TSSRNN22A21L219M'),
   (60807, 'BNDRRA22L01L219Q'),
   (60807, 'CBRMLE22E01L219K'),
   (60807, 'RGRCLD21T26L219C'),
   (60807, 'RCCCSN22L01L219N'),
   (47701, 'GZZFLV22A18L219D'),
   (47701, 'STNCTN22A01L219W'),
   (47701, 'CBRMLE22E01L219K'),
   (47701, 'FLLGLN22S01L219E'),
   (47701, 'TMBGRC22P01L219M'),
   (97231, 'GZZFLV22A18L219D'),
   (97231, 'GNNNNL21T30L219Y'),
   (97231, 'MRSRNN22D01L219T'),
   (97231, 'RGRCLD21T26L219C'),
   (97231, 'GRSCLD22A18L219P'),
   (74134, 'GRSCLD22A18L219P'),
   (74134, 'RCCCSN22L01L219N'),
   (74134, 'FLLGLN22S01L219E'),
   (74134, 'BNDRRA22L01L219Q'),
   (74134, 'GNNNNL21T30L219Y'),
   (79312, 'RGRCLD21T26L219C'),
   (79312, 'TRRGRC22A17L219P'),
   (79312, 'BNDRRA22L01L219Q'),
   (79312, 'CMRTTR21T29L219A'),
   (79312, 'TRRGRC22A17L219P'),
   (73982, 'GRSCLD22A18L219P'),
   (73982, 'STNCTN22A01L219W'),
   (73982, 'RCLLRT22A01L219U'),
   (73982, 'RCCCSN22L01L219N'),
   (73982, 'FLLGLN22S01L219E'),
   (63366, 'CZZGZL22A19L219F'),
   (63366, 'RGRCLD21T26L219C'),
   (63366, 'STNCTN22A01L219W'),
   (63366, 'GZZFLV22A18L219D'),
   (63366, 'RCLLRT22A01L219U'),
   (40518, 'TSSRNN22A21L219M'),
   (40518, 'RCLLRT22A01L219U'),
   (40518, 'CZZGZL22A19L219F'),
   (40518, 'STNDNI22S01L219J'),
   (40518, 'GNNNNL21T30L219Y'),
   (10187, 'CZZGZL22A19L219F'),
   (10187, 'CBRMLE22E01L219K'),
   (10187, 'TRRGRC22A17L219P'),
   (10187, 'GZZFLV22A18L219D'),
   (10187, 'STNDNI22S01L219J'),
   (40634, 'RGRCLD21T26L219C'),
   (40634, 'RCCCSN22L01L219N'),
   (40634, 'CZZGZL22A19L219F'),
   (40634, 'FLLGLN22S01L219E'),
   (40634, 'CMRTTR21T29L219A'),
   (95138, 'TMBGRC22P01L219M'),
   (95138, 'BNDRRA22L01L219Q'),
   (95138, 'GZZFLV22A18L219D'),
   (95138, 'RCCCSN22L01L219N'),
   (95138, 'CMRTTR21T29L219A'),
   (67234, 'STNDNI22S01L219J'),
   (67234, 'TSSRNN22A21L219M'),
   (67234, 'PNNDNN22A14L219Y'),
   (67234, 'MRSRNN22D01L219T'),
   (67234, 'BNDRRA22L01L219Q'),
   (71412, 'TMBGRC22P01L219M'),
   (71412, 'TRRGRC22A17L219P'),
   (71412, 'RCCCSN22L01L219N'),
   (71412, 'CMRTTR21T29L219A'),
   (71412, 'TRRGRC22A17L219P');
  INSERT IGNORE INTO BustaPaga(codB, retribuzioneOraria, oreLavorate, mese) VALUES 
  (52894, 28, 118, 'luglio'),
  (21301, 50, 115, 'marzo'),
  (95813, 41, 185, 'agosto'),
  (22131, 26, 50, 'settembre'),
  (37733, 7, 106, 'novembre'),
  (29200, 14, 186, 'maggio'),
  (46308, 35, 148, 'novembre'),
  (95633, 16, 65, 'aprile'),
  (38219, 8, 182, 'giugno'),
  (90055, 18, 128, 'giugno'),
  (42127, 21, 174, 'luglio'),
  (50317, 25, 53, 'agosto'),
  (61843, 36, 68, 'novembre'),
  (76956, 48, 94, 'agosto'),
  (85191, 21, 128, 'maggio'),
  (82577, 43, 163, 'maggio'),
  (40982, 35, 86, 'novembre'),
  (19607, 37, 170, 'dicembre'),
  (26199, 33, 66, 'maggio');
  INSERT IGNORE INTO Retribuzione(CF, CodB) VALUES
  ('TMBGRC22P01L219M', 52894),
  ('TSSRNN22A21L219M', 21301),
  ('RCLLRT22A01L219U', 95813),
  ('CBRMLE22E01L219K', 22131),
  ('FLLGLN22S01L219E', 37733),
  ('PNNDNN22A14L219Y', 29200),
  ('RGRCLD21T26L219C', 46308),
  ('CMRTTR21T29L219A', 95633),
  ('LNGRML21T26L219X', 38219),
  ('RCCCSN22L01L219N', 90055),
  ('STNCTN22A01L219W', 42127),
  ('GNNNNL21T30L219Y', 50317),
  ('TRRGRC22A17L219P', 61843),
  ('MRSRNN22D01L219T', 76956),
  ('BNDRRA22L01L219Q', 85191),
  ('GZZFLV22A18L219D', 82577),
  ('STNDNI22S01L219J', 40982),
  ('CZZGZL22A19L219F', 19607),
  ('GRSCLD22A18L219P', 26199);
  
   
   
   
   
   incollarlo sotto le insert di star wars e soprattutto per farlo andare sostituire ; con ;        e       null con null