windowfunctionSchema_5.sql

DROP TABLE IF EXISTS STUDENTS;

CREATE TABLE students (
    student_id INT,
    subject VARCHAR(20),
    score INT
);

INSERT INTO students (student_id, subject, score) VALUES
(1, 'Math', 85),
(1, 'English', 92),
(1, 'Science', 87),
(2, 'Math', 91),
(2, 'English', 88),
(2, 'Science', 93),
(3, 'Math', 78),
(3, 'English', 85),
(3, 'Science', 90),
(4, 'Math', 92),
(4, 'English', 86),
(4, 'Science', 89),
(5, 'Math', 90),
(5, 'English', 88),
(5, 'Science', 85),
(6, 'Math', 93),
(6, 'English', 82),
(6, 'Science', 90);

select * from students;