GAMEBOX_SQL.sql

DROP TABLE IF EXISTS INDIRIZZO CASCADE;
DROP TABLE IF EXISTS NEGOZIO CASCADE;
DROP TABLE IF EXISTS PRODOTTO CASCADE;
DROP TABLE IF EXISTS PRODUTTORE CASCADE;
DROP TABLE IF EXISTS VIDEOGIOCO CASCADE;
DROP TABLE IF EXISTS MERCHANDISE CASCADE;
DROP TABLE IF EXISTS CONSOLE CASCADE;
DROP TABLE IF EXISTS ORDINE CASCADE;
DROP TABLE IF EXISTS SPEDIZIONE CASCADE;
DROP TABLE IF EXISTS TESSERA CASCADE;
DROP TABLE IF EXISTS CLIENTE CASCADE;
DROP TABLE IF EXISTS LAN_PARTY CASCADE;
DROP TABLE IF EXISTS POSTAZIONE CASCADE;
DROP TABLE IF EXISTS ACQUISTA CASCADE;
DROP TABLE IF EXISTS OFFERTA CASCADE;
DROP TABLE IF EXISTS ACCEDERE CASCADE;
DROP TABLE IF EXISTS PRESSO CASCADE;

--
-- CREAZIONE TABELLE
--
CREATE TABLE INDIRIZZO (
	COD VARCHAR(7),
	REGIONE VARCHAR(20) NOT null,
	PROVINCIA VARCHAR(2) NOT null,
	VIA VARCHAR(32) NOT null,
	CIVICO SMALLINT NOT null,
  	PRIMARY KEY(COD)
);

CREATE TABLE NEGOZIO (
	COD VARCHAR(6),
	ORARIO_APERTURA TIME NOT null,
	ORARIO_CHIUSURA TIME NOT null,
	DATA_APERTURA DATE NOT null,
	DATA_CHIUSURA DATE,
	INDIRIZZO VARCHAR(7),
  	PRIMARY KEY (COD),
	foreign key (INDIRIZZO) references INDIRIZZO(COD)	on update cascade on delete cascade
);
  
CREATE TABLE PRODOTTO(
	COD VARCHAR(10),
	PREZZO DECIMAL(6,2) NOT null,
	DISPONIBILITA SMALLINT NOT null,
	COD_NEGOZIO	VARCHAR(10),
  	PRIMARY KEY(COD),
	foreign key (COD_NEGOZIO) references NEGOZIO(COD)	on update cascade on delete cascade
);
	
CREATE TABLE PRODUTTORE (
	NOME VARCHAR(50),
	CAPITALE BIGINT NOT null,
	NAZIONALITA VARCHAR(20) NOT null,
	PRIMARY KEY(NOME)
);

CREATE TABLE VIDEOGIOCO (
	COD VARCHAR(10),
	NOME VARCHAR(50), 
	GENERE VARCHAR(20) NOT null,  
	DATA_USCITA DATE NOT null, 
	PEGI INTEGER NOT null, 
	VALUTAZIONE DECIMAL(5,2) NOT null, 
	ONLINE_ INTEGER NOT null, 
	PRODUTTORE VARCHAR(50),
	COD_PRODOTTO VARCHAR(10),
	PRIMARY KEY(COD),
	foreign key (PRODUTTORE) references PRODUTTORE(NOME) on update cascade on delete cascade,
	foreign key (COD_PRODOTTO) references PRODOTTO(COD) on update cascade on delete cascade
);

CREATE TABLE MERCHANDISE (
	COD VARCHAR(10),
	CATEGORIA VARCHAR(20) NOT null,
	NOME VARCHAR(100),
	COD_PRODOTTO VARCHAR(10),
	PRIMARY KEY(COD),
	foreign key (COD_PRODOTTO) references PRODOTTO(COD) on update cascade on delete cascade
);

CREATE TABLE CONSOLE (
	COD VARCHAR(10),
	MODELLO VARCHAR(50) NOT null,
    DATA_USCITA DATE NOT null,
	COLORE VARCHAR(15) NOT null,
	MEMORIA VARCHAR(10) NOT null,
    PRODUTTORE VARCHAR(50),
	COD_PRODOTTO VARCHAR(10),
	PRIMARY KEY(COD),
    foreign key (PRODUTTORE) references PRODUTTORE(NOME) on update cascade on delete cascade,
	foreign key (COD_PRODOTTO) references PRODOTTO(COD) on update cascade on delete cascade
);

CREATE TABLE ORDINE (
	COD VARCHAR(10),
	DATA_ACQUISTO DATE NOT null,
	METODO_PAGAMENTO VARCHAR(20) NOT null,
	SCONTO SMALLINT,
    ONLINE_ SMALLINT NOT null,
	COD_NEGOZIO VARCHAR(6),
	PRIMARY KEY(COD),
	foreign key (COD_NEGOZIO) references NEGOZIO(COD) on update cascade on delete cascade
);

CREATE TABLE SPEDIZIONE (
	NUMERO VARCHAR(6),
	CORRIERE VARCHAR(5) NOT null,
	COSTO DECIMAL(5,2) NOT null,
	ARRIVO_PREVISTO DATE NOT null,
	MODALITA VARCHAR(20) NOT null,
  	COD_ORDINE VARCHAR(5),
	INDIRIZZO VARCHAR(7), 
	PRIMARY KEY(NUMERO),
	foreign key (COD_ORDINE) references ORDINE(COD)	on update cascade on delete cascade,
	foreign key (INDIRIZZO) references INDIRIZZO(COD) on update cascade on delete cascade
);

CREATE TABLE TESSERA (
	LIVELLO VARCHAR(5),
	COLORE VARCHAR(15) NOT null,
	PREZZO DECIMAL(5,2) NOT null,
	PRIMARY KEY(LIVELLO)
);

CREATE TABLE CLIENTE (
	CF VARCHAR(10),
	NOME VARCHAR(20) NOT null,
	COGNOME VARCHAR(20) NOT null,
	EMAIL VARCHAR(50) NOT null,
	DATA_NASCITA DATE NOT null,
  	ABBONATO SMALLINT NOT null,
	PUNTI INTEGER,
	DATA_INIZIO DATE,
	DATA_FINE DATE,
	TESSERA VARCHAR(5),
	INDIRIZZO VARCHAR(7),
	PRIMARY KEY(CF),
	foreign key (TESSERA) references TESSERA(LIVELLO) on update cascade on delete cascade,
	foreign key (INDIRIZZO) references INDIRIZZO(COD) on update cascade on delete cascade
);

CREATE TABLE LAN_PARTY (
	SALA VARCHAR(10),
	OMAGGIO VARCHAR(20) NOT null,
	CONNESSIONE VARCHAR(7) NOT null,
	COD_NEGOZIO VARCHAR(7),
	PRIMARY KEY(SALA),
	foreign key (COD_NEGOZIO) references NEGOZIO(COD)	on update cascade on delete cascade
);

CREATE TABLE POSTAZIONE (
	NUMERO SMALLINT,
	SALA_LAN VARCHAR(10),
    CONSOLE VARCHAR(10),
	PRIMARY KEY(NUMERO, SALA_LAN),
	foreign key (SALA_LAN) references LAN_PARTY(SALA) on update cascade on delete cascade,
    foreign key (CONSOLE) references CONSOLE(COD) on update cascade on delete cascade
);
	
CREATE TABLE ACQUISTA (
	CF_CLIENTE VARCHAR(10),
	PRODOTTO VARCHAR(10),
	ORDINE VARCHAR(10),
	PRIMARY KEY (CF_CLIENTE, PRODOTTO, ORDINE),
	foreign key (CF_CLIENTE) references CLIENTE(CF) on update cascade on delete cascade,
	foreign key (PRODOTTO) references PRODOTTO(COD) on update cascade on delete cascade,
	foreign key (ORDINE) references ORDINE(COD) on update cascade on delete cascade
);

CREATE TABLE OFFERTA (
	COD VARCHAR(10),
	SCONTO SMALLINT NOT null,
	TESSERA VARCHAR(5),
	PRIMARY KEY(COD),
	foreign key (TESSERA) references TESSERA(LIVELLO) on update cascade on delete cascade
);

CREATE TABLE ACCEDERE (
    SALA_LAN VARCHAR(10),
    ABBONATO VARCHAR(10),
    PRIMARY KEY(SALA_LAN, ABBONATO),
    foreign key (SALA_LAN) references LAN_PARTY(SALA) on update cascade on delete cascade,
   	foreign key (ABBONATO) references CLIENTE(CF) on update cascade on delete cascade
);

CREATE TABLE PRESSO (
    COD_NEGOZIO VARCHAR(10),
    COD_PRODOTTO VARCHAR(10),
    PRIMARY KEY(COD_NEGOZIO, COD_PRODOTTO),
    foreign key (COD_NEGOZIO) references NEGOZIO(COD) on update cascade on delete cascade,
    foreign key (COD_PRODOTTO) references PRODOTTO(COD) on update cascade on delete cascade
);
  
--
-- POPOLAZIONE TABELLE
--

