Crociere.sql

CREATE TABLE IF NOT EXISTS Compagnia (
    PI CHAR(10) PRIMARY KEY,
    Nome VARCHAR(100) NOT NULL,
    Sede VARCHAR(200) NOT NULL,
    Recapito_Telefonico VARCHAR(15)
);

CREATE TABLE IF NOT EXISTS Porto (
    Città VARCHAR(100) PRIMARY KEY,
    Numero_Massimo_Navi INT
);

CREATE TABLE IF NOT EXISTS Crociera (
    IMO CHAR(10) PRIMARY KEY,
    Nome_Nave VARCHAR(100) NOT NULL,
    Min_Equipaggio INT NOT NULL,
    Max_Passeggeri INT NOT NULL,
    Num_Prenotazioni INT NOT NULL,
    Porto_Partenza VARCHAR(100),
    Porto_Finale VARCHAR(100),
    Data_Ora_Partenza TIMESTAMP,
    Durata INT,
    PI_Compagnia CHAR(10),
    FOREIGN KEY (PI_Compagnia) REFERENCES Compagnia(PI),
    FOREIGN KEY (Porto_Partenza) REFERENCES Porto(Città),
    FOREIGN KEY (Porto_Finale) REFERENCES Porto(Città)
);

CREATE TABLE IF NOT EXISTS Tappa (
    IMO CHAR(10),
    Città VARCHAR(100),
    Data_Ora_Partenza TIMESTAMP,
    Data_Ora_Arrivo TIMESTAMP NOT NULL,
    PRIMARY KEY (IMO, Città, Data_Ora_Partenza),
    FOREIGN KEY (IMO) REFERENCES Crociera(IMO),
    FOREIGN KEY (Città) REFERENCES Porto(Città)
);

CREATE TABLE IF NOT EXISTS Persona (
    CF CHAR(16) PRIMARY KEY,
    Nome VARCHAR(100) NOT NULL,
    Cognome VARCHAR(100) NOT NULL,
    Sesso CHAR(1) NOT NULL
);

CREATE TABLE IF NOT EXISTS Ospite (
    CF CHAR(16),
    Costo DECIMAL(10, 2),
    IMO_Crociera CHAR(10),
    PRIMARY KEY (CF, IMO_Crociera),
    FOREIGN KEY (CF) REFERENCES Persona(CF),
    FOREIGN KEY (IMO_Crociera) REFERENCES Crociera(IMO)
);

CREATE TABLE IF NOT EXISTS Equipaggio (
    CF CHAR(16),
    IDequipaggio CHAR(10) NOT NULL,
    Lingue_Parlate VARCHAR(100),
    Stipendio DECIMAL(10, 2),
    Anni_Servizio INT,
    IMO_Crociera CHAR(10),
    PRIMARY KEY (CF),
    FOREIGN KEY (CF) REFERENCES Persona(CF)
);

CREATE TABLE IF NOT EXISTS Animatore (
    CF CHAR(16),
    Abilità VARCHAR(100),
    PRIMARY KEY (CF),
    FOREIGN KEY (CF) REFERENCES Equipaggio(CF)
);

CREATE TABLE IF NOT EXISTS Evento (
    Nome VARCHAR(100),
    Tipologia VARCHAR(100),
    IMO_Crociera CHAR(10),
    Num_Cons_Partecipanti INT,
    Num_Min_Animatori INT,
    Età_Consigliata INT,
    PRIMARY KEY (Nome, Tipologia, IMO_Crociera),
    FOREIGN KEY (IMO_Crociera) REFERENCES Crociera(IMO)
);

CREATE TABLE IF NOT EXISTS ORGANIZZA (
    CF_Animatore CHAR(16),
    Nome_Evento VARCHAR(100),
    Tipologia_Evento VARCHAR(100),
    IMO_Crociera_Evento CHAR(10),
    PRIMARY KEY (CF_Animatore, Nome_Evento, Tipologia_Evento, IMO_Crociera_Evento),
    FOREIGN KEY (CF_Animatore) REFERENCES Animatore(CF),
    FOREIGN KEY (Nome_Evento, Tipologia_Evento, IMO_Crociera_Evento) REFERENCES Evento(Nome, Tipologia, IMO_Crociera)
);


INSERT INTO Compagnia VALUES
('1111111111', 'Costa del Sole', 'Civitavecchia', '+390766123456'),
('2222222222', 'Vento Estivo', 'Bari', '+390805432198'),
('3333333333', 'Blue Horizon', 'Venezia', '+390412233445'),
('4444444444', 'Tramonto Cruise Line', 'Trieste', '+390402224466'),
('5555555555', 'Stella Marina Cruises', 'Livorno', '+390586334455'),
('6666666666', 'Azzurra Voyages', 'La Spezia', '+390187665544'),
('7777777777', 'Aurora Line', 'Brindisi', '+390831112233'),
('8888888888', 'Adriatica Cruise', 'Ancona', '+390712221133'),
('9999999999', 'Mediterraneo Royal', 'Reggio Calabria', '+390965778899'),
('1010101010', 'Sirena del Mare', 'Salerno', '+390892221100'),
('1212121212', 'Egeo Travel', 'Taranto', '+390997665544'),
('1313131313', 'Poseidon Cruises', 'Cagliari', '+390706665544'),
('1414141414', 'Atlantica Line', 'Ajaccio', '+33495223344'),
('1515151515', 'Europa Waves', 'Marsiglia', '+33491123456'),
('1616161616', 'Porto Viaggi', 'Barcellona', '+34933123456'),
('1717171717', 'Onda Serena', 'Valencia', '+34961222111'),
('1818181818', 'Grecia Mare', 'Pireo', '+302104445566'),
('1919191919', 'Croazia Blu', 'Dubrovnik', '+38520322333'),
('2020202020', 'Baltic Dream', 'Tallinn', '+3726611222'),
('2121212121', 'Nordik Sea Line', 'Oslo', '+4722345566');


INSERT INTO Porto VALUES
('Civitavecchia', 9),
('Napoli', 10),
('Livorno', 8),
('Venezia', 7),
('Trieste', 6),
('Palermo', 8),
('Marsiglia', 11),
('Barcellona', 9),
('La Spezia', 5),
('Savona', 6),
('Ravenna', 4),
('Bari', 7),
('Brindisi', 6),
('Ancona', 5),
('Salerno', 5),
('Reggio Calabria', 4),
('Olbia', 5),
('Trapani', 3),
('Messina', 5),
('Taranto', 4),
('Gaeta', 3),
('Piombino', 4),
('Porto Torres', 4),
('Ajaccio', 3),
('Bastia', 3),
('Nizza', 6),
('Tolone', 4),
('Le Havre', 7),
('Bordeaux', 5),
('Amsterdam', 10),
('Rotterdam', 12),
('Amburgo', 11),
('Brema', 6),
('Copenaghen', 8),
('Oslo', 7),
('Stoccolma', 9),
('Helsinki', 6),
('Tallinn', 5),
('Riga', 5),
('Vilnius', 3),
('Gdynia', 6),
('Danzica', 7),
('Szczecin', 4),
('Lisbona', 8),
('Funchal', 4),
('Pireo', 10),
('Salonicco', 6),
('Heraklion', 4),
('Rodi', 4),
('Corfù', 5),
('Dubrovnik', 6),
('Spalato', 5),
('Kotor', 4),
('Valletta', 5),
('Limassol', 6),
('Larnaca', 4),
('Haifa', 7),
('Ashdod', 6),
('Istanbul', 11),
('Izmir', 7),
('Antalya', 5),
('Alicante', 6),
('Valencia', 8),
('Malaga', 6),
('Cadice', 5),
('Bilbao', 5),
('Palamós', 3),
('Sete', 4),
('Cagliari', 6),
('Hvar', 3),
('Mykonos', 4),
('Santorini', 4),
('Patrasso', 3),
('Goteborg', 7),
('Reykjavik', 5),
('Halifax', 6),
('Québec City', 4),
('Vancouver', 8),
('Seattle', 7),
('San Francisco', 9),
('Los Angeles', 12),
('San Diego', 6),
('New York', 13),
('Miami', 15),
('Fort Lauderdale', 11),
('Galveston', 9),
('New Orleans', 8),
('Genova', 12),
('Atene', 4),
('Key West', 4),
('Southampton', 6),
('Nice', 6);

