BEGIN TRANSACTION;
DROP TABLE IF EXISTS "etudiants";
CREATE TABLE IF NOT EXISTS "etudiants" (
	"nom"	TEXT,
	"prenom"	TEXT,
	"adresse"	TEXT,
	"datenaiss"	TEXT,
	"langue"	TEXT
);
DROP TABLE IF EXISTS "notes";
CREATE TABLE IF NOT EXISTS "notes" (
	"nom"	TEXT,
	"prenom"	TEXT,
	"maths"	INTEGER,
	"si"	INTEGER,
	"physique"	INTEGER
);
INSERT INTO "etudiants" ("nom","prenom","adresse","datenaiss","langue") VALUES ('Bareau','Juliette','3 rue du Nil','03/05/2004','allemand'),
 ('Benali','Elias','34 rue de la Loge','07/07/2003','espagnol'),
 ('Dupont','Louise','1 place Coubertin','15/11/2003','anglais'),
 ('Fabre','Maria','6 impasse de la presse','31/12/2004','anglais'),
 ('Legentil','Antoine','124 avenue Clem','01/05/2002','anglais'),
 ('Marot','Sophia','5 rue Espoir','15/11/2003','allemand'),
 ('Perot','Martin','15 rue Sourie','20/12/2003','espagnol'),
 ('Raron','Anna','101 Bvd Jacod','11/03/2002','anglais'),
 ('Zeemann','David','17 rue Vincent','03/07/2004','espagnol');
INSERT INTO "notes" ("nom","prenom","maths","si","physique") VALUES ('Bareau','Juliette',13,15,8),
 ('Benali','Elias',6,12,3),
 ('Dupont','Louise',10,8,15),
 ('Fabre','Maria',5,4,9),
 ('Legentil','Antoine',11,9,8),
 ('Marot','Sophia',9,4,15),
 ('Perot','Martin',9,10,11),
 ('Raron','Anna',7,11,7),
 ('Zeemann','David',5,13,10);
COMMIT;
