generated from microverseinc/curriculum-template-databases
-
Notifications
You must be signed in to change notification settings - Fork 1
/
data.sql
71 lines (62 loc) · 2.39 KB
/
data.sql
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
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
/* Populate database with sample data. */
INSERT INTO animals
VALUES (0, 'Agumon', '2020-02-03', 0, true, 10.23);
INSERT INTO animals
VALUES (1, 'Gabumon', '2018-11-15', 2, true, 8);
INSERT INTO animals
VALUES (2, 'Pikachu', '2021-01-07', 1, false, 15.04);
INSERT INTO animals
VALUES (3, 'Devimon', '2017-05-12', 5, true, 11);
INSERT INTO animals
VALUES ('Charmander', '2020-02-08', 0, true, -11),
('Plantmon', '2021-11-15', 2, true, -5.7),
('Squirtle', '1993-04-02', 3, fase, -12.13),
('Angemon', '2005-06-12', 1, true, -45),
('Boardmon', '2005-06-07', 7, true, 20.4),
('Blossom', '1998-10-13', 3, true, 17),
('Ditto', '2022-05-14', 4, true, 22);
INSERT INTO owners(full_name, age)
VALUES ('Sam Smith',34),
('Jennifer Orwell', 19),
('Bob', 45),
('Melody Pond', 77),
('Dean Winchester', 14),
('Jodie Whittaker', 38);
INSERT INTO species(name)
values ('Pokemon'),
('Digimon');
UPDATE animals SET species_id = 2 WHERE name ~ 'mon$';
UPDATE animals SET species_id = 1 WHERE species_id IS NULL;
UPDATE animals SET owner_id =(SELECT id FROM owners WHERE full_name = 'Sam Smith') WHERE name = 'Agumon';
UPDATE animals SET owner_id =(SELECT id FROM owners WHERE full_name = 'Jennifer Orwell') WHERE name = 'Pikachu' OR name = 'Gabumon';
UPDATE animals SET owner_id =(SELECT id FROM owners WHERE full_name = 'Bob') WHERE name = 'Devimon' OR name = 'Plantmon';
UPDATE animals SET owner_id =(SELECT id FROM owners WHERE full_name = 'Melody Pond') WHERE name = 'Squirtle' OR name = 'Charmander' OR name = 'Blossom';
UPDATE animals SET owner_id =(SELECT id FROM owners WHERE full_name = 'Dean Winchester') WHERE name = 'Angemon' OR name = 'Boarmon';
INSERT INTO vets (name, age, date_of_graduation)
values ('William Tatcher', 45, 'Apr 23rd, 2000'),
('Maisy Smith', 26, 'Jan 17, 2019'),
('Stephanie Mendez', 64, 'May 4, 1981'),
('Jack Harkness', 38, 'Jun 8, 2008');
INSERT INTO specializations
VALUES (1, 1), (3, 2), (3, 1),(4, 2);
INSERT INTO visits
VALUES (1, 1, 'May 24, 2020'),
(3, 1, 'Jul 22, 2020'),
(2, 4, 'Feb 2, 2021'),
(2, 2, 'Jan 5, 2020'),
(2, 3, 'Mar 8, 2020'),
(2, 3, 'May 14, 2020'),
(3, 4, 'May 4, 2021'),
(4, 5, 'Feb 24, 2021'),
(2, 6,'Dec 21, 2019'),
(1, 6, 'Aug 10, 2020'),
(2, 6, 'Apr 7, 2021'),
(3, 7, 'Sep 29, 2019'),
(4, 8, 'Oct 3, 2020'),
(4, 8, 'Nov 4, 2020'),
(2, 9, 'Jan 24, 2019'),
(2, 9, 'May 15, 2019'),
(2, 9, 'Feb 27, 2020'),
(2, 9, 'Aug 3, 2020'),
(3, 10, 'May 24, 2020'),
(1, 10, 'Jan 11, 2021');