INSERT INTO Crociera VALUES
('IMO0000001', 'Nave Azzurra', 50, 500, 400, 'Genova', 'Atene', '2025-07-01 10:00:00', 168, '1010101010'),
('IMO0000002', 'Sole Mediterraneo', 60, 600, 520, 'Napoli', 'Barcellona', '2025-08-05 16:00:00', 120, '1212121212'),
('IMO0000003', 'Stella del Mare', 55, 450, 300, 'Palermo', 'Marsiglia', '2025-09-10 08:00:00', 144, '1313131313'),
('IMO0000004', 'Oceano Blu', 48, 520, 400, 'Civitavecchia', 'Valencia', '2025-06-15 09:00:00', 120, '1111111111'),
('IMO0000005', 'Alba Serena', 52, 530, 410, 'Venezia', 'Dubrovnik', '2025-06-20 17:00:00', 96, '2222222222'),
('IMO0000006', 'Costa Magica', 60, 580, 500, 'Livorno', 'Marsiglia', '2025-07-03 11:00:00', 72, '3333333333'),
('IMO0000007', 'Mare Dorato', 62, 600, 520, 'La Spezia', 'Barcellona', '2025-07-07 15:00:00', 96, '4444444444'),
('IMO0000008', 'Tramonto d Oriente', 55, 490, 420, 'Brindisi', 'Atene', '2025-07-10 14:00:00', 120, '5555555555'),
('IMO0000009', 'Sirena Bianca', 58, 550, 470, 'Bari', 'Corfù', '2025-07-14 10:30:00', 72, '6666666666'),
('IMO0000010', 'Regina del Mare', 50, 500, 400, 'Ancona', 'Salonicco', '2025-07-20 18:00:00', 96, '7777777777'),
('IMO0000011', 'Mediterranea Star', 60, 610, 490, 'Salerno', 'Palermo', '2025-07-25 08:30:00', 48, '8888888888'),
('IMO0000012', 'Vento del Sud', 45, 420, 300, 'Reggio Calabria', 'Messina', '2025-08-01 09:00:00', 24, '9999999999'),
('IMO0000013', 'Aurora', 55, 560, 430, 'Cagliari', 'Ajaccio', '2025-08-10 12:00:00', 72, '1010101010'),
('IMO0000014', 'Azzurra Dream', 50, 540, 450, 'Olbia', 'Genova', '2025-08-15 07:00:00', 48, '1212121212'),
('IMO0000015', 'Poseidon', 65, 620, 510, 'Ajaccio', 'Civitavecchia', '2025-08-20 18:00:00', 72, '1313131313'),
('IMO0000016', 'Atlantis', 70, 700, 600, 'Barcellona', 'Marsiglia', '2025-08-25 09:00:00', 48, '1414141414'),
('IMO0000017', 'Europa Cruise', 55, 500, 450, 'Marsiglia', 'Valencia', '2025-09-01 16:00:00', 48, '1515151515'),
('IMO0000018', 'Onda Luminosa', 58, 540, 420, 'Palermo', 'Napoli', '2025-09-05 08:00:00', 36, '1616161616'),
('IMO0000019', 'Grecia Explorer', 52, 500, 400, 'Pireo', 'Rodi', '2025-09-10 10:00:00', 48, '1717171717'),
('IMO0000020', 'Croazia Blu Tour', 48, 480, 380, 'Dubrovnik', 'Spalato', '2025-09-15 15:00:00', 24, '1818181818'),
('IMO0000021', 'Baltico Express', 60, 620, 520, 'Tallinn', 'Stoccolma', '2025-09-20 13:00:00', 72, '1919191919'),
('IMO0000022', 'Fjord Line', 70, 730, 600, 'Oslo', 'Copenaghen', '2025-09-25 08:00:00', 96, '2020202020'),
('IMO0000023', 'Nordik Star', 58, 570, 460, 'Amsterdam', 'Amburgo', '2025-10-01 09:00:00', 48, '2121212121'),
('IMO0000024', 'Sirena Nera', 53, 510, 420, 'Trieste', 'Venezia', '2025-10-05 17:00:00', 24, '1111111111'),
('IMO0000025', 'Mediterraneo Lux', 62, 600, 520, 'Napoli', 'Valletta', '2025-10-10 12:00:00', 72, '2222222222'),
('IMO0000026', 'Sea Spirit', 45, 480, 380, 'Bari', 'Rodi', '2025-10-15 14:00:00', 96, '3333333333'),
('IMO0000027', 'Oceania Bellezza', 50, 510, 410, 'Livorno', 'Barcellona', '2025-10-20 09:00:00', 96, '1111111111'),
('IMO0000028', 'Marina di Sera', 55, 550, 450, 'Cagliari', 'Trapani', '2025-10-25 15:00:00', 48, '2222222222'),
('IMO0000029', 'Costa del Nord', 58, 600, 500, 'Rotterdam', 'Oslo', '2025-11-01 11:00:00', 120, '3333333333'),
('IMO0000030', 'Stella Polare', 65, 700, 550, 'Le Havre', 'Southampton', '2025-11-05 08:30:00', 72, '4444444444'),
('IMO0000031', 'Alba Marina', 60, 630, 500, 'Valencia', 'Atene', '2025-11-10 16:00:00', 120, '5555555555'),
('IMO0000032', 'Azzurra Light', 54, 560, 430, 'Mykonos', 'Santorini', '2025-11-15 07:30:00', 24, '6666666666'),
('IMO0000033', 'Nave del Sole', 68, 680, 580, 'Venezia', 'Patrasso', '2025-11-20 10:00:00', 96, '7777777777'),
('IMO0000034', 'Riviera Star', 56, 590, 470, 'Ajaccio', 'Nice', '2025-11-25 14:00:00', 48, '8888888888'),
('IMO0000035', 'Blue Harmony', 62, 600, 490, 'Genova', 'Limassol', '2025-12-01 12:00:00', 144, '9999999999');