INSERT INTO INDIRIZZO (COD, REGIONE, PROVINCIA, VIA, CIVICO) VALUES
	('RMSCH07',		'Lazio',		'RM',	'Schiavonia',			'07'),    
	('RMPON14',		'Lazio',		'RM',	'Ponte di Ferro',		'14'),
	('FIMAN01',		'Toscana',		'FI',	'Mandria',				'01'),
	('FIFIA12',		'Toscana',		'FI',	'Fiaccalcollo',			'12'),
	('FIDRA09',		'Toscana',		'FI',	'Drapperie',			'09'),
	('MICIM14',		'Lombardia',	'MI',	'Cimarie',				'14'),
	('MICAS17',		'Lombardia',	'MI',	'Castel Tialto',		'17'),
	('MIBRO19',		'Lombardia',	'MI',	'Brochindosso',			'19'),
	('PDTRE31',		'Veneto',		'PD',	'Trebbo dei Carbonesi',	'31'),
	('VEVAS25',		'Veneto',		'VE',	'Vasselli',				'25'),
	('NAVIG06',		'Campania',		'NA',	'Vigne',				'06'),
	('NABRO13',		'Campania',		'NA',	'Brombeis',				'13'),
    ('GECAS09',		'Genova',		'GE',	'Tivofe',				'09'),
	('PGLID54',		'Perugia',		'PG',	'Listafe',				'54'),
	('ANBAT89',		'Ancona',		'AN',	'Cheschilli',			'89'),
	('MIFED92',		'Milano',		'MI',	'Dallita',				'92'),
	('ANTES09',		'Ancona',		'AN',	'Sosaso',				'09'),
	('PATIL37',		'Palermo',		'PA',	'Socevo',				'37'),
	('BATEF25',		'Bari',			'BA',	'Basota',				'25'),
	('TSSTA06',		'Trieste',		'TS',	'Achidasa',				'06'),
	('RMFAB91',		'Roma',			'RM',	'Fevofa',				'91'),
	('NAFES17',		'Napoli',		'NA',	'Raceso',				'17'),
	('CZTIF77',		'Catanzaro',	'CZ',	'Cheliso',				'77'),
	('BALIS80',		'Bari',			'BA',	'Stetifa',				'80'),
	('PGTIS91',		'Perugia',		'PG',	'Schivoca',				'91'),
	('BOTAB83',		'Bologna',		'BO',	'Sastavo',				'83'),
	('PGSTE51',		'Perugia',		'PG',	'Cescica',				'51'),
	('PGSAT83',		'Perugia',		'PG',	'Aiscita',				'83'),
	('GELIC06',		'Genova',		'GE',	'Balista',				'06'),
	('VEVOF53',		'Venezia',		'VE',	'Bavoti',				'53'),
	('TSFAL64',		'Trieste',		'TS',	'Atebaste',				'64'),
	('CZLLI96',		'Catanzaro',	'CZ',	'Daschice',				'96'),
	('BAFAS28',		'Bari',			'BA',	'Terasci',				'28'),
	('AODAD80',		'Aosta',		'AO',	'Alichesci',			'80'),
	('TNSTA73',		'Trento',		'TN',	'Tavoce',				'73'),
	('CACET23',		'Cagliari',		'CA',	'Stabasa',				'23'),
	('AOLIT26',		'Aosta',		'AO',	'Alifada',				'26'),
	('PATED78',		'Palermo',		'PA',	'Titira',				'78'),
	('PASCH66',		'Palermo',		'PA',	'Votasa',				'66'),
	('NAFET01',		'Napoli',		'NA',	'Dafesa',				'01'),
	('BOSCH22',		'Bologna',		'BO',	'Lirasta',				'22'),
	('MICAS72',		'Milano',		'MI',	'Vosciso',				'72'),
	('CZRAL19',		'Catanzaro',	'CZ',	'Schicace',				'19'),
	('CBVOR89',		'Campobasso',	'CB',	'Favovo',				'89'),
	('TNSCH51',		'Trento',		'TN',	'Chetefa',				'51'),
	('PAFAD99',		'Palermo',		'PA',	'Fatefa',				'99'),
	('MISOT57',		'Milano',		'MI',	'Lischili',				'57'),
	('AQRAC50',		'Aquila',		'AQ',	'Lichesta',				'50'),
	('CBBAF86',		'Campobasso',	'CB',	'Listaso',				'86'),
	('FITAC05',		'Firenze',		'FI',	'Alidasa',				'05'),
	('PZSCI70',		'Potenza',		'PZ',	'Tilliche',				'70'),
	('PGDAF76',		'Perugia',		'PG',	'Fascischi',			'76'),
	('PAFES12',		'Palermo',		'PA',	'Taschista',			'12'),
	('CZSTE77',		'Catanzaro',	'CZ',	'Scicesa',				'77'),
	('PACEB95',		'Palermo',		'PA',	'Libara',				'95'),
	('PZFAR67',		'Potenza',		'PZ',	'Sosace',				'67'),
	('BOSTA58',		'Bologna',		'BO',	'Teteba',				'58'),
	('CASOC03',		'Cagliari',		'CA',	'Fasoda',				'03'),
	('TNSOC45',		'Trento',		'TN',	'Stataste',				'45'),
	('MISOR04',		'Milano',		'MI',	'Sorasci',				'04'),
	('CASTE39',		'Cagliari',		'CA',	'Taschili',				'39'),
	('CASCH09',		'Cagliari',		'CA',	'Tasafe',				'09'),
	('ANTIV83',		'Ancona',		'AN',	'Schistefa',			'83'),
	('PZDAT16',		'Potenza',		'PZ',	'Bavote',				'16'),
	('VESCI50',		'Venezia',		'VE',	'Chevoschi',			'50'),
	('RMCES62',		'Roma',			'RM',	'Saravo',				'62'),
	('AQSOT34',		'Aquila',		'AQ',	'Davoste',				'34'),
	('AOSCI39',		'Aosta',		'AO',	'Cacali',				'39'),
	('AQFAD86',		'Aquila',		'AQ',	'Dadache',				'86'),
	('NASOS14',		'Napoli',		'NA',	'Sterate',				'14'),
	('PASTA98',		'Palermo',		'PA',	'Farata',				'98'),
	('GESTE11',		'Genova',		'GE',	'Satista',				'11'),
	('TOFEV89',		'Torino',		'TO',	'Steschista',			'89'),
	('CAFAS84',		'Cagliari',		'CA',	'Ticeda',				'84'),
	('PACAR46',		'Palermo',		'PA',	'Liscista',				'46'),
	('NAFES00',		'Napoli',		'NA',	'Batesa',				'00'),
	('TSSAF77',		'Trieste',		'TS',	'Voscivo',				'77'),
	('BATAF39',		'Bari',			'BA',	'Taraca',				'39'),
	('ANSCH41',		'Ancona',		'AN',	'Stedafe',				'41'),
	('BOCES42',		'Bologna',		'BO',	'Stafesta',				'42'),
	('VESTA02',		'Venezia',		'VE',	'Balira',				'02'),
	('TNSTE97',		'Trento',		'TN',	'Stevosta',				'97'),
	('CBCES74',		'Campobasso',	'CB',	'Sasosci',				'74'),
	('AQCHE88',		'Aquila',		'AQ',	'Dadafa',				'88'),
	('CZVOB91',		'Catanzaro',	'CZ',	'Fafache',				'91'),
	('CALIT70',		'Cagliari',		'CA',	'Sestefe',				'70'),
	('CACHE58',		'Cagliari',		'CA',	'Statelli',				'58'),
	('PALLI48',		'Palermo',		'PA',	'Stacalli',				'48'),
	('VESCI37',		'Venezia',		'VE',	'Stelira',				'37'),
	('AQRAC35',		'Aquila',		'AQ',	'Dastesa',				'35'),
	('GEVOC10',		'Genova',		'GE',	'Ticasta',				'10'),
	('ANTAC41',		'Ancona',		'AN',	'Techete',				'41'),
	('VETET66',		'Venezia',		'VE',	'Basata',				'66'),
	('BATAD96',		'Bari',			'BA',	'Livoche',				'96'),
	('PGLIL73',		'Perugia',		'PG',	'Feteba',				'73'),
	('MILIC62',		'Milano',		'MI',	'Fastelli',				'62'),
	('ANSCI70',		'Ancona',		'AN',	'Dallilli',				'70'),
	('VESOL45',		'Venezia',		'VE',	'Rastafa',				'45'),
	('VEFES38',		'Venezia',		'VE',	'Rasciche',				'38'),
	('BOVOV94',		'Bologna',		'BO',	'Alischita',			'94'),
	('TSRAC61',		'Trieste',		'TS',	'Scistaca',				'61'),
	('FIDAS89',		'Firenze',		'FI',	'Rabaschi',				'89'),
	('ANLIF27',		'Ancona',		'AN',	'Faliche',				'27'),
	('ANBAB02',		'Ancona',		'AN',	'Chebaste',				'02'),
	('PZSAS77',		'Potenza',		'PZ',	'Catira',				'77'),
	('NATET09',		'Napoli',		'NA',	'Rataba',				'09'),
	('TNCHE24',		'Trento',		'TN',	'Alisaso',				'24'),
	('ANRAS33',		'Ancona',		'AN',	'Tisoba',				'33'),
	('TOSCI17',		'Torino',		'TO',	'Dasosa',				'17'),
	('CZDAS99',		'Catanzaro',	'CZ',	'Caschilli',			'99'),
	('GESTA05',		'Genova',		'GE',	'Stecaso',				'05'),
	('BOSOT17',		'Bologna',		'BO',	'Cateschi',				'17');

INSERT INTO NEGOZIO (COD, ORARIO_APERTURA, ORARIO_CHIUSURA, DATA_APERTURA, DATA_CHIUSURA, INDIRIZZO) VALUES
	('RM0519', 		'14:00:00',		'21:00:00',		'2022-05-19',	null,				'RMSCH07'),    
	('RM0218', 		'14:00:00',		'21:00:00',		'2022-02-18',	null,				'RMPON14'),
	('FI0304', 		'14:00:00',		'21:00:00',		'2022-03-04',	null,				'FIMAN01'),
	('FI0122', 		'14:00:00',		'21:00:00',		'2022-01-22',	'2022-06-14',		'FIFIA12'),
	('FI0519', 		'14:00:00',		'21:00:00',		'2022-05-19',	null,				'FIDRA09'),    
	('MI0203', 		'14:00:00',		'21:00:00',		'2022-02-03',	null,				'MICIM14'),
	('MI0327', 		'14:00:00',		'21:00:00',		'2022-03-27',	null,				'MICAS17'),
	('MI0401', 		'14:00:00',		'21:00:00',		'2022-04-01',	'2022-05-04',		'MIBRO19'),
	('PD0228', 		'14:00:00',		'21:00:00',		'2022-02-28',	null,				'PDTRE31'),    
	('VE0226', 		'14:00:00',		'21:00:00',		'2022-02-26',	null,				'VEVAS25'),
	('NA0115', 		'14:00:00',		'21:00:00',		'2022-01-15',	'2022-04-09',		'NAVIG06'),
	('NA0206', 		'14:00:00',		'21:00:00',		'2022-02-06',	null,				'NABRO13');
	
INSERT INTO PRODOTTO (COD, PREZZO, DISPONIBILITA, COD_NEGOZIO) VALUES
	('C13PS4ST5B',	   '199.00', 	'0',		null),
	('C13PS4ST5N',	   '199.00', 	'1',		'VE0226'),
	('C13PS4ST1B',	   '199.00', 	'1',		'MI0203'),
	('C13PS4ST1N',	   '199.00', 	'1',		'RM0218'),
	('C13PS4SL5B',	   '229.00', 	'1',		'FI0304'),
	('C13PS4SL5N',	   '229.00', 	'0',		null),
	('C13PS4SL1B',	   '229.00', 	'1',		'RM0218'),
	('C13PS4SL1N',	   '229.00', 	'1',		'MI0401'),
	('C13PS4PR5B',	   '249.00', 	'1',		'VE0226'),
	('C13PS4PR5N',	   '249.00', 	'1',		'FI0122'),
	('C13PS4PR1B',	   '249.00', 	'0',		null),
	('C13PS4PR1N',	   '249.00', 	'1',		'RM0218'),
	('C20PS5ST5B',	   '399.00', 	'1',		'FI0519'),
	('C20PS5ST5N',	   '399.00', 	'1',		'MI0401'),
	('C20PS5ST1B',	   '399.00', 	'1',		'VE0226'),
	('C20PS5ST1N',	   '399.00', 	'1',		'RM0218'),
	('C20PS5DE5B',	   '499.00', 	'1',		'FI0304'),
	('C20PS5DE5N',	   '499.00', 	'1',		'NA0115'),
	('C20PS5DE1B',	   '499.00', 	'1',		'VE0226'),
	('C20PS5DE1N',	   '499.00', 	'0',		null),
	('C12WIIUU5B',	   '161.80', 	'1',		'FI0122'),    
	('C12WIIUU5R',	   '161.80', 	'1',		'MI0203'),   
	('C12WIIUU1B',	   '161.80', 	'1',		'PD0228'), 		   
	('C12WIIUU1R',	   '161.80', 	'1',		'NA0115'),    
	('C17NINSW5B',	   '240.00', 	'1',		'NA0206'), 		  
	('C17NINSW5R',	   '240.00', 	'1',		'RM0519'),   
	('C17NINSW1B',	   '240.00', 	'1',		'MI0327'), 		  
	('C17NINSW1R',	   '240.00', 	'0',		null),    
	('C13XBOON5B',	   '199.00', 	'0',		null),     
	('C13XBOON5N',	   '199.00', 	'1',		'MI0203'),		    
	('C13XBOON1B',	   '199.00', 	'1',		'RM0519'),    
	('C13XBOON1N',	   '199.00', 	'1',		'MI0401'),		   
	('C13XBOOS5B',	   '229.00', 	'1',		'NA0206'),  
	('C13XBOOS5N',	   '229.00', 	'0',		null),		   
	('C13XBOOS1B',	   '229.00', 	'1',		'MI0401'),   
	('C13XBOOS1N',	   '229.00', 	'1',		'RM0218'),		     
	('C13XBOOX5B',	   '249.00', 	'1',		'FI0122'),   
	('C13XBOOX5N',	   '249.00', 	'1',		'FI0122'),		   
	('C13XBOOX1B',	   '249.00', 	'1',		'PD0228'),   
	('C13XBOOX1N',	   '249.00', 	'1',		'FI0304'),		
	('C20XBOSS5B',	   '399.00', 	'1',		'RM0519'),   
	('C20XBOSS5N',	   '399.00', 	'0',		null),		  
	('C20XBOSS1B',	   '399.00', 	'1',		'PD0228'),  
	('C20XBOSS1N',	   '399.00', 	'1',		'MI0203'),		   
	('C20XBOSX5B',	   '499.00', 	'1',		'MI0327'),  
	('C20XBOSX5N',	   '499.00', 	'0',		null),		  
	('C20XBOSX1B',	   '499.00', 	'1',		'FI0122'),  
	('C20XBOSX1N',	   '499.00', 	'1',		'NA0115'), 
	('V000112HOG',	   '69.00', 	'1',		'RM0218'),     
	('V000414SUC',	   '39.00', 	'1',		'FI0122'),
	('V000319OUT',	   '49.00', 	'0',		'RM0519'),
	('V000419ILS',	   '49.00', 	'1',		'FI0304'),     
	('V000511EVI',	   '79.00', 	'1',		'RM0218'), 
	('V000202ONE',	   '79.00', 	'1',		'FI0122'), 
	('V000304POK',	   '59.00', 	'0',		null),      
	('V000126POK',	   '59.00', 	'1',		'FI0519'),         
	('V000524KAM',	   '39.00', 	'1',		'PD0228'),      
	('V000614GOT',	   '49.00', 	'1',		'RM0218'),
	('V000311MAT',	   '69.00', 	'0',		null),       
	('V000117STA',	   '69.00', 	'1',		'RM0218'), 
	('V000419THE',	   '49.00', 	'0',		null),       
	('V000510SIA',	   '59.00', 	'1',		'FI0122'),
    ('M0000ACCUF',	   '22.98',		'1',		'FI0304'),
	('M0000ACIVE',	   '109.98',	'1',		'NA0115'),
	('M0000ACMIC',	   '139.98',	'1',		'FI0519'),
	('M0000ACXBO',	   '60.98',		'1',		'FI0304'),
	('M0000ACINI',	   '129.98',	'0',		null),
	('M0000ACPEX',	   '129.98',	'1',		'MI0401'),
	('M0000PETYH',	   '6.98',		'1',		'MI0401'),
	('M0000PETYG',	   '6.98',		'1',		'VE0226'),
	('M0000PEHEL',	   '22.98',		'1',		'FI0519'),
	('M0000PEAMO',	   '22.98',		'0',		null),
	('M0000FIMYH',	   '99.98',		'1',		'NA0206'),
	('M0000FIJUJ',	   '32.98',		'1',		'MI0401'),
	('M0000FIDRG',	   '32.98',		'0',		null),
	('M0000FIDRA',	   '32.98',		'1',		'MI0203'),
	('M0000CAYUG',	   '4.98',		'1',		'NA0115'),
	('M0000CAYUI',	   '18.98',		'1',		'VE0226'),
	('M0000CAPOK',	   '59.98',		'1',		'MI0401'),
	('M0000FUDUS',	   '15.98',		'1',		'FI0519'),
	('M0000FUUND',	   '15.98',		'1',		'FI0122'),
	('M0000FUDAR',	   '15.98',		'0',		null),
	('M0000FUZOR',	   '15.98',		'1',		'FI0122');
	
