· 4 years ago · Jun 04, 2021, 04:12 AM
1CREATE TABLE IF NOT EXISTS person (
2 "id" TEXT,
3 "first_name" TEXT,
4 "birth_date" DATE,
5 "gender" TEXT,
6 "favorite_color" TEXT,
7 "study_group" INT
8)
9
10INSERT INTO "person" VALUES
11 ('person-1','David Tanner','1988-06-03','Male','blue',1),
12 ('person-2','Luis Stokes','1986-07-07','Male','red',2),
13 ('person-3','Kelly Gregory','2002-08-16','Female','orange',3),
14 ('person-4','Ernest Garrett','1981-05-24','Male','blue',4),
15 ('person-5','Linda Thompson','2011-12-29','Female','green',1),
16 ('person-6','Patrick Henderson','1984-08-07','Female','orange',2),
17 ('person-7','Christopher Dean','2010-10-26','Female','orange',3),
18 ('person-8','Trevor Johnson','2020-04-14','Female','green',4),
19 ('person-9','Kristen Rogers','2005-05-01','Female','green',5),
20 ('person-10','Mark West','2019-06-19','Male','red',1),
21 ('person-11','Jessica Young','2016-02-18','Male','blue',2),
22 ('person-12','Amy Shepherd','1980-09-26','Female','green',3),
23 ('person-13','Jamie Thomas','1979-07-08','Female','green',4),
24 ('person-14','Jose Rodriguez','1977-11-25','Female','green',5),
25 ('person-15','Jeremy Mckenzie','1991-05-24','Male','red',1),
26 ('person-16','Brittany Haynes','2000-12-08','Male','red',2),
27 ('person-17','Dillon Hodge','2012-07-21','Female','green',3),
28 ('person-18','Leslie Raymond','2017-01-06','Male','blue',4),
29 ('person-19','Stacy Williams','2011-10-01','Male','red',5),
30 ('person-20','Robin Tran','2018-06-23','Male','red',1),
31 ('person-21','Ryan Black','2010-10-04','Female','green',2),
32 ('person-22','Christopher Lee','1982-01-13','Male','blue',3),
33 ('person-23','Molly Bryant','1974-11-20','Female','orange',4),
34 ('person-24','David Rodriguez','1970-08-31','Male','red',5),
35 ('person-25','Elizabeth Forbes','2020-07-11','Female','orange',1),
36 ('person-26','Erika Roberts','1998-10-08','Female','green',2),
37 ('person-27','Logan Cross','1999-12-22','Male','blue',3),
38 ('person-28','Dylan Carter','1983-06-05','Male','blue',4),
39 ('person-29','Carrie Henderson','2008-06-17','Female','green',5),
40 ('person-30','Christine Henry','1980-11-18','Male','blue',1),
41 ('person-31','Todd Torres','2020-08-05','Female','green',2),
42 ('person-32','Cheryl Munoz','2012-05-25','Male','blue',3),
43 ('person-33','Tina Martinez','2020-02-01','Male','red',4),
44 ('person-34','Paul Adkins','1992-10-20','Female','orange',5),
45 ('person-35','Dana Grant','2007-01-22','Male','red',1),
46 ('person-36','Travis Jacobs','1978-09-28','Female','orange',2),
47 ('person-37','Paul Patel','1972-02-07','Female','green',3),
48 ('person-38','Stephanie Cruz','2007-10-12','Male','blue',4),
49 ('person-39','Stephanie Hampton','1989-05-31','Male','red',5),
50 ('person-40','Theresa Castro','1992-11-15','Male','red',1),
51 ('person-41','Michael Sanchez','1980-05-27','Female','green',2),
52 ('person-42','Diane Santos','1987-09-15','Male','red',3),
53 ('person-43','Derek Carter','2012-12-02','Male','red',4),
54 ('person-44','Joanna Hudson','2004-09-27','Male','blue',5),
55 ('person-45','Gary Deleon','2000-06-30','Female','orange',1),
56 ('person-46','Mr. William Peterson MD','2020-06-21','Female','orange',2),
57 ('person-47','David Smith','2009-11-16','Male','red',3),
58 ('person-48','Austin King','2001-05-30','Female','green',4),
59 ('person-49','Brian Russo','1999-05-11','Male','red',5),
60 ('person-50','Carlos Reese','1976-07-09','Male','blue',1),
61 ('person-51','Michele Morris','1985-12-20','Female','orange',2),
62 ('person-52','Nicole Jimenez','1975-02-22','Female','green',3),
63 ('person-53','Charles Brown','1973-07-30','Female','green',4),
64 ('person-54','Sydney Dudley','1999-05-04','Female','orange',5),
65 ('person-55','Brandon Edwards','1995-05-30','Female','green',1),
66 ('person-56','Richard Stephens','2013-10-14','Female','orange',2),
67 ('person-57','Marilyn Forbes','1984-01-26','Male','red',3),
68 ('person-58','Hannah Horton','1995-11-22','Female','green',4),
69 ('person-59','Mark Hanna MD','1979-11-19','Female','orange',5),
70 ('person-60','Justin Brown','1999-12-25','Female','green',1),
71 ('person-61','Charles Jackson','1970-02-18','Male','red',2),
72 ('person-62','Sara Sims','2014-08-17','Female','orange',3),
73 ('person-63','Jacqueline Rodriguez','2005-01-25','Female','green',4),
74 ('person-64','Ashley Newton','1998-10-09','Male','red',5),
75 ('person-65','Taylor Howard','1977-06-23','Male','red',1),
76 ('person-66','James Clark','2003-07-17','Male','red',2),
77 ('person-67','Ruth Morris','1985-02-24','Female','orange',3),
78 ('person-68','Sandra Tucker','1970-01-05','Female','green',4),
79 ('person-69','Beth Watson','2000-01-03','Male','blue',5),
80 ('person-70','Todd Hicks','1988-11-17','Male','blue',1),
81 ('person-71','Jorge Webb','2015-03-12','Male','red',2),
82 ('person-72','Robert Burke','1981-09-29','Male','red',3),
83 ('person-73','Ashley Dominguez','1980-03-27','Female','green',4),
84 ('person-74','Jacob Boyd','2009-04-23','Male','blue',5),
85 ('person-75','Nichole Haney','2017-09-12','Female','orange',1),
86 ('person-76','Timothy Webb','1990-05-08','Female','orange',2),
87 ('person-77','Paul Dillon','1971-01-02','Male','blue',3),
88 ('person-78','Jessica Mcintosh','2003-08-29','Male','blue',4),
89 ('person-79','Faith Cross','1988-07-08','Male','red',5),
90 ('person-80','Kelly Smith','2007-08-06','Female','green',1),
91 ('person-81','Samantha Miller','2010-04-04','Female','green',2),
92 ('person-82','Gregory Smith','1997-10-28','Male','red',3),
93 ('person-83','Alexandria Edwards','1997-01-27','Male','blue',4),
94 ('person-84','Sara Warren','2019-02-26','Male','blue',5),
95 ('person-85','Suzanne Ortiz','1983-11-23','Female','green',1),
96 ('person-86','Erin Meadows','1970-02-17','Male','red',2),
97 ('person-87','Kelly Kim','1973-07-18','Male','blue',3),
98 ('person-88','Elizabeth Good','2007-09-02','Female','orange',4),
99 ('person-89','Jesse Lee','2007-08-12','Male','red',5),
100 ('person-90','Melanie Meyer','1998-10-26','Male','blue',1),
101 ('person-91','Aaron Fleming','1983-04-21','Male','red',2),
102 ('person-92','Todd Mcmillan','1982-05-27','Female','orange',3),
103 ('person-93','Stephanie Wells','1989-12-16','Male','blue',4),
104 ('person-94','John Rangel','2005-03-04','Female','green',5),
105 ('person-95','Jennifer Mendez','2018-11-24','Male','red',1),
106 ('person-96','Brandon Smith','1973-12-17','Female','green',2),
107 ('person-97','Paul Swanson','1988-04-13','Female','green',3),
108 ('person-98','Benjamin Dunn','1981-09-19','Female','orange',4),
109 ('person-99','Tonya Stewart','2009-01-09','Male','red',5),
110 ('person-100','Victoria Krause','1982-12-07','Male','blue',1),
111 ('person-101','Samantha Webster','1996-08-05','Female','orange',2),
112 ('person-102','Adam Myers','2007-04-27','Female','green',3),
113 ('person-103','Johnny Miller','2019-06-10','Female','orange',4),
114 ('person-104','Joshua Blevins','2001-01-15','Male','red',5),
115 ('person-105','John Tanner','1997-09-03','Female','green',1),
116 ('person-106','Alexandra Fuller','1998-09-10','Male','red',2),
117 ('person-107','Anthony Rodriguez','1986-05-31','Female','orange',3),
118 ('person-108','Brian Gray','1977-07-11','Female','green',4),
119 ('person-109','Justin May','2018-07-21','Male','blue',5),
120 ('person-110','Shane Wilson','2020-02-25','Female','orange',1),
121 ('person-111','David Daniels','2000-02-27','Female','green',2),
122 ('person-112','Veronica Robinson','1990-07-19','Female','green',3),
123 ('person-113','Joseph Nelson','2017-11-26','Female','orange',4),
124 ('person-114','Angela Ortega','1993-06-24','Male','blue',5),
125 ('person-115','Sherri Foster','1976-03-18','Female','green',1),
126 ('person-116','Jacob Lee','1992-03-06','Female','orange',2),
127 ('person-117','Deanna Gaines','1979-01-17','Female','orange',3),
128 ('person-118','Heather Sanchez','1989-09-01','Female','green',4),
129 ('person-119','Lindsey Garza','1980-07-02','Female','orange',5),
130 ('person-120','Kenneth Chapman','2011-08-16','Female','green',1),
131 ('person-121','Dennis Williamson','2019-02-01','Male','red',2),
132 ('person-122','Alicia King','2019-09-12','Female','green',3),
133 ('person-123','James Boyd','1981-02-14','Male','red',4),
134 ('person-124','Denise Bowman','1979-04-30','Female','green',5),
135 ('person-125','Isaac Kelly','1989-09-07','Male','blue',1),
136 ('person-126','Thomas Acosta','2001-08-13','Female','green',2),
137 ('person-127','Janet Ruiz','1989-11-08','Male','blue',3),
138 ('person-128','Haley Anderson','1984-04-27','Male','blue',4),
139 ('person-129','Deanna Walker','2014-01-30','Male','blue',5),
140 ('person-130','Heather Park','2004-07-19','Female','green',1),
141 ('person-131','Derrick Smith','1981-10-04','Male','blue',2),
142 ('person-132','Laura Johnson','1998-10-06','Female','green',3),
143 ('person-133','Laura Jones','2011-08-28','Male','red',4),
144 ('person-134','Rebecca Farmer','1984-04-15','Male','blue',5),
145 ('person-135','Lindsey Pearson','1983-08-03','Female','orange',1),
146 ('person-136','Kristy Martinez','2003-06-08','Male','blue',2),
147 ('person-137','Jerry Moore','1997-12-08','Male','red',3),
148 ('person-138','Kylie Garcia','1971-10-30','Female','orange',4),
149 ('person-139','Anthony Edwards','1990-10-06','Male','blue',5),
150 ('person-140','Stacey Beck','2015-08-19','Male','blue',1),
151 ('person-141','Gary Mclaughlin','2016-01-08','Male','red',2),
152 ('person-142','Alexis Roberts','2011-07-25','Male','red',3),
153 ('person-143','Alicia Martinez PhD','1982-12-11','Male','red',4),
154 ('person-144','Nicole Miller','2009-06-18','Male','red',5),
155 ('person-145','Mark Holmes','2011-02-14','Male','red',1),
156 ('person-146','Brian Woodard','1980-03-10','Male','blue',2),
157 ('person-147','Rebecca Johnson','2009-12-08','Male','blue',3),
158 ('person-148','Sharon Smith DVM','2020-07-30','Male','red',4),
159 ('person-149','Stephanie Robinson','1978-05-15','Female','orange',5),
160 ('person-150','Ricardo Perry','1972-05-08','Male','red',1),
161 ('person-151','Bobby Daniels','2001-05-07','Male','red',2),
162 ('person-152','Jimmy Sanchez','2005-05-05','Female','green',3),
163 ('person-153','Alyssa Tran','2021-04-25','Female','green',4),
164 ('person-154','Gary Banks','1977-12-29','Female','green',5),
165 ('person-155','Sharon Garrison','2020-11-21','Male','blue',1),
166 ('person-156','Mary Simpson DDS','1997-02-02','Female','orange',2),
167 ('person-157','Daniel Pope','1986-06-08','Female','orange',3),
168 ('person-158','Angela Baker','2007-12-08','Male','blue',4),
169 ('person-159','Ashley Cook','2002-10-01','Male','blue',5),
170 ('person-160','Benjamin Wright','1971-04-23','Male','red',1),
171 ('person-161','Leslie King','2007-11-13','Male','red',2),
172 ('person-162','Frank Graham','2021-02-27','Female','orange',3),
173 ('person-163','William Ramirez DVM','2011-02-25','Female','orange',4),
174 ('person-164','Jason Jensen','1988-04-22','Female','orange',5),
175 ('person-165','Brittany Wright','2007-04-18','Male','red',1),
176 ('person-166','Gregory Koch','2021-05-12','Male','red',2),
177 ('person-167','Hector Ingram','1982-08-28','Male','blue',3),
178 ('person-168','Nathan Rogers','2006-03-17','Male','blue',4),
179 ('person-169','Gregory White','2011-07-11','Female','orange',5),
180 ('person-170','George Jimenez','1976-01-11','Female','green',1),
181 ('person-171','Tiffany Carr','1996-03-19','Female','green',2),
182 ('person-172','William Moore','1976-06-30','Female','green',3),
183 ('person-173','David Stevens','2016-06-10','Female','orange',4),
184 ('person-174','Christina Hunter','1971-08-30','Female','orange',5),
185 ('person-175','Melanie Ross','1996-04-11','Male','blue',1),
186 ('person-176','Michael Johnson','1996-08-05','Female','green',2),
187 ('person-177','Thomas Cruz MD','2013-07-24','Male','blue',3),
188 ('person-178','William Phillips','2008-02-25','Female','green',4),
189 ('person-179','Jimmy Simpson','1975-05-10','Female','orange',5),
190 ('person-180','Melinda Roberts','1985-08-22','Male','blue',1),
191 ('person-181','Angela Munoz','2006-11-04','Male','blue',2),
192 ('person-182','Alexandra Brewer','2016-05-27','Female','green',3),
193 ('person-183','Alec Sullivan','1995-07-15','Male','red',4),
194 ('person-184','Alisha Harris','1986-09-30','Male','blue',5),
195 ('person-185','Amber Patterson','1987-06-03','Male','red',1),
196 ('person-186','Sheri Smith','2007-11-20','Male','red',2),
197 ('person-187','Alan Mcclain','1986-02-24','Female','green',3),
198 ('person-188','Kristen Ortiz','1989-03-04','Female','orange',4),
199 ('person-189','Christopher Salazar','2014-03-23','Female','green',5),
200 ('person-190','Robin Tran','1995-05-31','Female','green',1),
201 ('person-191','Dale Avila','2016-08-29','Male','blue',2),
202 ('person-192','Wendy Stewart MD','1988-01-13','Male','red',3),
203 ('person-193','Jeff Berry','1989-11-22','Female','green',4),
204 ('person-194','Amanda Gallagher','1971-05-08','Male','red',5),
205 ('person-195','Justin Simpson','2015-07-18','Female','green',1),
206 ('person-196','Erin Vaughn','2005-10-26','Female','green',2),
207 ('person-197','Miss Julie Martinez','2000-08-16','Female','orange',3),
208 ('person-198','Natasha Li','1992-08-20','Male','blue',4),
209 ('person-199','Zachary Foster','2008-10-09','Male','blue',5),
210 ('person-200','Stephen Calhoun','1996-12-19','Male','blue',1),
211 ('person-201','Alicia White','1980-10-07','Male','red',2),
212 ('person-202','Sarah Ward','2004-10-27','Female','green',3),
213 ('person-203','Dawn King','1992-08-28','Female','orange',4),
214 ('person-204','Bridget Salinas','2015-03-09','Male','blue',5),
215 ('person-205','Shawn Sherman','2014-01-23','Female','green',1),
216 ('person-206','Willie Caldwell','2004-01-03','Female','orange',2),
217 ('person-207','Debra Barajas','1976-01-03','Male','blue',3),
218 ('person-208','Brittany Jones','2010-06-01','Female','green',4),
219 ('person-209','Frank Lee','1993-02-25','Male','red',5),
220 ('person-210','Amber Holmes','2005-09-14','Male','blue',1),
221 ('person-211','Brenda King','1997-09-21','Male','red',2),
222 ('person-212','Melody Cannon','2021-02-21','Female','orange',3),
223 ('person-213','Logan Phillips','1977-10-23','Female','green',4),
224 ('person-214','Kenneth Perez','1985-09-15','Male','red',5),
225 ('person-215','Christina Leon','2015-10-21','Female','green',1),
226 ('person-216','Joseph Bray','1971-02-18','Male','blue',2),
227 ('person-217','Mr. Christopher Montgomery','2009-07-06','Male','red',3),
228 ('person-218','Susan Blackwell','1981-04-21','Female','orange',4),
229 ('person-219','Shelly Hammond','1973-11-10','Female','green',5),
230 ('person-220','Ralph Walton','1974-06-16','Female','green',1),
231 ('person-221','Latoya Contreras','1998-01-24','Male','red',2),
232 ('person-222','Denise Kirby','1987-04-16','Female','green',3),
233 ('person-223','Carlos Manning Jr.','1993-07-03','Male','red',4),
234 ('person-224','Robert Jones','1999-10-12','Male','blue',5),
235 ('person-225','Chad Brown','2016-11-11','Female','green',1),
236 ('person-226','Katherine Smith','1977-09-10','Female','orange',2),
237 ('person-227','Eric Garcia','1982-07-07','Female','green',3),
238 ('person-228','Robert Espinoza','1981-04-02','Female','orange',4),
239 ('person-229','Christina Burch','2006-02-17','Male','blue',5),
240 ('person-230','Sarah Powell','1978-11-19','Female','orange',1),
241 ('person-231','Breanna Lewis','1999-11-17','Male','blue',2),
242 ('person-232','Dwayne Logan','2020-10-10','Male','red',3),
243 ('person-233','Adam Brown','2009-03-18','Female','orange',4),
244 ('person-234','Cheryl Young','2016-09-11','Female','orange',5),
245 ('person-235','Monica Moore','2017-11-15','Female','green',1),
246 ('person-236','Willie Dunn','2007-01-12','Male','blue',2),
247 ('person-237','William Mclaughlin','1992-01-07','Female','orange',3),
248 ('person-238','Andrew Harrell','2006-06-29','Female','orange',4),
249 ('person-239','Lisa Finley','2021-03-08','Male','blue',5),
250 ('person-240','Brandon Mendoza','2007-07-17','Female','green',1),
251 ('person-241','Kristopher Silva','2003-12-05','Female','orange',2),
252 ('person-242','Ashlee Mcclain','2007-10-16','Female','green',3),
253 ('person-243','Heather Aguirre','2000-10-19','Male','red',4),
254 ('person-244','Sheila Moore','1992-06-26','Female','orange',5),
255 ('person-245','Michael Vargas','1979-07-11','Female','orange',1),
256 ('person-246','Greg Martinez','2014-03-12','Male','red',2),
257 ('person-247','Terry Mueller','1973-10-19','Male','red',3),
258 ('person-248','Linda Morton DVM','2007-08-21','Male','blue',4),
259 ('person-249','Shelly Fleming','1999-09-30','Male','red',5),
260 ('person-250','Manuel Andersen','1982-04-28','Female','green',1)