INSERT INTO Tappa VALUES
('IMO0000001', 'Napoli', '2025-07-02 10:00:00', '2025-07-01 22:00:00'),
('IMO0000001', 'Palermo', '2025-07-03 10:00:00', '2025-07-02 22:00:00'),
('IMO0000001', 'Barcellona', '2025-07-04 10:00:00', '2025-07-03 22:00:00'),
('IMO0000001', 'Marsiglia', '2025-07-05 10:00:00', '2025-07-04 22:00:00'),
('IMO0000002', 'Genova', '2025-08-06 12:00:00', '2025-08-05 20:00:00'),
('IMO0000002', 'Marsiglia', '2025-08-07 14:00:00', '2025-08-06 20:00:00'),
('IMO0000003', 'Cagliari', '2025-09-11 12:00:00', '2025-09-10 22:00:00'),
('IMO0000003', 'Ajaccio', '2025-09-12 13:00:00', '2025-09-11 21:00:00'),
('IMO0000003', 'Genova', '2025-09-13 14:00:00', '2025-09-12 22:00:00'),
('IMO0000004', 'Livorno', '2025-06-16 12:00:00', '2025-06-15 21:00:00'),
('IMO0000004', 'Marsiglia', '2025-06-17 13:00:00', '2025-06-16 20:00:00'),
('IMO0000005', 'Ancona', '2025-06-21 11:00:00', '2025-06-20 22:00:00'),
('IMO0000005', 'Spalato', '2025-06-22 13:00:00', '2025-06-21 20:00:00'),
('IMO0000006', 'Civitavecchia', '2025-07-04 12:00:00', '2025-07-03 22:00:00'),
('IMO0000006', 'Palermo', '2025-07-05 13:00:00', '2025-07-04 21:00:00'),
('IMO0000007', 'Ajaccio', '2025-07-08 13:00:00', '2025-07-07 22:00:00'),
('IMO0000007', 'Valencia', '2025-07-09 14:00:00', '2025-07-08 21:00:00'),
('IMO0000008', 'Corfù', '2025-07-11 12:00:00', '2025-07-10 21:00:00'),
('IMO0000008', 'Salonicco', '2025-07-12 13:00:00', '2025-07-11 22:00:00'),
('IMO0000009', 'Dubrovnik', '2025-07-15 10:00:00', '2025-07-14 20:00:00'),
('IMO0000009', 'Spalato', '2025-07-16 11:00:00', '2025-07-15 20:00:00'),
('IMO0000010', 'Bari', '2025-07-21 12:00:00', '2025-07-20 22:00:00'),
('IMO0000011', 'Cagliari', '2025-07-26 10:00:00', '2025-07-25 20:00:00'),
('IMO0000011', 'Ajaccio', '2025-07-27 12:00:00', '2025-07-26 20:00:00'),
('IMO0000012', 'Olbia', '2025-08-02 09:00:00', '2025-08-01 20:00:00'),
('IMO0000012', 'Genova', '2025-08-03 11:00:00', '2025-08-02 20:00:00'),
('IMO0000013', 'Ajaccio', '2025-08-11 10:00:00', '2025-08-10 20:00:00'),
('IMO0000013', 'Civitavecchia', '2025-08-12 12:00:00', '2025-08-11 20:00:00'),
('IMO0000014', 'Barcellona', '2025-08-16 09:00:00', '2025-08-15 20:00:00'),
('IMO0000015', 'Valencia', '2025-08-21 10:00:00', '2025-08-20 20:00:00'),
('IMO0000015', 'Palermo', '2025-08-22 12:00:00', '2025-08-21 20:00:00'),
('IMO0000016', 'Marsiglia', '2025-08-26 09:00:00', '2025-08-25 20:00:00'),
('IMO0000016', 'Genova', '2025-08-27 11:00:00', '2025-08-26 20:00:00'),
('IMO0000017', 'Valencia', '2025-09-02 10:00:00', '2025-09-01 20:00:00'),
('IMO0000017', 'Barcellona', '2025-09-03 12:00:00', '2025-09-02 20:00:00'),
('IMO0000018', 'Napoli', '2025-09-06 09:00:00', '2025-09-05 20:00:00'),
('IMO0000018', 'Civitavecchia', '2025-09-07 11:00:00', '2025-09-06 20:00:00'),
('IMO0000019', 'Heraklion', '2025-09-12 12:00:00', '2025-09-11 20:00:00'),
('IMO0000020', 'Spalato', '2025-09-16 09:00:00', '2025-09-15 20:00:00'),
('IMO0000020', 'Kotor', '2025-09-17 11:00:00', '2025-09-16 20:00:00'),
('IMO0000021', 'Stoccolma', '2025-09-21 10:00:00', '2025-09-20 20:00:00'),
('IMO0000021', 'Helsinki', '2025-09-22 12:00:00', '2025-09-21 20:00:00'),
('IMO0000002', 'Barcellona', '2025-08-08 15:00:00', '2025-08-07 20:00:00'),
('IMO0000003', 'Napoli', '2025-09-14 15:00:00', '2025-09-13 21:00:00'),
('IMO0000004', 'Ajaccio', '2025-06-18 14:00:00', '2025-06-17 20:00:00'),
('IMO0000004', 'Cagliari', '2025-06-19 13:00:00', '2025-06-18 20:00:00'),
('IMO0000005', 'Dubrovnik', '2025-06-23 14:00:00', '2025-06-22 21:00:00'),
('IMO0000006', 'Cagliari', '2025-07-07 16:00:00', '2025-07-06 21:00:00'),
('IMO0000007', 'Barcellona', '2025-07-10 16:00:00', '2025-07-09 20:00:00'),
('IMO0000008', 'Brindisi', '2025-07-13 15:00:00', '2025-07-12 21:00:00'),
('IMO0000008', 'Bari', '2025-07-14 14:00:00', '2025-07-13 21:00:00'),
('IMO0000009', 'Ancona', '2025-07-17 12:00:00', '2025-07-16 21:00:00'),
('IMO0000010', 'Corfù', '2025-07-23 15:00:00', '2025-07-22 21:00:00'),
('IMO0000010', 'Salonicco', '2025-07-24 14:00:00', '2025-07-23 21:00:00'),
('IMO0000011', 'Livorno', '2025-07-28 13:00:00', '2025-07-27 20:00:00'),
('IMO0000011', 'Genova', '2025-07-29 12:00:00', '2025-07-28 20:00:00'),
('IMO0000012', 'Civitavecchia', '2025-08-04 13:00:00', '2025-08-03 20:00:00'),
('IMO0000013', 'Olbia', '2025-08-14 12:00:00', '2025-08-13 21:00:00'),
('IMO0000014', 'Valencia', '2025-08-18 13:00:00', '2025-08-17 20:00:00'),
('IMO0000015', 'Cagliari', '2025-08-23 13:00:00', '2025-08-22 20:00:00'),
('IMO0000015', 'Genova', '2025-08-24 14:00:00', '2025-08-23 21:00:00'),
('IMO0000016', 'Ajaccio', '2025-08-28 13:00:00', '2025-08-27 20:00:00'),
('IMO0000017', 'Marsiglia', '2025-09-04 13:00:00', '2025-09-03 20:00:00'),
('IMO0000018', 'Palermo', '2025-09-08 13:00:00', '2025-09-07 20:00:00'),
('IMO0000018', 'Cagliari', '2025-09-09 14:00:00', '2025-09-08 21:00:00'),
('IMO0000019', 'Brindisi', '2025-09-13 13:00:00', '2025-09-12 20:00:00'),
('IMO0000020', 'Bari', '2025-09-18 13:00:00', '2025-09-17 20:00:00'),
('IMO0000020', 'Corfù', '2025-09-19 12:00:00', '2025-09-18 20:00:00'),
('IMO0000021', 'Genova', '2025-09-24 13:00:00', '2025-09-23 20:00:00');