INSERT INTO PRODUTTORE (NOME, CAPITALE, NAZIONALITA) VALUES
	('Nintendo', 				        '750773000',      'Giappone'),
	('Sony Interactive Entertainment',  '1454026000',     'Giappone'),
	('Electronic Arts', 			    '1571093000',     'USA'),
	('Activision Blizzard', 		    '2184343000',     'USA'),
	('Ubisoft', 				        '934135000',      'Francia'),
	('Epic Games', 				        '3440241000',     'USA'),
	('Mojang', 				            '1524012000',     'Svezia'),
	('Rockstar Games', 				    '2563449000',     'USA'),
	('Novomatic', 				        '204231000',      'Austria'),
	('Microsoft', 				        '1081123000',     'USA');

INSERT INTO VIDEOGIOCO (COD, NOME, GENERE, DATA_USCITA, PEGI, VALUTAZIONE, ONLINE_, PRODUTTORE, COD_PRODOTTO) VALUES
	('0112HOG',		'Hogwarts Legacy', 				             'Hack and Slash',		 '2022-01-12',	'12',		'9.2',		'1',		'Epic Games',			'V000112HOG'),         
	('0414SUC',		'Sucide Squad: Kill the Justice League', 	 'Adventure',			 '2022-04-14',	'18',		'8.8',		'1',		'Rockstar Games',		'V000414SUC'),	  
	('0319OUT',		'Outcast 2', 				                 'Open World',		     '2022-03-19',	'18',		'9.5',		'0',		'Rockstar Games',		'V000319OUT'),
	('0419ILS',		'Il Signore degli Anelli: Gollum', 		     'FPS Arena',			 '2022-04-19',	'12',		'8.9',		'1',		'Novomatic',			'V000419ILS'),     		   
	('0511EVI',		'Evil West', 				                 'Casual Game',		     '2022-05-11',	'18',		'6.1',		'1',		'Rockstar Games',		'V000511EVI'),  
	('0202ONE',		'One Piece Odissey', 				         'MOBA',		     	 '2022-02-02',	'03',		'7.8',		'1',		'Rockstar Games',		'V000202ONE'),    
	('0304POK',		'Pokemon Scarlatto', 				         'Open World',		 	 '2022-03-04',	'03',		'9.7',		'0',		'Mojang',				'V000304POK'),      
	('0126POK',		'Pokemon Violetto', 				         'Open World',		 	 '2022-01-26',	'03',		'7.5',		'1',		'Mojang',				'V000126POK'),              
	('0524KAM',		'Kamiwaza: Way of the Thief', 				 'Survival Horror',		 '2022-05-24',	'12',		'5.0',		'1',		'Novomatic',			'V000524KAM'),                    
	('0614GOT',		'Gotham Knights - Deluxe Edition', 			 'Hack and Slash',		 '2022-06-14',	'12',		'7.5',		'1',		'Electronic Arts',		'V000614GOT'),        	          
	('0311MAT',		'Matchpoint: Tennis Championships', 		 'MOBA',			 	 '2022-03-11',	'03',		'5.3',		'0',		'Nintendo',				'V000311MAT'),            	       
	('0117STA',		'Star Trek Prodigy: Supernova', 			 'Hack and Slash',		 '2022-01-17',	'12',		'5.7',		'1',		'Rockstar Games',		'V000117STA'),                  
	('0419THE',		'The Last Of Us Parte 2', 				     'Hack and Slash',		 '2022-04-19',	'18',		'7.5',		'0',		'Nintendo',				'V000419THE'),       
	('0510SIA',		'Saints Row', 				                 'Open World',		     '2022-05-10',	'18',		'8.4',		'1',		'Electronic Arts',		'V000510SIA');
	
INSERT INTO MERCHANDISE (COD, CATEGORIA, NOME, COD_PRODOTTO) VALUES
	('ACCUF',		'Elettronica',			'CUFFIE HYPERX CLOUD',										'M0000ACCUF'),    
	('ACIVE',		'Elettronica',			'VOLANTE HORI - RACING WHEEL OVERDRIVE',					'M0000ACIVE'),
	('ACMIC',		'Elettronica',			'MICROFONO ELGATO - WAVE:3',								'M0000ACMIC'),		
	('ACXBO',		'Elettronica',			'XBOX STEREO HEADSET',										'M0000ACXBO'),
	('ACINI',		'Elettronica',			'VOLANTE + PEDALIERA LAMBORGHINI',							'M0000ACINI'),			
	('ACPEX',		'Elettronica',			'VOLANTE HORI - RACING WHEEL APEX', 						'M0000ACPEX'),				
	('PETYH',		'Peluches',				'TY - HEATHER (BEANIE BOOS)',								'M0000PETYH'),		
	('PETYG',		'Peluches',				'TY - GILDA (BEANIE BOOS)',									'M0000PETYG'),	
	('PEHEL',		'Peluches',				'HELLO KITTY - KIMONO - 25 CM',								'M0000PEHEL'),		
	('PEAMO',		'Peluches',				'AMONG US - CREWMATES (ASSORTITI)',							'M0000PEAMO'),			
	('FIMYH',		'Action Figure',		'MY HERO ACADEMIA - ALL MIGHT (SILVER AGE)', 				'M0000FIMYH'),						
	('FIJUJ',		'Action Figure',		'JUJUTSU KAISEN SORCERY FIGHT - NOBARA KIGISAKI (DXF)',		'M0000FIJUJ'),								
	('FIDRG',		'Action Figure',		'DRAGON BALL GT - SON GOKU SUPER SAIYAN 4',					'M0000FIDRG'),
    ('FIDRA',		'Action Figure',		'DRAGON BALL Z - SON GOKU FLYING NIMBUS',					'M0000FIDRA'),					
	('CAYUG',		'Carte',				'YU-GI-OH! - TACTICAL MASTERS 1A EDIZIONE', 				'M0000CAYUG'),						
	('CAYUI',		'Carte',				'YU-GI-OH! - DUELLANTI LEGGENDARI: STAGIONE 3',				'M0000CAYUI'),						
	('CAPOK',		'Carte',				'POKÉMON - COLLEZIONE PREMIUM PROF.SSA ARALIA TOURNAMENT',	'M0000CAPOK'),									
	('FUDUS',		'Funko Pop',			'DUSTIN CON D20 (NETFLIX: STRANGER THINGS STAGIONE 4)',		'M0000FUDUS'),								
	('FUUND',		'Funko Pop',			'UNDICI (NETFLIX: STRANGER THINGS STAGIONE 4)',				'M0000FUUND'),						
	('FUDAR',		'Funko Pop',			'DARTH SIDIOUS (STAR WARS: RED SABER SERIES VOLUME 1)',		'M0000FUDAR'),								
	('FUZOR',		'Funko Pop',			'ZORRO (ZORRO: ANNIVERSARY)',		      					'M0000FUZOR');
	
