CREATE TABLE iktge24a
(
	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 iktge24a (lastname, firstname, birthdate, phone, email)
VALUES
	('Boman','Jonatan','1979-09-28','+358 44 446 5555', 'jonatan.boman@student.vamia.fi'),
	('Dmytrenko','Andrii','1988-06-06','+358 45 545 5556', 'andrii.dmytrenko@student.vamia.fi'),
	('Fållbäck','Hampus','2001-09-14','+358 44 445 5557', 'hampus.fallback@student.vamia.fi'),	
	('Kern','Nico','1999-07-21','+358 45 545 5558', 'nico.kern@student.vamia.fi'),
	('Koskimäki','Kristian','1975-05-25','+358 50 545 5560', 'kristian.koskimaki@student.vamia.fi'),
	('Pham Duc','Bao','1999-04-12','+358 50 445 5569', 'bao.pham@student.vamia.fi'),
	('Saarto','Mico','2004-10-01','+358 44 565 4449', 'mico.saarto@student.vamia.fi'),
	('Smulter','Lucas','1990-07-04','+358 44 665 4450', 'lucas.smulter@student.vamia.fi');
    
    
    
    
	('Snickars','Fabian','2000-09-28','+358 50 455 4567', 'fabian.snickars@student.vamia.fi');