CREATE TABLE IF NOT EXISTS g_namelist(
id smallint not null auto_increment primary key,
name varchar(30) not null,
sex char(1) default 'M'
);
INSERT INTO g_namelist (name,sex) VALUES('Andrea','M');
INSERT INTO g_namelist (name,sex) VALUES('Luca','M');
INSERT INTO g_namelist (name,sex) VALUES('Marco','M');
INSERT INTO g_namelist (name,sex) VALUES('Francesco','M');
INSERT INTO g_namelist (name,sex) VALUES('Matteo','M');
INSERT INTO g_namelist (name,sex) VALUES('Alessandro','M');
INSERT INTO g_namelist (name,sex) VALUES('Davide','M');
INSERT INTO g_namelist (name,sex) VALUES('Simone','M');
INSERT INTO g_namelist (name,sex) VALUES('Federico','M');
INSERT INTO g_namelist (name,sex) VALUES('Lorenzo','M');
INSERT INTO g_namelist (name,sex) VALUES('Mattia','M');
INSERT INTO g_namelist (name,sex) VALUES('Stefano','M');
INSERT INTO g_namelist (name,sex) VALUES('Giuseppe','M');
INSERT INTO g_namelist (name,sex) VALUES('Riccardo','M');
INSERT INTO g_namelist (name,sex) VALUES('Daniele','M');
INSERT INTO g_namelist (name,sex) VALUES('Michele','M');
INSERT INTO g_namelist (name,sex) VALUES('Alessio','M');
INSERT INTO g_namelist (name,sex) VALUES('Antonio','M');
INSERT INTO g_namelist (name,sex) VALUES('Giovanni','M');
INSERT INTO g_namelist (name,sex) VALUES('Nicola','M');
INSERT INTO g_namelist (name,sex) VALUES('Gabriele','M');
INSERT INTO g_namelist (name,sex) VALUES('Fabio','M');
INSERT INTO g_namelist (name,sex) VALUES('Alberto','M');
INSERT INTO g_namelist (name,sex) VALUES('Giacomo','M');
INSERT INTO g_namelist (name,sex) VALUES('Giulio','M');
INSERT INTO g_namelist (name,sex) VALUES('Filippo','M');
INSERT INTO g_namelist (name,sex) VALUES('Gianluca','M');
INSERT INTO g_namelist (name,sex) VALUES('Paolo','M');
INSERT INTO g_namelist (name,sex) VALUES('Roberto','M');
INSERT INTO g_namelist (name,sex) VALUES('Salvatore','M');
INSERT INTO g_namelist (name,sex) VALUES('Emanuele','M');
INSERT INTO g_namelist (name,sex) VALUES('Edoardo','M');
INSERT INTO g_namelist (name,sex) VALUES('Enrico','M');
INSERT INTO g_namelist (name,sex) VALUES('Vincenzo','M');
INSERT INTO g_namelist (name,sex) VALUES('Nicolò','M');
INSERT INTO g_namelist (name,sex) VALUES('Leonardo','M');
INSERT INTO g_namelist (name,sex) VALUES('Jacopo','M');
INSERT INTO g_namelist (name,sex) VALUES('Manuel','M');
INSERT INTO g_namelist (name,sex) VALUES('Mirko','M');
INSERT INTO g_namelist (name,sex) VALUES('Tommaso','M');
INSERT INTO g_namelist (name,sex) VALUES('Pietro','M');
INSERT INTO g_namelist (name,sex) VALUES('Luigi','M');
INSERT INTO g_namelist (name,sex) VALUES('Giorgio','M');
INSERT INTO g_namelist (name,sex) VALUES('Angelo','M');
INSERT INTO g_namelist (name,sex) VALUES('Dario','M');
INSERT INTO g_namelist (name,sex) VALUES('Valerio','M');
INSERT INTO g_namelist (name,sex) VALUES('Domenico','M');
INSERT INTO g_namelist (name,sex) VALUES('Claudio','M');
INSERT INTO g_namelist (name,sex) VALUES('Alex','M');
INSERT INTO g_namelist (name,sex) VALUES('Beatrice','F');
INSERT INTO g_namelist (name,sex) VALUES('Valeria','F');
INSERT INTO g_namelist (name,sex) VALUES('Michela','F');
INSERT INTO g_namelist (name,sex) VALUES('Serena','F');
INSERT INTO g_namelist (name,sex) VALUES('Camilla','F');
INSERT INTO g_namelist (name,sex) VALUES('Irene','F');
INSERT INTO g_namelist (name,sex) VALUES('Cristina','F');
INSERT INTO g_namelist (name,sex) VALUES('Simona','F');
INSERT INTO g_namelist (name,sex) VALUES('Maria','F');
INSERT INTO g_namelist (name,sex) VALUES('Noemi','F');
INSERT INTO g_namelist (name,sex) VALUES('Stefania','F');
INSERT INTO g_namelist (name,sex) VALUES('Erika','F');
INSERT INTO g_namelist (name,sex) VALUES('Sofia','F');
INSERT INTO g_namelist (name,sex) VALUES('Lucia','F');
INSERT INTO g_namelist (name,sex) VALUES('Vanessa','F');
INSERT INTO g_namelist (name,sex) VALUES('Greta','F');
INSERT INTO g_namelist (name,sex) VALUES('Debora','F');
INSERT INTO g_namelist (name,sex) VALUES('Nicole','F');
INSERT INTO g_namelist (name,sex) VALUES('Angela','F');
INSERT INTO g_namelist (name,sex) VALUES('Paola','F');
INSERT INTO g_namelist (name,sex) VALUES('Caterina','F');
INSERT INTO g_namelist (name,sex) VALUES('Monica','F');
INSERT INTO g_namelist (name,sex) VALUES('Erica','F');
INSERT INTO g_namelist (name,sex) VALUES('Lisa','F');
INSERT INTO g_namelist (name,sex) VALUES('Gaia','F');