INSERT INTO CONSOLE (COD, MODELLO, DATA_USCITA, MEMORIA, COLORE, PRODUTTORE, COD_PRODOTTO) VALUES
	('13PS4ST5B',		'PlayStation 4 Standard', 			  '2013-11-15',	  	'500 Gb',		'Bianco',		'Sony Interactive Entertainment',		'C13PS4ST5B'),
	('13PS4ST5N',		'PlayStation 4 Standard', 			  '2013-11-15',	  	'500 Gb',		'Nero',			'Sony Interactive Entertainment',		'C13PS4ST5N'),
	('13PS4ST1B',		'PlayStation 4 Standard', 			  '2013-11-15',	  	'1 Tb',			'Bianco',		'Sony Interactive Entertainment',		'C13PS4ST1B'),
	('13PS4ST1N',		'PlayStation 4 Standard', 			  '2013-11-15',	  	'1 Tb',			'Nero',			'Sony Interactive Entertainment',		'C13PS4ST1N'),
	('13PS4SL5B',		'PlayStation 4 Slim', 				  '2013-11-15',	  	'500 Gb',		'Bianco',		'Sony Interactive Entertainment',		'C13PS4SL5B'),
	('13PS4SL5N',		'PlayStation 4 Slim', 				  '2013-11-15',	  	'500 Gb',		'Nero',			'Sony Interactive Entertainment',		'C13PS4SL5N'),		
	('13PS4SL1B',		'PlayStation 4 Slim', 				  '2013-11-15',	  	'1 Tb',			'Bianco',		'Sony Interactive Entertainment',		'C13PS4SL1B'),
	('13PS4SL1N',		'PlayStation 4 Slim', 				  '2013-11-15',	  	'1 Tb',			'Nero',			'Sony Interactive Entertainment',		'C13PS4SL1N'),		    
	('13PS4PR5B',		'PlayStation 4 Pro', 				  '2013-11-15',	  	'500 Gb',		'Bianco',		'Sony Interactive Entertainment',		'C13PS4PR5B'),    
	('13PS4PR5N',		'PlayStation 4 Pro', 				  '2013-11-15',	  	'500 Gb',		'Nero',			'Sony Interactive Entertainment',		'C13PS4PR5N'),		    
	('13PS4PR1B',		'PlayStation 4 Pro', 				  '2013-11-15',	  	'1 Tb',			'Bianco',		'Sony Interactive Entertainment',		'C13PS4PR1B'),    
	('13PS4PR1N',		'PlayStation 4 Pro', 				  '2013-11-15',	  	'1 Tb',			'Nero',			'Sony Interactive Entertainment',		'C13PS4PR1N'),		         
	('20PS5ST5B',		'PlayStation 5 Standard', 			  '2020-11-19',	  	'500 Gb',		'Bianco',		'Sony Interactive Entertainment',		'C20PS5ST5B'),        
	('20PS5ST5N',		'PlayStation 5 Standard', 			  '2020-11-19',	  	'500 Gb',		'Nero',			'Sony Interactive Entertainment',		'C20PS5ST5N'),		        
	('20PS5ST1B',		'PlayStation 5 Standard', 			  '2020-11-19',	  	'1 Tb',			'Bianco',		'Sony Interactive Entertainment',		'C20PS5ST1B'),        
	('20PS5ST1N',		'PlayStation 5 Standard', 			  '2020-11-19',	  	'1 Tb',			'Nero',			'Sony Interactive Entertainment',		'C20PS5ST1N'),		   
	('20PS5DE5B',		'PlayStation 5 Digital Edition', 	  '2020-11-19',	  	'500 Gb',		'Bianco',		'Sony Interactive Entertainment',		'C20PS5DE5B'),    
	('20PS5DE5N',		'PlayStation 5 Digital Edition', 	  '2020-11-19',	  	'500 Gb',		'Nero',			'Sony Interactive Entertainment',		'C20PS5DE5N'),		    
	('20PS5DE1B',		'PlayStation 5 Digital Edition', 	  '2020-11-19',	  	'1 Tb',			'Bianco',		'Sony Interactive Entertainment',		'C20PS5DE1B'),    
	('20PS5DE1N',		'PlayStation 5 Digital Edition', 	  '2020-11-19',	  	'1 Tb',			'Nero',			'Sony Interactive Entertainment',		'C20PS5DE1N'),		    
	('12WIIUU5B',		'Wii U', 				              '2012-11-08',	  	'500 Gb',		'Bianco',		'Nintendo',								'C12WIIUU5B'),    
	('12WIIUU5R',		'Wii U', 				              '2012-11-08',	  	'500 Gb',		'Rosso-Blu',	'Nintendo',								'C12WIIUU5R'),   
	('12WIIUU1B',		'Wii U', 				              '2012-11-08',	  	'1 Tb',			'Bianco',		'Nintendo',								'C12WIIUU1B'), 		   
	('12WIIUU1R',		'Wii U', 				              '2012-11-08',	  	'1 Tb',			'Rosso-Blu',	'Nintendo',								'C12WIIUU1R'),    
	('17NINSW5B',		'Nintendo Switch', 				   	  '2017-03-03',	  	'500 Gb',		'Bianco',		'Nintendo',								'C17NINSW5B'), 		  
	('17NINSW5R',		'Nintendo Switch', 				   	  '2017-03-03',	  	'500 Gb',		'Rosso-Blu',	'Nintendo',								'C17NINSW5R'),   
	('17NINSW1B',		'Nintendo Switch', 				   	  '2017-03-03',	  	'1 Tb',			'Bianco',		'Nintendo',								'C17NINSW1B'), 		  
	('17NINSW1R',		'Nintendo Switch', 				   	  '2017-03-03',	  	'1 Tb',			'Rosso-Blu',	'Nintendo',								'C17NINSW1R'),    
	('13XBOON5B',		'Xbox One', 				          '2013-11-22',	  	'500 Gb',		'Bianco',		'Microsoft',							'C13XBOON5B'),     
	('13XBOON5N',		'Xbox One', 				          '2013-11-22',	  	'500 Gb',		'Nero',			'Microsoft',							'C13XBOON5N'),		    
	('13XBOON1B',		'Xbox One', 				          '2013-11-22',	  	'1 Tb',			'Bianco',		'Microsoft',							'C13XBOON1B'),    
	('13XBOON1N',		'Xbox One', 				          '2013-11-22',	  	'1 Tb',			'Nero',			'Microsoft',							'C13XBOON1N'),		   
	('13XBOOS5B',		'Xbox One S', 				          '2013-11-22',	  	'500 Gb',		'Bianco',		'Microsoft',							'C13XBOOS5B'),  
	('13XBOOS5N',		'Xbox One S', 				          '2013-11-22',	  	'500 Gb',		'Nero',			'Microsoft',							'C13XBOOS5N'),		   
	('13XBOOS1B',		'Xbox One S', 				          '2013-11-22',	  	'1 Tb',			'Bianco',		'Microsoft',							'C13XBOOS1B'),   
	('13XBOOS1N',		'Xbox One S', 				          '2013-11-22',	  	'1 Tb',			'Nero',			'Microsoft',							'C13XBOOS1N'),		     
	('13XBOOX5B',		'Xbox One X', 				          '2013-11-22',	  	'500 Gb',		'Bianco',		'Microsoft',							'C13XBOOX5B'),   
	('13XBOOX5N',		'Xbox One X', 				          '2013-11-22',	  	'500 Gb',		'Nero',			'Microsoft',							'C13XBOOX5N'),		   
	('13XBOOX1B',		'Xbox One X', 				          '2013-11-22',	  	'1 Tb',			'Bianco',		'Microsoft',							'C13XBOOX1B'),   
	('13XBOOX1N',		'Xbox One X', 				          '2013-11-22',	  	'1 Tb',			'Nero',			'Microsoft',							'C13XBOOX1N'),		
    ('20XBOSS5B',		'Xbox Series S', 				      '2020-11-10',	  	'500 Gb',		'Bianco',		'Microsoft',							'C20XBOSS5B'),   
    ('20XBOSS5N',		'Xbox Series S', 				      '2020-11-10',	  	'500 Gb',		'Nero',			'Microsoft',							'C20XBOSS5N'),		  
    ('20XBOSS1B',		'Xbox Series S', 				      '2020-11-10',	  	'1 Tb',			'Bianco',		'Microsoft',							'C20XBOSS1B'),  
    ('20XBOSS1N',		'Xbox Series S', 				      '2020-11-10',	  	'1 Tb',			'Nero',			'Microsoft',							'C20XBOSS1N'),		   
	('20XBOSX5B',		'Xbox Series X', 				      '2020-11-10',	  	'500 Gb',		'Bianco',		'Microsoft',							'C20XBOSX5B'),  
	('20XBOSX5N',		'Xbox Series X', 				      '2020-11-10',	  	'500 Gb',		'Nero',			'Microsoft',							'C20XBOSX5N'),		  
	('20XBOSX1B',		'Xbox Series X', 				      '2020-11-10',	  	'1 Tb',			'Bianco',		'Microsoft',							'C20XBOSX1B'),  
	('20XBOSX1N',		'Xbox Series X', 				      '2020-11-10',	  	'1 Tb',			'Nero',			'Microsoft',							'C20XBOSX1N');
    
INSERT INTO ORDINE (COD, DATA_ACQUISTO, METODO_PAGAMENTO, SCONTO, ONLINE_, COD_NEGOZIO) VALUES
	('0530HY1', 		'2022-05-30',	'Hype',					'3',	'1',	null),    
	('0413VI0', 		'2022-04-13',	'Visa',					null,	'0',	'RM0519'),
	('1103AP1', 		'2022-11-03',	'ApplePay',				'3',	'1',	null),
	('0436CR1', 		'2022-04-26',	'Crypto.com Card',		'3',	'1',	null),
	('0326AP1', 		'2022-03-26',	'ApplePay',				'3',	'1',	null),    
	('1026AP1', 		'2022-10-26',	'ApplePay',				'3',	'1',	null),
	('0413CR0', 		'2022-04-13',	'Crypto.com Card',		null,	'0',	'RM0218'),
	('0621MA1', 		'2022-06-21',	'MasterCard',			'3',	'1',	null),
	('0419MA1', 		'2022-04-19',	'MasterCard',			'3',	'1',	null),    
	('0422MA1', 		'2022-04-22',	'MasterCard',			'3',	'1',	null),
	('0315CO0', 		'2022-03-15',	'Contanti',				null,	'0',	'FI0304'),
	('0705AP1', 		'2022-07-05',	'ApplePay',				'3',	'1',	null),
	('0611HY1', 		'2022-06-11',	'Hype',					'3',	'1',	null),    
	('0319CO0', 		'2022-03-19',	'Contanti',				null,	'0',	'FI0122'),
	('1015MA1', 		'2022-10-15',	'MasterCard',			'3',	'1',	null),
	('0918VI1', 		'2022-09-18',	'Visa',					'3',	'1',	null),
	('1107CR1', 		'2022-11-07',	'Crypto.com Card',		'3',	'1',	null),    
	('0513CR1', 		'2022-05-13',	'Crypto.com Card',		'3',	'1',	null),
	('0306VI0', 		'2022-03-06',	'Visa',					null,	'0',	'FI0519'),
	('0514VI1', 		'2022-05-14',	'Visa',					'3',	'1',	null),
	('0304CR1', 		'2022-03-04',	'Crypto.com Card',		'3',	'1',	null),    
	('1008AP1', 		'2022-10-08',	'ApplePay',				'3',	'1',	null),
	('0113AP1', 		'2022-01-13',	'ApplePay',				'3',	'1',	null),
	('0521AP1', 		'2022-05-21',	'ApplePay',				'3',	'1',	null),
	('0103AP1', 		'2022-01-03',	'ApplePay',				'3',	'1',	null),    
	('1206CO0', 		'2022-12-06',	'Contanti',				null,	'0',	'MI0203'),
	('0311AP1', 		'2022-03-11',	'ApplePay',				'3',	'1',	null),
	('0508VI1', 		'2022-05-08',	'Visa',					'3',	'1',	null),
	('1201HY1', 		'2022-12-01',	'Hype',					'3',	'1',	null),    
	('0817VI1', 		'2022-08-17',	'Visa',					'3',	'1',	null),
	('1219AP1', 		'2022-12-19',	'ApplePay',				'3',	'1',	null),
	('1007VI1', 		'2022-10-07',	'Visa',					'3',	'1',	null),
	('0803CR1', 		'2022-08-03',	'Crypto.com Card',		'3',	'1',	null),    
	('1011MA1', 		'2022-10-11',	'MasterCard',			'3',	'1',	null),
	('0610MA0', 		'2022-06-10',	'MasterCard',			null,	'0',	'MI0327'),
	('1219CR0', 		'2022-12-19',	'Crypto.com Card',		null,	'0',	'MI0401'),
	('1007AP1', 		'2022-10-07',	'ApplePay',				'3',	'1',	null),
	('0803HY1', 		'2022-08-03',	'Hype',					'3',	'1',	null),
	('1011CO0', 		'2022-10-11',	'Contanti',				null,	'0',	'PD0228'),    
	('0610CR1', 		'2022-06-10',	'Crypto.com Card',		'3',	'1',	null),
	('0921CR1', 		'2022-09-21',	'Crypto.com Card',		'3',	'1',	null),
	('0627AP1', 		'2022-06-27',	'ApplePay',				'3',	'1',	null),
	('0513HY1', 		'2022-05-13',	'Hype',					'3',	'1',	null),    
	('0118CO0', 		'2022-01-18',	'Contanti',				null,	'0',	'VE0226'),
	('1003CO0', 		'2022-10-03',	'Contanti',				null,	'0',	'NA0115'),
	('0312HY1', 		'2022-03-12',	'Hype',					null,	'0',	'NA0206');