INSERT INTO Persona VALUES
('BNCGNN80A01F205A', 'Gianna', 'Bianchi', 'F'),
('RSSPLA81B02H501B', 'Paolo', 'Rossi', 'M'),
('VRDLGI82C03L219C', 'Giulia', 'Verdi', 'F'),
('PLLMNL83D04A562D', 'Manuel', 'Paolini', 'M'),
('GRGFNC84M05C351E', 'Francesca', 'Gargiulo', 'F'),
('BNCLRA85C06H501F', 'Lara', 'Bianchi', 'F'),
('RSSMRA86A07F205G', 'Mario', 'Russo', 'M'),
('VRDLGU87T08L219H', 'Luigi', 'Verdi', 'M'),
('PLLMNL88D09A562I', 'Manuela', 'Pallini', 'F'),
('GRGFNC89M10C351J', 'Gianfranco', 'Gargiulo', 'M'),
('BNCLRA90C11H501K', 'Lorenzo', 'Bianchi', 'M'),
('RSSMRA91A12F205L', 'Martina', 'Rossi', 'F'),
('VRDLGU92T13L219M', 'Lucia', 'Verdi', 'F'),
('PLLMNL93D14A562N', 'Manolo', 'Paolini', 'M'),
('GRGFNC94M15C351O', 'Giorgia', 'Gargiulo', 'F'),
('BNCLRA95C16H501P', 'Leonardo', 'Bianchi', 'M'),
('RSSMRA96A17F205Q', 'Marta', 'Rossi', 'F'),
('VRDLGU97T18L219R', 'Ludovica', 'Verdi', 'F'),
('PLLMNL98D19A562S', 'Manuela', 'Pallini', 'F'),
('GRGFNC99M20C351T', 'Gianluca', 'Gargiulo', 'M'),
('BNCLRA00C21H501U', 'Luca', 'Bianchi', 'M'),
('RSSMRA01A22F205V', 'Marco', 'Rossi', 'M'),
('VRDLGU02T23L219W', 'Luisa', 'Verdi', 'F'),
('PLLMNL03D24A562X', 'Manuela', 'Paolini', 'F'),
('GRGFNC04M25C351Y', 'Franco', 'Gargiulo', 'M'),
('BNCLRA05C26H501Z', 'Lara', 'Bianchi', 'F'),
('RSSMRA06A27F205A', 'Mario', 'Rossi', 'M'),
('VRDLGU07T28L219B', 'Luca', 'Verdi', 'M'),
('PLLMNL08D29A562C', 'Manuela', 'Paolini', 'F'),
('GRGFNC09M30C351D', 'Francesco', 'Gargiulo', 'M'),
('BNCLRA10C31H501E', 'Laura', 'Bianchi', 'F'),
('RSSMRA11A32F205F', 'Mario', 'Rossi', 'M'),
('VRDLGU12T33L219G', 'Luca', 'Verdi', 'M'),
('PLLMNL13D34A562H', 'Manuela', 'Paolini', 'F'),
('GRGFNC14M35C351I', 'Francesco', 'Gargiulo', 'M'),
('BNCLRA15C36H501J', 'Laura', 'Bianchi', 'F'),
('RSSMRA16A37F205K', 'Mario', 'Rossi', 'M'),
('VRDLGU17T38L219L', 'Luca', 'Verdi', 'M'),
('PLLMNL18D39A562M', 'Manuela', 'Paolini', 'F'),
('GRGFNC19M40C351N', 'Francesco', 'Gargiulo', 'M'),
('BNCLRA20C41H501O', 'Laura', 'Bianchi', 'F'),
('RSSMRA21A42F205P', 'Mario', 'Rossi', 'M'),
('VRDLGU22T43L219Q', 'Luca', 'Verdi', 'M'),
('PLLMNL23D44A562R', 'Manuela', 'Paolini', 'F'),
('GRGFNC24M45C351S', 'Francesco', 'Gargiulo', 'M'),
('BNCLRA25C46H501T', 'Laura', 'Bianchi', 'F'),
('RSSMRA26A47F205U', 'Mario', 'Rossi', 'M'),
('VRDLGU27T48L219V', 'Luca', 'Verdi', 'M'),
('PLLMNL28D49A562W', 'Manuela', 'Paolini', 'F'),
('GRGFNC29M50C351X', 'Francesco', 'Gargiulo', 'M'),
('BNCLRA30C51H501Y', 'Laura', 'Bianchi', 'F'),
('RSSMRA31A52F205Z', 'Mario', 'Rossi', 'M'),
('VRDLGU32T53L219A', 'Luca', 'Verdi', 'M'),
('PLLMNL33D54A562B', 'Manuela', 'Paolini', 'F'),
('GRGFNC34M55C351C', 'Francesco', 'Gargiulo', 'M'),
('BNCLRA35C56H501D', 'Laura', 'Bianchi', 'F'),
('RSSMRA36A57F205E', 'Mario', 'Rossi', 'M'),
('VRDLGU37T58L219F', 'Luca', 'Verdi', 'M'),
('PLLMNL38D59A562G', 'Manuela', 'Paolini', 'F'),
('GRGFNC39M60C351H', 'Francesco', 'Gargiulo', 'M'),
('BNCLRA40C61H501I', 'Laura', 'Bianchi', 'F'),
('RSSMRA41A62F205J', 'Mario', 'Rossi', 'M'),
('VRDLGU42T63L219K', 'Luca', 'Verdi', 'M'),
('PLLMNL43D64A562L', 'Manuela', 'Paolini', 'F'),
('GRGFNC44M65C351M', 'Francesco', 'Gargiulo', 'M'),
('BNCLRA45C66H501N', 'Laura', 'Bianchi', 'F'),
('RSSMRA46A67F205O', 'Mario', 'Rossi', 'M'),
('VRDLGU47T68L219P', 'Luca', 'Verdi', 'M'),
('PLLMNL48D69A562Q', 'Manuela', 'Paolini', 'F'),
('GRGFNC49M70C351R', 'Francesco', 'Gargiulo', 'M'),
('BNCLRA50C71H501S', 'Laura', 'Bianchi', 'F'),
('RSSMRA51A72F205T', 'Mario', 'Rossi', 'M'),
('VRDLGU52T73L219U', 'Luca', 'Verdi', 'M'),
('PLLMNL53D74A562V', 'Manuela', 'Paolini', 'F'),
('GRGFNC54M75C351W', 'Francesco', 'Gargiulo', 'M'),
('BNCLRA55C76H501X', 'Laura', 'Bianchi', 'F'),
('RSSMRA56A77F205Y', 'Mario', 'Rossi', 'M'),
('VRDLGU57T78L219Z', 'Luca', 'Verdi', 'M'),
('PLLMNL58D79A562A', 'Manuela', 'Paolini', 'F'),
('GRGFNC59M80C351B', 'Francesco', 'Gargiulo', 'M'),
('BNCLRA60C81H501C', 'Laura', 'Bianchi', 'F'),
('RSSMRA61A82F205D', 'Mario', 'Rossi', 'M'),
('VRDLGU62T83L219E', 'Luca', 'Verdi', 'M'),
('PLLMNL63D84A562F', 'Manuela', 'Paolini', 'F'),
('GRGFNC64M85C351G', 'Francesco', 'Gargiulo', 'M'),
('BNCLRA65C86H501H', 'Laura', 'Bianchi', 'F'),
('RSSMRA66A87F205I', 'Mario', 'Rossi', 'M'),
('VRDLGU67T88L219J', 'Luca', 'Verdi', 'M'),
('PLLMNL68D89A562K', 'Manuela', 'Paolini', 'F'),
('GRGFNC69M90C351L', 'Francesco', 'Gargiulo', 'M'),
('BNCLRA70C91H501M', 'Laura', 'Bianchi', 'F'),
('RSSMRA71A92F205N', 'Mario', 'Rossi', 'M'),
('VRDLGU72T93L219O', 'Luca', 'Verdi', 'M'),
('PLLMNL73D94A562P', 'Manuela', 'Paolini', 'F'),
('GRGFNC74M95C351Q', 'Francesco', 'Gargiulo', 'M'),
('BNCLRA75C96H501R', 'Laura', 'Bianchi', 'F'),
('RSSMRA76A97F205S', 'Mario', 'Rossi', 'M'),
('VRDLGU77T98L219T', 'Luca', 'Verdi', 'M'),
('PLLMNL78D99A562U', 'Manuela', 'Paolini', 'F'),
('GRGFNC79M00C351V', 'Francesco', 'Gargiulo', 'M'),
('BNCLRA80C01H501W', 'Laura', 'Bianchi', 'F'),
('RSSMRA81A02F205X', 'Mario', 'Rossi', 'M'),
('VRDLGU82T03L219Y', 'Luca', 'Verdi', 'M'),
('PLLMNL83D04A562Z', 'Manuela', 'Paolini', 'F'),
('GRGFNC84M05C351A', 'Francesco', 'Gargiulo', 'M'),
('BNCLRA85C06H501B', 'Laura', 'Bianchi', 'F'),
('RSSMRA86A07F205C', 'Mario', 'Rossi', 'M'),
('VRDLGU87T08L219D', 'Luca', 'Verdi', 'M'),
('PLLMNL88D09A562E', 'Manuela', 'Paolini', 'F'),
('GRGFNC89M10C351F', 'Francesco', 'Gargiulo', 'M'),
('BNCLRA90C11H501G', 'Laura', 'Bianchi', 'F'),
('RSSMRA91A12F205H', 'Mario', 'Rossi', 'M'),
('VRDLGU92T13L219I', 'Luca', 'Verdi', 'M'),
('PLLMNL93D14A562J', 'Manuela', 'Paolini', 'F'),
('GRGFNC94M15C351K', 'Francesco', 'Gargiulo', 'M'),
('BNCLRA95C16H501L', 'Laura', 'Bianchi', 'F'),
('RSSMRA96A17F205M', 'Mario', 'Rossi', 'M'),
('VRDLGU97T18L219N', 'Luca', 'Verdi', 'M'),
('PLLMNL98D19A562O', 'Manuela', 'Paolini', 'F'),
('GRGFNC99M20C351P', 'Francesco', 'Gargiulo', 'M'),
('BNCLRA00C21H501Q', 'Laura', 'Bianchi', 'F'),
('RSSMRA01A22F205R', 'Mario', 'Rossi', 'M'),
('VRDLGU02T23L219S', 'Luca', 'Verdi', 'M'),
('PLLMNL03D24A562T', 'Manuela', 'Paolini', 'F'),
('GRGFNC04M25C351U', 'Francesco', 'Gargiulo', 'M'),
('BNCLRA05C26H501V', 'Laura', 'Bianchi', 'F'),
('RSSMRA06A27F205W', 'Mario', 'Rossi', 'M'),
('VRDLGU07T28L219X', 'Luca', 'Verdi', 'M'),
('PLLMNL08D29A562Y', 'Manuela', 'Paolini', 'F'),
('GRGFNC09M30C351Z', 'Francesco', 'Gargiulo', 'M'),
('BNCLRA10C31H501A', 'Laura', 'Bianchi', 'F'),
('RSSMRA11A32F205B', 'Mario', 'Rossi', 'M'),
('VRDLGU12T33L219C', 'Luca', 'Verdi', 'M'),
('PLLMNL13D34A562D', 'Manuela', 'Paolini', 'F'),
('GRGFNC14M35C351E', 'Francesco', 'Gargiulo', 'M'),
('BNCLRA15C36H501F', 'Laura', 'Bianchi', 'F'),
('RSSMRA16A37F205G', 'Mario', 'Rossi', 'M'),
('VRDLGU17T38L219H', 'Luca', 'Verdi', 'M'),
('PLLMNL18D39A562I', 'Manuela', 'Paolini', 'F'),
('GRGFNC19M40C351J', 'Francesco', 'Gargiulo', 'M'),
('BNCLRA20C41H501K', 'Laura', 'Bianchi', 'F'),
('RSSMRA21A42F205L', 'Mario', 'Rossi', 'M'),
('VRDLGU22T43L219M', 'Luca', 'Verdi', 'M'),
('PLLMNL23D44A562N', 'Manuela', 'Paolini', 'F'),
('GRGFNC24M45C351O', 'Francesco', 'Gargiulo', 'M'),
('BNCLRA25C46H501P', 'Laura', 'Bianchi', 'F'),
('RSSMRA26A47F205Q', 'Mario', 'Rossi', 'M'),
('VRDLGU27T48L219R', 'Luca', 'Verdi', 'M'),
('PLLMNL28D49A562S', 'Manuela', 'Paolini', 'F'),
('GRGFNC29M50C351T', 'Francesco', 'Gargiulo', 'M'),
('BNCLRA30C51H501U', 'Laura', 'Bianchi', 'F'),
('RSSMRA31A52F205V', 'Mario', 'Rossi', 'M'),
('VRDLGU32T53L219W', 'Luca', 'Verdi', 'M'),
('PLLMNL33D54A562X', 'Manuela', 'Paolini', 'F'),
('GRGFNC34M55C351Y', 'Francesco', 'Gargiulo', 'M'),
('BNCLRA35C56H501Z', 'Laura', 'Bianchi', 'F'),
('RSSMRA36A57F205A', 'Mario', 'Rossi', 'M'),
('VRDLGU37T58L219B', 'Luca', 'Verdi', 'M'),
('PLLMNL38D59A562C', 'Manuela', 'Paolini', 'F'),
('GRGFNC39M60C351D', 'Francesco', 'Gargiulo', 'M'),
('BNCLRA40C61H501E', 'Laura', 'Bianchi', 'F'),
('RSSMRA41A62F205F', 'Mario', 'Rossi', 'M'),
('VRDLGU42T63L219G', 'Luca', 'Verdi', 'M'),
('PLLMNL43D64A562H', 'Manuela', 'Paolini', 'F'),
('GRGFNC44M65C351I', 'Francesco', 'Gargiulo', 'M'),
('BNCLRA45C66H501J', 'Laura', 'Bianchi', 'F'),
('RSSMRA46A67F205K', 'Mario', 'Rossi', 'M'),
('VRDLGU47T68L219L', 'Luca', 'Verdi', 'M'),
('PLLMNL48D69A562M', 'Manuela', 'Paolini', 'F'),
('GRGFNC49M70C351N', 'Francesco', 'Gargiulo', 'M'),
('BNCLRA50C71H501O', 'Laura', 'Bianchi', 'F'),
('RSSMRA51A72F205P', 'Mario', 'Rossi', 'M'),
('VRDLGU52T73L219Q', 'Luca', 'Verdi', 'M'),
('PLLMNL53D74A562R', 'Manuela', 'Paolini', 'F'),
('GRGFNC54M75C351S', 'Francesco', 'Gargiulo', 'M'),
('BNCLRA55C76H501T', 'Laura', 'Bianchi', 'F'),
('RSSMRA56A77F205U', 'Mario', 'Rossi', 'M'),
('VRDLGU57T78L219V', 'Luca', 'Verdi', 'M'),
('PLLMNL58D79A562W', 'Manuela', 'Paolini', 'F');

