seed.sql

-- =============================================================
-- Seed data for Section 13 — CTEs
-- =============================================================

SET search_path TO adv_cte;

-- Org chart:
-- Ada (CEO)
--  ├── Alan (CTO)
--  │    ├── Grace (Eng Manager)
--  │    │    ├── Linus (Senior Engineer)
--  │    │    └── Donald (Engineer)
--  │    └── Dennis (Principal Engineer)
--  └── Margaret (COO)
--       ├── Katherine (Ops Lead)
--       └── Radia (Operations)
INSERT INTO employee (full_name, title, manager_id, salary) VALUES
('Ada Lovelace',      'CEO',                NULL, 200000),     -- 1
('Alan Turing',       'CTO',                1,    180000),     -- 2
('Grace Hopper',      'Engineering Manager',2,    140000),     -- 3
('Linus Torvalds',    'Senior Engineer',    3,    120000),     -- 4
('Donald Knuth',      'Engineer',           3,     95000),     -- 5
('Dennis Ritchie',    'Principal Engineer', 2,    150000),     -- 6
('Margaret Hamilton', 'COO',                1,    175000),     -- 7
('Katherine Johnson', 'Ops Lead',           7,    110000),     -- 8
('Radia Perlman',     'Operations',         7,     85000);     -- 9

-- Category tree:
-- Electronics
--  ├── Computers
--  │    ├── Laptops
--  │    └── Desktops
--  └── Audio
--       ├── Headphones
--       └── Speakers
-- Home
--  └── Kitchen
--       ├── Ovens
--       └── Blenders
INSERT INTO category (name, parent_id) VALUES
('Electronics', NULL), -- 1
('Computers',   1),    -- 2
('Laptops',     2),    -- 3
('Desktops',    2),    -- 4
('Audio',       1),    -- 5
('Headphones',  5),    -- 6
('Speakers',    5),    -- 7
('Home',        NULL), -- 8
('Kitchen',     8),    -- 9
('Ovens',       9),    -- 10
('Blenders',    9);    -- 11

INSERT INTO sale (sold_at, amount_cents) VALUES
('2026-01-05', 14999),
('2026-01-12',  9900),
('2026-02-03', 22500),
('2026-02-14', 18000),
('2026-02-28', 12000),
('2026-03-05', 25000),
('2026-03-18',  8000),
('2026-03-29', 30000);