init-window-function.sql

CREATE TABLE students(
	id serial PRIMARY KEY,
	name TEXT,
	mark INTEGER,
	age INTEGER,
	subject TEXT
);

INSERT INTO students(name, mark, age, subject) 
VALUES
	('John', 9, 15, 'Math'),
	('Thomas', 2, 15, 'Math'),
	('Alice', 6, 14, 'Math'),
	('Tom', 9, 13, 'History'),
	('Bob', 9, 13, 'History'),
	('Nancy', 7, 12, 'History'),
	('Will', 7, 17, 'History'),
	('El', 3, 13, 'History'),
	('Jones', 9, 13, 'Biology'),
	('Smith', 8, 13, 'Biology'),
	('Daisy', 8, 13, 'Biology'),
	('Jerry', 8, 13, 'Biology'),
	('Eric', 6, 13, 'Biology'),
	('Logan', 7, 13, 'Biology')