INSERT INTO Ospite VALUES
('BNCGNN80A01F205A', 523.00, 'IMO0000001'),
('RSSPLA81B02H501B', 784.00, 'IMO0000002'),
('VRDLGI82C03L219C', 672.00, 'IMO0000003'),
('PLLMNL83D04A562D', 915.00, 'IMO0000004'),
('GRGFNC84M05C351E', 237.00, 'IMO0000005'),
('BNCLRA85C06H501F', 358.00, 'IMO0000006'),
('RSSMRA86A07F205G', 846.00, 'IMO0000007'),
('VRDLGU87T08L219H', 431.00, 'IMO0000008'),
('PLLMNL88D09A562I', 754.00, 'IMO0000009'),
('GRGFNC89M10C351J', 982.00, 'IMO0000010'),
('BNCLRA90C11H501K', 683.00, 'IMO0000011'),
('RSSMRA91A12F205L', 570.00, 'IMO0000012'),
('VRDLGU92T13L219M', 299.00, 'IMO0000013'),
('PLLMNL93D14A562N', 812.00, 'IMO0000014'),
('GRGFNC94M15C351O', 491.00, 'IMO0000015'),
('BNCLRA95C16H501P', 660.00, 'IMO0000016'),
('RSSMRA96A17F205Q', 218.00, 'IMO0000017'),
('VRDLGU97T18L219R', 931.00, 'IMO0000018'),
('PLLMNL98D19A562S', 401.00, 'IMO0000019'),
('GRGFNC99M20C351T', 597.00, 'IMO0000020'),
('BNCLRA00C21H501U', 747.00, 'IMO0000021'),
('RSSMRA01A22F205V', 268.00, 'IMO0000022'),
('VRDLGU02T23L219W', 369.00, 'IMO0000023'),
('PLLMNL03D24A562X', 950.00, 'IMO0000024'),
('GRGFNC04M25C351Y', 472.00, 'IMO0000025'),
('BNCLRA05C26H501Z', 821.00, 'IMO0000026'),
('RSSMRA06A27F205A', 315.00, 'IMO0000027'),
('VRDLGU07T28L219B', 574.00, 'IMO0000028'),
('PLLMNL08D29A562C', 639.00, 'IMO0000029'),
('GRGFNC09M30C351D', 801.00, 'IMO0000030'),
('BNCLRA10C31H501E', 422.00, 'IMO0000031'),
('RSSMRA11A32F205F', 978.00, 'IMO0000032'),
('VRDLGU12T33L219G', 283.00, 'IMO0000033'),
('PLLMNL13D34A562H', 631.00, 'IMO0000034'),
('GRGFNC14M35C351I', 704.00, 'IMO0000035'),
('BNCLRA15C36H501J', 460.00, 'IMO0000001'),
('RSSMRA16A37F205K', 595.00, 'IMO0000002'),
('VRDLGU17T38L219L', 781.00, 'IMO0000003'),
('PLLMNL18D39A562M', 314.00, 'IMO0000004'),
('GRGFNC19M40C351N', 257.00, 'IMO0000005'),
('BNCLRA20C41H501O', 820.00, 'IMO0000006'),
('RSSMRA21A42F205P', 485.00, 'IMO0000007'),
('VRDLGU22T43L219Q', 923.00, 'IMO0000008'),
('PLLMNL23D44A562R', 533.00, 'IMO0000009'),
('GRGFNC24M45C351S', 699.00, 'IMO0000010'),
('BNCLRA25C46H501T', 611.00, 'IMO0000011'),
('RSSMRA26A47F205U', 376.00, 'IMO0000012'),
('VRDLGU27T48L219V', 821.00, 'IMO0000013'),
('PLLMNL28D49A562W', 734.00, 'IMO0000014'),
('GRGFNC29M50C351X', 259.00, 'IMO0000015');


