sql-exercises/04-advanced-databases/14-window-functions/seed.sql at main · amigoscode/sql-exercises · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
-- =============================================================
-- Seed data for Section 14 — Window Functions
-- =============================================================

SET search_path TO adv_windows;

INSERT INTO employee (full_name, department, country, salary, hired_on) VALUES
('Ada Lovelace',      'engineering', 'GB',  95000, '2015-03-02'),
('Alan Turing',       'engineering', 'GB', 110000, '2010-09-01'),
('Grace Hopper',      'engineering', 'US',  88000, '2018-01-15'),
('Linus Torvalds',    'engineering', 'FI', 145000, '2019-11-04'),
('Donald Knuth',      'engineering', 'US',  98000, '2016-06-20'),
('Margaret Hamilton', 'data',        'US',  98000, '2014-05-12'),
('Dennis Ritchie',    'data',        'US',  72000, '2008-07-21'),
('Katherine Johnson', 'data',        'US',  64000, '2022-02-14'),
('Radia Perlman',     'sales',       'US',  55000, '2016-06-06'),
('Barbara Liskov',    'sales',       'US',  58000, '2020-03-17'),
('Edsger Dijkstra',   'marketing',   'NL',  45000, '2021-08-10'),
('Tim Berners-Lee',   'marketing',   'GB',  62000, '2013-10-08');

INSERT INTO sale (rep_name, sold_at, amount, region) VALUES
('Radia Perlman',  '2026-01-05',  12000, 'NA'),
('Radia Perlman',  '2026-01-19',   8000, 'NA'),
('Barbara Liskov', '2026-01-12',  25000, 'NA'),
('Barbara Liskov', '2026-01-28',  15000, 'NA'),
('Radia Perlman',  '2026-02-02',  18000, 'NA'),
('Barbara Liskov', '2026-02-14',  22000, 'NA'),
('Radia Perlman',  '2026-02-21',   9000, 'NA'),
('Barbara Liskov', '2026-03-03',  30000, 'NA'),
('Radia Perlman',  '2026-03-10',  11000, 'NA'),
('Barbara Liskov', '2026-03-25',  27000, 'NA'),
('Radia Perlman',  '2026-03-30',  14000, 'NA');