CREATE TABLE iktge23a
(
	studentid		INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY,
	lastname		VARCHAR(20) NOT NULL,
	firstname		VARCHAR(30) NOT NULL,
	birthdate		DATE NOT NULL,	
	phone			VARCHAR(16),
	email			VARCHAR(50)
);


INSERT INTO iktge23a (lastname, firstname, birthdate, phone, email)
VALUES
	('Back','Emilia','1999-09-28','+358 44 445 5555', 'emilia.back@student.vamia.fi'),
	('Hagin','David','1987-06-06','+358 45 445 5556', 'david.hagin@student.vamia.fi'),
	('Lax','Jenny','1995-09-14','+358 44 445 5557', 'jenny.lax@student.vamia.fi'),	
	('Lindell','Zakarias','1995-07-21','+358 45 445 5558', 'zakarias.lindell@student.vamia.fi'),
	('Lindqvist','Isac','1975-05-25','+358 50 445 5560', 'isac.lindqvist@student.vamia.fi'),
	('Loo','Viola','1999-04-12','+358 50 445 5561', 'viola.loo@student.vamia.fi'),
	('Ngoie','Valancia','1994-10-01','+358 44 555 4449', 'valancia.ngoie@student.vamia.fi'),
	('Penttilä','Aleksi','1990-07-04','+358 44 555 4450', 'aleksi.penttila@student.vamia.fi'),
	('Weiner','Isak','1990-07-04','+358 44 555 4450', 'isak.weiner@student.vamia.fi'),
	('Österback','Sevin','1886-09-28','+358 50 444 4567', 'sevin.osterback@student.vamia.fi');