INSERT INTO Equipaggio VALUES
('PLLMNL68D89A562K', 'EQ001', 'Italiano, Inglese', 2200.00, 5, 'IMO0000001'),
('GRGFNC69M90C351L', 'EQ001', 'Italiano, Inglese', 2100.00, 4, 'IMO0000001'),
('BNCLRA70C91H501M', 'EQ001', 'Italiano, Inglese', 2150.00, 3, 'IMO0000018'),
('RSSMRA71A92F205N', 'EQ001', 'Italiano, Inglese', 2250.00, 7, 'IMO0000002'),
('VRDLGU72T93L219O', 'EQ001', 'Italiano, Inglese', 2300.00, 6, 'IMO0000003'),
('PLLMNL73D94A562P', 'EQ002', 'Italiano, Inglese', 2100.00, 2, 'IMO0000005'),
('GRGFNC74M95C351Q', 'EQ002', 'Italiano, Inglese', 2200.00, 3, 'IMO0000003'),
('BNCLRA75C96H501R', 'EQ002', 'Italiano, Inglese', 2050.00, 1, 'IMO0000016'),
('RSSMRA76A97F205S', 'EQ002', 'Italiano, Inglese', 2350.00, 8, 'IMO0000005'),
('VRDLGU77T98L219T', 'EQ002', 'Italiano, Inglese', 2400.00, 5, 'IMO0000020'),
('PLLMNL78D99A562U', 'EQ003', 'Italiano, Inglese', 2250.00, 4, 'IMO0000009'),
('GRGFNC79M00C351V', 'EQ003', 'Italiano, Inglese', 2150.00, 3, 'IMO0000015'),
('BNCLRA80C01H501W', 'EQ003', 'Italiano, Inglese', 2200.00, 5, 'IMO0000019'),
('RSSMRA81A02F205X', 'EQ003', 'Italiano, Inglese', 2100.00, 2, 'IMO0000008'),
('VRDLGU82T03L219Y', 'EQ003', 'Italiano, Inglese', 2300.00, 7, 'IMO0000007'),
('PLLMNL83D04A562Z', 'EQ004', 'Italiano, Inglese', 2400.00, 8, 'IMO0000035'),
('GRGFNC84M05C351A', 'EQ004', 'Italiano, Inglese', 2350.00, 6, 'IMO0000034'),
('BNCLRA85C06H501B', 'EQ004', 'Italiano, Inglese', 2250.00, 5, 'IMO0000033'),
('RSSMRA86A07F205C', 'EQ004', 'Italiano, Inglese', 2150.00, 4, 'IMO0000032'),
('VRDLGU87T08L219D', 'EQ004', 'Italiano, Inglese', 2200.00, 3, 'IMO0000004'),
('PLLMNL88D09A562E', 'EQ005', 'Italiano, Inglese', 2100.00, 2, 'IMO0000031'),
('GRGFNC89M10C351F', 'EQ005', 'Italiano, Inglese', 2250.00, 5, 'IMO0000030'),
('BNCLRA90C11H501G', 'EQ005', 'Italiano, Inglese', 2350.00, 7, 'IMO0000029'),
('RSSMRA91A12F205H', 'EQ005', 'Italiano, Inglese', 2300.00, 6, 'IMO0000028'),
('VRDLGU92T13L219I', 'EQ005', 'Italiano, Inglese', 2200.00, 4, 'IMO0000027'),
('PLLMNL93D14A562J', 'EQ006', 'Italiano, Inglese', 2150.00, 3, 'IMO0000026'),
('GRGFNC94M15C351K', 'EQ006', 'Italiano, Inglese', 2100.00, 2, 'IMO0000025'),
('BNCLRA95C16H501L', 'EQ006', 'Italiano, Inglese', 2200.00, 5, 'IMO0000024'),
('RSSMRA96A17F205M', 'EQ006', 'Italiano, Inglese', 2250.00, 6, 'IMO0000023'),
('VRDLGU97T18L219N', 'EQ006', 'Italiano, Inglese', 2300.00, 7, 'IMO0000006'),
('PLLMNL98D19A562O', 'EQ007', 'Italiano, Inglese', 2100.00, 3, 'IMO0000022'),
('GRGFNC99M20C351P', 'EQ007', 'Italiano, Inglese', 2150.00, 4, 'IMO0000021'),
('BNCLRA00C21H501Q', 'EQ007', 'Italiano, Inglese', 2200.00, 5, 'IMO0000020'),
('RSSMRA01A22F205R', 'EQ007', 'Italiano, Inglese', 2250.00, 6, 'IMO0000017'),
('VRDLGU02T23L219S', 'EQ007', 'Italiano, Inglese', 2300.00, 7, 'IMO0000016'),
('PLLMNL03D24A562T', 'EQ008', 'Italiano, Inglese', 2350.00, 8, 'IMO0000014'),
('GRGFNC04M25C351U', 'EQ008', 'Italiano, Inglese', 2400.00, 9, 'IMO0000013'),
('BNCLRA05C26H501V', 'EQ008', 'Italiano, Inglese', 2300.00, 7, 'IMO0000012'),
('RSSMRA06A27F205W', 'EQ008', 'Italiano, Inglese', 2250.00, 6, 'IMO0000008'),
('VRDLGU07T28L219X', 'EQ008', 'Italiano, Inglese', 2200.00, 5, 'IMO0000008'),
('PLLMNL08D29A562Y', 'EQ009', 'Italiano, Inglese', 2150.00, 4, 'IMO0000011'),
('GRGFNC09M30C351Z', 'EQ009', 'Italiano, Inglese', 2100.00, 3, 'IMO0000010'),
('BNCLRA10C31H501A', 'EQ009', 'Italiano, Inglese', 2200.00, 5, 'IMO0000009'),
('RSSMRA11A32F205B', 'EQ009', 'Italiano, Inglese', 2250.00, 6, 'IMO0000009'),
('VRDLGU12T33L219C', 'EQ009', 'Italiano, Inglese', 2300.00, 7, 'IMO0000009'),
('PLLMNL13D34A562D', 'EQ010', 'Italiano, Inglese', 2350.00, 8, 'IMO0000006'),
('GRGFNC14M35C351E', 'EQ010', 'Italiano, Inglese', 2400.00, 9, 'IMO0000007'),
('BNCLRA15C36H501F', 'EQ010', 'Italiano, Inglese', 2300.00, 7, 'IMO0000008'),
('RSSMRA16A37F205G', 'EQ010', 'Italiano, Inglese', 2250.00, 6, 'IMO0000035'),
('VRDLGU17T38L219H', 'EQ010', 'Italiano, Inglese', 2200.00, 5, 'IMO0000010'),
('PLLMNL18D39A562I', 'EQ011', 'Italiano, Inglese', 2150.00, 4, 'IMO0000011'),
('GRGFNC19M40C351J', 'EQ011', 'Italiano, Inglese', 2100.00, 3, 'IMO0000021'),
('BNCLRA20C41H501K', 'EQ011', 'Italiano, Inglese', 2200.00, 5, 'IMO0000011'),
('RSSMRA21A42F205L', 'EQ011', 'Italiano, Inglese', 2250.00, 6, 'IMO0000031'),
('VRDLGU22T43L219M', 'EQ011', 'Italiano, Inglese', 2300.00, 7, 'IMO0000011'),
('PLLMNL23D44A562N', 'EQ012', 'Italiano, Inglese', 2350.00, 8, 'IMO0000022'),
('GRGFNC24M45C351O', 'EQ012', 'Italiano, Inglese', 2400.00, 9, 'IMO0000012'),
('BNCLRA25C46H501P', 'EQ012', 'Italiano, Inglese', 2300.00, 7, 'IMO0000032'),
('RSSMRA26A47F205Q', 'EQ012', 'Italiano, Inglese', 2250.00, 6, 'IMO0000012'),
('VRDLGU27T48L219R', 'EQ012', 'Italiano, Inglese', 2200.00, 5, 'IMO0000022'),
('PLLMNL28D49A562S', 'EQ013', 'Italiano, Inglese', 2150.00, 4, 'IMO0000013'),
('GRGFNC29M50C351T', 'EQ013', 'Italiano, Inglese', 2100.00, 3, 'IMO0000033'),
('BNCLRA30C51H501U', 'EQ013', 'Italiano, Inglese', 2200.00, 5, 'IMO0000013'),
('RSSMRA31A52F205V', 'EQ013', 'Italiano, Inglese', 2250.00, 6, 'IMO0000023'),
('VRDLGU32T53L219W', 'EQ013', 'Italiano, Inglese', 2300.00, 7, 'IMO0000013'),
('PLLMNL33D54A562X', 'EQ014', 'Italiano, Inglese', 2350.00, 8, 'IMO0000024'),
('GRGFNC34M55C351Y', 'EQ014', 'Italiano, Inglese', 2400.00, 9, 'IMO0000014'),
('BNCLRA35C56H501Z', 'EQ014', 'Italiano, Inglese', 2300.00, 7, 'IMO0000034'),
('RSSMRA36A57F205A', 'EQ014', 'Italiano, Inglese', 2250.00, 6, 'IMO0000014'),
('VRDLGU37T58L219B', 'EQ014', 'Italiano, Inglese', 2200.00, 5, 'IMO0000024'),
('PLLMNL38D59A562C', 'EQ015', 'Italiano, Inglese', 2150.00, 4, 'IMO0000015'),
('GRGFNC39M60C351D', 'EQ015', 'Italiano, Inglese', 2100.00, 3, 'IMO0000035'),
('BNCLRA40C61H501E', 'EQ015', 'Italiano, Inglese', 2200.00, 5, 'IMO0000015'),
('RSSMRA41A62F205F', 'EQ015', 'Italiano, Inglese', 2250.00, 6, 'IMO0000025'),
('VRDLGU42T63L219G', 'EQ015', 'Italiano, Inglese', 2300.00, 7, 'IMO0000015'),
('PLLMNL43D64A562H', 'EQ016', 'Italiano, Inglese', 2350.00, 8, 'IMO0000026'),
('GRGFNC44M65C351I', 'EQ016', 'Italiano, Inglese', 2400.00, 9, 'IMO0000016'),
('BNCLRA45C66H501J', 'EQ016', 'Italiano, Inglese', 2300.00, 7, 'IMO0000026'),
('RSSMRA46A67F205K', 'EQ016', 'Italiano, Inglese', 2250.00, 6, 'IMO0000016'),
('VRDLGU47T68L219L', 'EQ016', 'Italiano, Inglese', 2200.00, 5, 'IMO0000006'),
('PLLMNL48D69A562M', 'EQ017', 'Italiano, Inglese', 2150.00, 4, 'IMO0000017'),
('GRGFNC49M70C351N', 'EQ017', 'Italiano, Inglese', 2100.00, 3, 'IMO0000017');