INSERT INTO SPEDIZIONE (NUMERO, CORRIERE, COSTO, ARRIVO_PREVISTO, MODALITA) VALUES
	('A00001',	'DHL',	'10.00',	'2022-04-14', 	'Standard'),    
	('A00002',	'DHL',	'7.00',		'2022-07-21', 	'Standard'),
	('A00003',	'UPS',	'50.00',	'2022-12-28', 	'Veloce'),
	('A00004',	'DHL',	'10.00',	'2022-10-09', 	'Standard'),
	('A00005',	'DHL',	'3.99',		'2022-09-05', 	'Standard'),
	('A00006',	'UPS',	'50.00',	'2022-01-12', 	'Veloce'),
	('A00007',	'DHL',	'8.00',		'2022-07-14', 	'Standard'),
	('A00008',	'DHL',	'2.99',		'2022-03-19', 	'Standard'),
	('A00009',	'DHL',	'10.00',	'2022-04-19', 	'Standard'),
	('A00010',	'DHL',	'10.00',	'2022-05-11', 	'Standard'),
	('A00011',	'DHL',	'2.00',		'2022-02-02', 	'Standard'),
	('A00012',	'DHL',	'10.00',	'2022-03-04', 	'Standard'),
	('A00013',	'DHL',	'8.00'	,	'2022-01-26', 	'Standard'),
	('A00014',	'UPS',	'50.00',	'2022-05-24', 	'Veloce'),
	('A00015',	'UPS',	'50.00',	'2022-06-14', 	'Veloce'),
	('A00016',	'DHL',	'3.99',		'2022-03-11', 	'Standard'),
	('A00017',	'DHL',	'3.99',		'2022-01-17', 	'Standard'),
	('A00018',	'DHL',	'2.99',		'2022-04-19', 	'Standard'),
	('A00019',	'DHL',	'8.00',		'2022-05-10', 	'Standard'),
	('A00020',	'DHL',	'7.00',		'2022-03-11', 	'Standard'),
	('A00021',	'UPS',	'50.00',	'2022-05-11', 	'Veloce'),
	('A00022',	'UPS',	'50.00',	'2022-02-02', 	'Veloce');

INSERT INTO TESSERA (LIVELLO, COLORE, PREZZO) VALUES
	('LV1',		'Arancione',		'4.99'),    
	('LV2',		'Verde',			'9.99'),
	('LV3',		'Grigio',			'14.99'),
	('LV4',		'Nero',				'24.99');
    

	
