sql-exercises/02-sql-fundamentals/05-modifying-data/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
33
34
35
36
37
38
39
40
-- =============================================================
-- Section 5 — Seed data
-- =============================================================
-- 30 products across 6 categories with varying price, stock,
-- and active flags — plenty to update, delete, and clean up.
-- =============================================================

SET search_path TO sqlf_modifying;

INSERT INTO product (id, name, category, price, stock, is_active, last_restocked) VALUES
(1,  'Wireless Mouse',         'Electronics',  29.99,  120, TRUE,  '2024-01-15'),
(2,  'Mechanical Keyboard',    'Electronics', 119.00,   45, TRUE,  '2024-02-10'),
(3,  '27" Monitor',            'Electronics', 349.99,   22, TRUE,  '2024-01-22'),
(4,  'USB-C Hub',              'Electronics',  49.50,    0, TRUE,  '2023-11-30'),
(5,  'Webcam HD',              'Electronics',  79.99,   15, FALSE, '2023-09-05'),
(6,  'Running Shoes',          'Footwear',     89.00,   60, TRUE,  '2024-02-01'),
(7,  'Trail Boots',            'Footwear',    149.99,   12, TRUE,  '2024-01-18'),
(8,  'Sandals',                'Footwear',     35.00,   80, TRUE,  '2024-03-02'),
(9,  'Formal Loafers',         'Footwear',    129.00,    4, FALSE, '2023-08-20'),
(10, 'The Pragmatic Programmer','Books',       39.99,   75, TRUE,  '2024-02-25'),
(11, 'Clean Code',             'Books',        34.99,   50, TRUE,  '2024-01-12'),
(12, 'Designing Data-Intensive Applications', 'Books', 44.99, 30, TRUE,  '2024-02-18'),
(13, 'The Mythical Man-Month', 'Books',        25.00,    8, FALSE, '2023-07-14'),
(14, 'Cotton T-Shirt',         'Clothing',     19.99,  200, TRUE,  '2024-03-05'),
(15, 'Denim Jeans',            'Clothing',     59.99,  110, TRUE,  '2024-02-20'),
(16, 'Wool Sweater',           'Clothing',     89.00,   40, TRUE,  '2023-12-15'),
(17, 'Winter Jacket',          'Clothing',    199.99,   18, TRUE,  '2023-11-10'),
(18, 'Swim Shorts',            'Clothing',     24.99,    0, FALSE, '2023-06-30'),
(19, 'Instant Coffee 200g',    'Grocery',       7.49,  500, TRUE,  '2024-03-10'),
(20, 'Dark Chocolate Bar',     'Grocery',       3.99,  300, TRUE,  '2024-03-08'),
(21, 'Olive Oil 1L',           'Grocery',      14.99,  150, TRUE,  '2024-02-28'),
(22, 'Pasta 500g',             'Grocery',       2.49,  400, TRUE,  '2024-03-12'),
(23, 'Rice 2kg',               'Grocery',       6.99,  220, TRUE,  '2024-03-01'),
(24, 'Garden Hose',            'Garden',       39.99,   55, TRUE,  '2024-02-14'),
(25, 'Pruning Shears',         'Garden',       24.99,   90, TRUE,  '2024-01-30'),
(26, 'Wheelbarrow',            'Garden',      109.99,    7, TRUE,  '2023-10-22'),
(27, 'Bag of Compost 40L',     'Garden',       12.49,  180, TRUE,  '2024-03-06'),
(28, 'Lawn Mower',             'Garden',      299.00,    3, FALSE, '2023-08-15'),
(29, 'Broken Lamp (returns)',  'Electronics',   0.00,    0, FALSE, '2023-05-01'),
(30, 'Expired Snack Pack',     'Grocery',       1.99,    0, FALSE, '2023-04-20');