BEGIN TRANSACTION;
CREATE TABLE personne (nom char(20),prenom char(20),code_ville int);
INSERT INTO personne VALUES('DUPONT','Virginie',18);
INSERT INTO personne VALUES('MARTIN','Pierre',17);
INSERT INTO personne VALUES('BERNARD','Caroline',25);
INSERT INTO personne VALUES('THOMAS','Roland',31);
INSERT INTO personne VALUES('PETIT','Oscar',16);
INSERT INTO personne VALUES('ROBERT','Paul',11);
INSERT INTO personne VALUES('RICHARD','Manon',24);
INSERT INTO personne VALUES('DUBOIS','Maxence',22);
INSERT INTO personne VALUES('LOPEZ','Jean',43);
INSERT INTO personne VALUES('DURAND','Clément',36);
INSERT INTO personne VALUES('HUBERT','Stella',29);
INSERT INTO personne VALUES('DUPUIS','Simon',33);
INSERT INTO personne VALUES('MOULIN','Fanny',19);
INSERT INTO personne VALUES('BOUCHER','Antoine',28);
INSERT INTO personne VALUES('POIRIER','Florent',26);
INSERT INTO personne VALUES('PARIS','Josiane',15);
INSERT INTO personne VALUES('FLEURY','Gaspard',41);
INSERT INTO personne VALUES('FONTAINE','Xavier',21);
COMMIT;