CREATE TABLE IF NOT EXISTS windows_functions."salary" (
    "id" INT,
    "first_name" TEXT,
    "department" TEXT,
    "gross_salary" INT
);
INSERT INTO windows_functions."salary" VALUES
    (1,'Kolya','Sales',100000),
    (2,'Ira','Marketing',100000),
    (3,'Nina','HR',150000),
    (4,'Arkadiy','IT',300000),
    (5,'Innokentiy','IT',100000),
    (6,'Kollbek','IT',133000),
    (7,'Nastya','HR',60000),
    (8,'Lena','IT',98000),
    (9,'Masha','IT',98000),
    (10,'Masha','Marketing',98000),
    (11,'Igor','Marketing',50000),
    (12,'Masha','Sales',98000),
    (13,'Mayya','Sales',20000);