INSERT INTO CLIENTE (CF, NOME, COGNOME, EMAIL, DATA_NASCITA, ABBONATO, DATA_INIZIO, DATA_FINE, PUNTI, TESSERA, INDIRIZZO) VALUES
	('MNGD01',	'Mason', 		'Greenwood', 			'mason.greenwood@gmail.com', 		'2001-10-01', 		'1', 	'2022-01-01',		'2023-01-01',		'346',		'LV3',	'GECAS09'),    
	('RDMZ85',	'Ryhad', 		'Marhez', 				'ryhad.marhez@gmail.com',			'1985-02-05', 		'1', 	'2022-03-27',		'2023-03-27',		'754',		'LV1',	'PGLID54'),
	('EDMY92',	'Edouard', 		'Mendy', 				'edouard.mendy@gmail.com', 			'1992-03-01', 		'0', 	'2021-03-08',		'2022-03-08',		null,		null,	'ANBAT89'),
	('KAAA94',	'Kepa', 		'Arrizabalaga', 		'kepa.arrizabalaga@gmail.com',		'1994-10-03', 		'1', 	'2022-08-10',		'2023-08-10',		'125',		'LV2',	'MIFED92'),
	('MSBI92',	'Marcus', 		'Bettinelli', 			'marcus.bettinelli@gmail.com', 		'1992-05-24', 		'0', 	'2021-01-30',		'2022-01-30',		null,		null,	'ANTES09'),    
	('AORR93',	'Antonio', 		'Rüdiger', 				'antonio.rüdiger@gmail.com', 		'1993-03-03', 		'1', 	'2022-12-17',		'2023-12-17',		'521',		'LV4',	'PATIL37'),
	('ASCN96',	'Andreas', 		'Christensen', 			'andreas.christensen@gmail.com',	'1996-04-10', 		'1', 	'2022-01-19',		'2023-01-19',		'461',		'LV1',	'BATEF25'),
	('THCH99',	'Trevoh', 		'Chalobah', 			'trevoh.chalobah@gmail.com', 		'1999-07-05', 		'1', 	'2022-11-30',		'2023-11-30',		'1054',		'LV2',	'TSSTA06'),    
	('MGSR99',	'Malang', 		'Sarr', 				'malang.sarr@gmail.com', 			'1999-01-23', 		'0', 	'2021-01-13',		'2022-01-13',		null,		null,	'RMFAB91'),
	('TOSA84',	'Thiago', 		'Silva', 				'thiago.silva@gmail.com', 			'1984-09-22', 		'0', 	'2021-05-21',		'2022-05-21',		null,		null,	'NAFES17'),
	('BNCL96',	'Ben', 			'Chilwell', 			'ben.chilwell@gmail.com', 			'1996-12-21', 		'1', 	'2022-02-13',		'2023-02-13',		'78',		'LV3',	'CZTIF77'),    
	('MSAO90',	'Marcos', 		'Alonso', 				'marcos.alonso@gmail.com', 			'1990-12-28', 		'1', 	'2022-07-31',		'2023-07-31',		'235',		'LV3',	'BALIS80'),
	('REJS99',	'Reece', 		'James', 				'reece.james@gmail.com', 			'1999-12-08', 		'1', 	'2022-12-12',		'2023-12-12',		'783',		'LV1',	'PGTIS91'),
	('CRAA89',	'César', 		'Azpilicueta', 			'césar.azpilicueta@gmail.com',		'1989-08-28', 		'1', 	'2022-09-04',		'2023-09-04',		'634',		'LV2',	'BOTAB83'),    
	('MOKC94',	'Mateo', 		'Kovacic', 				'mateo.kovacic@gmail.com', 			'1994-05-06', 		'1', 	'2022-08-02',		'2023-08-02',		'531',		'LV4',	'PGSTE51'),
	('SLÑZ94',	'Saúl', 		'Ñíguez', 				'saúl.níguez@gmail.com', 			'1994-11-21', 		'0', 	'2021-03-18',		'2022-03-18',		null,		null,	'PGSAT83'),
	('RNLK96',	'Ruben', 		'Loftus-Cheek', 		'ruben.loftuscheek@gmail.com',		'1996-01-23', 		'1', 	'2022-11-09',		'2023-11-09',		'546',		'LV4',	'GELIC06'),
	('MODĆ92', 	'Marko', 		'Dmitrović', 			'marko.dmitrović@gmail.com',		'1992-01-24',		'1',	'2022-12-15',		'2023-12-15',		'782',		'LV4',	'VEVOF53'),		
	('JIDZ97', 	'Javi', 		'Díaz', 				'javi.díaz@gmail.com',				'1997-05-15',		'1',	'2022-04-28',		'2023-04-28',		'674',		'LV2',	'TSFAL64'),		
	('JSKÉ98', 	'Jules', 		'Koundé', 				'jules.koundé@gmail.com',			'1998-11-12',		'1',	'2022-03-25',		'2023-03-25',		'463',		'LV1',	'CZLLI96'),		
	('DOCS93', 	'Diego', 		'Carlos', 				'diego.carlos@gmail.com',			'1993-03-15',		'1',	'2022-10-31',		'2023-10-31',		'868',		'LV2',	'BAFAS28'),		
	('KMRK94', 	'Karim', 		'Rekik', 				'karim.rekik@gmail.com',			'1994-12-02',		'1',	'2022-04-27',		'2023-04-27',		'674',		'LV2',	'AODAD80'),		
	('MSAA91', 	'Marcos', 		'Acuña', 				'marcos.acuña@gmail.com',			'1991-10-28',		'1',	'2022-10-01',		'2023-10-01',		'846',		'LV3',	'TNSTA73'),		
	('LGAN94', 	'Ludwig', 		'Augustinsson', 		'ludwig.augustinsson@gmail.com',	'1994-04-21',		'1',	'2022-02-05',		'2023-02-05',		'4657',		'LV2',	'CACET23'),		
	('GOML97', 	'Gonzalo', 		'Montiel', 				'gonzalo.montiel@gmail.com',		'1997-01-01',		'1',	'2022-03-01',		'2023-03-01',		'35',		'LV3',	'AOLIT26'),		
	('JSNS85', 	'Jesús', 		'Navas', 				'jesús.navas@gmail.com',			'1985-11-21',		'0',	'2021-10-03',		'2022-10-03',		null,		null,	'PATED78'),		
	('TSDY91', 	'Thomas', 		'Delaney', 				'thomas.delaney@gmail.com',			'1991-09-03',		'1',	'2022-05-24',		'2023-05-24',		'886',		'LV2',	'PASCH66'),		
	('NAGJ91', 	'Nemanja', 		'Gudelj', 				'nemanja.gudelj@gmail.com',			'1991-11-16',		'1',	'2022-03-03',		'2023-03-03',		'644',		'LV2',	'NAFET01'),		
	('FOLZ87', 	'Fernando', 	'Luiz', 				'fernando.luiz@gmail.com',			'1987-07-25',		'1',	'2022-04-10',		'2023-04-10',		'532',		'LV2',	'BOSCH22'),		
	('JNJN94', 	'Joan', 		'Jordán', 				'joan.jordan@gmail.com',			'1994-07-06',		'1',	'2022-07-05',		'2023-07-05',		'65',		'LV2',	'MICAS72'),		
	('ÓRTS94', 	'Óliver', 		'Torres', 				'oliver.torres@gmail.com',			'1994-11-10',		'1',	'2022-01-23',		'2023-01-23',		'512',		'LV2',	'CZRAL19'),		
	('INRC88', 	'Ivan', 		'Rakitic', 				'ivan.rakitic@gmail.com',			'1988-03-10',		'1',	'2022-09-22',		'2023-09-22',		'235',		'LV4',	'CBVOR89'),		
	('PUGZ88', 	'Papu', 		'Gómez', 				'papu.gómez@gmail.com',				'1988-02-15',		'1',	'2022-12-21',		'2023-12-21',		'643',		'LV2',	'TNSCH51'),		
	('LSOS94', 	'Lucas', 		'Ocampos', 				'lucas.ocampos@gmail.com',			'1994-07-11',		'1',	'2022-12-28',		'2023-12-28',		'634',		'LV1',	'PAFAD99'),		
	('EKLA92', 	'Erik', 		'Lamela', 				'erik.lamela@gmail.com',			'1992-03-04',		'1',	'2022-12-08',		'2023-12-08',		'789',		'LV4',	'MISOT57'),		
	('TOCA93', 	'Tecatito', 	'Corona', 				'tecatito.corona@gmail.com',		'1993-01-06',		'1',	'2022-08-28',		'2023-08-28',		'30',		'LV1',	'AQRAC50'),		
	('SOJN93', 	'Suso', 		'Joaquín', 				'suso.joaquín@gmail.com',			'1993-11-19',		'0',	'2021-03-29',		'2022-03-29',		null,		null,	'CBBAF86'),		
	('YFEI97', 	'Youssef', 		'En-Nesyri', 			'youssef.ennesyri@gmail.com',		'1997-06-01',		'1',	'2022-12-20',		'2023-12-20',		'301',		'LV2',	'FITAC05'),		
	('AYML95', 	'Anthony', 		'Martial', 				'anthony.martial@gmail.com',		'1995-12-05',		'1',	'2022-05-06',		'2023-05-06',		'003',		'LV2',	'PZSCI70'),		
	('RAMR97', 	'Rafa', 		'Mir', 					'rafa.mir@gmail.com',				'1997-06-18',		'1',	'2022-11-21',		'2023-11-21',		'524',		'LV1',	'PGDAF76'),		
	('MREI95', 	'Munir', 		'El Haddadi', 			'munir.elhaddadi@gmail.com',		'1995-09-01',		'1',	'2022-01-23',		'2023-01-23',		'303',		'LV4',	'PAFES12'),		
	('AÉOA96', 	'André', 		'Onana', 				'andré.onana@gmail.com',			'1996-04-02',		'1',	'2022-12-05',		'2023-12-05',		'410',		'LV2',	'CZSTE77'),		
	('JYGR00', 	'Jay', 			'Gorter', 				'jay.gorter@gmail.com',				'2000-05-30',		'1',	'2022-02-08',		'2023-02-08',		'705',		'LV1',	'PACEB95'),		
	('MNSG82', 	'Maarten', 		'Stekelenburg', 		'maarten.stekelenburg@gmail.com',	'1982-09-22',		'0',	'2021-01-10',		'2022-01-10',		null,		null,	'PZFAR67'),		
	('PWTN87', 	'Przemyslaw', 	'Tyton', 				'przemyslaw.tyton@gmail.com',		'1987-01-04',		'1',	'2022-06-11',		'2023-06-11',		'113',		'LV4',	'BOSTA58'),		
	('ROPR83', 	'Remko', 		'Pasveer', 				'remko.pasveer@gmail.com',			'1983-11-08',		'1',	'2022-03-19',		'2023-03-19',		'521',		'LV2',	'CASOC03'),		
	('LOMZ98', 	'Lisandro', 	'Martínez', 			'lisandro.martínez@gmail.com',		'1998-01-18',		'1',	'2022-10-15',		'2023-10-15',		'213',		'LV1',	'TNSOC45'),		
	('JNTR01', 	'Jurrien', 		'Timber', 				'jurrien.timber@gmail.com',			'2001-06-17',		'1',	'2022-09-18',		'2023-09-18',		'731',		'LV2',	'MISOR04'),		
	('PRSS99', 	'Perr', 		'Schuurs', 				'perr.schuurs@gmail.com',			'1999-11-26',		'1',	'2022-11-07',		'2023-11-07',		'212',		'LV2',	'CASTE39'),		
	('NSTO92', 	'Nicolás', 		'Tagliafico', 			'nicolas.tagliafico@gmail.com',		'1992-08-31',		'1',	'2022-05-13',		'2023-05-13',		'904',		'LV3',	'CASCH09'),		
	('DYBD90', 	'Daley', 		'Blind', 				'daley.blind@gmail.com',			'1990-03-09',		'1',	'2022-03-06',		'2023-03-06',		'802',		'LV2',	'ANTIV83'),		
	('NRMI97', 	'Noussair', 	'Mazraoui', 			'noussair.mazraoui@gmail.com',		'1997-11-14',		'1',	'2022-05-14',		'2023-05-14',		'318',		'LV3',	'PZDAT16'),		
	('DERH03', 	'Devyne', 		'Rensch', 				'devyne.rensch@gmail.com',			'2003-01-18',		'0',	'2021-03-04',		'2022-03-04',		null,		null,	'VESCI50'),		
	('SNKR94', 	'Sean', 		'Klaiber', 				'sean.klaiber@gmail.com',			'1994-07-31',		'1',	'2022-10-08',		'2023-10-08',		'846',		'LV4',	'RMCES62'),
	('BNCE95', 	'Bryan', 		'Cristante', 			'bryan.cristante@gmail.com',		'1995-03-03', 		'0', 	'2021-01-13',		'2022-01-13',		null,		null,	'AQSOT34'),
	('AUDA97', 	'Amadou', 		'Diawara', 				'amadou.diawara@gmail.com',			'1997-07-17', 		'0', 	'2021-05-21',		'2022-05-21',		null,		null,	'AOSCI39'),
	('EADE01', 	'Ebrima', 		'Darboe', 				'ebrima.darboe@gmail.com',			'2001-06-06', 		'1', 	'2022-02-13',		'2023-02-13',		'78',		'LV3',	'AQFAD86'),   
	('FOTI02', 	'Filippo', 		'Tripi', 				'filippo.tripi@gmail.com',			'2002-01-06', 		'1', 	'2022-07-31',		'2023-07-31',		'235',		'LV3',	'NASOS14'),
	('JNVT93', 	'Jordan', 		'Veretout', 			'jordan.veretout@gmail.com',		'1993-03-01', 		'1', 	'2022-12-12',		'2023-12-12',		'783',		'LV1',	'PASTA98'),
	('SOOA92', 	'Sérgio', 		'Oliveira', 			'sérgio.oliveira@gmail.com',		'1992-06-02', 		'1', 	'2022-09-04',		'2023-09-04',		'634',		'LV2',	'GESTE11'),   
	('EOBE02', 	'Edoardo', 		'Bove', 				'edoardo.bove@gmail.com',			'2002-05-16', 		'1', 	'2022-08-02',		'2023-08-02',		'531',		'LV4',	'TOFEV89'),
	('AYMS97', 	'Ainsley', 		'Maitland-Niles', 		'ainsley.maitlandniles@gmail.com',	'1997-08-29', 		'0', 	'2021-03-18',		'2022-03-18',		null,		null,	'CAFAS84'),
	('NAZI02', 	'Nicola', 		'Zalewski', 			'nicola.zalewski@gmail.com',		'2002-01-23', 		'1', 	'2022-11-09',		'2023-11-09',		'546',		'LV4',	'PACAR46'),
	('LOPI96', 	'Lorenzo', 		'Pellegrini', 			'lorenzo.pellegrini@gmail.com',		'1996-06-19', 		'1',	'2022-04-07',		'2023-04-07',		'708',		'LV2',	'NAFES00'),	
	('HHMN89', 	'Henrikh', 		'Mkhitaryan', 			'henrikh.mkhitaryan@gmail.com',		'1989-01-21', 		'1',	'2022-08-24',		'2023-08-24',		'219',		'LV2',	'TSSAF77'),	
	('SNEY92', 	'Stephan', 		'El Shaarawy', 			'stephan.elshaarawy@gmail.com',		'1992-10-27', 		'1',	'2022-05-22',		'2023-05-22',		'112',		'LV1',	'BATAF39'),	
	('NÒZO99', 	'Nicolò', 		'Zaniolo', 				'nicolò.zaniolo@gmail.com',			'1999-07-02', 		'1',	'2022-04-18',		'2023-04-18',		'605',		'LV4',	'ANSCH41'),	
	('CSPZ98', 	'Carles', 		'Pérez', 				'carles.pérez@gmail.com',			'1998-02-16', 		'1',	'2022-07-05',		'2023-07-05',		'326',		'LV2',	'BOCES42'),	
	('TYAM97', 	'Tammy', 		'Abraham', 				'tammy.abraham@gmail.com',			'1997-10-02', 		'1',	'2022-02-02',		'2023-02-02',		'021',		'LV1',	'VESTA02'),	
	('ERSV95', 	'Eldor', 		'Shomurodov', 			'eldor.shomurodov@gmail.com',		'1995-06-29', 		'1',	'2022-08-13',		'2023-08-13',		'355',		'LV2',	'TNSTE97'),	
	('FXAN03', 	'Felix', 		'Afena-Gyan', 			'felix.afenagyan@gmail.com',		'2003-01-19', 		'1',	'2022-08-22',		'2023-08-22',		'63',		'LV1',	'CBCES74'),	
	('OSVS94', 	'Odysseas', 	'Vlachodimos', 			'odysseas.vlachodimos@gmail.com',	'1994-04-26', 		'0',	'2021-03-17',		'2022-03-17',		null,		null,	'AQCHE88'),
	('HNLE90', 	'Helton', 		'Leite', 				'helton.leite@gmail.com',			'1990-09-02', 		'1',	'2022-12-19',		'2023-12-19',		'609',		'LV2',	'CZVOB91'),	
	('MESR99', 	'Mile', 		'Svilar', 				'mile.svilar@gmail.com',			'1999-08-27', 		'1',	'2022-09-05',		'2023-09-05',		'602',		'LV2',	'CALIT70'),	
	('LSVO95', 	'Lucas', 		'Veríssimo', 			'lucas.verissimo@gmail.com',		'1995-07-02', 		'1',	'2022-07-03',		'2023-07-03',		'106',		'LV1',	'CACHE58'),	
	('MORS01', 	'Morato', 		'Rodrigues', 			'morato.rodrigues@gmail.com',		'2001-06-30', 		'1',	'2022-02-09',		'2023-02-09',		'906',		'LV4',	'PALLI48'),	
	('NSOI88', 	'Nicolás', 		'Otamendi', 			'nicolás.otamendi@gmail.com',		'1988-02-12', 		'1',	'2022-07-08',		'2023-07-08',		'511',		'LV2',	'VESCI37'),	
	('JNVN87', 	'Jan', 			'Vertonghen', 			'jan.vertonghen@gmail.com',			'1987-04-24', 		'1',	'2022-12-19',		'2023-12-19',		'202',		'LV1',	'AQRAC35'),	
	('AOGO95', 	'Alejandro', 	'Grimaldo', 			'alejandro.grimaldo@gmail.com',		'1995-09-20', 		'1',	'2022-01-12',		'2023-01-12',		'105',		'LV3',	'GEVOC10'),	
	('VOLO96', 	'Valentino', 	'Lazaro', 				'valentino.lazaro@gmail.com',		'1996-03-24', 		'1',	'2022-06-05',		'2023-06-05',		'005',		'LV3',	'ANTAC41'),	
	('GOMS93', 	'Gilberto', 	'Moraes', 				'gilberto.moraes@gmail.com',		'1993-03-07', 		'1',	'2022-03-26',		'2023-03-26',		'805',		'LV3',	'VETET66'),	
	('AÉAA90', 	'André', 		'Almeida', 				'andré.almeida@gmail.com',			'1990-09-10', 		'1',	'2022-10-21',		'2023-10-21',		'511',		'LV3',	'BATAD96'),	
	('JNWL95', 	'Julian', 		'Weigl', 				'julian.weigl@gmail.com',			'1995-09-08', 		'0',	'2021-10-06',		'2022-10-06',		null,		null,	'PGLIL73'),
	('JOMO93', 	'João', 		'Mário', 				'joão.mário@gmail.com',				'1993-01-19', 		'1',	'2022-01-03',		'2023-01-03',		'92',		'LV2',	'MILIC62'),	
	('SOMÉ94', 	'Soualiho', 	'Meïté', 				'soualiho.meïté@gmail.com',			'1994-03-17', 		'1',	'2022-12-06',		'2023-12-06',		'32',		'LV2',	'ANSCI70'),	
	('POBO02', 	'Paulo', 		'Bernardo', 			'paulo.bernardo@gmail.com',			'2002-01-24', 		'1',	'2022-03-11',		'2023-03-11',		'30',		'LV1',	'VESOL45'),	
	('ALTT89', 	'Adel', 		'Taarabt', 				'adel.taarabt@gmail.com',			'1989-05-24', 		'1',	'2022-05-08',		'2023-05-08',		'91',		'LV4',	'VEFES38'),	
	('RASA93', 	'Rafa', 		'Silva', 				'rafa.silva@gmail.com',				'1993-05-17', 		'1',	'2022-12-01',		'2023-12-01',		'90',		'LV2',	'BOVOV94'),	
	('DOGS97', 	'Diogo', 		'Gonçalves', 			'diogo.goncalves@gmail.com',		'1997-02-06', 		'1',	'2022-08-17',		'2023-08-17',		'11',		'LV1',	'TSRAC61'),	
	('ÉNSA96', 	'Éverton', 		'Sousa', 				'éverton.sousa@gmail.com',			'1996-03-22', 		'0',	'2021-12-19',		'2022-12-19',		null,		null,	'FIDAS89'),
	('GLDS96', 	'Gil', 			'Dias', 				'gil.dias@gmail.com',				'1996-09-28', 		'1',	'2022-10-07',		'2023-10-07',		'619',		'LV2',	'ANLIF27'),	
	('NARĆ96', 	'Nemanja', 		'Radonjić', 			'nemanja.radonjić@gmail.com',		'1996-02-15', 		'1',	'2022-08-03',		'2023-08-03',		'121',		'LV2',	'ANBAB02'),	
	('GORS01', 	'Gonçalo', 		'Ramos', 				'gonçalo.ramos@gmail.com',			'2001-06-20', 		'1',	'2022-10-11',		'2023-10-11',		'27',		'LV1',	'PZSAS77'),	
	('DNNZ99', 	'Darwin', 		'Núñez', 				'darwin.nunez@gmail.com',			'1999-06-24', 		'1',	'2022-06-10',		'2023-06-10',		'702',		'LV4',	'NATET09'),	
	('RNYK95', 	'Roman', 		'Yaremchuk', 			'roman.yaremchuk@gmail.com',		'1995-11-27', 		'1',	'2022-09-21',		'2023-09-21',		'216',		'LV2',	'TNCHE24'),	
	('HSSC92', 	'Haris', 		'Seferovic', 			'haris.seferovic@gmail.com',		'1992-02-22', 		'1',	'2022-06-27',		'2023-06-27',		'002',		'LV1',	'ANRAS33'),	
	('ROPO91', 	'Rodrigo', 		'Pinho', 				'rodrigo.pinho@gmail.com',			'1991-05-30', 		'1',	'2022-05-13',		'2023-05-13',		'629',		'LV3',	'TOSCI17'),	
	('PRGI90', 	'Péter', 		'Gulácsi', 				'péter.gulacsi@gmail.com',			'1990-05-06', 		'1',	'2022-01-18',		'2023-01-18',		'735',		'LV3',	'CZDAS99'),	
	('JPMZ98', 	'Josep', 		'Martínez', 			'josep.martínez@gmail.com',			'1998-05-27', 		'0',	'2021-10-03',		'2022-10-03',		null,		null,	'GESTA05'),
	('PPTR85', 	'Philipp', 		'Tschauner', 			'philipp.tschauner@gmail.com',		'1985-11-03', 		'1',	'2022-03-12',		'2023-03-12',		'472',		'LV3',	'BOSOT17');

