drop table if exists student;

CREATE TABLE student (
	id	CHAR(4) NOT NULL,
	name	VARCHAR(20),
	dob	DATE,
	gender	CHAR(1),
	class	CHAR(2),
	house	CHAR(1),
	district	CHAR(3),
	mtest	int(3),
	remission	BINARY(1),
	PRIMARY KEY (id) 
);

insert into student values
(9801,'Peter',	'1996-06-04','M','1A','R','SSP',70,'FALSE'),
(9802,'Mary',	'1996-01-10','F','1A','Y','HHM',92,'FALSE'),
(9803,'Johnny',	'1996-03-16','M','1A','G','SSP',91,'TRUE'),
(9804,'Wendy',	'1996-07-09','F','1B','B','YMT',84,'FALSE'),
(9805,'Tobe',	'1996-10-17','M','1B','R','YMT',88,'FALSE'),
(9806,'Kitty',	'1997-01-25','F','1B','R','YMT',64,'TRUE'),
(9807,'Eric',	'1997-05-05','M','1C','Y','MKK',51,'FALSE'),
(9808,'Patty',	'1997-08-13','F','1C','Y','HHM',36,'TRUE'),
(9809,'Kevin',	'1997-11-21','M','1C','G','MKK',19,'TRUE'),
(9810,'Luke',	'1996-01-01','M','1A','G','MKK',86,'FALSE'),
(9811,'Bobby',	'1996-02-16','M','1A','B','TST',92,'FALSE'),
(9812,'Aaron',	'1996-08-02','M','1A','R','YMT',83,'FALSE'),
(9813,'Ron',	'1996-12-17','M','1A','R','MKK',91,'FALSE'),
(9814,'Kenny',	'1995-12-31','M','1B','Y','HHM',84,'FALSE'),
(9815,'Eddy',	'1996-01-15','M','1B','Y','TSW',75,'FALSE'),
(9816,'Teddy',	'1996-01-30','M','1B','B','SSP',64,'FALSE'),
(9817,'George',	'1996-02-14','M','1C','G','SSP',41,'FALSE'),
(9818,'Edmond',	'1995-02-28','M','1C','R','YMT',38,'FALSE'),
(9819,'Vincent','1995-03-15','M','1C','Y','MKK',29,'FALSE'),
(9820,'Jill',	'1995-12-21','F','1A','Y','HHM',91,'TRUE'),
(9821,'Mandy',	'1996-03-04','F','1A','B','TST',79,'TRUE'),
(9822,'Janet',	'1996-03-17','F','1B','R','SSP',74,'FALSE'),
(9823,'Queenie','1996-03-30','F','1C','G','SSP',31,'FALSE'),
(9824,'Gigi',	'1996-04-12','F','1A','G','YMT',84,'FALSE'),
(9825,'Laura',	'1996-04-25','F','1C','G','MKK',45,'FALSE'),
(9826,'Sandy',	'1996-05-08','F','1B','G','HHM',64,'FALSE'),
(9827,'Nancy',	'1996-05-21','F','1C','Y','HHM',51,'FALSE'),
(9828,'Mimi',	'1996-06-03','F','1B','R','TST',36,'FALSE'),
(9701,'Paula',	'1995-02-14','F','2A','R','YMT',94,'TRUE'),
(9702,'Helen',	'1995-02-24','F','2A','Y','TST',88,'FALSE'),
(9703,'Rosa',	'1995-03-06','F','2A','B','SSP',91,'FALSE'),
(9704,'Susan',	'1995-06-20','F','2A','G','YMT',96,'FALSE'),
(9705,'Chris',	'1995-07-03','M','2B','R','MKK',75,'FALSE'),
(9706,'Franky',	'1995-07-16','M','2B','Y','HHM',64,'FALSE'),
(9707,'Zion',	'1995-07-29','M','2B','B','MKK',51,'FALSE'),
(9708,'Jason',	'1995-08-11','M','2B','G','MMK',36,'TRUE'),
(9709,'Yvonne',	'1995-08-24','F','2C','R','TST',10,'FALSE'),
(9710,'Leon',	'1995-09-06','M','2C','Y','SSP',23,'TRUE'),
(9711,'Leslie',	'1995-05-20','M','2C','B','MKK',22,'FALSE'),
(9712,'Jimmy',	'1995-06-04','M','2A','G','HHM',96,'FALSE'),
(9713,'Tim',	'1995-06-19','M','2A','R','HHM',91,'TRUE'),
(9714,'Samual',	'1995-07-04','M','2A','Y','SHT',84,'TRUE'),
(9715,'Joseph',	'1995-07-19','M','2A','B','TSW',75,'FALSE'),
(9716,'Linda',	'1995-08-03','F','2B','G','YMT',64,'FALSE'),
(9717,'Donna',	'1995-08-18','F','2B','R','SSP',51,'FALSE'),
(9718,'May',	'1995-09-02','F','2B','Y','HHM',36,'FALSE'),
(9719,'Josephine','1995-09-17','F','2B','B','YMT',48,'FALSE'),
(9720,'Cindy',	'1995-03-16','F','2C','G','SSP',29,'FALSE'),
(9721,'June',	'1995-03-31','F','2C','R','KWC',62,'FALSE'),
(9722,'Flora',	'1995-04-15','F','2C','R','YMT',50,'FALSE');
