mysql-window-functions.sql

CREATE TABLE Students(
	student_number	INT AUTO_INCREMENT PRIMARY KEY,
	student_name	VARCHAR(100),
	dept_name		VARCHAR(100),
	subject			VARCHAR(100),
	marks			INT
);

INSERT INTO Students (student_name,dept_name,subject,marks) VALUES
('Tom','CS','Programming',90),
('Tom','CS','Database',100),
('Rob','CS','Programming',95),
('Fred','CS','Programming',80),
('Alter','CS','Database',100),
('Jason','CS','Database',98),
('Jason','CS','Programming',80),
('John','English','Literature',75),
('Alicia','English','History',60),
('Sofia','English','History',70),
('Sofia','English','Grammar',70);