INSERT INTO LAN_PARTY (SALA, CONNESSIONE, OMAGGIO, COD_NEGOZIO) VALUES
	('RM0519001',		'372mbps',		'Pepsi',		'RM0519'),
	('RM0218001',		'289mbps',		'Coca Cola', 	'RM0218'),
	('FI0304001',		'325mbps',		'Coca Cola',	'FI0304'),
	('FI0122001',		'274mbps',		'Fanta',		'FI0122'),
	('FI0519001',		'345mbps',		'Sprite',		'FI0519'),
	('MI0203001',		'679mbps',		'Fanta',		'MI0203'),
	('MI0327001',		'579mbps',		'Pepsi',		'MI0327'),
	('MI0401001',		'517mbps',		'RedBull',		'MI0401'),
	('PD0228001',		'524mbps',		'Pepsi',		'PD0228'),
	('VE0226001',		'269mbps',		'RedBull',		'VE0226'),
	('NA0115001',		'183mbps',		'Fanta',		'NA0115'),
	('NA0206001',		'169mbps',		'Coca Cola',	'NA0206');

    
INSERT INTO POSTAZIONE (NUMERO, SALA_LAN, CONSOLE) VALUES
	('001',		'RM0519001',		'13PS4ST1B'),
	('002',		'RM0519001',		'20XBOSX1N'),
	('003',		'RM0519001',		'13XBOON1N'),
	('004',		'RM0519001',		'13PS4PR1N'),
	('005',		'RM0519001',		'13XBOON5B'),
	('006',		'RM0519001',		'20XBOSX1N'),
	('007',		'RM0519001',		'20PS5ST1N'),
	('008',		'RM0519001',		'13PS4ST1N'),
	('009',		'RM0519001',		'13XBOON5N'),
	('010',		'RM0519001',		'20XBOSX5N'),
	('001',		'RM0218001',		'20PS5DE1N'),
	('002',		'RM0218001',		'13XBOON1N'),
	('003',		'RM0218001',		'20XBOSX1B'),
	('004',		'RM0218001',		'20PS5DE5B'),
	('005',		'RM0218001',		'20XBOSX5B'),
	('006',		'RM0218001',		'13XBOOX5N'),
	('007',		'RM0218001',		'20XBOSS5N'),
	('008',		'RM0218001',		'13XBOON5N'),
	('009',		'RM0218001',		'13XBOON5N'),
	('010',		'RM0218001',		'20XBOSS1B'),
	('001',		'FI0304001',		'17NINSW1R'),
	('002',		'FI0304001',		'13XBOOX5N'),
	('003',		'FI0304001',		'13XBOOX1B'),
	('004',		'FI0304001',		'20XBOSX1B'),
	('005',		'FI0304001',		'12WIIUU1B'),
	('006',		'FI0304001',		'13PS4PR5N'),
	('007',		'FI0304001',		'17NINSW1R'),
	('008',		'FI0304001',		'13XBOOX5N'),
	('009',		'FI0304001',		'12WIIUU1B'),
	('010',		'FI0304001',		'12WIIUU1B'),
	('001',		'FI0122001',		'13PS4PR5B'),
	('002',		'FI0122001',		'20PS5ST1N'),
	('003',		'FI0122001',		'13XBOON1B'),
	('004',		'FI0122001',		'20PS5DE1N'),
	('005',		'FI0122001',		'17NINSW1R'),
	('006',		'FI0122001',		'13XBOOX5B'),
	('007',		'FI0122001',		'17NINSW5R'),
	('008',		'FI0122001',		'13PS4ST1B'),
	('009',		'FI0122001',		'17NINSW1B'),
	('010',		'FI0122001',		'20PS5DE1B'),
	('001',		'MI0203001',		'13PS4ST5B'),
	('002',		'MI0203001',		'13PS4PR1B'),
	('003',		'MI0203001',		'13PS4SL1N'),
	('004',		'MI0203001',		'13PS4PR5B'),
	('005',		'MI0203001',		'13XBOOX1N'),
	('006',		'MI0203001',		'17NINSW5B'),
	('007',		'MI0203001',		'20XBOSS1N'),
	('008',		'MI0203001',		'13PS4PR1B'),
	('009',		'MI0203001',		'13PS4PR5N'),
	('010',		'MI0203001',		'20PS5DE1B'),
	('001',		'MI0327001',		'13XBOON1N'),
	('002',		'MI0327001',		'13XBOOS1N'),
	('003',		'MI0327001',		'13PS4ST1N'),
	('004',		'MI0327001',		'13XBOON1N'),
	('005',		'MI0327001',		'13PS4ST5B'),
	('006',		'MI0327001',		'13PS4PR1B'),
	('007',		'MI0327001',		'20PS5ST5B'),
	('008',		'MI0327001',		'13XBOOX5N'),
	('009',		'MI0327001',		'20XBOSX5N'),
	('010',		'MI0327001',		'13XBOON1B'),
	('001',		'MI0401001',		'20PS5DE5B'),
	('002',		'MI0401001',		'13XBOOS5N'),
	('003',		'MI0401001',		'13PS4ST1B'),
	('004',		'MI0401001',		'13PS4PR1B'),
	('005',		'MI0401001',		'20PS5ST1N'),
    ('006',		'MI0401001',		'20XBOSX1N'),
	('007',		'MI0401001',		'13PS4ST1B'),
	('008',		'MI0401001',		'13XBOOS1B'),
	('009',		'MI0401001',		'12WIIUU5R'),
	('010',		'MI0401001',		'20PS5ST5B'),
	('001',		'PD0228001',		'20XBOSX5N'),
	('002',		'PD0228001',		'20PS5DE5N'),
	('003',		'PD0228001',		'13PS4ST5B'),
	('004',		'PD0228001',		'13PS4SL5N'),
	('005',		'PD0228001',		'13PS4SL5B'),
	('006',		'PD0228001',		'20XBOSS5N'),
	('007',		'PD0228001',		'17NINSW1B'),
	('008',		'PD0228001',		'12WIIUU1R'),
	('009',		'PD0228001',		'13PS4ST1N'),
	('010',		'PD0228001',		'20XBOSS5N'),
	('001',		'VE0226001',		'13XBOOS5B'),
	('002',		'VE0226001',		'12WIIUU5R'),
	('003',		'VE0226001',		'20PS5DE1B'),
	('004',		'VE0226001',		'20PS5DE1N'),
	('005',		'VE0226001',		'13PS4ST5B'),
	('006',		'VE0226001',		'17NINSW5B'),
	('007',		'VE0226001',		'13XBOON1B'),
	('008',		'VE0226001',		'20XBOSS1B'),
	('009',		'VE0226001',		'13XBOOS1B'),
	('010',		'VE0226001',		'13PS4PR1N'),
	('001',		'NA0115001',		'13XBOOS1N'),
	('002',		'NA0115001',		'13PS4ST1N'),
	('003',		'NA0115001',		'20XBOSX1N'),
	('004',		'NA0115001',		'13PS4PR1N'),
	('005',		'NA0115001',		'13PS4PR5B'),
	('006',		'NA0115001',		'13PS4PR1B'),
	('007',		'NA0115001',		'20XBOSX1N'),
	('008',		'NA0115001',		'17NINSW1B'),
	('009',		'NA0115001',		'13XBOON1N'),
	('010',		'NA0115001',		'20PS5DE5B'),
	('001',		'FI0519001',		'20XBOSS1N'),
	('002',		'FI0519001',		'17NINSW1B'),
	('003',		'FI0519001',		'20XBOSS5N'),
	('004',		'FI0519001',		'12WIIUU1R'),
	('005',		'FI0519001',		'13PS4SL5B'),
	('006',		'FI0519001',		'20PS5DE5B'),
	('007',		'FI0519001',		'20PS5ST1B'),
	('008',		'FI0519001',		'13PS4SL1N'),
	('009',		'FI0519001',		'20XBOSX1N'),
	('010',		'FI0519001',		'20XBOSX1B'),
	('001',		'NA0206001',		'13XBOOX5B'),
	('002',		'NA0206001',		'17NINSW1B'),
	('003',		'NA0206001',		'17NINSW1B'),
	('004',		'NA0206001',		'13XBOOS5B'),
	('005',		'NA0206001',		'20PS5ST5N'),
	('006',		'NA0206001',		'20PS5DE5N'),
	('007',		'NA0206001',		'20PS5ST1N'),
	('008',		'NA0206001',		'13XBOON5B'),
	('009',		'NA0206001',		'17NINSW1B'),
	('010',		'NA0206001',		'20PS5ST5B');
    