INSERT INTO Animatore VALUES
('PLLMNL68D89A562K', 'Balli di gruppo, Karaoke'),
('GRGFNC69M90C351L', 'Giochi per bambini, Spettacoli di magia'),
('BNCLRA70C91H501M', 'Organizzazione feste, Animazione sportiva'),
('RSSMRA71A92F205N', 'Balli di gruppo, Musica dal vivo'),
('VRDLGU72T93L219O', 'Karaoke, Animazione teatrale'),
('PLLMNL73D94A562P', 'Spettacoli di magia, Laboratori creativi'),
('GRGFNC74M95C351Q', 'Giochi di gruppo, Animazione per famiglie'),
('BNCLRA75C96H501R', 'Laboratori creativi, Balli di gruppo'),
('RSSMRA76A97F205S', 'Karaoke, Animazione sportiva'),
('VRDLGU77T98L219T', 'Animazione teatrale, Spettacoli di magia'),
('PLLMNL78D99A562U', 'Giochi per bambini, Musica dal vivo'),
('GRGFNC79M00C351V', 'Organizzazione feste, Laboratori creativi'),
('BNCLRA80C01H501W', 'Balli di gruppo, Giochi di gruppo'),
('RSSMRA81A02F205X', 'Animazione sportiva, Karaoke'),
('VRDLGU82T03L219Y', 'Spettacoli di magia, Animazione per famiglie');


INSERT INTO Evento VALUES
('Festa di Benvenuto', 'Intrattenimento', 'IMO0000001', 150, 2, 18),
('Karaoke Night', 'Musica', 'IMO0000001', 100, 1, 16),
('Spettacolo Teatrale', 'Teatro', 'IMO0000002', 120, 2, 14),
('Cena di Gala', 'Cucina', 'IMO0000002', 200, 2, 18),
('Serata Latina', 'Balli', 'IMO0000003', 120, 2, 16),
('Quiz Night', 'Giochi', 'IMO0000003', 80, 1, 14),
('Cinema sotto le Stelle', 'Cinema', 'IMO0000004', 100, 1, 12),
('Aperitivo Musicale', 'Musica', 'IMO0000004', 90, 1, 16),
('Laboratorio Creativo', 'Laboratori', 'IMO0000005', 60, 1, 10),
('Serata Jazz', 'Musica', 'IMO0000005', 110, 1, 18),
('Spettacolo di Magia', 'Intrattenimento', 'IMO0000006', 130, 2, 12),
('Degustazione Vini', 'Cucina', 'IMO0000006', 70, 1, 18),
('Torneo di Ping Pong', 'Sport', 'IMO0000007', 40, 1, 12),
('Serata Disco', 'Balli', 'IMO0000007', 150, 2, 16),
('Yoga al Tramonto', 'Benessere', 'IMO0000008', 30, 1, 14),
('Spettacolo Comico', 'Teatro', 'IMO0000008', 120, 2, 16),
('Laboratorio di Pittura', 'Laboratori', 'IMO0000009', 50, 1, 10),
('Serata Karaoke', 'Musica', 'IMO0000009', 90, 1, 16),
('Cena a Tema', 'Cucina', 'IMO0000010', 200, 2, 18),
('Spettacolo di Danza', 'Balli', 'IMO0000010', 100, 1, 14),
('Serata Cinema', 'Cinema', 'IMO0000011', 80, 1, 12),
('Laboratorio di Cucina', 'Laboratori', 'IMO0000011', 60, 1, 10),
('Spettacolo di Burattini', 'Intrattenimento', 'IMO0000012', 70, 1, 8),
('Serata Rock', 'Musica', 'IMO0000012', 120, 2, 16),
('Torneo di Calcio Balilla', 'Sport', 'IMO0000013', 40, 1, 12),
('Serata Anni 80', 'Balli', 'IMO0000013', 150, 2, 16),
('Laboratorio di Fotografia', 'Laboratori', 'IMO0000014', 50, 1, 14),
('Spettacolo di Illusionismo', 'Intrattenimento', 'IMO0000014', 130, 2, 12),
('Serata Jazz', 'Musica', 'IMO0000015', 110, 1, 18),
('Cena di Gala', 'Cucina', 'IMO0000015', 200, 2, 18),
('Spettacolo di Cabaret', 'Teatro', 'IMO0000016', 120, 2, 14),
('Serata Disco', 'Balli', 'IMO0000016', 150, 2, 16),
('Laboratorio di Scacchi', 'Laboratori', 'IMO0000017', 30, 1, 10),
('Serata Cinema', 'Cinema', 'IMO0000017', 80, 1, 12),
('Spettacolo di Magia', 'Intrattenimento', 'IMO0000018', 130, 2, 12),
('Serata Karaoke', 'Musica', 'IMO0000018', 90, 1, 16),
('Laboratorio di Pittura', 'Laboratori', 'IMO0000019', 50, 1, 10),
('Serata Latina', 'Balli', 'IMO0000019', 120, 2, 16),
('Cena a Tema', 'Cucina', 'IMO0000020', 200, 2, 18),
('Spettacolo di Danza', 'Balli', 'IMO0000020', 100, 1, 14),
('Serata Cinema', 'Cinema', 'IMO0000021', 80, 1, 12),
('Laboratorio di Cucina', 'Laboratori', 'IMO0000021', 60, 1, 10),
('Spettacolo di Burattini', 'Intrattenimento', 'IMO0000022', 70, 1, 8),
('Serata Rock', 'Musica', 'IMO0000022', 120, 2, 16),
('Torneo di Calcio Balilla', 'Sport', 'IMO0000023', 40, 1, 12),
('Serata Anni 80', 'Balli', 'IMO0000023', 150, 2, 16),
('Laboratorio di Fotografia', 'Laboratori', 'IMO0000024', 50, 1, 14),
('Spettacolo di Illusionismo', 'Intrattenimento', 'IMO0000024', 130, 2, 12),
('Serata Jazz', 'Musica', 'IMO0000025', 110, 1, 18),
('Cena di Gala', 'Cucina', 'IMO0000025', 200, 2, 18),
('Spettacolo di Cabaret', 'Teatro', 'IMO0000026', 120, 2, 14),
('Serata Disco', 'Balli', 'IMO0000026', 150, 2, 16),
('Laboratorio di Scacchi', 'Laboratori', 'IMO0000027', 30, 1, 10),
('Serata Cinema', 'Cinema', 'IMO0000027', 80, 1, 12),
('Spettacolo di Magia', 'Intrattenimento', 'IMO0000028', 130, 2, 12),
('Serata Karaoke', 'Musica', 'IMO0000028', 90, 1, 16),
('Laboratorio di Pittura', 'Laboratori', 'IMO0000029', 50, 1, 10),
('Serata Latina', 'Balli', 'IMO0000029', 120, 2, 16),
('Cena a Tema', 'Cucina', 'IMO0000030', 200, 2, 18),
('Spettacolo di Danza', 'Balli', 'IMO0000030', 100, 1, 14),
('Serata Cinema', 'Cinema', 'IMO0000031', 80, 1, 12),
('Laboratorio di Cucina', 'Laboratori', 'IMO0000031', 60, 1, 10),
('Spettacolo di Burattini', 'Intrattenimento', 'IMO0000032', 70, 1, 8),
('Serata Rock', 'Musica', 'IMO0000032', 120, 2, 16),
('Torneo di Calcio Balilla', 'Sport', 'IMO0000033', 40, 1, 12),
('Serata Anni 80', 'Balli', 'IMO0000033', 150, 2, 16),
('Laboratorio di Fotografia', 'Laboratori', 'IMO0000034', 50, 1, 14),
('Spettacolo di Illusionismo', 'Intrattenimento', 'IMO0000034', 130, 2, 12),
('Serata Jazz', 'Musica', 'IMO0000035', 110, 1, 18),
('Torneo di Calcio Balilla', 'Sport', 'IMO0000007', 40, 1, 4),
('Cena di Gala', 'Cucina', 'IMO0000035', 200, 2, 18);

