SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE Test ( loginStudent varchar(10), -- Логин студента questionNumber int, -- Номер вопроса ratingTeacher int, -- оценка преподавателя ratingStudent int); -- оценка студента INSERT INTO Test ( loginStudent, questionNumber, ratingTeacher, ratingStudent) VALUES ('denis', 1, 1, 1), ('denis', 2, 1, 1), ('denis', 3, 0, 1), ('denis', 4, 1, 0), ('denis', 4, 0, 1), ('mark', 1, 1, 1), ('mark', 2, 1, 1), ('mark', 3, 0, 0), ('mark', 4, 0, 1), ('mark', 4, 1, 0), ('ann', 1, 0, 1), ('ann', 1, 1, 0), ('ann', 1, 0, 1), ('ann', 2, 1, 0), ('ann', 3, 1, 0), ('ann', 4, 0, 1); select * from Test where questionNumber = ratingTeacher;