sql-exercises/02-sql-fundamentals/04-mathematical-operators-and-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
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
-- =============================================================
-- Section 4 — Seed data
-- =============================================================
-- Same 40-car dataset as section 11 (trimmed slightly).
-- =============================================================

SET search_path TO sqlf_math;

INSERT INTO cars (id, brand, model, price, mileage, is_electric) VALUES
(1,  'Tesla',        'Model S',        79999.99, 15000, TRUE),
(2,  'Tesla',        'Model 3',        49999.99, 20000, TRUE),
(3,  'Tesla',        'Model X',        89999.99, 12000, TRUE),
(4,  'Tesla',        'Model Y',        59999.99, 18000, TRUE),
(5,  'Lamborghini',  'Huracan',       250000.00,  5000, FALSE),
(6,  'Lamborghini',  'Aventador',     350000.00,  3000, FALSE),
(7,  'Lamborghini',  'Urus',          200000.00, 10000, FALSE),
(8,  'Ferrari',      '488 GTB',       280000.00,  8000, FALSE),
(9,  'Ferrari',      'Roma',          220000.00,  6000, FALSE),
(10, 'Ferrari',      'F8 Tributo',    300000.00,  4000, FALSE),
(11, 'Rivian',       'R1T',            75000.00,  5000, TRUE),
(12, 'Rivian',       'R1S',            77000.00,  7000, TRUE),
(13, 'BYD',          'Tang',           45000.00, 25000, TRUE),
(14, 'BYD',          'Han',            40000.00, 23000, TRUE),
(15, 'BMW',          'i3',             45000.00, 20000, TRUE),
(16, 'BMW',          'i8',            140000.00, 15000, TRUE),
(17, 'BMW',          'X5',             60000.00, 20000, FALSE),
(18, 'BMW',          '3 Series',       50000.00, 15000, FALSE),
(19, 'Audi',         'A4',             45000.00, 18000, FALSE),
(20, 'Audi',         'Q5',             55000.00, 15000, FALSE),
(21, 'Audi',         'e-tron',         70000.00, 10000, TRUE),
(22, 'Mercedes-Benz','C-Class',        50000.00, 12000, FALSE),
(23, 'Mercedes-Benz','E-Class',        60000.00, 11000, FALSE),
(24, 'Mercedes-Benz','EQC',            80000.00,  8000, TRUE),
(25, 'Toyota',       'Camry',          30000.00, 18000, FALSE),
(26, 'Toyota',       'Corolla',        25000.00, 20000, FALSE),
(27, 'Toyota',       'Prius',          27000.00, 15000, TRUE),
(28, 'Honda',        'Civic',          22000.00, 17000, FALSE),
(29, 'Honda',        'Accord',         28000.00, 14000, FALSE),
(30, 'Ford',         'Mustang',        40000.00, 16000, FALSE),
(31, 'Ford',         'F-150',          50000.00, 20000, FALSE),
(32, 'Ford',         'Mach-E',         45000.00, 10000, TRUE),
(33, 'Nissan',       'Leaf',           30000.00, 12000, TRUE),
(34, 'Hyundai',      'Kona Electric',  35000.00, 13000, TRUE),
(35, 'Kia',          'Soul EV',        37000.00, 14000, TRUE),
(36, 'Jaguar',       'I-Pace',         80000.00, 12000, TRUE),
(37, 'Porsche',      '911',           100000.00, 10000, FALSE),
(38, 'Porsche',      'Taycan',        150000.00,  9000, TRUE),
(39, 'Volvo',        'XC60',           55000.00, 13000, FALSE),
(40, 'Mini',         'Cooper SE',      30000.00, 13000, TRUE);