INSERT INTO ORGANIZZA VALUES
('PLLMNL68D89A562K', 'Festa di Benvenuto', 'Intrattenimento', 'IMO0000001'),
('GRGFNC69M90C351L', 'Karaoke Night', 'Musica', 'IMO0000001'),
('BNCLRA70C91H501M', 'Spettacolo di Magia', 'Intrattenimento', 'IMO0000018'),
('RSSMRA71A92F205N', 'Spettacolo Teatrale', 'Teatro', 'IMO0000002'),
('VRDLGU72T93L219O', 'Serata Latina', 'Balli', 'IMO0000003'),
('PLLMNL73D94A562P', 'Laboratorio Creativo', 'Laboratori', 'IMO0000005'),
('GRGFNC74M95C351Q', 'Quiz Night', 'Giochi', 'IMO0000003'),
('BNCLRA75C96H501R', 'Serata Disco', 'Balli', 'IMO0000016'),
('RSSMRA76A97F205S', 'Serata Jazz', 'Musica', 'IMO0000005'),
('VRDLGU77T98L219T', 'Spettacolo di Danza', 'Balli', 'IMO0000020'),
('PLLMNL78D99A562U', 'Serata Karaoke', 'Musica', 'IMO0000009'),
('GRGFNC79M00C351V', 'Cena di Gala', 'Cucina', 'IMO0000015'),
('BNCLRA80C01H501W', 'Laboratorio di Pittura', 'Laboratori', 'IMO0000019'),
('RSSMRA81A02F205X', 'Spettacolo Comico', 'Teatro', 'IMO0000008'),
('PLLMNL68D89A562K', 'Karaoke Night', 'Musica', 'IMO0000001'),
('GRGFNC69M90C351L', 'Festa di Benvenuto', 'Intrattenimento', 'IMO0000001'),
('BNCLRA70C91H501M', 'Serata Karaoke', 'Musica', 'IMO0000018'),
('RSSMRA71A92F205N', 'Cena di Gala', 'Cucina', 'IMO0000002'),
('VRDLGU72T93L219O', 'Quiz Night', 'Giochi', 'IMO0000003'),
('PLLMNL73D94A562P', 'Serata Jazz', 'Musica', 'IMO0000005'),
('GRGFNC74M95C351Q', 'Serata Latina', 'Balli', 'IMO0000003'),
('BNCLRA75C96H501R', 'Spettacolo di Cabaret', 'Teatro', 'IMO0000016'),
('RSSMRA76A97F205S', 'Laboratorio Creativo', 'Laboratori', 'IMO0000005'),
('VRDLGU77T98L219T', 'Cena a Tema', 'Cucina', 'IMO0000020'),
('PLLMNL78D99A562U', 'Laboratorio di Pittura', 'Laboratori', 'IMO0000009'),
('GRGFNC79M00C351V', 'Serata Jazz', 'Musica', 'IMO0000015'),
('BNCLRA80C01H501W', 'Serata Latina', 'Balli', 'IMO0000019'),
('RSSMRA81A02F205X', 'Yoga al Tramonto', 'Benessere', 'IMO0000008'),
('VRDLGU82T03L219Y', 'Torneo di Calcio Balilla', 'Sport', 'IMO0000007'),
('VRDLGU82T03L219Y', 'Torneo di Ping Pong', 'Sport', 'IMO0000007');


CREATE INDEX idx_crociera_porto_partenza ON Crociera(Porto_Partenza) USING HASH;

-- Query 1 - Trovare le crociere che toccano piu' di un numero di porti diversi indicati dall'utente
SELECT C.IMO, C.Nome_Nave, C.Porto_Partenza, C.Porto_Finale, COUNT(DISTINCT T.Città) AS Numero_Tappe
FROM Crociera C
JOIN Tappa T ON C.IMO = T.IMO
GROUP BY C.IMO, C.Nome_Nave, C.Porto_Partenza, C.Porto_Finale
HAVING COUNT(DISTINCT T.Città) > '<NUMERO TAPPE>'
ORDER BY Numero_Tappe DESC;

-- Query 2 - Visualizzare tutte le crociere in partenza da una citta' inserita dall'utente
SELECT c.IMO, c.Nome_Nave, c.Num_Prenotazioni
FROM Crociera c
WHERE c.Porto_Partenza = '<PORTO>';

-- Query 3 - Trovare le crociere che hanno una media del costo dei biglietti superiore a un importo dato
SELECT O.IMO_Crociera, C.Nome_Nave, AVG(O.Costo) AS Media_Costo
FROM Ospite O
JOIN Crociera C ON O.IMO_Crociera = C.IMO
GROUP BY O.IMO_Crociera, C.Nome_Nave
HAVING AVG(O.Costo) > '<PREZZO>'
ORDER BY Media_Costo DESC;

-- Query 4 - Visualizzare il numero di Animatori e Media Eventi Organizzati per Crociera
SELECT 
    C.Nome_Nave,
    C.IMO,
    COUNT(DISTINCT A.CF) AS Num_Animatori,
    ROUND(CAST(COUNT(O.CF_Animatore) AS DECIMAL) / NULLIF(COUNT(DISTINCT A.CF), 0), 2) AS Media_Eventi_Per_Animatore
FROM Crociera C
JOIN Evento E ON C.IMO = E.IMO_Crociera
JOIN ORGANIZZA O ON E.Nome = O.Nome_Evento 
                 AND E.Tipologia = O.Tipologia_Evento 
                 AND E.IMO_Crociera = O.IMO_Crociera_Evento
JOIN Animatore A ON A.CF = O.CF_Animatore
GROUP BY C.Nome_Nave, C.IMO
ORDER BY Media_Eventi_Per_Animatore DESC;


-- Query 5 - Trovare, per ogni crociera, la percentuale di occupazione rispetto alla capacita' massima (Num_Prenotazioni / Max_Passeggeri) 
SELECT IMO, Nome_Nave,
    ROUND((Num_Prenotazioni * 100.0) / Max_Passeggeri, 2) AS Percentuale_Occupazione
FROM Crociera
WHERE Max_Passeggeri > 0
  AND (Num_Prenotazioni * 100.0) / Max_Passeggeri > '<PERCENTUALE_MINIMA>'
ORDER BY Percentuale_Occupazione DESC;

-- Query 6 - Trovare le crociere che hanno un numero minimo di tappe e una media del costo degli ospiti inferiore a un certo importo
SELECT C.IMO, C.Nome_Nave, COUNT(DISTINCT T.Città) AS Numero_Tappe, AVG(O.Costo) AS Media_Costo
FROM Crociera C
JOIN Tappa T ON C.IMO = T.IMO
JOIN Ospite O ON C.IMO = O.IMO_Crociera
GROUP BY C.IMO, C.Nome_Nave
HAVING COUNT(DISTINCT T.Città) >= '<NUM_MIN_TAPPE>'
   AND AVG(O.Costo) <= '<MAX_COSTO>'
ORDER BY Numero_Tappe DESC, Media_Costo ASC;