CREATE TABLE name(
id smallint not null auto_increment primary key
nome varchar(30) not null,
sex char(1) default 'M'
);
INSERT INTO name (name,sex) VALUES('Andrea','M');
INSERT INTO name (name,sex) VALUES('Luca','M');
INSERT INTO name (name,sex) VALUES('Marco','M');
INSERT INTO name (name,sex) VALUES('Francesco','M');
INSERT INTO name (name,sex) VALUES('Matteo','M');
INSERT INTO name (name,sex) VALUES('Alessandro','M');
INSERT INTO name (name,sex) VALUES('Davide','M');
INSERT INTO name (name,sex) VALUES('Simone','M');
INSERT INTO name (name,sex) VALUES('Federico','M');
INSERT INTO name (name,sex) VALUES('Lorenzo','M');
INSERT INTO name (name,sex) VALUES('Mattia','M');
INSERT INTO name (name,sex) VALUES('Stefano','M');
INSERT INTO name (name,sex) VALUES('Giuseppe','M');
INSERT INTO name (name,sex) VALUES('Riccardo','M');
INSERT INTO name (name,sex) VALUES('Daniele','M');
INSERT INTO name (name,sex) VALUES('Michele','M');
INSERT INTO name (name,sex) VALUES('Alessio','M');
INSERT INTO name (name,sex) VALUES('Antonio','M');
INSERT INTO name (name,sex) VALUES('Giovanni','M');
INSERT INTO name (name,sex) VALUES('Nicola','M');
INSERT INTO name (name,sex) VALUES('Gabriele','M');
INSERT INTO name (name,sex) VALUES('Fabio','M');
INSERT INTO name (name,sex) VALUES('Alberto','M');
INSERT INTO name (name,sex) VALUES('Giacomo','M');
INSERT INTO name (name,sex) VALUES('Giulio','M');
INSERT INTO name (name,sex) VALUES('Filippo','M');
INSERT INTO name (name,sex) VALUES('Gianluca','M');
INSERT INTO name (name,sex) VALUES('Paolo','M');
INSERT INTO name (name,sex) VALUES('Roberto','M');
INSERT INTO name (name,sex) VALUES('Salvatore','M');
INSERT INTO name (name,sex) VALUES('Emanuele','M');
INSERT INTO name (name,sex) VALUES('Edoardo','M');
INSERT INTO name (name,sex) VALUES('Enrico','M');
INSERT INTO name (name,sex) VALUES('Vincenzo','M');
INSERT INTO name (name,sex) VALUES('Nicolò','M');
INSERT INTO name (name,sex) VALUES('Leonardo','M');
INSERT INTO name (name,sex) VALUES('Jacopo','M');
INSERT INTO name (name,sex) VALUES('Manuel','M');
INSERT INTO name (name,sex) VALUES('Mirko','M');
INSERT INTO name (name,sex) VALUES('Tommaso','M');
INSERT INTO name (name,sex) VALUES('Pietro','M');
INSERT INTO name (name,sex) VALUES('Luigi','M');
INSERT INTO name (name,sex) VALUES('Giorgio','M');
INSERT INTO name (name,sex) VALUES('Angelo','M');
INSERT INTO name (name,sex) VALUES('Dario','M');
INSERT INTO name (name,sex) VALUES('Valerio','M');
INSERT INTO name (name,sex) VALUES('Domenico','M');
INSERT INTO name (name,sex) VALUES('Claudio','M');
INSERT INTO name (name,sex) VALUES('Alex','M');
INSERT INTO name (name,sex) VALUES('Beatrice','F');
INSERT INTO name (name,sex) VALUES('Valeria','F');
INSERT INTO name (name,sex) VALUES('Michela','F');
INSERT INTO name (name,sex) VALUES('Serena','F');
INSERT INTO name (name,sex) VALUES('Camilla','F');
INSERT INTO name (name,sex) VALUES('Irene','F');
INSERT INTO name (name,sex) VALUES('Cristina','F');
INSERT INTO name (name,sex) VALUES('Simona','F');
INSERT INTO name (name,sex) VALUES('Maria','F');
INSERT INTO name (name,sex) VALUES('Noemi','F');
INSERT INTO name (name,sex) VALUES('Stefania','F');
INSERT INTO name (name,sex) VALUES('Erika','F');
INSERT INTO name (name,sex) VALUES('Sofia','F');
INSERT INTO name (name,sex) VALUES('Lucia','F');
INSERT INTO name (name,sex) VALUES('Vanessa','F');
INSERT INTO name (name,sex) VALUES('Greta','F');
INSERT INTO name (name,sex) VALUES('Debora','F');
INSERT INTO name (name,sex) VALUES('Nicole','F');
INSERT INTO name (name,sex) VALUES('Angela','F');
INSERT INTO name (name,sex) VALUES('Paola','F');
INSERT INTO name (name,sex) VALUES('Caterina','F');
INSERT INTO name (name,sex) VALUES('Monica','F');
INSERT INTO name (name,sex) VALUES('Erica','F');
INSERT INTO name (name,sex) VALUES('Lisa','F');
INSERT INTO name (name,sex) VALUES('Gaia','F');

SQL to list and generate common italian names

SQL to list Italian names

SQL