-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathseed.sql
More file actions
55 lines (53 loc) · 4.77 KB
/
seed.sql
File metadata and controls
55 lines (53 loc) · 4.77 KB
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
-- =============================================================
-- Section 1 — Seed data
-- =============================================================
-- 40 people from a mix of countries, genders, and ages. A few
-- have NULL phone numbers or NULL emails so you can see how
-- missing values behave in your queries.
--
-- Load AFTER schema.sql:
-- psql -U postgres -d sql_exercise \
-- -f 02-sql-fundamentals/01-insert-and-query-data/seed.sql
-- =============================================================
SET search_path TO sqlf_insert_query;
INSERT INTO person (id, first_name, last_name, gender, dob, email, phone_number, country_of_origin) VALUES
(1, 'Ahmed', 'Khan', 'M', '1980-01-15', 'ahmed.khan@example.com', NULL, 'Pakistan'),
(2, 'Aisha', 'Ali', 'F', '1991-02-20', 'aisha.ali@example.com', '020-555-0002', 'Egypt'),
(3, 'John', 'Smith', 'M', '1985-03-25', 'john.smith@example.com', '020-555-0003', 'USA'),
(4, 'Fatima', 'Zahra', 'F', '1992-04-30', 'fatima.z@example.com', '020-555-0004', 'Morocco'),
(5, 'Ali', 'Hussein', 'M', '1987-05-05', NULL, NULL, 'Iraq'),
(6, 'Maryam', 'Hassan', 'F', '1994-06-10', 'maryam.h@example.com', '020-555-0006', 'Jordan'),
(7, 'Robert', 'Brown', 'M', '1981-07-15', 'rob.brown@example.com', '020-555-0007', 'UK'),
(8, 'Nadia', 'Kamal', 'F', '1993-08-20', 'nadia.kamal@example.com', '020-555-0008', 'Saudi Arabia'),
(9, 'David', 'Johnson', 'M', '1982-09-25', 'david.j@example.com', NULL, 'USA'),
(10, 'Sara', 'Yusuf', 'F', '1995-10-30', 'sara.yusuf@example.com', '020-555-0010', 'Turkey'),
(11, 'Mohammed', 'Saeed', 'M', '1983-11-15', 'm.saeed@example.com', '020-555-0011', 'UAE'),
(12, 'Layla', 'Omar', 'F', '1996-12-20', 'layla.omar@example.com', '020-555-0012', 'Sudan'),
(13, 'Michael', 'Williams', 'M', '1984-01-10', 'mike.w@example.com', '020-555-0013', 'Canada'),
(14, 'Khadija', 'Ahmed', 'F', '1997-02-15', NULL, NULL, 'Somalia'),
(15, 'Omar', 'Nasir', 'M', '1986-03-20', 'omar.nasir@example.com', '020-555-0015', 'Egypt'),
(16, 'Iman', 'Rahman', 'F', '1998-04-25', 'iman.r@example.com', '020-555-0016', 'Lebanon'),
(17, 'James', 'Taylor', 'M', '1987-05-30', 'james.t@example.com', '020-555-0017', 'Australia'),
(18, 'Zainab', 'Qureshi', 'F', '1999-06-05', 'zainab.q@example.com', '020-555-0018', 'Pakistan'),
(19, 'William', 'Jones', 'M', '1988-07-10', 'will.jones@example.com', NULL, 'USA'),
(20, 'Amina', 'Salim', 'F', '2000-08-15', 'amina.s@example.com', '020-555-0020', 'India'),
(21, 'Isaac', 'Green', 'M', '1989-09-20', 'isaac.green@example.com', '020-555-0021', 'South Africa'),
(22, 'Hana', 'Mahmoud', 'F', '2001-10-25', NULL, '020-555-0022', 'Indonesia'),
(23, 'Abdullah', 'Sheikh', 'M', '1990-11-30', 'abdullah@example.com', '020-555-0023', 'Bangladesh'),
(24, 'Sahar', 'Fahad', 'F', '2002-12-05', 'sahar.fahad@example.com', '020-555-0024', 'Kuwait'),
(25, 'Chris', 'Martinez', 'M', '1991-01-10', 'chris.m@example.com', '020-555-0025', 'Mexico'),
(26, 'Fatma', 'Adel', 'F', '2003-02-15', 'fatma.adel@example.com', '020-555-0026', 'Libya'),
(27, 'Hassan', 'Ibrahim', 'M', '1992-03-20', 'hassan.i@example.com', NULL, 'Algeria'),
(28, 'Noura', 'Yassin', 'F', '2004-04-25', 'noura.y@example.com', '020-555-0028', 'Syria'),
(29, 'Adam', 'Garcia', 'M', '1993-05-30', 'adam.garcia@example.com', '020-555-0029', 'Spain'),
(30, 'Lina', 'Najeeb', 'F', '2005-06-05', 'lina.n@example.com', '020-555-0030', 'Palestine'),
(31, 'Jacob', 'White', 'M', '1994-07-10', 'jacob.white@example.com', '020-555-0031', 'New Zealand'),
(32, 'Maha', 'Halim', 'F', '1996-08-15', 'maha.halim@example.com', '020-555-0032', 'Oman'),
(33, 'Ethan', 'Clark', 'M', '1995-09-20', 'ethan.clark@example.com', NULL, 'USA'),
(34, 'Rania', 'Saleh', 'F', '1988-10-25', 'rania.saleh@example.com', '020-555-0034', 'Tunisia'),
(35, 'Noah', 'Lewis', 'M', '1996-11-30', NULL, '020-555-0035', 'UK'),
(36, 'Salma', 'Othman', 'F', '1990-12-05', 'salma.o@example.com', '020-555-0036', 'Yemen'),
(37, 'Isa', 'Hadi', 'M', '1997-01-10', 'isa.hadi@example.com', '020-555-0037', 'Iraq'),
(38, 'Dina', 'Gamal', 'F', '1989-02-15', 'dina.gamal@example.com', '020-555-0038', 'Egypt'),
(39, 'Jack', 'Walker', 'M', '1998-03-20', 'jack.walker@example.com', '020-555-0039', 'Australia'),
(40, 'Reem', 'Aziz', 'F', '1991-04-25', 'reem.aziz@example.com', '020-555-0040', 'Saudi Arabia');