INSERT INTO ACQUISTA (CF_CLIENTE, PRODOTTO, ORDINE) VALUES
	('REJS99',	 'C13XBOOX5B', 		'0315CO0'),
	('TOSA84',	 'C13XBOON5N', 		'0118CO0'),
	('RNLK96',	 'M0000FIJUJ', 		'0304CR1'),
	('MGSR99',	 'C13PS4PR1N', 		'0103AP1'),
	('RDMZ85',	 'M0000CAPOK', 		'0413VI0'),
	('EDMY92',	 'C13XBOOS1N', 		'1011CO0'),
	('KAAA94',	 'C13PS4SL5N', 		'1011CO0'),
	('EDMY92',	 'C17NINSW1B', 		'0306VI0'),
	('MSBI92',	 'C20PS5DE5N', 		'1219AP1'),
	('BNCL96',	 'C13XBOOS5B', 		'0627AP1'),
	('MGSR99',	 'M0000PETYH', 		'0419MA1'),
	('MOKC94',	 'V000614GOT', 		'0621MA1'),
	('RDMZ85',	 'C13XBOOS5B', 		'0514VI1'),
	('EDMY92',	 'C12WIIUU1B', 		'0436CR1'),
	('MOKC94',	 'V000414SUC', 		'0817VI1'),
	('CRAA89',	 'C13PS4PR5B', 		'0419MA1'),
	('JNVT93',	 'C13XBOOX1N', 		'0118CO0'),
	('SOOA92',	 'M0000ACXBO', 		'0627AP1'),
	('EOBE02',	 'C13PS4SL1N', 		'0311AP1'),
	('AYMS97',	 'C13PS4PR1B', 		'0521AP1'),
	('NAZI02',	 'C13XBOON1N', 		'0508VI1'),
	('LOPI96',	 'C17NINSW1B', 		'0530HY1'),
	('HHMN89',	 'C20PS5ST1B', 		'0118CO0'),
	('SNEY92',	 'M0000FIMYH', 		'1011CO0'),
	('NÒZO99',	 'C12WIIUU1R', 		'1015MA1'),
	('CSPZ98',	 'V000414SUC', 		'0521AP1'),
	('TYAM97',	 'M0000ACXBO', 		'0118CO0'),
	('ERSV95',	 'M0000ACPEX', 		'0921CR1'),
	('FXAN03',	 'C13PS4SL5N', 		'1007AP1'),
	('OSVS94',	 'M0000FIDRG', 		'0610CR1'),
	('HNLE90',	 'M0000FUDAR', 		'0326AP1'),
	('MESR99',	 'M0000FUDAR', 		'0921CR1'),
	('LSVO95',	 'C12WIIUU1R', 		'0921CR1'),
	('MORS01',	 'C20PS5DE5N', 		'0413CR0'),
	('NSOI88',	 'C13XBOOS5N', 		'1206CO0'),
	('JNVN87',	 'M0000ACPEX', 		'0315CO0'),
	('AOGO95',	 'C20XBOSS5N', 		'0304CR1'),
	('VOLO96',	 'C13XBOON1B', 		'1206CO0'),
	('GOMS93',	 'M0000ACMIC', 		'0311AP1'),
	('AÉAA90',	 'C17NINSW1R', 		'0514VI1'),
	('JNWL95',	 'M0000FUUND', 		'1008AP1'),
	('JOMO93',	 'V000311MAT', 		'0611HY1'),
	('SOMÉ94',	 'M0000FUUND', 		'0921CR1'),
	('POBO02',	 'M0000PETYG', 		'0419MA1'),
	('ALTT89',	 'V000319OUT', 		'0514VI1'),
	('RASA93',	 'C17NINSW1B', 		'0113AP1'),
	('DOGS97',	 'V000419THE', 		'0304CR1'),
	('ÉNSA96',	 'M0000PETYH', 		'0436CR1'),
	('GLDS96',	 'V000202ONE', 		'0113AP1'),
	('NARĆ96',	 'C20XBOSX5B', 		'0803HY1');
    
INSERT INTO OFFERTA (COD, SCONTO, TESSERA) VALUES
    ('LV105', '5',  'LV1'),
    ('LV210', '10', 'LV2'),
    ('LV315', '15', 'LV3'),
    ('LV420', '20', 'LV4');
    
INSERT INTO ACCEDERE (SALA_LAN, ABBONATO) VALUES
	('RM0519001', 'GLDS96'),
	('RM0218001', 'NARĆ96'),
	('FI0304001', 'GORS01'),
	('FI0122001', 'DNNZ99'),
	('FI0519001', 'RNYK95'),
	('MI0203001', 'HSSC92'),
	('MI0327001', 'ROPO91'),
	('MI0401001', 'PRGI90'),
	('PD0228001', 'JOMO93'),
	('VE0226001', 'SOMÉ94'),
	('NA0115001', 'POBO02'),
	('NA0206001', 'ALTT89'),
	('RM0519001', 'RASA93'),
	('RM0218001', 'DOGS97'),
	('FI0122001', 'RNLK96'),
	('FI0519001', 'MODĆ92'),
	('MI0203001', 'JIDZ97'),
	('MI0327001', 'JSKÉ98'),
	('MI0401001', 'DOCS93'),
	('PD0228001', 'KMRK94'),
	('VE0226001', 'MSAA91'),
	('NA0115001', 'LGAN94'),
	('NA0206001', 'GOML97'),
	('FI0304001', 'HNLE90'),
	('FI0122001', 'MESR99'),
	('FI0519001', 'LSVO95'),
	('MI0203001', 'MORS01'),
	('MI0327001', 'NSOI88'),
	('MI0401001', 'JNVN87'),
	('PD0228001', 'AOGO95'),
	('VE0226001', 'VOLO96'),
	('NA0115001', 'GOMS93'),
	('NA0206001', 'AÉAA90'),
	('RM0218001', 'NAZI02'),
	('FI0304001', 'LOPI96'),
	('FI0122001', 'HHMN89'),
	('FI0519001', 'SNEY92'),
	('MI0203001', 'NÒZO99'),
	('MI0327001', 'CSPZ98'),
	('MI0401001', 'TYAM97'),
	('PD0228001', 'ERSV95'),
	('VE0226001', 'TSDY91'),
	('NA0115001', 'NAGJ91'),
	('NA0206001', 'MNGD01');

INSERT INTO PRESSO (COD_NEGOZIO, COD_PRODOTTO) VALUES  
	('FI0122', 'C13PS4ST5N'),
	('FI0519', 'C13PS4ST1B'),
	('NA0206', 'C13PS4ST1N'),
	('PD0228', 'C13PS4SL5B'),
	('RM0519', 'C13PS4SL1B'),
	('FI0304', 'C13PS4SL1N'),
	('FI0519', 'C13PS4PR5B'),
	('MI0203', 'C13PS4PR5N'),
	('NA0115', 'C13PS4PR1N'),
	('RM0218', 'C20PS5ST5B'),
	('MI0401', 'C20PS5ST5N'),
	('RM0218', 'C20PS5ST1B'),
	('FI0304', 'C20PS5ST1N'),
	('NA0115', 'C20PS5DE5B'),
	('VE0226', 'C20PS5DE5N'),
	('NA0206', 'C20PS5DE1B'),
	('RM0218', 'C12WIIUU5B'),
	('NA0115', 'C12WIIUU5R'),
	('VE0226', 'C12WIIUU1B'),
	('MI0203', 'C12WIIUU1R'),
	('PD0228', 'C17NINSW5B'),
	('MI0327', 'C17NINSW5R'),
	('PD0228', 'C17NINSW1B'),
	('FI0122', 'C13XBOON5N'),
	('MI0401', 'C13XBOON1B'),
	('FI0519', 'C13XBOON1N'),
	('MI0401', 'C13XBOOS5B'),
	('MI0203', 'C13XBOOS1B'),
	('NA0206', 'C13XBOOS1N'),
	('RM0218', 'C13XBOOX5B'),
	('MI0203', 'C13XBOOX5N'),
	('NA0206', 'C13XBOOX1B'),
	('NA0206', 'C13XBOOX1N'),
	('PD0228', 'C20XBOSS5B'),
	('RM0519', 'C20XBOSS1B'),
	('NA0206', 'C20XBOSS1N'),
	('NA0115', 'C20XBOSX5B'),
	('NA0115', 'C20XBOSX1B'),
	('RM0519', 'C20XBOSX1N'),
	('FI0304', 'V000112HOG'),
	('MI0327', 'V000414SUC'),
	('PD0228', 'V000319OUT'),
	('VE0226', 'V000419ILS'),
	('FI0122', 'V000511EVI'),
	('NA0206', 'V000202ONE'),
	('NA0206', 'V000126POK'),
	('NA0115', 'V000524KAM'),
	('MI0203', 'V000614GOT'),
	('NA0206', 'V000117STA'),
	('RM0218', 'V000510SIA'),
	('FI0304', 'M0000ACCUF'),
	('NA0206', 'M0000ACIVE'),
	('MI0327', 'M0000ACMIC'),
	('FI0122', 'M0000ACXBO'),
	('VE0226', 'M0000ACPEX'),
	('VE0226', 'M0000PETYH'),
	('PD0228', 'M0000PETYG'),
	('PD0228', 'M0000PEHEL'),
	('FI0519', 'M0000FIMYH'),
	('VE0226', 'M0000FIJUJ'),
	('NA0115', 'M0000FIDRA'),
	('RM0519', 'M0000CAYUG'),
	('RM0218', 'M0000CAYUI'),
	('MI0401', 'M0000CAPOK'),
	('MI0203', 'M0000FUDUS'),
	('FI0304', 'M0000FUUND'),
	('VE0226', 'M0000FUZOR');
--
-- QUERY 1: clienti che hanno acquistato di più online
--
SELECT ACQUISTA.CF_CLIENTE, sum(case when ORDINE.ONLINE_='1' THEN 1 ELSE 0 END) AS TOT_ORDINI
FROM ACQUISTA INNER JOIN ORDINE ON ACQUISTA.ORDINE=ORDINE.COD
GROUP BY CF_CLIENTE
ORDER BY TOT_ORDINI DESC
LIMIT 10

--
-- QUERY 2: bilancio
--
SELECT COUNT(ACQUISTA.ORDINE) AS TOT_ORDINI, SUM(PRODOTTO.PREZZO) AS LORDO
FROM PRODOTTO INNER JOIN ACQUISTA ON PRODOTTO.COD=ACQUISTA.PRODOTTO
			  INNER JOIN ORDINE ON ORDINE.COD=ACQUISTA.ORDINE
WHERE PRODOTTO.COD=ACQUISTA.PRODOTTO
	AND ORDINE.DATA_ACQUISTO BETWEEN '2022-01-01' AND '2022-06-30'

--
-- QUERY 3: genere acquistati da clienti
--
SELECT VIDEOGIOCO.GENERE, COUNT(ACQUISTA.ORDINE) AS GIOCHI_VENDUTI, SUM(PRODOTTO.PREZZO) AS INCASSO
FROM ACQUISTA INNER JOIN PRODOTTO ON PRODOTTO.COD=ACQUISTA.PRODOTTO
              INNER JOIN VIDEOGIOCO ON PRODOTTO.COD=VIDEOGIOCO.COD_PRODOTTO
GROUP BY VIDEOGIOCO.GENERE

--
-- QUERY 4: numero di abbonati lv3 che accedono alle varie sale lan
--
SELECT ACCEDERE.SALA_LAN, COUNT(ACCEDERE.ABBONATO) AS NUMERO_ABBONATI
FROM ACCEDERE INNER JOIN CLIENTE ON ACCEDERE.ABBONATO=CLIENTE.CF
WHERE CLIENTE.TESSERA='LV3'
GROUP BY ACCEDERE.SALA_LAN
ORDER BY NUMERO_ABBONATI DESC

--
-- QUERY 5: quanto pagano i clienti che accedono alla lan_party divisi per omaggi offerti
--
SELECT LAN_PARTY.OMAGGIO, COUNT(ACCEDERE.ABBONATO) AS TOT_PRESENTI, SUM(TESSERA.PREZZO) AS INCASSI_DA_TESSERA
FROM LAN_PARTY INNER JOIN ACCEDERE ON LAN_PARTY.SALA=ACCEDERE.SALA_LAN
			   INNER JOIN CLIENTE ON ACCEDERE.ABBONATO=CLIENTE.CF
               INNER JOIN TESSERA ON CLIENTE.TESSERA=TESSERA.LIVELLO
GROUP BY LAN_PARTY.OMAGGIO

--
-- QUERY 6: lista negozi con ordini fisici
--
SELECT DISTINCT NEGOZIO.COD, COUNT(ORDINE.COD) AS ORDINI_FISICI
FROM NEGOZIO INNER JOIN ORDINE ON NEGOZIO.COD=ORDINE.COD_NEGOZIO
WHERE ORDINE.ONLINE_='0'
 	AND NEGOZIO.COD=ORDINE.COD_NEGOZIO
GROUP BY NEGOZIO.COD

--
-- INDICE: disponibilità prodotti
--
CREATE INDEX DISPONIBILITA_PRODOTTI ON PRODOTTO (COD_PRODOTTO, DISPONIBILITA);