create table students(
PP INTEGER NOT NULL AUTO_INCREMENT ,
Firstname VARCHAR(15) NOT NULL ,
Secondname VARCHAR(15) NOT NULL,
Math int(1) NOT NULL,
Physics int (1) NOT NULL,
Russian int(1) NOT NULL,
Literature int(1) NOT NULL,
History int(1) NOT NULL,
Computerscience int(1) NOT NULL,
PRIMARY KEY(PP));
INSERT INTO students VALUES('1','Зайцев','Роман','4','4','5','5','4','4');
INSERT INTO students VALUES('2','Иванов','Николай','4','5','4','4','3','4');
INSERT INTO students VALUES('3','Котова','Ксения','2','3','3','3','3','2');
INSERT INTO students VALUES('4','Новикова','Елена','4','3','4','5','3','3');
INSERT INTO students VALUES('5','Сидоров','Петр','5','4','4','5','5','5');
INSERT INTO students VALUES('6','Петрова','Мария','2','2','3','3','3','3');
INSERT INTO students VALUES('7','Фролов','Михаил','3','3','4','4','3','3');