quizresults.sql

CREATE TABLE `states` (
 `state_name` TEXT,
 `state_abbrev` TEXT,
 `region` TEXT,
 `division` TEXT 
);
INSERT INTO `states` (state_name,state_abbrev,region,division) VALUES ('Alabama','AL','South','East South Central');
INSERT INTO `states` (state_name,state_abbrev,region,division) VALUES ('Alaska','AK','West','Pacific');
INSERT INTO `states` (state_name,state_abbrev,region,division) VALUES ('Arizona','AZ','West','Mountain');
INSERT INTO `states` (state_name,state_abbrev,region,division) VALUES ('Arkansas','AR','South','West South Central');
INSERT INTO `states` (state_name,state_abbrev,region,division) VALUES ('California','CA','West','Pacific');
INSERT INTO `states` (state_name,state_abbrev,region,division) VALUES ('Colorado','CO','West','Mountain');
INSERT INTO `states` (state_name,state_abbrev,region,division) VALUES ('Connecticut','CT','Northeast','New England');
INSERT INTO `states` (state_name,state_abbrev,region,division) VALUES ('Delaware','DE','South','South Atlantic');
INSERT INTO `states` (state_name,state_abbrev,region,division) VALUES ('Florida','FL','South','South Atlantic');
INSERT INTO `states` (state_name,state_abbrev,region,division) VALUES ('Georgia','GA','South','South Atlantic');
INSERT INTO `states` (state_name,state_abbrev,region,division) VALUES ('Hawaii','HI','West','Pacific');
INSERT INTO `states` (state_name,state_abbrev,region,division) VALUES ('Idaho','ID','West','Mountain');
INSERT INTO `states` (state_name,state_abbrev,region,division) VALUES ('Illinois','IL','Northeast','East North Central');
INSERT INTO `states` (state_name,state_abbrev,region,division) VALUES ('Indiana','IN','Northeast','East North Central');
INSERT INTO `states` (state_name,state_abbrev,region,division) VALUES ('Iowa','IA','Midwest','West North Central');
INSERT INTO `states` (state_name,state_abbrev,region,division) VALUES ('Kansas','KS','Midwest','West North Central');
INSERT INTO `states` (state_name,state_abbrev,region,division) VALUES ('Kentucky','KY','South','East South Central');
INSERT INTO `states` (state_name,state_abbrev,region,division) VALUES ('Louisiana','LA','South','West South Central');
INSERT INTO `states` (state_name,state_abbrev,region,division) VALUES ('Maine','ME','Northeast','New England');
INSERT INTO `states` (state_name,state_abbrev,region,division) VALUES ('Maryland','MD','South','South Atlantic');
INSERT INTO `states` (state_name,state_abbrev,region,division) VALUES ('Massachusetts','MA','Northeast','New England');
INSERT INTO `states` (state_name,state_abbrev,region,division) VALUES ('Michigan','MI','Midwest','East North Central');
INSERT INTO `states` (state_name,state_abbrev,region,division) VALUES ('Minnesota','MN','Midwest','West North Central');
INSERT INTO `states` (state_name,state_abbrev,region,division) VALUES ('Mississippi','MS','South','East South Central');
INSERT INTO `states` (state_name,state_abbrev,region,division) VALUES ('Missouri','MO','Midwest','West North Central');
INSERT INTO `states` (state_name,state_abbrev,region,division) VALUES ('Montana','MT','West','Mountain');
INSERT INTO `states` (state_name,state_abbrev,region,division) VALUES ('Nebraska','NE','Midwest','West North Central');
INSERT INTO `states` (state_name,state_abbrev,region,division) VALUES ('Nevada','NV','West','Mountain');
INSERT INTO `states` (state_name,state_abbrev,region,division) VALUES ('New Hampshire','NH','Northeast','New England');
INSERT INTO `states` (state_name,state_abbrev,region,division) VALUES ('New Jersey','NJ','Northeast','Middle Atlantic');
INSERT INTO `states` (state_name,state_abbrev,region,division) VALUES ('New Mexico','NM','West','Mountain');
INSERT INTO `states` (state_name,state_abbrev,region,division) VALUES ('New York','NY','Northeast','Middle Atlantic');
INSERT INTO `states` (state_name,state_abbrev,region,division) VALUES ('North Carolina','NC','South','South Atlantic');
INSERT INTO `states` (state_name,state_abbrev,region,division) VALUES ('North Dakota','ND','Midwest','West North Central');
INSERT INTO `states` (state_name,state_abbrev,region,division) VALUES ('Ohio','OH','Midwest','East North Central');
INSERT INTO `states` (state_name,state_abbrev,region,division) VALUES ('Oklahoma','OK','South','West South Central');
INSERT INTO `states` (state_name,state_abbrev,region,division) VALUES ('Oregon','OR','West','Pacific');
INSERT INTO `states` (state_name,state_abbrev,region,division) VALUES ('Pennsylvania','PA','Northeast','Middle Atlantic');
INSERT INTO `states` (state_name,state_abbrev,region,division) VALUES ('Rhode Island','RI','Northeast','New England');
INSERT INTO `states` (state_name,state_abbrev,region,division) VALUES ('South Carolina','SC','South','South Atlantic');
INSERT INTO `states` (state_name,state_abbrev,region,division) VALUES ('South Dakota','SD','Midwest','West North Central');
INSERT INTO `states` (state_name,state_abbrev,region,division) VALUES ('Tennessee','TN','South','East South Central');
INSERT INTO `states` (state_name,state_abbrev,region,division) VALUES ('Texas','TX','South','West South Central');
INSERT INTO `states` (state_name,state_abbrev,region,division) VALUES ('Utah','UT','West','Mountain');
INSERT INTO `states` (state_name,state_abbrev,region,division) VALUES ('Vermont','VT','Northeast','New England');
INSERT INTO `states` (state_name,state_abbrev,region,division) VALUES ('Virginia','VA','South','South Atlantic');
INSERT INTO `states` (state_name,state_abbrev,region,division) VALUES ('Washington','WA','West','Pacific');
INSERT INTO `states` (state_name,state_abbrev,region,division) VALUES ('West Virginia','WV','South','South Atlantic');
INSERT INTO `states` (state_name,state_abbrev,region,division) VALUES ('Wisconsin','WI','Midwest','East North Central');
INSERT INTO `states` (state_name,state_abbrev,region,division) VALUES ('Wyoming','WY','West','Mountain');
CREATE TABLE `people` (
 `first_name` TEXT,
 `last_name` TEXT,
 `city` TEXT,
 `state` TEXT,
 `shirt_or_hat` TEXT,
 `quiz_points` NUMERIC,
 `team` TEXT,
 `signup` TEXT,
 `id_number` INTEGER,
 `company` TEXT
);
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Janice','Howell','Los Angeles','CA','hat',100,'red','2015-02-07','9500','Homenick Group');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Wanda','Alvarez','Riverside','CA','shirt',20,'blue','2016-06-06','9501','Nicolas Inc');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Laura','Olson','San Mateo','CA','shirt',90,'green','2014-06-17','9502','Hoeger-O''Keefe');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Jack','Garcia','Hicksville','NY','shirt',90,'red','2015-09-05','9503','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Ryan','Rice','Wilmington','DE','shirt',70,'blue','2014-06-16','9504','Carter-VonRueden');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Christine','Wood','Grand Rapids','MI','shirt',50,'green','2015-06-12','9505','Zboncak-Leannon');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Dennis','Banks','New York City','NY','hat',20,'red','2016-02-19','9506','Ullrich, Schroeder and Rempel');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Paula','Montgomery','Mobile','AL','shirt',90,'blue','2015-10-17','9507','Krajcik-Koss');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Jerry','Ferguson','Carol Stream','IL','shirt',80,'green','2014-11-02','9508','Tromp, Schuppe and Jacobs');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Donald','Black','Pensacola','FL','shirt',50,'red','2016-10-12','9509','Cartwright LLC');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Gerald','Johnston','Dallas','TX','shirt',70,'blue','2016-04-24','9510','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Bonnie','Brooks','Bridgeport','CT','hat',90,'green','2015-05-15','9511','Terry-Weber');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Rose','Armstrong','Anchorage','AK','shirt',20,'red','2015-11-17','9512','Bashirian Inc');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Patrick','Johnson','Boise','ID','hat',80,'blue','2015-03-21','9513','Boehm, Grant and Kuphal');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Linda','Mitchell','Burbank','CA','shirt',70,'green','2014-07-23','9514','Steuber LLC');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Brian','George','Lake Worth','FL','hat',70,'red','2014-03-10','9515','Stehr, Windler and MacGyver');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Jonathan','Ryan','Alexandria','LA','hat',10,'blue','2016-04-13','9516','Davis, Stark and Spencer');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Paul','Williamson','Apache Junction','AZ','hat',40,'green','2014-12-08','9517','Rohan and Sons');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Robin','Hayes','Salinas','CA','shirt',10,'red','2013-12-14','9518','Cole, Cronin and Ruecker');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('James','Graham','Ogden','UT','shirt',70,'blue','2016-10-14','9519','Bosco Inc');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Robert','Hart','Everett','WA','shirt',90,'green','2014-08-19','9520','Gulgowski and Sons');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Joe','Thompson','Peoria','IL','shirt',100,'red','2016-07-02','9521','Yundt Group');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Michelle','Montgomery','Salinas','CA','hat',70,'blue','2016-06-01','9522','Treutel-Luettgen');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Randy','Oliver','Dallas','TX','hat',20,'green','2014-04-25','9523','Rice Group');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Earl','Snyder','Birmingham','AL','hat',100,'red','2016-09-08','9524','Mills and Sons');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Helen','Berry','New Haven','CT','shirt',70,'blue','2014-11-06','9525','Gerhold-Runte');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Christina','Evans','Phoenix','AZ','shirt',80,'green','2016-06-07','9526','Hagenes and Sons');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Scott','Thompson','Des Moines','IA','hat',90,'red','2015-11-29','9527','Lang, Spinka and Herman');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Gerald','Montgomery','Albuquerque','NM','shirt',20,'blue','2014-08-27','9528','Zulauf-Kozey');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Nicole','Willis','Fargo','ND','hat',100,'green','2015-12-04','9529','Simonis LLC');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('John','Howard','Albany','NY','hat',90,'red','2013-11-28','9530','Denesik Inc');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Donna','Daniels','Port Charlotte','FL','hat',100,'blue','2015-08-22','9531','Ziemann and Sons');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Michelle','Nelson','Springfield','MA','hat',90,'green','2015-07-31','9532','Schowalter, Bogan and Franecki');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Gary','Peters','Carson City','NV','shirt',80,'red','2016-07-18','9533','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Donald','Ellis','El Paso','TX','hat',30,'blue','2014-07-11','9534','Hickle and Sons');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Sharon','Brown','Portland','OR','hat',100,'green','2014-07-29','9535','Sipes, Adams and Steuber');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Margaret','Hamilton','Detroit','MI','hat',20,'red','2016-06-22','9536','Dickinson, Lakin and Waters');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Richard','Fox','Baton Rouge','LA','hat',30,'blue','2014-04-17','9537','Jaskolski and Sons');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Linda','Foster','Austin','TX','shirt',90,'green','2016-08-28','9538','Collins and Sons');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Janet','Rodriguez','Stockton','CA','hat',20,'red','2015-01-11','9539','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Jacqueline','Morales','Fairfax','VA','shirt',30,'blue','2016-01-08','9540','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Barbara','Ortiz','Los Angeles','CA','shirt',100,'green','2015-08-16','9541','Smitham, Kertzmann and Leffler');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Tina','Greene','Seattle','WA','hat',80,'red','2014-05-29','9542','Becker, Davis and Moen');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Roy','Lopez','San Francisco','CA','hat',10,'blue','2015-08-12','9543','Schneider and Sons');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('David','Ford','Fort Wayne','IN','shirt',40,'green','2015-01-19','9544','Howe, Reinger and Ondricka');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Robert','Bradley','Chicago','IL','hat',90,'red','2015-02-25','9545','Gottlieb, Ebert and Kuphal');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Paul','Schmidt','Davenport','IA','shirt',100,'blue','2015-08-22','9546','Luettgen, Schroeder and Green');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Christina','Watkins','Montpelier','VT','hat',70,'green','2016-04-18','9547','Hauck-Brakus');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Carlos','Gray','Garden Grove','CA','hat',80,'red','2016-01-08','9548','Johnston-Labadie');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Raymond','Reyes','Paterson','NJ','hat',10,'blue','2016-06-19','9549','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Sarah','Fernandez','Inglewood','CA','hat',20,'green','2016-08-31','9550','Marks, Stanton and Mann');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Stephen','Jacobs','Arlington','TX','shirt',20,'red','2016-01-04','9551','Frami Inc');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Anne','Ellis','Baton Rouge','LA','hat',80,'blue','2014-06-14','9552','Padberg-Swaniawski');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Teresa','Martinez','Springfield','MA','hat',100,'green','2016-04-28','9553','Boehm-Shields');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Catherine','Rodriguez','Rochester','NY','hat',90,'red','2014-08-12','9554','Kemmer, Trantow and Wuckert');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Lawrence','Hill','Saint Petersburg','FL','shirt',80,'blue','2014-01-04','9555','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Ann','Adams','Lincoln','NE','shirt',80,'green','2016-06-15','9556','Mertz Group');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Victor','Shaw','Olympia','WA','hat',90,'red','2016-03-29','9557','Spinka and Sons');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Fred','Peters','Pittsburgh','PA','hat',100,'blue','2015-07-19','9558','Collier Inc');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Jerry','Henderson','Tucson','AZ','shirt',100,'green','2016-04-02','9559','Boehm, Ziemann and Maggio');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Philip','Ray','Brooklyn','NY','hat',10,'red','2014-12-02','9560','White Group');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('James','Morrison','Bradenton','FL','hat',80,'blue','2015-02-11','9561','Keebler Inc');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Lawrence','Hart','Jacksonville','FL','shirt',100,'green','2016-02-24','9562','Renner Group');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Willie','Thomas','Wilkes Barre','PA','hat',100,'red','2015-04-16','9563','Schimmel Inc');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Richard','White','Reston','VA','hat',90,'blue','2014-12-15','9564','Morar-Gulgowski');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Laura','Brown','Miami','FL','shirt',70,'green','2016-01-19','9565','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Keith','Ferguson','Jefferson City','MO','hat',80,'red','2015-12-20','9566','Purdy-Hahn');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Doris','Cruz','Saint Petersburg','FL','hat',80,'blue','2016-01-31','9567','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Rose','Williams','Fort Lauderdale','FL','shirt',80,'green','2015-02-13','9568','Heaney, Pouros and Crist');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Nicole','Banks','San Francisco','CA','shirt',50,'red','2016-07-13','9569','Collins Group');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Teresa','Oliver','Arvada','CO','hat',90,'blue','2015-05-18','9570','Frami and Sons');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Rose','Kelley','Wichita','KS','hat',60,'green','2015-04-27','9571','Green-Lind');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Brian','Palmer','Fresno','CA','shirt',30,'red','2016-02-02','9572','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Philip','Carr','New York City','NY','hat',10,'blue','2015-06-08','9573','Shanahan, DuBuque and Treutel');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Sharon','Foster','Detroit','MI','hat',70,'green','2016-06-24','9574','Connelly-Fay');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Douglas','Williamson','Houston','TX','shirt',30,'red','2015-04-02','9575','Bashirian LLC');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Dennis','Harper','Fort Lauderdale','FL','shirt',20,'blue','2015-04-24','9576','Metz-Kling');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Roy','Rivera','Minneapolis','MN','shirt',60,'green','2015-12-23','9577','Hayes, Greenfelder and Schulist');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Billy','Marshall','Salinas','CA','shirt',90,'red','2015-09-17','9578','Heidenreich-Reynolds');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Louise','Knight','Fort Smith','AR','hat',30,'blue','2014-04-12','9579','Windler-Ondricka');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Jennifer','Lawson','Des Moines','IA','hat',80,'green','2015-09-27','9580','Schumm-Jakubowski');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Kevin','Martinez','Denver','CO','hat',90,'red','2014-01-25','9581','Rowe-Ferry');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Carol','Matthews','Shawnee Mission','KS','hat',90,'blue','2015-01-04','9582','Hirthe, Barton and McGlynn');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Kimberly','Fernandez','Allentown','PA','hat',100,'green','2014-09-16','9583','Dicki Group');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Matthew','Bowman','Raleigh','NC','hat',20,'red','2015-06-03','9584','Lesch, Mante and Durgan');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Annie','Greene','Miami','FL','hat',20,'blue','2015-02-11','9585','Cormier-Altenwerth');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Anthony','Day','Norfolk','VA','shirt',100,'green','2014-03-01','9586','Prohaska LLC');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Jack','Gutierrez','Milwaukee','WI','shirt',100,'red','2016-10-23','9587','Schmeler Group');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('William','Richardson','Richmond','VA','hat',40,'blue','2013-12-26','9588','Corwin, Kulas and Wilderman');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Howard','Gilbert','Syracuse','NY','hat',90,'green','2014-11-11','9589','Wilkinson-Jacobson');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Angela','Martinez','Memphis','TN','hat',50,'red','2016-06-18','9590','Prosacco-Beatty');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Shirley','Green','Tacoma','WA','hat',10,'blue','2014-07-20','9591','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Sarah','Payne','Corpus Christi','TX','hat',90,'green','2016-05-28','9592','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Donna','Carr','West Palm Beach','FL','shirt',90,'red','2014-12-16','9593','Bins, Schneider and Rutherford');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Philip','Kim','Sacramento','CA','hat',10,'blue','2015-02-18','9594','Rodriguez, Schroeder and Rippin');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Joyce','Marshall','Erie','PA','hat',70,'green','2014-04-04','9595','Moen-Gutkowski');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Jesse','Jenkins','Lakewood','WA','shirt',20,'red','2014-11-30','9596','Nitzsche-Veum');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Robert','Hart','Richmond','VA','shirt',90,'blue','2016-07-27','9597','White, Herman and Bailey');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Kelly','Perkins','New Orleans','LA','hat',100,'green','2014-09-06','9598','Herman Inc');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('James','Murray','Cincinnati','OH','shirt',40,'red','2016-09-30','9599','Trantow-Carroll');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Michael','Turner','Tampa','FL','hat',90,'blue','2015-07-04','9600','Spinka-Gorczany');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Donald','Greene','Miami','FL','hat',100,'green','2014-11-26','9601','Stanton, Runolfsdottir and Pouros');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Willie','Hudson','Albany','GA','shirt',10,'red','2016-07-04','9602','Howe, Romaguera and Osinski');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Judith','Mason','Shreveport','LA','shirt',100,'blue','2015-08-23','9603','Kozey, Padberg and White');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Kathleen','Bryant','Huntington','WV','shirt',50,'green','2014-08-07','9604','McKenzie, Runolfsdottir and Green');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Tina','Alexander','Philadelphia','PA','hat',70,'red','2015-08-02','9605','Maggio, Schiller and Rippin');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Antonio','West','New York City','NY','hat',90,'blue','2015-05-30','9606','Welch LLC');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Nicole','Powell','Milwaukee','WI','hat',10,'green','2014-09-08','9607','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Kimberly','Black','Largo','FL','hat',80,'red','2014-01-13','9608','Weber-Crona');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Matthew','Woods','New York City','NY','shirt',10,'blue','2015-12-06','9609','Russel-Shields');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Nicole','Carter','Jamaica','NY','hat',70,'green','2013-11-19','9610','Gulgowski, Pfeffer and Sanford');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Jason','Cole','Orlando','FL','hat',100,'red','2016-05-24','9611','Murphy, Beier and Jacobi');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Jerry','Hawkins','San Francisco','CA','hat',10,'blue','2014-04-25','9612','Schamberger Inc');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Nicholas','Cruz','Louisville','KY','hat',80,'green','2016-08-09','9613','Terry-Rippin');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Lillian','King','Houston','TX','shirt',90,'red','2016-03-20','9614','Kemmer-Berge');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Albert','Lawson','San Francisco','CA','hat',80,'blue','2016-10-21','9615','Kessler, Stamm and Dickinson');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Roy','Reid','Dallas','TX','shirt',90,'green','2015-06-29','9616','Bruen-Rolfson');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('David','Davis','Sterling','VA','hat',90,'red','2016-04-21','9617','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Ralph','Burke','Boston','MA','shirt',50,'blue','2015-03-15','9618','Ward LLC');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Lori','Watson','Reston','VA','hat',60,'green','2015-10-29','9619','Douglas, Bernier and Klein');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Clarence','Reed','Waco','TX','shirt',100,'red','2014-01-27','9620','Wolff Inc');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Debra','Scott','Santa Fe','NM','hat',30,'blue','2015-03-18','9621','Stracke Group');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Victor','Johnson','Brooklyn','NY','shirt',100,'green','2014-02-25','9622','Kessler, Keeling and Terry');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Jason','Lynch','Greensboro','NC','shirt',100,'red','2014-08-21','9623','Ratke-Bosco');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Eugene','Stewart','Greeley','CO','hat',90,'blue','2014-08-21','9624','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Johnny','Lopez','Rockford','IL','hat',80,'green','2016-06-22','9625','Rodriguez and Sons');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Anna','Cooper','San Antonio','TX','shirt',100,'red','2014-07-17','9626','Goodwin LLC');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Maria','Simmons','Bloomington','IN','shirt',80,'blue','2015-06-26','9627','Morissette, Larkin and Murazik');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Billy','Gray','Columbia','SC','hat',90,'green','2015-05-24','9628','Hettinger, Corwin and Kautzer');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Jonathan','Cook','Portland','OR','shirt',60,'red','2015-09-03','9629','Rolfson-Barrows');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Kevin','Nguyen','Portsmouth','NH','hat',40,'blue','2016-08-02','9630','Borer, Kutch and Turcotte');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Cheryl','Myers','Honolulu','HI','shirt',100,'green','2016-02-29','9631','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Ruth','Scott','Pittsburgh','PA','hat',90,'red','2016-02-04','9632','Hintz-Metz');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Betty','Wilson','New York City','NY','hat',80,'blue','2015-12-22','9633','Wunsch-Stanton');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Robin','Shaw','Wilmington','NC','shirt',90,'green','2015-11-09','9634','Bosco-Thiel');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Diana','Gonzales','San Jose','CA','hat',90,'red','2014-04-10','9635','Koelpin Group');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Lawrence','Torres','Warren','MI','shirt',20,'blue','2014-02-19','9636','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Lillian','Rodriguez','Bridgeport','CT','hat',30,'green','2016-09-07','9637','Quigley-Durgan');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Stephanie','Martinez','Las Vegas','NV','shirt',10,'red','2015-11-11','9638','Towne-Zemlak');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Andrew','Parker','Norwalk','CT','shirt',30,'blue','2014-05-19','9639','Weber-Lakin');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Shawn','Thompson','Lubbock','TX','shirt',70,'green','2016-05-06','9640','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Joyce','Payne','Santa Monica','CA','shirt',90,'red','2016-03-13','9641','Predovic Inc');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Sandra','Green','Fort Wayne','IN','hat',40,'blue','2016-09-24','9642','Davis and Sons');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Ernest','Mills','San Jose','CA','shirt',80,'green','2015-02-17','9643','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Janet','Brooks','Richmond','VA','shirt',70,'red','2014-10-11','9644','Kilback LLC');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Jerry','Fisher','Wichita','KS','shirt',30,'blue','2015-11-03','9645','Balistreri Group');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Rachel','Robinson','Atlanta','GA','hat',60,'green','2015-06-27','9646','Marks LLC');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Martin','Murray','Bridgeport','CT','shirt',90,'red','2014-05-20','9647','Ruecker, Bruen and Maggio');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Gary','Young','Fayetteville','NC','hat',70,'blue','2014-06-04','9648','Ernser-Jast');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Joan','Watkins','Minneapolis','MN','hat',70,'green','2015-01-27','9649','Morissette and Sons');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Harold','Patterson','Fort Pierce','FL','shirt',50,'red','2015-11-06','9650','Gibson Group');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Edward','Adams','New Orleans','LA','hat',60,'blue','2014-03-18','9651','Gerlach, Upton and Maggio');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Andrew','Peterson','Farmington','MI','hat',50,'green','2016-05-12','9652','Gulgowski Group');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Jennifer','Morgan','Youngstown','OH','hat',80,'red','2014-01-21','9653','Muller-O''Kon');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Larry','Cruz','Woburn','MA','hat',80,'blue','2014-01-02','9654','O''Hara-Veum');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Ronald','Hughes','Los Angeles','CA','hat',100,'green','2016-10-22','9655','Langworth, Schaefer and Stanton');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Karen','Kelley','Naples','FL','hat',80,'red','2014-09-23','9656','Senger, Casper and Koss');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Jacqueline','Stanley','Fort Lauderdale','FL','shirt',40,'blue','2015-09-05','9657','Huel, Cummerata and Halvorson');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Larry','Gomez','Kansas City','MO','hat',100,'green','2016-10-08','9658','Bergnaum-Marks');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Kathryn','Welch','Olympia','WA','hat',10,'red','2015-05-12','9659','Mayert and Sons');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Phyllis','Webb','Odessa','TX','shirt',100,'blue','2016-08-14','9660','Carroll, Yost and Lang');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Walter','Hughes','Long Beach','CA','hat',100,'green','2015-04-01','9661','Robel, Langworth and Kemmer');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Amy','Crawford','Phoenix','AZ','shirt',90,'red','2015-04-08','9662','Durgan Inc');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Jeffrey','Dunn','San Diego','CA','shirt',40,'blue','2016-07-08','9663','Goyette-Kerluke');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Joan','Wheeler','Birmingham','AL','shirt',60,'green','2014-02-02','9664','O''Hara Group');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Matthew','Castillo','Mobile','AL','shirt',10,'red','2014-12-13','9665','Jaskolski-Larson');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Peter','Nelson','Tallahassee','FL','hat',100,'blue','2015-05-22','9666','Steuber, Watsica and Little');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Jacqueline','Evans','Miami','FL','shirt',90,'green','2015-08-15','9667','Roob, Mohr and Baumbach');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Matthew','Nichols','Saint Louis','MO','shirt',10,'red','2014-01-11','9668','Wolff, Powlowski and Nitzsche');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Keith','Gordon','Hartford','CT','shirt',70,'blue','2014-10-19','9669','Gulgowski-Smitham');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Irene','Perkins','Lincoln','NE','shirt',60,'green','2015-01-20','9670','Lesch, Frami and Raynor');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Jack','Dean','Portland','OR','shirt',100,'red','2013-12-22','9671','Bayer-Hilll');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Eugene','Jackson','Denver','CO','hat',80,'blue','2015-03-12','9672','O''Connell Inc');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Tammy','Gonzales','Columbia','SC','shirt',90,'green','2014-11-01','9673','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Carlos','Morrison','Houston','TX','hat',10,'red','2013-12-06','9674','Hand and Sons');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Anna','Bryant','Durham','NC','hat',10,'blue','2015-03-12','9675','Stroman, Bergstrom and Ryan');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Benjamin','Bowman','Orlando','FL','shirt',20,'green','2016-09-09','9676','Sauer LLC');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Lois','Coleman','Kansas City','MO','hat',80,'red','2016-03-29','9677','Krajcik and Sons');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Carolyn','Mills','Tampa','FL','shirt',40,'blue','2014-06-04','9678','Pollich-Rice');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Deborah','Lee','San Francisco','CA','hat',50,'green','2014-09-03','9679','Langosh and Sons');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Denise','Gutierrez','Abilene','TX','hat',100,'red','2015-02-12','9680','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Ryan','Ramos','Houston','TX','shirt',90,'blue','2016-09-28','9681','Haag-Rodriguez');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Clarence','Watson','New York City','NY','shirt',10,'green','2016-05-02','9682','Fisher LLC');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Pamela','Chapman','Toledo','OH','shirt',50,'red','2015-07-09','9683','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Jesse','Stone','Oakland','CA','hat',70,'blue','2016-05-19','9684','Kiehn Inc');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Jennifer','Medina','Birmingham','AL','shirt',100,'green','2015-11-18','9685','Ullrich LLC');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Jerry','Watkins','Daytona Beach','FL','hat',50,'red','2015-01-22','9686','Nader LLC');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Kevin','Russell','Southfield','MI','shirt',90,'blue','2014-08-28','9687','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Brian','Carter','Philadelphia','PA','shirt',40,'green','2014-11-16','9688','Gutmann Group');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Phillip','Dixon','Brooklyn','NY','shirt',100,'red','2014-01-13','9689','O''Hara-O''Kon');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Joan','Vasquez','El Paso','TX','shirt',20,'blue','2015-09-03','9690','Luettgen, Cassin and Barrows');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('William','Howard','Odessa','TX','hat',90,'green','2016-05-21','9691','Nienow-Nitzsche');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Bruce','Phillips','West Palm Beach','FL','hat',100,'red','2015-10-21','9692','Jacobson-Bins');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Catherine','Dean','Cincinnati','OH','hat',90,'blue','2015-06-06','9693','Rau Inc');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Raymond','Diaz','Columbus','OH','shirt',50,'green','2015-03-09','9694','Goodwin LLC');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Louis','Cole','San Bernardino','CA','shirt',100,'red','2014-06-04','9695','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Doris','Lane','Miami','FL','hat',20,'blue','2016-01-27','9696','Kub and Sons');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Marilyn','Ferguson','Grand Rapids','MI','shirt',20,'green','2015-04-26','9697','McCullough and Sons');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Jose','Cooper','North Little Rock','AR','hat',90,'red','2015-09-15','9698','Glover and Sons');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Marilyn','Davis','Atlanta','GA','hat',100,'blue','2015-05-09','9699','Schinner Inc');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Martha','Cruz','Hollywood','FL','hat',10,'green','2015-04-29','9700','Ernser-Weimann');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Keith','Harrison','San Diego','CA','shirt',100,'red','2016-05-28','9701','Pouros Inc');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Emily','Elliott','Port Washington','NY','shirt',60,'blue','2015-09-07','9702','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Louis','Hanson','Honolulu','HI','shirt',90,'green','2016-02-13','9703','Morissette-Kassulke');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Gerald','Price','Harrisburg','PA','hat',40,'red','2015-11-11','9704','Dietrich Group');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Kevin','Clark','Baton Rouge','LA','shirt',70,'blue','2015-07-18','9705','Braun-Rau');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Arthur','Bishop','Tacoma','WA','hat',20,'green','2014-10-22','9706','Grady, Ruecker and Howell');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Judy','Ramirez','San Diego','CA','hat',100,'red','2013-12-10','9707','Brekke Group');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Cheryl','Sims','Portland','OR','shirt',70,'blue','2016-05-11','9708','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Stephanie','Russell','Oklahoma City','OK','shirt',80,'green','2016-06-15','9709','Hermiston LLC');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Joan','Perkins','Annapolis','MD','hat',90,'red','2016-04-09','9710','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Lori','Johnson','Johnson City','TN','shirt',80,'blue','2016-03-19','9711','Predovic, Borer and Hauck');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Debra','Frazier','Las Vegas','NV','hat',50,'green','2015-09-27','9712','Baumbach LLC');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Carl','Mendoza','Akron','OH','hat',60,'red','2016-08-08','9713','Hackett-Williamson');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Nicole','Wallace','Silver Spring','MD','shirt',80,'blue','2013-12-15','9714','Batz Inc');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Alice','Miller','Daytona Beach','FL','hat',70,'green','2015-11-29','9715','Padberg-Cummings');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Terry','Fernandez','Shawnee Mission','KS','hat',40,'red','2014-11-20','9716','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Ruth','Warren','Springfield','MA','hat',80,'blue','2013-12-28','9717','Waelchi-Smith');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Linda','Matthews','Miami','FL','hat',10,'green','2014-11-28','9718','Boyer, Senger and Lemke');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Chris','Wilson','Lake Charles','LA','hat',70,'red','2014-02-24','9719','Hartmann-Kirlin');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Susan','Welch','Rochester','NY','hat',70,'blue','2016-11-14','9720','Hoeger, Boyle and Emard');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Todd','Ross','Houston','TX','hat',20,'green','2016-09-29','9721','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Andrea','Hart','Charleston','WV','hat',80,'red','2014-07-24','9722','Reinger, Hills and Anderson');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Gregory','Fields','Phoenix','AZ','hat',90,'blue','2016-06-05','9723','Parisian, Blanda and Schinner');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Henry','Burns','Santa Ana','CA','shirt',60,'green','2014-06-03','9724','Jerde-Yundt');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Chris','Jenkins','Albany','NY','shirt',70,'red','2016-03-20','9725','Deckow-Hudson');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Stephen','Carter','Dallas','TX','hat',70,'blue','2015-05-18','9726','Gottlieb-Cole');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Doris','Washington','El Paso','TX','hat',90,'green','2015-12-08','9727','Bruen-Stracke');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Wayne','Young','Great Neck','NY','hat',50,'red','2016-05-15','9728','O''Reilly, Pfeffer and Reichel');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Ashley','Harper','Nashville','TN','shirt',20,'blue','2015-08-20','9729','Lockman, Goodwin and Waelchi');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Randy','Wells','San Francisco','CA','hat',40,'green','2014-02-22','9730','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Susan','Dixon','San Francisco','CA','hat',60,'red','2014-05-09','9731','Reichel and Sons');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Katherine','Warren','Canton','OH','shirt',80,'blue','2016-06-20','9732','Bechtelar-Bosco');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Thomas','Oliver','Santa Barbara','CA','hat',100,'green','2016-04-12','9733','Friesen LLC');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Harry','Freeman','Baltimore','MD','hat',60,'red','2014-01-10','9734','Harris, Corkery and Ryan');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Gloria','Roberts','Bakersfield','CA','hat',30,'blue','2016-10-28','9735','Roberts, Lynch and Nitzsche');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Dennis','Bishop','Sioux Falls','SD','hat',60,'green','2015-05-11','9736','Goldner LLC');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('David','Roberts','Atlanta','GA','hat',90,'red','2015-10-16','9737','Conn-Ryan');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Melissa','Palmer','Wichita','KS','shirt',50,'blue','2016-01-16','9738','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Gary','Greene','Mesa','AZ','hat',40,'green','2015-10-08','9739','Moore-Rutherford');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Joan','Elliott','Corona','CA','hat',60,'red','2014-01-22','9740','Hauck-Gerlach');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Bonnie','Sanchez','Fort Smith','AR','shirt',10,'blue','2016-07-22','9741','Brekke-Romaguera');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Thomas','Stewart','Atlanta','GA','shirt',50,'green','2016-02-21','9742','Toy, Tromp and Waters');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Gloria','Rogers','New York City','NY','shirt',10,'red','2014-03-05','9743','Wuckert, Huels and Wilderman');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Brenda','Miller','Cincinnati','OH','hat',100,'blue','2013-11-29','9744','Schmeler-Miller');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Keith','Scott','Tyler','TX','hat',90,'green','2016-07-12','9745','Weber-Conn');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Christopher','Kim','Oklahoma City','OK','hat',100,'red','2016-07-25','9746','Sporer, VonRueden and Casper');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Thomas','Martin','Sacramento','CA','shirt',90,'blue','2016-05-04','9747','Harris, Braun and Wisozk');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Terry','Bradley','Schenectady','NY','hat',60,'green','2014-08-19','9748','Deckow, Nikolaus and Considine');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Peter','Murray','Mobile','AL','hat',60,'red','2016-05-03','9749','McDermott, Koch and Mayert');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Matthew','Kelly','Louisville','KY','hat',70,'blue','2015-12-02','9750','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('David','Hunter','Albuquerque','NM','hat',60,'green','2014-05-07','9751','Johns LLC');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Donald','Phillips','Minneapolis','MN','hat',90,'red','2016-10-18','9752','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Teresa','Perkins','Madison','WI','hat',50,'blue','2016-05-27','9753','Wolf LLC');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Ronald','Thomas','Tacoma','WA','hat',80,'green','2015-09-25','9754','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Roy','Clark','Huntsville','AL','hat',60,'red','2014-03-24','9755','Goldner, Gulgowski and Murazik');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Nancy','Sullivan','Corpus Christi','TX','hat',90,'blue','2015-09-26','9756','Haag, Kerluke and Dach');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Willie','Elliott','Mesquite','TX','shirt',100,'green','2015-09-19','9757','Fay, Runte and Steuber');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Daniel','Williamson','San Francisco','CA','shirt',30,'red','2014-05-24','9758','Hand LLC');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Gloria','Reed','Fort Worth','TX','hat',100,'blue','2016-09-16','9759','Little and Sons');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Adam','West','Colorado Springs','CO','hat',40,'green','2014-10-20','9760','Sipes LLC');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Janice','Peterson','Montgomery','AL','hat',80,'red','2014-09-25','9761','Predovic, Baumbach and Denesik');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Matthew','Chavez','San Jose','CA','hat',50,'blue','2014-06-11','9762','Metz-Bartoletti');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Christina','Graham','Las Vegas','NV','hat',100,'green','2016-11-01','9763','Tremblay-Robel');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Emily','Richards','Columbus','OH','hat',20,'red','2016-11-12','9764','Simonis-Wiegand');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Lawrence','Ryan','Waterbury','CT','hat',70,'blue','2014-09-13','9765','Runolfsdottir, O''Conner and Marvin');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Annie','Richards','Littleton','CO','shirt',50,'green','2015-04-23','9766','Hilpert-Thompson');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Norma','Simpson','North Hollywood','CA','hat',90,'red','2016-06-22','9767','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Larry','Cole','New York City','NY','hat',80,'blue','2015-07-10','9768','Emmerich-Bradtke');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Victor','Gray','Columbus','OH','shirt',80,'green','2014-11-23','9769','Williamson, Mraz and D''Amore');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Lisa','Wallace','Louisville','KY','hat',80,'red','2014-05-18','9770','Tromp-Romaguera');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Rose','Burton','Spring','TX','shirt',90,'blue','2016-06-29','9771','Reichel Group');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Stephanie','Ryan','Buffalo','NY','hat',80,'green','2014-10-16','9772','Schroeder, Dickinson and Ryan');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Stephen','Howard','Phoenix','AZ','shirt',70,'red','2016-02-03','9773','Lesch-Kovacek');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Sarah','Allen','Anaheim','CA','hat',80,'blue','2016-08-02','9774','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Ruth','Johnson','Kansas City','MO','shirt',10,'green','2016-07-26','9775','O''Connell, Mills and Wehner');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Christine','Jacobs','Lexington','KY','hat',50,'red','2015-12-14','9776','Ondricka, Nitzsche and Lind');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Carolyn','Henry','Abilene','TX','shirt',90,'blue','2014-01-02','9777','Leuschke, Collins and Rath');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Jeffrey','Sanchez','Bethlehem','PA','shirt',80,'green','2015-02-15','9778','Schuppe, Mayert and Morissette');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Todd','Mason','Oklahoma City','OK','hat',90,'red','2014-08-19','9779','Bednar LLC');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Patricia','Riley','Louisville','KY','hat',40,'blue','2014-03-22','9780','Moore, Hyatt and Blick');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Mark','George','Metairie','LA','shirt',90,'green','2014-12-25','9781','Morissette, Kutch and Koch');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Amy','Warren','Mount Vernon','NY','hat',90,'red','2014-09-11','9782','Skiles, Leannon and Wyman');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Raymond','Stephens','Baltimore','MD','hat',90,'blue','2016-04-03','9783','Kuhn Group');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Frances','Barnes','San Antonio','TX','shirt',90,'green','2016-09-26','9784','Feest-Price');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Earl','Green','Independence','MO','shirt',100,'red','2015-07-18','9785','Hauck-Wisozk');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Janet','Ferguson','Florence','SC','shirt',90,'blue','2014-08-06','9786','Auer and Sons');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Antonio','Hart','Young America','MN','shirt',90,'green','2013-12-18','9787','Feest Inc');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Angela','Russell','Peoria','IL','hat',40,'red','2016-10-01','9788','Hodkiewicz, Osinski and Larson');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Joyce','Perry','San Antonio','TX','hat',90,'blue','2013-11-20','9789','Reichert and Sons');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Robin','Gardner','Vero Beach','FL','hat',30,'green','2015-04-10','9790','Morar-Yundt');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Louis','Cole','Chicago','IL','shirt',100,'red','2015-05-21','9791','Grady, Ernser and Wuckert');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Debra','Henry','Anderson','SC','hat',90,'blue','2016-07-09','9792','Pollich Group');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Rebecca','Henderson','Peoria','IL','hat',90,'green','2014-02-13','9793','Hirthe Group');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Stephen','Fernandez','Chicago','IL','hat',20,'red','2014-05-28','9794','Mante, Larkin and MacGyver');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Douglas','Freeman','Fort Lauderdale','FL','hat',60,'blue','2015-09-21','9795','Vandervort, Bartoletti and Stanton');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Ruth','Peterson','El Paso','TX','hat',70,'green','2016-08-24','9796','Harris-Heidenreich');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Richard','Myers','Charlotte','NC','shirt',20,'red','2015-05-12','9797','Schuster, Streich and Schaefer');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Steven','Green','Atlanta','GA','shirt',30,'blue','2016-05-26','9798','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Roy','Stanley','Harrisburg','PA','hat',90,'green','2015-08-29','9799','Hintz and Sons');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Kathy','Riley','Memphis','TN','hat',60,'red','2015-12-17','9800','Gaylord Inc');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Wayne','Gutierrez','Sioux Falls','SD','shirt',80,'blue','2015-03-20','9801','Wehner, Beer and Fadel');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Jimmy','Wagner','Jackson','MS','hat',40,'green','2015-08-25','9802','Gusikowski, Gerlach and Kihn');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Annie','Kennedy','Punta Gorda','FL','hat',80,'red','2016-01-01','9803','Green-Kreiger');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Martha','Gardner','Huntington','WV','shirt',90,'blue','2014-04-10','9804','Price-Effertz');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Jennifer','Fowler','Albuquerque','NM','shirt',60,'green','2015-03-04','9805','Baumbach Group');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Steve','Gomez','Montgomery','AL','shirt',40,'red','2014-01-18','9806','Weissnat-Cremin');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Andrew','Cox','Philadelphia','PA','shirt',90,'blue','2014-04-26','9807','Corkery LLC');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Joseph','Howard','Baltimore','MD','shirt',100,'green','2015-06-14','9808','O''Keefe, Nader and Bartell');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Cynthia','Evans','San Antonio','TX','shirt',30,'red','2015-06-05','9809','Emard, Ruecker and Halvorson');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Kevin','Fox','Birmingham','AL','hat',90,'blue','2015-07-15','9810','Lind-Bernier');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('George','White','Billings','MT','hat',70,'green','2014-01-09','9811','Cremin-Pagac');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Sandra','Bryant','Newport Beach','CA','hat',80,'red','2016-07-07','9812','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Linda','Garrett','Louisville','KY','hat',50,'blue','2014-09-19','9813','Macejkovic, Orn and Smith');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Mark','Williams','Jacksonville','FL','hat',70,'green','2016-01-17','9814','Mann Inc');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Ashley','Burton','Milwaukee','WI','hat',80,'red','2016-04-30','9815','Lemke Inc');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Patrick','Gordon','Spokane','WA','hat',40,'blue','2016-07-18','9816','Walter, Gutmann and Berge');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Robin','Wheeler','Los Angeles','CA','hat',90,'green','2015-12-23','9817','Hammes-Okuneva');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Lillian','Kim','Richmond','VA','hat',20,'red','2014-10-10','9818','Connelly-Schinner');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Katherine','Kennedy','Brooklyn','NY','hat',50,'blue','2016-01-20','9819','Nolan Group');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('William','Mason','Lexington','KY','hat',20,'green','2015-01-17','9820','Pagac and Sons');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Deborah','Hanson','Palm Bay','FL','shirt',90,'red','2015-11-20','9821','Stiedemann, Schaden and Lakin');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Jeremy','Boyd','San Antonio','TX','hat',80,'blue','2016-05-07','9822','Osinski, Thompson and Haag');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Debra','Gonzalez','Milwaukee','WI','shirt',90,'green','2015-01-11','9823','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Helen','Thompson','Dayton','OH','hat',40,'red','2013-11-26','9824','Lowe Inc');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Henry','Kim','Bradenton','FL','shirt',70,'blue','2015-11-21','9825','Wintheiser LLC');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Gerald','Ortiz','Bakersfield','CA','hat',90,'green','2014-08-30','9826','Rohan Inc');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Amy','Simpson','Akron','OH','shirt',60,'red','2014-03-12','9827','Schulist and Sons');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Joyce','Ward','Frankfort','KY','hat',80,'blue','2014-01-31','9828','Wisoky, Reichel and Mante');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Cheryl','Elliott','Kansas City','MO','hat',100,'green','2014-12-21','9829','Zemlak and Sons');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Bobby','Garrett','Shawnee Mission','KS','hat',100,'red','2015-11-14','9830','Labadie, Legros and Reichert');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Betty','Hall','Oakland','CA','shirt',100,'blue','2015-10-17','9831','Schinner, Emard and Osinski');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Andrew','Moreno','Fort Lauderdale','FL','hat',10,'green','2016-03-26','9832','Hackett-Sipes');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Judy','Johnson','High Point','NC','hat',80,'red','2016-07-05','9833','Bogisich and Sons');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('John','White','Annapolis','MD','hat',90,'blue','2015-09-15','9834','Vandervort Inc');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Anna','Brown','Murfreesboro','TN','shirt',80,'green','2014-06-27','9835','Haag Inc');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Harold','Richards','El Paso','TX','hat',10,'red','2014-09-08','9836','Hansen LLC');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Shirley','Montgomery','Newton','MA','shirt',60,'blue','2014-04-02','9837','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Ryan','Webb','Burbank','CA','hat',10,'green','2014-05-23','9838','Hickle and Sons');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Mary','Ruiz','San Angelo','TX','shirt',70,'red','2013-12-05','9839','Kris Group');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Walter','Clark','Atlanta','GA','shirt',50,'blue','2016-10-18','9840','Wiza Group');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Wanda','Torres','Winston Salem','NC','shirt',10,'green','2014-12-29','9841','Jacobi Group');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Donald','Harris','Denver','CO','shirt',90,'red','2016-08-21','9842','Dibbert-Rowe');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Anna','Porter','Denver','CO','hat',60,'blue','2016-06-27','9843','Weber, Herman and Hermann');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Bobby','Lynch','Oakland','CA','shirt',80,'green','2014-08-29','9844','Predovic, Witting and Koepp');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Jason','West','Fort Lauderdale','FL','hat',90,'red','2016-02-03','9845','Moore and Sons');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Deborah','Rivera','El Paso','TX','hat',50,'blue','2015-10-31','9846','Rosenbaum LLC');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Carlos','Howell','Detroit','MI','hat',30,'green','2015-09-27','9847','Ullrich Inc');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Eugene','Ray','Chicago','IL','shirt',80,'red','2016-09-01','9848','Carroll, Weber and Smith');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Philip','Hudson','Sioux City','IA','hat',80,'blue','2016-08-20','9849','Marvin-Simonis');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Sean','Lane','Greensboro','NC','hat',90,'green','2016-05-30','9850','Gerlach-White');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Christina','Richardson','Charlotte','NC','hat',40,'red','2014-08-09','9851','Cartwright Group');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Ronald','Gibson','Sacramento','CA','hat',80,'blue','2014-02-17','9852','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Carolyn','Carter','Las Vegas','NV','hat',20,'green','2016-02-24','9853','Beatty Inc');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Justin','Stanley','Spokane','WA','hat',100,'red','2014-03-03','9854','Koepp Group');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Jennifer','Garrett','Saint Petersburg','FL','shirt',30,'blue','2016-09-15','9855','Osinski, Greenholt and Spencer');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Kimberly','Chavez','Idaho Falls','ID','hat',70,'green','2014-01-27','9856','Will Inc');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Walter','Hamilton','Albany','NY','hat',40,'red','2015-08-14','9857','Glover-Reynolds');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Joan','Barnes','Irving','TX','hat',90,'blue','2016-10-19','9858','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Kathy','Collins','Salt Lake City','UT','hat',100,'green','2014-08-31','9859','Johnston-Tromp');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Keith','Fox','Lansing','MI','shirt',80,'red','2014-04-30','9860','Bailey, Farrell and Kuvalis');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Kathryn','Day','Sacramento','CA','hat',90,'blue','2016-03-16','9861','Beahan Inc');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Nancy','Murphy','Fort Lauderdale','FL','shirt',90,'green','2014-10-10','9862','Tromp-Raynor');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Stephen','Snyder','Springfield','MO','shirt',90,'red','2015-03-29','9863','Armstrong, Herman and Wisoky');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Mildred','Ortiz','San Francisco','CA','hat',70,'blue','2016-03-29','9864','Vandervort, Larson and Ferry');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Philip','Arnold','Glendale','CA','hat',40,'green','2014-01-03','9865','Renner-Corkery');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Edward','Ross','Houston','TX','shirt',90,'red','2015-02-01','9866','Gislason LLC');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Phyllis','Clark','Norfolk','VA','shirt',100,'blue','2016-08-25','9867','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Melissa','Franklin','Boise','ID','shirt',20,'green','2015-11-02','9868','Bednar LLC');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Todd','Richards','San Jose','CA','hat',100,'red','2015-06-20','9869','Schulist-Mills');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Jason','Daniels','Boston','MA','shirt',80,'blue','2014-06-26','9870','Heathcote LLC');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Emily','Marshall','San Antonio','TX','shirt',70,'green','2014-11-20','9871','Sanford LLC');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Christine','Rivera','Fayetteville','NC','hat',50,'red','2016-05-04','9872','Beatty, Predovic and Oberbrunner');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Beverly','Garza','El Paso','TX','shirt',90,'blue','2014-03-29','9873','Abernathy LLC');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Julie','Grant','Albany','NY','hat',90,'green','2015-12-14','9874','Fadel Group');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Raymond','Butler','Midland','TX','hat',100,'red','2016-06-06','9875','Hackett-Metz');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Carl','Greene','Augusta','GA','shirt',90,'blue','2015-12-05','9876','Stroman, Nikolaus and Feest');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Sandra','Lawrence','Van Nuys','CA','shirt',90,'green','2016-04-09','9877','Nikolaus-Mann');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Joshua','Perkins','Corpus Christi','TX','hat',90,'red','2015-09-02','9878','Frami-Lynch');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Angela','Duncan','Miami Beach','FL','hat',70,'blue','2015-07-29','9879','Stoltenberg-Lakin');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Eric','Turner','Akron','OH','hat',70,'green','2015-07-22','9880','Murphy Inc');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Charles','Matthews','Vienna','VA','shirt',80,'red','2015-10-03','9881','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Phyllis','George','Kansas City','MO','hat',40,'blue','2015-07-05','9882','Herman-Borer');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Frank','West','Corpus Christi','TX','shirt',30,'green','2015-12-20','9883','Lockman-Russel');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Paula','Bishop','Naples','FL','shirt',100,'red','2014-11-08','9884','Feeney, White and Corwin');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Kathryn','Banks','Rochester','NY','shirt',30,'blue','2014-05-14','9885','Predovic, Beahan and Bahringer');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Stephanie','Ruiz','Palo Alto','CA','hat',90,'green','2015-03-29','9886','Sanford, Blick and Beer');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Linda','Gonzalez','Chicago','IL','shirt',100,'red','2014-09-13','9887','Little-Armstrong');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Patrick','Hunt','Spartanburg','SC','shirt',90,'blue','2014-09-14','9888','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Christopher','Hunter','Peoria','IL','hat',70,'green','2015-06-30','9889','Harvey LLC');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Jesse','Jones','Grand Rapids','MI','shirt',80,'red','2013-12-20','9890','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Bruce','Stone','Lynn','MA','hat',100,'blue','2016-04-09','9891','Baumbach and Sons');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Maria','Morgan','Moreno Valley','CA','shirt',100,'green','2015-10-08','9892','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Sara','Payne','Springfield','MA','shirt',100,'red','2016-01-31','9893','Emmerich-Gleason');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Shirley','Graham','Tulsa','OK','hat',90,'blue','2014-03-12','9894','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Joyce','Henry','San Jose','CA','hat',80,'green','2015-02-28','9895','Lockman, Conroy and Lind');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Angela','Cunningham','Milwaukee','WI','hat',20,'red','2015-05-12','9896','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Beverly','Hudson','Kansas City','KS','hat',100,'blue','2016-01-16','9897','Ruecker-Moen');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Jacqueline','Payne','Dayton','OH','shirt',80,'green','2016-03-02','9898','Abernathy, Crona and Watsica');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Ryan','Hayes','Houston','TX','hat',20,'red','2014-05-30','9899','Spencer-Toy');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Gloria','Reynolds','Port Charlotte','FL','hat',40,'blue','2013-12-26','9900','Becker-Heller');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Irene','Bowman','Lincoln','NE','hat',30,'green','2014-08-20','9901','Gleichner, Mohr and Casper');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Aaron','Jacobs','Albuquerque','NM','shirt',70,'red','2016-03-03','9902','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Gerald','Freeman','Macon','GA','shirt',90,'blue','2016-01-01','9903','Mayer-Kilback');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Clarence','Williamson','Raleigh','NC','hat',100,'green','2014-12-03','9904','Lesch-Grady');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Barbara','Garza','North Little Rock','AR','shirt',80,'red','2016-04-16','9905','Lang Inc');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Earl','Ruiz','Hampton','VA','hat',90,'blue','2016-04-04','9906','Mayert, Huel and Greenholt');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Eric','Martinez','Charlotte','NC','shirt',90,'green','2014-03-08','9907','Conroy-Bednar');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Lori','Burke','Los Angeles','CA','shirt',30,'red','2014-10-21','9908','Fisher LLC');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Cheryl','Phillips','Portland','OR','shirt',90,'blue','2015-04-28','9909','Prosacco LLC');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Thomas','Rivera','New York City','NY','hat',100,'green','2014-02-21','9910','Morissette-Lang');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Howard','Ramirez','Greensboro','NC','hat',70,'red','2015-02-16','9911','Johns Group');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Frank','Willis','Hampton','VA','hat',70,'blue','2016-04-30','9912','Cummerata LLC');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Anne','Porter','Fort Lauderdale','FL','shirt',10,'green','2015-09-13','9913','Smith, Mertz and Sawayn');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Louis','Cox','Young America','MN','hat',70,'red','2015-07-27','9914','Mitchell-Nolan');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Cynthia','Powell','Odessa','TX','shirt',100,'blue','2016-11-05','9915','Jaskolski-Wiegand');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Jimmy','Willis','Denver','CO','shirt',80,'green','2014-12-02','9916','McKenzie LLC');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Jimmy','Price','San Francisco','CA','shirt',80,'red','2013-11-15','9917','Bartell-Armstrong');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Virginia','Howell','Alexandria','VA','hat',30,'blue','2015-10-08','9918','Deckow, Wilkinson and Stoltenberg');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Catherine','King','Philadelphia','PA','hat',30,'green','2014-01-20','9919','Auer Group');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Margaret','Hughes','Roanoke','VA','shirt',10,'red','2014-08-16','9920','Upton-Considine');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Matthew','Robinson','San Francisco','CA','hat',90,'blue','2014-07-11','9921','Gerhold and Sons');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Lois','Gordon','Kalamazoo','MI','hat',10,'green','2015-08-02','9922','Senger LLC');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Barbara','Hunt','El Paso','TX','shirt',90,'red','2015-04-17','9923','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('George','Gonzalez','Naperville','IL','shirt',10,'blue','2014-12-18','9924','Heidenreich LLC');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Cynthia','Alexander','Jersey City','NJ','hat',60,'green','2014-03-30','9925','Berge, Nicolas and Hahn');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Debra','Hughes','Brooksville','FL','shirt',80,'red','2016-09-21','9926','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Amy','Hart','Indianapolis','IN','hat',70,'blue','2016-07-11','9927','Stroman, White and Bosco');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Rebecca','Murray','Omaha','NE','shirt',60,'green','2014-09-04','9928','Braun-Keebler');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Christina','Gibson','West Palm Beach','FL','shirt',30,'red','2015-11-06','9929','Bernhard-Lemke');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Edward','Campbell','Tucson','AZ','hat',80,'blue','2014-01-28','9930','Torphy LLC');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Martha','Bell','Richmond','VA','hat',30,'green','2016-10-15','9931','Blanda, Eichmann and Smitham');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Louise','Fisher','Stamford','CT','hat',100,'red','2016-10-01','9932','Braun-Rodriguez');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('John','Sanders','Augusta','GA','shirt',80,'blue','2015-11-22','9933','Dickinson-Brakus');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Gloria','Wells','New York City','NY','hat',90,'green','2016-01-20','9934','Friesen-Ferry');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Phillip','Hansen','Dallas','TX','shirt',100,'red','2014-01-30','9935','Hahn-Runolfsdottir');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Gloria','Olson','Troy','MI','hat',100,'blue','2015-04-20','9936','Ratke Group');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Keith','Butler','Wichita','KS','hat',70,'green','2015-03-31','9937','Hilpert and Sons');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Terry','Grant','San Jose','CA','hat',30,'red','2015-04-17','9938','Wiza, Rau and Hauck');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Willie','Elliott','Denver','CO','shirt',30,'blue','2015-07-07','9939','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Kelly','Burns','San Francisco','CA','hat',40,'green','2014-09-14','9940','Denesik-Balistreri');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Cheryl','Kim','Pasadena','CA','shirt',100,'red','2015-01-18','9941','Pagac-Harris');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Rebecca','Hayes','San Francisco','CA','hat',50,'blue','2015-06-06','9942','Breitenberg-Lesch');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Denise','Lawson','San Francisco','CA','shirt',80,'green','2015-07-25','9943','Mohr and Sons');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Catherine','Lewis','Youngstown','OH','shirt',90,'red','2015-09-26','9944','Paucek-Muller');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Marie','Reynolds','El Paso','TX','shirt',80,'blue','2015-01-17','9945','Heidenreich-Stroman');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Anna','Porter','Charleston','WV','shirt',90,'green','2013-12-16','9946','Powlowski, Hilll and Kovacek');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Russell','Jackson','Arlington','TX','shirt',90,'red','2014-06-18','9947','Wunsch-Reynolds');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Rose','Jones','Littleton','CO','hat',90,'blue','2013-11-28','9948','Corkery-Johnston');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Samuel','Berry','Boston','MA','hat',100,'green','2016-01-20','9949','Boehm-Larkin');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Juan','Murphy','Evansville','IN','hat',70,'red','2014-05-28','9950','Bruen and Sons');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Chris','Castillo','Duluth','MN','shirt',100,'blue','2014-02-09','9951','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Johnny','Jacobs','Springfield','IL','hat',20,'green','2016-04-15','9952','Klocko, Ernser and Carter');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Walter','Medina','Pittsburgh','PA','hat',80,'red','2015-11-15','9953','O''Kon, Schneider and Harber');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Marie','Hawkins','Tulsa','OK','shirt',50,'blue','2013-12-05','9954','Hyatt, Rath and Torp');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Joe','Owens','San Francisco','CA','shirt',40,'green','2015-09-28','9955','Rippin, Olson and Weimann');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Helen','Fuller','New York City','NY','shirt',70,'red','2014-12-31','9956','Hermiston-Corkery');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Ashley','Fisher','Saint Paul','MN','shirt',40,'blue','2016-07-18','9957','Keeling and Sons');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Kathy','Gilbert','Las Vegas','NV','hat',80,'green','2016-11-06','9958','Predovic, Schultz and Predovic');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Charles','Diaz','Birmingham','AL','hat',60,'red','2013-12-16','9959','Corkery-Hoeger');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Anthony','Palmer','Gainesville','GA','hat',80,'blue','2014-05-15','9960','Kihn-Dach');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Judy','Armstrong','Shreveport','LA','shirt',90,'green','2016-06-06','9961','Tremblay-Fay');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Raymond','Bailey','Virginia Beach','VA','hat',100,'red','2016-07-05','9962','Hamill-Parker');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Rebecca','Peterson','Jackson','MS','shirt',90,'blue','2016-10-10','9963','Lockman-Leffler');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Emily','Johnson','Syracuse','NY','hat',90,'green','2015-06-18','9964','Rau-Pouros');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Frank','Perkins','Rochester','NY','hat',80,'red','2015-12-02','9965','Collier-Kuhn');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Bonnie','Gibson','Boston','MA','hat',90,'blue','2014-10-26','9966','Torphy, Sporer and Moore');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Evelyn','Austin','Albuquerque','NM','hat',50,'green','2015-01-31','9967','Keeling Group');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Raymond','Moore','Cleveland','OH','hat',80,'red','2015-06-15','9968','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Todd','Fields','San Diego','CA','shirt',80,'blue','2016-11-09','9969','Rodriguez-McGlynn');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Willie','Kennedy','Alexandria','VA','shirt',30,'green','2014-09-27','9970','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Philip','Foster','Dallas','TX','hat',10,'red','2014-02-05','9971','Volkman-Block');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Doris','Jenkins','San Francisco','CA','shirt',70,'blue','2015-05-27','9972','Shields, Lind and Legros');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Terry','Peters','Manassas','VA','shirt',80,'green','2015-01-04','9973','Mann-Turner');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Brandon','Hayes','Raleigh','NC','shirt',50,'red','2016-01-24','9974','West-Hintz');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Lori','Jones','Salt Lake City','UT','hat',70,'blue','2014-04-04','9975','Zboncak, Kuhn and Ebert');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Louise','Howard','Oakland','CA','shirt',90,'green','2015-06-07','9976','Armstrong, Hoeger and Walker');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Michelle','Mason','Seattle','WA','hat',90,'red','2014-04-24','9977','Gibson-Grant');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Julie','Mason','Reston','VA','hat',70,'blue','2014-02-20','9978','Russel, Weimann and Sawayn');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Catherine','Peters','Port Charlotte','FL','hat',90,'green','2014-01-26','9979','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Ryan','Holmes','San Francisco','CA','hat',100,'red','2015-02-07','9980','Kuhn-Emard');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Sara','Morales','Pensacola','FL','shirt',70,'blue','2014-09-28','9981','Brekke-Waelchi');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Charles','Grant','Louisville','KY','hat',80,'green','2016-05-15','9982','Brakus-Reichert');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Matthew','Mendoza','Mobile','AL','shirt',80,'red','2014-06-06','9983','Sauer-Pouros');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Fred','Walker','Baltimore','MD','shirt',70,'blue','2015-08-29','9984','Satterfield Group');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Philip','Brown','Van Nuys','CA','hat',90,'green','2013-11-17','9985','Kemmer LLC');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Irene','Crawford','Huntington Beach','CA','hat',80,'red','2014-02-11','9986','Botsford, Kirlin and Brekke');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Ruth','Murphy','New Hyde Park','NY','hat',20,'blue','2014-12-03','9987','Kunze, Bauch and Ebert');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Laura','Lopez','Huntington','WV','shirt',80,'green','2016-08-17','9988','Legros Group');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Carl','Olson','Reno','NV','hat',100,'red','2014-01-09','9989','Schmitt, Goodwin and Wilderman');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Amy','Matthews','Fort Wayne','IN','hat',90,'blue','2014-12-10','9990','Torphy-Johnston');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Teresa','Ford','Seattle','WA','shirt',90,'green','2015-06-23','9991','Steuber and Sons');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Julia','Hawkins','Grand Rapids','MI','shirt',90,'red','2015-11-26','9992','Skiles, Predovic and Conroy');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Raymond','Romero','Fort Myers','FL','shirt',80,'blue','2015-11-14','9993','Von-Walter');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Donna','Flores','Cincinnati','OH','hat',70,'green','2015-01-24','9994','Green Group');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Ernest','Fowler','Concord','CA','hat',50,'red','2015-04-17','9995','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Anna','Chapman','Helena','MT','hat',10,'blue','2014-02-03','9996','O''Conner Inc');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Patricia','Ryan','Dayton','OH','hat',60,'green','2015-12-25','9997','Hoppe Group');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Jose','Butler','Norwalk','CT','hat',70,'red','2016-01-17','9998','Bahringer Inc');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Donna','Daniels','Irving','TX','hat',80,'blue','2015-07-05','9999','Schaden-Christiansen');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Stephen','Wallace','Boston','MA','hat',60,'green','2015-04-08','10000','Bayer-Brekke');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Annie','Jackson','Omaha','NE','hat',50,'red','2016-06-20','10001','Koch LLC');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Phyllis','Hicks','Saint Louis','MO','hat',90,'blue','2016-01-28','10002','Pfeffer, Strosin and Dicki');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Jacqueline','Rivera','Scranton','PA','shirt',100,'green','2016-09-09','10003','Gislason-Nikolaus');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Carl','Boyd','South Bend','IN','shirt',90,'red','2016-01-19','10004','Marks-Rath');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Patricia','James','Gulfport','MS','shirt',80,'blue','2015-01-31','10005','Schuppe, Hauck and Lindgren');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Christine','James','Albany','NY','shirt',100,'green','2016-05-25','10006','Kreiger-Dickinson');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('William','Black','Philadelphia','PA','hat',100,'red','2014-08-10','10007','Homenick-Purdy');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Michael','Hill','Trenton','NJ','hat',100,'blue','2014-06-05','10008','Schaden, Schaefer and Wiza');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Maria','Harrison','Pueblo','CO','shirt',10,'green','2016-11-02','10009','Dickinson and Sons');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Andrew','Mason','Tulsa','OK','hat',70,'red','2014-04-02','10010','D''Amore, Franecki and Hintz');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Dennis','Gordon','Richmond','CA','shirt',70,'blue','2015-11-12','10011','Beier-Wintheiser');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('William','Martinez','Concord','CA','hat',70,'green','2014-02-24','10012','Roberts and Sons');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Angela','Elliott','Fullerton','CA','shirt',90,'red','2014-12-03','10013','Doyle-Murazik');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Eugene','Welch','Tuscaloosa','AL','hat',60,'blue','2016-08-15','10014','O''Keefe and Sons');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Linda','Bowman','Tampa','FL','hat',80,'green','2016-09-27','10015','Ortiz, Rippin and Hudson');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Anna','Perkins','Champaign','IL','shirt',100,'red','2015-05-26','10016','Waelchi LLC');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Doris','Hunter','Boynton Beach','FL','hat',50,'blue','2013-11-21','10017','Hilpert LLC');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Justin','Olson','Panama City','FL','hat',90,'green','2014-08-17','10018','Mann Inc');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Joan','Young','Nashville','TN','shirt',70,'red','2014-12-05','10019','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Terry','Stanley','Ocala','FL','shirt',100,'blue','2015-07-21','10020','Ferry, Bartoletti and Prohaska');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Alice','Bennett','Palm Bay','FL','hat',50,'green','2015-11-07','10021','Reichel, Miller and Effertz');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Walter','Kelly','Cleveland','OH','hat',100,'red','2014-01-03','10022','Stokes-Schultz');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Debra','Daniels','Dallas','TX','hat',70,'blue','2016-01-12','10023','Kuhic, VonRueden and Kohler');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Brian','Matthews','Philadelphia','PA','hat',20,'green','2016-08-12','10024','Toy and Sons');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Gerald','Shaw','El Paso','TX','shirt',60,'red','2014-06-19','10025','Hermann, Nitzsche and Mueller');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Emily','Gutierrez','Fort Myers','FL','shirt',90,'blue','2015-09-19','10026','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Phillip','Crawford','Dallas','TX','hat',70,'green','2013-12-31','10027','Balistreri and Sons');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Sarah','Ryan','Louisville','KY','shirt',50,'red','2014-03-25','10028','Keebler, Huels and Heaney');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Jack','Harvey','Charlotte','NC','hat',90,'blue','2014-01-15','10029','Hayes, Blick and Brekke');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Mary','Gray','Syracuse','NY','hat',80,'green','2015-10-15','10030','Orn Inc');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Jack','Martinez','Stamford','CT','hat',80,'red','2013-11-24','10031','Sipes Group');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Deborah','Johnston','Pasadena','CA','hat',20,'blue','2015-05-20','10032','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Frank','Gutierrez','San Jose','CA','shirt',30,'green','2016-10-02','10033','Stehr LLC');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Margaret','Arnold','Denver','CO','shirt',60,'red','2015-07-07','10034','Gulgowski, Marks and Johnson');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Michael','Kelly','Savannah','GA','hat',80,'blue','2015-04-29','10035','Blanda-Wilkinson');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Brandon','Hicks','Dallas','TX','hat',90,'green','2016-05-04','10036','Rice Inc');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Judy','Black','Hollywood','FL','hat',90,'red','2014-05-21','10037','Mertz-Auer');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Edward','Hart','Birmingham','AL','hat',10,'blue','2014-09-08','10038','Predovic-Osinski');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Justin','Snyder','San Francisco','CA','shirt',80,'green','2016-02-23','10039','Littel-Wilderman');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Virginia','Harvey','Paterson','NJ','hat',90,'red','2015-01-08','10040','Schuppe, Lang and Harvey');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Paula','Williamson','Houston','TX','shirt',90,'blue','2014-12-05','10041','Wyman, Tremblay and Mertz');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Harry','Welch','Rochester','MN','hat',90,'green','2014-03-03','10042','Wehner Group');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Norma','Robertson','Stockton','CA','shirt',100,'red','2015-05-01','10043','Mante, Powlowski and Ryan');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Steven','Fox','Buffalo','NY','hat',60,'blue','2015-10-12','10044','Turcotte, Hegmann and Auer');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Jeffrey','Martinez','Tampa','FL','shirt',70,'green','2015-11-19','10045','Kilback Inc');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Alan','Wagner','Spartanburg','SC','shirt',50,'red','2014-11-18','10046','Fritsch, Powlowski and Smith');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Randy','Ellis','Kansas City','MO','shirt',70,'blue','2015-08-02','10047','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Charles','Torres','Huntsville','AL','hat',100,'green','2014-04-03','10048','Gaylord, Corwin and Gottlieb');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Ralph','Fisher','Brooklyn','NY','shirt',50,'red','2016-07-27','10049','Wilderman, Ullrich and Collier');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Anne','Franklin','Roanoke','VA','shirt',10,'blue','2016-06-26','10050','Nienow and Sons');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Joe','Ellis','Memphis','TN','hat',70,'green','2015-06-25','10051','Feeney, Koepp and McKenzie');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Jeremy','Martin','New York City','NY','hat',100,'red','2015-02-13','10052','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Sandra','Ferguson','Boca Raton','FL','hat',20,'blue','2016-01-08','10053','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Charles','Hansen','Corpus Christi','TX','hat',60,'green','2014-10-13','10054','Haley-Luettgen');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Benjamin','Thompson','Elmira','NY','shirt',100,'red','2016-07-27','10055','Kuphal, Pouros and Weimann');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Lisa','Riley','Rochester','NY','hat',30,'blue','2015-05-31','10056','Breitenberg-Russel');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Susan','Pierce','Pensacola','FL','hat',90,'green','2016-01-12','10057','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Victor','Owens','Chicago','IL','shirt',80,'red','2016-05-03','10058','Lemke-Christiansen');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Carlos','Graham','New Orleans','LA','hat',70,'blue','2016-03-20','10059','Reynolds LLC');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Shawn','Spencer','Dayton','OH','shirt',100,'green','2013-12-30','10060','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Steven','Foster','Pensacola','FL','hat',30,'red','2015-01-06','10061','Rodriguez, Gorczany and Hickle');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Daniel','Woods','Glendale','CA','shirt',70,'blue','2016-06-27','10062','Weber Inc');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Stephanie','Flores','Lincoln','NE','hat',50,'green','2016-01-04','10063','Harris and Sons');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Fred','Williamson','Louisville','KY','hat',100,'red','2016-10-09','10064','Friesen-Heathcote');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Heather','Foster','Youngstown','OH','hat',70,'blue','2016-05-31','10065','Greenholt-Gulgowski');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Arthur','Carroll','Birmingham','AL','hat',60,'green','2013-11-22','10066','O''Conner and Sons');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Steve','Cook','Las Vegas','NV','hat',80,'red','2016-01-14','10067','Graham-Bednar');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Jane','Simmons','Richmond','VA','shirt',100,'blue','2015-06-23','10068','Barrows, Jenkins and Roberts');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Martin','Richardson','Minneapolis','MN','hat',90,'green','2014-12-12','10069','Ortiz, Lubowitz and Brekke');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Bruce','Ross','Stockton','CA','hat',50,'red','2014-12-06','10070','Schaden, Grant and Hoeger');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Theresa','Fox','Sacramento','CA','hat',80,'blue','2015-05-12','10071','Zieme Group');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Keith','Perez','Long Beach','CA','hat',30,'green','2016-01-29','10072','Crooks, Roberts and Beahan');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Michael','Wagner','Santa Barbara','CA','shirt',80,'red','2014-06-03','10073','Wilkinson-O''Keefe');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Kathy','Ellis','Simi Valley','CA','hat',80,'blue','2014-03-28','10074','Treutel Inc');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Cynthia','Carroll','Monticello','MN','hat',30,'green','2015-06-24','10075','Stracke and Sons');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Bruce','Wallace','Raleigh','NC','hat',50,'red','2016-03-01','10076','Towne, Mueller and Gusikowski');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Diana','Torres','Denver','CO','hat',90,'blue','2014-07-29','10077','Rowe, Fay and Bosco');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Craig','Payne','Phoenix','AZ','hat',80,'green','2016-07-19','10078','MacGyver LLC');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Melissa','Olson','Littleton','CO','hat',90,'red','2014-11-04','10079','Fahey, Goodwin and Borer');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Michelle','Marshall','Little Rock','AR','hat',90,'blue','2014-11-14','10080','Dach Group');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Charles','Green','Los Angeles','CA','hat',90,'green','2014-12-27','10081','Lehner-Lubowitz');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Shawn','Ryan','Tucson','AZ','hat',90,'red','2015-03-10','10082','Larson LLC');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Rose','Garcia','West Hartford','CT','shirt',10,'blue','2016-09-18','10083','Hansen Inc');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Wayne','Mcdonald','Indianapolis','IN','hat',70,'green','2016-02-04','10084','Carter LLC');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Evelyn','Peters','Lima','OH','shirt',80,'red','2016-06-20','10085','Kshlerin Group');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Walter','Andrews','New Brunswick','NJ','shirt',90,'blue','2015-10-13','10086','Kautzer Group');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Joyce','Morgan','Denver','CO','hat',90,'green','2015-05-16','10087','Little, Kunze and Emard');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Jack','Butler','Maple Plain','MN','hat',80,'red','2016-03-14','10088','Keeling, Kozey and Casper');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Lois','Hart','Kansas City','KS','shirt',90,'blue','2015-07-30','10089','Bartell-D''Amore');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Earl','Watkins','Hagerstown','MD','shirt',70,'green','2015-07-02','10090','Renner-Kub');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Ernest','Peters','Shawnee Mission','KS','hat',40,'red','2016-05-28','10091','Beer, Wolf and Cruickshank');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Jacqueline','Patterson','Cleveland','OH','shirt',90,'blue','2014-04-11','10092','Turcotte, Blanda and Wyman');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Benjamin','Hernandez','Garden Grove','CA','hat',80,'green','2014-10-29','10093','Wintheiser and Sons');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Eugene','Hansen','Springfield','MO','shirt',50,'red','2016-01-25','10094','Gutmann-Berge');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Katherine','Perkins','Atlanta','GA','hat',100,'blue','2015-09-12','10095','Feil-Deckow');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Sara','Lawson','Trenton','NJ','shirt',90,'green','2016-07-30','10096','Crona LLC');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Raymond','Stephens','Modesto','CA','shirt',70,'red','2015-08-13','10097','Dare-Muller');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Wanda','Perez','Las Vegas','NV','shirt',100,'blue','2014-10-05','10098','Kerluke, Shields and Klocko');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Joyce','Bennett','Hicksville','NY','shirt',80,'green','2014-07-08','10099','Keebler, Schaden and Bogan');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Earl','Russell','Naples','FL','hat',20,'red','2015-07-07','10100','Haag Inc');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Shirley','Walker','Bethesda','MD','hat',80,'blue','2016-05-18','10101','Hudson, Halvorson and Brakus');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Andrew','Lane','Odessa','TX','hat',100,'green','2014-04-22','10102','Lindgren-Schowalter');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Ruby','Mendoza','Beaumont','TX','hat',100,'red','2015-07-31','10103','Ernser-Bauch');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Linda','Rivera','San Diego','CA','hat',50,'blue','2015-05-18','10104','Lehner-Jenkins');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Douglas','Mills','Oklahoma City','OK','shirt',30,'green','2015-11-08','10105','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Anthony','Morris','Cincinnati','OH','hat',90,'red','2016-02-21','10106','Bernier Group');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Irene','Gibson','Sacramento','CA','shirt',80,'blue','2014-02-28','10107','Glover, Batz and Williamson');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Michelle','Roberts','Long Beach','CA','hat',60,'green','2015-05-29','10108','Vandervort, Paucek and Sipes');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Kelly','Lewis','Atlanta','GA','hat',10,'red','2016-04-02','10109','Greenfelder, Denesik and Rolfson');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Ralph','Medina','Montgomery','AL','shirt',30,'blue','2015-12-18','10110','Price and Sons');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Kathy','West','Corpus Christi','TX','hat',80,'green','2016-10-20','10111','Dietrich-Tillman');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Eric','Morgan','Charlotte','NC','hat',90,'red','2015-12-25','10112','Lebsack-Kihn');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Gerald','Wagner','Columbia','MO','shirt',20,'blue','2016-03-07','10113','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Alice','Brown','El Paso','TX','hat',60,'green','2015-03-15','10114','Beatty, Feeney and Howe');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Dennis','Lopez','Alexandria','VA','shirt',10,'red','2016-10-23','10115','Hyatt, Streich and Ortiz');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Kenneth','Campbell','Louisville','KY','shirt',70,'blue','2015-09-11','10116','Gutmann, Barrows and Price');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Philip','Crawford','South Bend','IN','shirt',40,'green','2015-11-19','10117','Goldner-Stokes');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Anna','Foster','Huntsville','AL','hat',20,'red','2014-01-16','10118','Schaefer-Cummings');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Jacqueline','Montgomery','Saint Paul','MN','shirt',50,'blue','2016-09-09','10119','Steuber-Gottlieb');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Sara','Wallace','High Point','NC','hat',50,'green','2014-10-20','10120','Mayer-Auer');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Jennifer','Reynolds','Houston','TX','hat',20,'red','2014-11-15','10121','Reilly, Ledner and Labadie');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Maria','Martin','Silver Spring','MD','shirt',80,'blue','2014-12-03','10122','Schowalter LLC');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Ruth','Taylor','Tulsa','OK','hat',90,'green','2015-09-27','10123','Schmidt and Sons');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Frank','Grant','New Orleans','LA','shirt',20,'red','2015-03-02','10124','Fay, Schinner and Herman');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Brandon','Green','Shawnee Mission','KS','hat',90,'blue','2014-07-26','10125','Hintz-Tillman');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Teresa','Stephens','Houston','TX','shirt',100,'green','2015-10-07','10126','Pacocha-Donnelly');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Helen','Reyes','Norfolk','VA','hat',90,'red','2016-02-21','10127','Terry Inc');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Douglas','Stanley','College Station','TX','hat',90,'blue','2015-11-17','10128','Paucek, Bernier and Leuschke');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Shawn','Hayes','Corpus Christi','TX','shirt',60,'green','2014-01-07','10129','Dach-Koepp');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Kathleen','Watson','Baton Rouge','LA','shirt',40,'red','2013-12-25','10130','Wilderman-Ebert');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Ann','Holmes','Birmingham','AL','hat',100,'blue','2016-03-24','10131','Satterfield, Keebler and Kihn');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Teresa','Sullivan','Jacksonville','FL','shirt',80,'green','2014-01-28','10132','Pollich-Gutmann');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Kenneth','Fisher','Columbia','SC','hat',80,'red','2014-07-11','10133','West-Dibbert');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Shirley','Chavez','Missoula','MT','hat',100,'blue','2015-11-04','10134','Dicki, Spencer and Hamill');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Keith','Knight','Orlando','FL','hat',100,'green','2014-03-11','10135','Jerde-Ondricka');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Ruby','Kelley','Raleigh','NC','hat',30,'red','2016-04-03','10136','Langworth-Ledner');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Jane','Powell','Terre Haute','IN','hat',90,'blue','2016-01-17','10137','Brekke Group');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Carolyn','Ruiz','Omaha','NE','hat',50,'green','2016-03-03','10138','Cormier and Sons');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Benjamin','Duncan','Hollywood','FL','hat',50,'red','2014-04-19','10139','Bailey and Sons');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Harold','Gonzales','Phoenix','AZ','shirt',90,'blue','2014-08-29','10140','Cassin, Flatley and Wintheiser');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Ruth','Alvarez','Concord','CA','shirt',20,'green','2014-06-09','10141','Schiller LLC');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Debra','Bennett','Raleigh','NC','shirt',80,'red','2014-01-01','10142','Hudson and Sons');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Cheryl','Burns','Phoenix','AZ','hat',80,'blue','2016-10-18','10143','Kessler-Lakin');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Deborah','Murray','Decatur','GA','shirt',60,'green','2015-04-20','10144','Mante, Hessel and Ziemann');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Arthur','Dunn','Indianapolis','IN','hat',70,'red','2015-07-18','10145','Ledner, Kuvalis and Bogan');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Jose','Hunt','Phoenix','AZ','hat',90,'blue','2014-06-29','10146','Zemlak-Halvorson');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Ashley','Ramirez','Buffalo','NY','hat',100,'green','2015-08-19','10147','Russel LLC');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Brenda','Green','Birmingham','AL','shirt',100,'red','2016-04-20','10148','Hilll Inc');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Janet','Carroll','Honolulu','HI','shirt',60,'blue','2014-01-17','10149','Rosenbaum-Gottlieb');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Susan','Greene','Alexandria','VA','hat',80,'green','2014-06-08','10150','West, Volkman and Kerluke');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Sean','Webb','Los Angeles','CA','hat',70,'red','2013-11-17','10151','Stark LLC');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Wayne','Ryan','Pinellas Park','FL','shirt',100,'blue','2014-01-29','10152','Schumm Group');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Lillian','Cunningham','Baton Rouge','LA','hat',70,'green','2016-07-20','10153','Considine Group');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Jason','Knight','Phoenix','AZ','shirt',10,'red','2014-04-27','10154','McGlynn, Hudson and Rodriguez');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Bobby','Stewart','Dayton','OH','hat',70,'blue','2016-04-28','10155','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Matthew','Franklin','Hartford','CT','hat',30,'green','2016-10-11','10156','Kovacek-Schumm');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Andrea','Carpenter','Silver Spring','MD','shirt',80,'red','2014-10-25','10157','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Russell','Peterson','Lexington','KY','shirt',100,'blue','2014-03-21','10158','Ebert-Crooks');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Keith','Peters','Springfield','IL','hat',100,'green','2014-06-12','10159','DuBuque Inc');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Roger','Hill','Toledo','OH','shirt',80,'red','2013-11-18','10160','Kozey, Heidenreich and Schmidt');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Joyce','Edwards','Austin','TX','shirt',90,'blue','2014-04-11','10161','Kilback-Hintz');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Melissa','Hunt','Portland','OR','shirt',90,'green','2014-11-06','10162','Swift Inc');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Brian','Frazier','Huntington','WV','hat',80,'red','2014-04-20','10163','Heller, Balistreri and Mraz');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Jimmy','Harrison','Atlanta','GA','shirt',80,'blue','2015-01-16','10164','Gislason-Mueller');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Eugene','Perry','Saint Louis','MO','hat',90,'green','2016-09-12','10165','Willms Group');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Sarah','Johnston','Miami','FL','hat',90,'red','2014-08-26','10166','Dickinson Group');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Joshua','Green','Orlando','FL','shirt',90,'blue','2013-12-13','10167','Jacobson, Herman and Zboncak');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Patrick','Barnes','Redwood City','CA','shirt',40,'green','2015-08-01','10168','Russel-Bartoletti');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Aaron','Alexander','Philadelphia','PA','shirt',20,'red','2015-06-25','10169','Ferry, Keeling and Langworth');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Emily','Carroll','Bethesda','MD','hat',80,'blue','2015-07-25','10170','Oberbrunner-Dicki');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Thomas','Williamson','Cincinnati','OH','hat',90,'green','2014-12-25','10171','Hessel and Sons');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Julia','Williams','Salt Lake City','UT','hat',80,'red','2016-10-04','10172','Crist, Wyman and Johnston');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Norma','Willis','Gainesville','FL','hat',90,'blue','2014-07-11','10173','Thompson-Rosenbaum');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Daniel','Hunt','Pueblo','CO','hat',90,'green','2016-09-21','10174','O''Conner-Schinner');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Adam','Richardson','Ocala','FL','hat',100,'red','2016-07-29','10175','Prosacco LLC');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Russell','Crawford','Richmond','VA','hat',80,'blue','2016-11-03','10176','Pacocha-Kilback');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Denise','Fuller','Denver','CO','shirt',80,'green','2015-02-16','10177','Ward-Effertz');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Stephanie','Carpenter','Buffalo','NY','hat',80,'red','2016-07-25','10178','Gulgowski-Bartoletti');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Nicholas','Peters','West Palm Beach','FL','hat',100,'blue','2014-12-21','10179','Pagac-Cartwright');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Nancy','Henderson','Minneapolis','MN','hat',70,'green','2014-08-03','10180','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Linda','Hanson','Indianapolis','IN','shirt',80,'red','2014-01-20','10181','Turner-Bruen');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Wanda','Hernandez','Scranton','PA','shirt',90,'blue','2016-04-21','10182','Altenwerth, Zboncak and Marks');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Annie','Collins','San Antonio','TX','hat',70,'green','2015-12-08','10183','Daniel, Wilkinson and Schmitt');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Brandon','Perkins','Kansas City','MO','shirt',70,'red','2015-06-02','10184','Miller-Kirlin');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Justin','Dean','Tacoma','WA','hat',10,'blue','2015-04-20','10185','Huel-Lebsack');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Kimberly','Payne','Springfield','MO','hat',70,'green','2014-04-05','10186','Kris LLC');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Edward','Hicks','Bakersfield','CA','hat',10,'red','2014-02-04','10187','Parker, Block and Hyatt');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Jeremy','Cunningham','Portland','OR','shirt',80,'blue','2015-05-20','10188','Sawayn and Sons');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Jennifer','Warren','Alexandria','VA','hat',100,'green','2016-08-04','10189','Bauch Inc');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Anna','Arnold','Memphis','TN','shirt',50,'red','2015-06-30','10190','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Jennifer','Lopez','Charlotte','NC','hat',40,'blue','2015-10-10','10191','Kilback-Frami');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Ernest','Woods','Dallas','TX','hat',80,'green','2014-07-15','10192','Mann, Crist and Ziemann');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Steve','Jenkins','Boston','MA','hat',100,'red','2016-05-06','10193','Medhurst and Sons');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('James','Little','Fresno','CA','shirt',30,'blue','2014-06-18','10194','Simonis Inc');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Kenneth','Gomez','Van Nuys','CA','shirt',90,'green','2016-06-20','10195','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Helen','Stanley','Van Nuys','CA','shirt',100,'red','2016-07-01','10196','Swaniawski, Weber and Rolfson');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Ann','Gonzales','Iowa City','IA','shirt',100,'blue','2016-02-07','10197','Renner LLC');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Denise','Lawson','San Antonio','TX','shirt',70,'green','2013-12-31','10198','Veum LLC');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Rebecca','Cunningham','Wichita Falls','TX','hat',100,'red','2014-06-25','10199','Zieme, Botsford and Kemmer');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Evelyn','Oliver','Lima','OH','shirt',50,'blue','2016-06-03','10200','Grady-Harber');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Johnny','Wells','Detroit','MI','shirt',100,'green','2014-11-22','10201','Eichmann, Effertz and Ledner');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Harold','Collins','Boston','MA','hat',30,'red','2015-06-30','10202','Dare-Huel');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Michelle','Baker','Boca Raton','FL','hat',100,'blue','2015-01-22','10203','Von-Bashirian');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Adam','Knight','Augusta','GA','hat',60,'green','2015-03-23','10204','Collier LLC');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Carl','Pierce','Chesapeake','VA','hat',40,'red','2016-03-03','10205','Hoeger Inc');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Chris','Jacobs','Oklahoma City','OK','hat',80,'blue','2015-04-21','10206','Jones-Zboncak');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Thomas','Hanson','Richmond','VA','hat',80,'green','2015-01-27','10207','Rempel-Rutherford');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Edward','Sanchez','San Francisco','CA','hat',100,'red','2014-01-30','10208','Koch-Hudson');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Jose','Carroll','Daytona Beach','FL','hat',80,'blue','2014-05-17','10209','Bergnaum, Bauch and Hickle');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Stephen','Hughes','West Palm Beach','FL','shirt',80,'green','2016-04-10','10210','Leffler and Sons');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Rebecca','Hicks','Fort Worth','TX','shirt',100,'red','2014-01-27','10211','Bins Group');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Adam','Ford','Saint Louis','MO','hat',70,'blue','2015-11-07','10212','Bogan Group');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Louis','Stone','Indianapolis','IN','shirt',100,'green','2015-12-18','10213','Wuckert-Wilderman');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Sharon','Oliver','Oklahoma City','OK','shirt',80,'red','2015-03-31','10214','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Gerald','West','Decatur','GA','shirt',100,'blue','2016-08-03','10215','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('David','Wheeler','Humble','TX','hat',10,'green','2014-04-01','10216','Gerlach, Tillman and Mosciski');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Ann','Moore','Nashville','TN','shirt',90,'red','2014-10-09','10217','Kuhlman, Leannon and Harber');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Jimmy','Carr','Tampa','FL','shirt',40,'blue','2015-02-24','10218','Hudson, Bogan and Gaylord');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Ruby','Richards','Buffalo','NY','hat',100,'green','2014-12-09','10219','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Barbara','Bryant','San Diego','CA','hat',90,'red','2014-10-01','10220','Jerde Inc');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Dennis','Hicks','Springfield','VA','hat',70,'blue','2014-09-29','10221','Dach, Schuster and Rodriguez');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Tammy','Wagner','Fresno','CA','hat',90,'green','2015-10-20','10222','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Julia','Carroll','El Paso','TX','hat',80,'red','2014-06-07','10223','Prohaska Group');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Rebecca','Reed','Brooklyn','NY','shirt',100,'blue','2016-08-28','10224','Johnston-Murray');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Mark','Holmes','Lancaster','PA','shirt',50,'green','2016-09-22','10225','Franecki Inc');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Earl','Simmons','Spokane','WA','hat',100,'red','2015-03-27','10226','Simonis Inc');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Tina','Fox','Fayetteville','NC','hat',100,'blue','2014-11-22','10227','Crist-Cartwright');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Maria','Mitchell','Dayton','OH','shirt',80,'green','2015-01-03','10228','Fadel-Wiegand');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Betty','Welch','Aurora','CO','shirt',70,'red','2014-04-20','10229','Zemlak-McDermott');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Steve','West','San Francisco','CA','shirt',70,'blue','2015-11-23','10230','Rice, Crist and Kulas');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Ruth','Jones','Houston','TX','hat',90,'green','2016-02-14','10231','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Mary','Myers','Boise','ID','hat',70,'red','2014-09-06','10232','Towne, Spencer and Mante');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Christina','Lynch','Cincinnati','OH','shirt',100,'blue','2015-05-07','10233','Crona-MacGyver');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Ashley','Riley','Baltimore','MD','shirt',30,'green','2015-12-08','10234','Macejkovic, Marks and Stamm');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Carolyn','Griffin','Evansville','IN','hat',70,'red','2014-01-20','10235','Olson, Dicki and Rogahn');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Clarence','Olson','Denver','CO','hat',90,'blue','2014-05-21','10236','Monahan, Walker and Bechtelar');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Ruby','Daniels','Minneapolis','MN','shirt',90,'green','2014-07-13','10237','Wyman-Toy');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Janice','Bailey','Trenton','NJ','shirt',10,'red','2016-08-21','10238','Auer-Donnelly');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Nancy','Rivera','Atlanta','GA','shirt',80,'blue','2016-05-26','10239','Hills-Maggio');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Alan','Butler','Philadelphia','PA','shirt',80,'green','2014-02-10','10240','Kulas LLC');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Barbara','Howard','Sacramento','CA','shirt',90,'red','2014-06-14','10241','Collier and Sons');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Christine','Reyes','Louisville','KY','shirt',90,'blue','2015-04-11','10242','Johns, Johns and Schimmel');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Debra','Garrett','Panama City','FL','shirt',50,'green','2016-04-22','10243','Rosenbaum LLC');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Ruby','Burton','San Francisco','CA','hat',30,'red','2014-10-07','10244','Kris, Hackett and Murray');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Gerald','Harrison','Biloxi','MS','hat',20,'blue','2014-02-15','10245','Kling, Crist and Eichmann');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Michelle','Carr','Fort Pierce','FL','hat',20,'green','2016-02-17','10246','Ankunding-Cormier');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Shirley','Payne','Young America','MN','shirt',70,'red','2013-12-31','10247','Bins and Sons');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Ashley','Rice','Irvine','CA','hat',50,'blue','2015-03-14','10248','Heidenreich, Renner and Schulist');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Christine','Marshall','Spokane','WA','hat',40,'green','2015-01-02','10249','Runolfsson LLC');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Donna','Armstrong','Portland','OR','hat',10,'red','2014-09-06','10250','Torp-Leuschke');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Juan','Walker','El Paso','TX','hat',70,'blue','2015-04-02','10251','Kertzmann-Bayer');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Wanda','Alexander','Portland','OR','hat',90,'green','2015-03-03','10252','Gorczany-Bogisich');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Sharon','Roberts','San Antonio','TX','hat',90,'red','2015-12-04','10253','Dicki-Kub');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Bruce','Mills','Alexandria','VA','shirt',90,'blue','2014-10-03','10254','Ankunding and Sons');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Eugene','Flores','Boca Raton','FL','hat',40,'green','2014-02-20','10255','Wintheiser, Abernathy and Ankunding');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Randy','Washington','Olympia','WA','shirt',80,'red','2014-07-11','10256','Pfeffer-Cole');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Irene','Morgan','San Francisco','CA','hat',100,'blue','2014-09-08','10257','Hermann, Keeling and Ernser');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Louise','Stewart','Evansville','IN','shirt',30,'green','2014-05-20','10258','Toy and Sons');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Earl','Jenkins','Omaha','NE','shirt',50,'red','2016-04-08','10259','Maggio-Reynolds');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Jacqueline','Fisher','Saint Louis','MO','hat',10,'blue','2015-09-23','10260','Reinger, O''Hara and Kihn');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Judy','Andrews','Winston Salem','NC','shirt',90,'green','2016-05-14','10261','Padberg, MacGyver and Kohler');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Jennifer','Thomas','Jacksonville','FL','shirt',70,'red','2016-03-23','10262','Hettinger Inc');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('George','Nguyen','Saint Louis','MO','hat',10,'blue','2014-09-08','10263','Hane-Schoen');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Judith','Barnes','Bronx','NY','hat',70,'green','2013-11-28','10264','King, Kuhlman and Klein');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Ronald','Nelson','Kansas City','MO','shirt',100,'red','2014-12-09','10265','Mante, Lakin and Beatty');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Randy','Day','Phoenix','AZ','hat',10,'blue','2015-08-23','10266','Schowalter and Sons');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Earl','Evans','Memphis','TN','hat',90,'green','2015-08-29','10267','Kerluke, Anderson and Reynolds');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Michelle','Hawkins','Phoenix','AZ','hat',90,'red','2016-01-03','10268','Emard, Gulgowski and Wolf');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Benjamin','Sims','Durham','NC','shirt',40,'blue','2015-09-11','10269','Harvey LLC');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Craig','Ortiz','Grand Forks','ND','shirt',90,'green','2013-11-27','10270','Dietrich LLC');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Nicole','Moreno','New York City','NY','hat',70,'red','2015-12-12','10271','Ernser-Lynch');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Kenneth','Gilbert','Anderson','IN','hat',20,'blue','2015-07-05','10272','Boyle-Marks');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Janice','Bryant','Hartford','CT','shirt',100,'green','2013-12-11','10273','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Sean','Reed','Santa Rosa','CA','shirt',80,'red','2016-03-30','10274','Huel-Littel');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Jeremy','Tucker','Las Vegas','NV','hat',80,'blue','2016-02-28','10275','Lynch-Reichert');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Keith','Pierce','Fresno','CA','hat',90,'green','2015-06-25','10276','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Roger','Tucker','New York City','NY','hat',80,'red','2014-07-06','10277','Thompson, Lubowitz and Leuschke');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Sean','Gibson','Philadelphia','PA','shirt',40,'blue','2016-09-17','10278','Borer, Cummings and Wunsch');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Shirley','Ramirez','Saint Louis','MO','hat',50,'green','2015-09-03','10279','Kunze-Gutmann');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Janet','Reynolds','New York City','NY','hat',90,'red','2015-01-14','10280','Stamm, Volkman and Wilderman');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Joyce','Wells','Rockford','IL','shirt',100,'blue','2016-07-31','10281','Kilback, Parker and Reichel');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Ralph','Morales','Toledo','OH','shirt',100,'green','2016-09-27','10282','Schimmel, Donnelly and Halvorson');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Julia','Lee','Knoxville','TN','hat',50,'red','2014-12-03','10283','Cartwright Inc');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Shawn','Jordan','Houston','TX','shirt',100,'blue','2015-06-23','10284','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Richard','Patterson','Charlottesville','VA','hat',40,'green','2015-07-02','10285','Thiel, Kirlin and Morissette');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Eugene','Martinez','Dayton','OH','hat',90,'red','2014-08-03','10286','Jast-Lesch');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Phillip','James','Tallahassee','FL','shirt',90,'blue','2015-07-28','10287','Kiehn-Muller');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Anne','Romero','Reading','PA','hat',50,'green','2013-11-19','10288','Kuhic-Ratke');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Pamela','Payne','South Bend','IN','hat',80,'red','2016-01-07','10289','Swift, Lang and Stoltenberg');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Russell','Green','Atlanta','GA','hat',60,'blue','2015-09-21','10290','Jenkins, Senger and Gulgowski');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Patricia','Cooper','Orlando','FL','shirt',90,'green','2014-01-14','10291','Dickens, Anderson and Boyle');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Randy','Brown','Young America','MN','shirt',20,'red','2016-07-25','10292','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Tammy','Nichols','Miami','FL','shirt',80,'blue','2014-11-27','10293','Hackett Group');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Frank','Nguyen','Seattle','WA','shirt',10,'green','2016-10-28','10294','Langosh, Graham and Prohaska');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Jennifer','Cooper','Akron','OH','shirt',100,'red','2014-06-14','10295','Lebsack, Nitzsche and Schmeler');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Todd','Lopez','Brooklyn','NY','shirt',60,'blue','2016-05-10','10296','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Julie','Bell','Punta Gorda','FL','shirt',20,'green','2014-04-21','10297','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Timothy','Powell','Stockton','CA','shirt',10,'red','2013-12-18','10298','Morissette-Auer');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Randy','Johnston','New York City','NY','shirt',30,'blue','2016-01-16','10299','Parisian-Windler');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Joe','Gray','Salt Lake City','UT','shirt',60,'green','2016-07-24','10300','Fadel-McCullough');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Norma','Cunningham','Brockton','MA','shirt',80,'red','2015-06-16','10301','Gutkowski Inc');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Teresa','Day','Colorado Springs','CO','shirt',90,'blue','2016-03-15','10302','O''Connell, Larson and Schiller');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Ashley','Reid','San Diego','CA','shirt',90,'green','2016-01-29','10303','Runolfsson-Emard');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Arthur','Lawson','Salt Lake City','UT','shirt',60,'red','2016-04-22','10304','Little-Botsford');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Brian','Stevens','Shreveport','LA','shirt',80,'blue','2014-02-23','10305','Konopelski-Kirlin');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Louise','Garcia','Saint Paul','MN','hat',90,'green','2014-04-30','10306','Wolf-Ullrich');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Bobby','Frazier','Fort Worth','TX','shirt',40,'red','2014-05-11','10307','Bernier-Rippin');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Martin','Simpson','Houston','TX','shirt',100,'blue','2014-07-11','10308','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Gary','Parker','Albany','NY','hat',90,'green','2016-07-02','10309','Russel-Collier');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Brandon','Lopez','Columbus','OH','hat',30,'red','2015-08-08','10310','Klocko, Bahringer and Funk');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Louis','Watson','Norman','OK','shirt',30,'blue','2014-08-07','10311','Altenwerth, Romaguera and Crooks');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Mark','Franklin','New York City','NY','shirt',80,'green','2015-01-02','10312','Kulas, Schamberger and Crona');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Daniel','George','Scranton','PA','hat',90,'red','2014-06-04','10313','Runte, Little and Koch');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Patrick','Watkins','San Francisco','CA','hat',90,'blue','2014-04-27','10314','Gutmann LLC');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Billy','Banks','San Francisco','CA','shirt',90,'green','2016-08-27','10315','Bauch-Kuhn');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Emily','Berry','Tacoma','WA','hat',80,'red','2013-12-04','10316','Howell Inc');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Heather','Little','Saint Petersburg','FL','shirt',80,'blue','2015-12-28','10317','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Nancy','Shaw','Pittsburgh','PA','hat',80,'green','2015-02-08','10318','Roberts-Carter');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Jesse','Garcia','Dallas','TX','hat',50,'red','2016-02-23','10319','Cartwright Group');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Gloria','Crawford','Warren','MI','shirt',60,'blue','2014-08-29','10320','Schmitt, O''Kon and Okuneva');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Eric','Gardner','Bloomington','IN','hat',100,'green','2015-11-06','10321','Hartmann LLC');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Margaret','Weaver','Oklahoma City','OK','hat',70,'red','2016-09-02','10322','Hermann, Farrell and Trantow');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Aaron','Davis','New York City','NY','hat',90,'blue','2014-06-22','10323','Frami, Dibbert and Kuphal');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('William','Carroll','Denver','CO','hat',10,'green','2016-03-30','10324','Fahey-Rodriguez');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Justin','Washington','San Antonio','TX','hat',10,'red','2015-09-16','10325','Rosenbaum-Glover');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Ann','Adams','Mesa','AZ','shirt',20,'blue','2014-11-18','10326','Kirlin Inc');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Brandon','Greene','Naples','FL','hat',10,'green','2015-11-15','10327','Erdman-Nolan');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Deborah','Meyer','Saint Louis','MO','hat',10,'red','2016-10-30','10328','Herman-Kuhic');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Marie','Riley','New Castle','PA','hat',30,'blue','2014-12-15','10329','Harris-Stoltenberg');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Howard','Morris','New Orleans','LA','hat',90,'green','2015-09-28','10330','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Bruce','King','Wichita','KS','hat',10,'red','2016-01-19','10331','Yundt, McCullough and Gleichner');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Marilyn','Williams','Lancaster','PA','hat',100,'blue','2016-08-01','10332','Leannon, Armstrong and Gerlach');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Stephen','Grant','Jamaica','NY','hat',50,'green','2015-05-28','10333','Becker-Franecki');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Brian','Berry','Mobile','AL','shirt',80,'red','2014-12-28','10334','Senger, Bashirian and O''Hara');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Michael','Scott','Ashburn','VA','hat',90,'blue','2014-02-09','10335','Reichel-Anderson');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Rebecca','Jones','Norfolk','VA','hat',90,'green','2015-01-14','10336','Rolfson, Wolff and Pouros');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Jane','Lopez','North Little Rock','AR','hat',20,'red','2014-06-28','10337','Deckow-Lehner');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Nicole','Chavez','Portland','OR','shirt',90,'blue','2014-07-23','10338','Keeling Group');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Jessica','Price','Bronx','NY','hat',90,'green','2015-10-11','10339','Gleichner and Sons');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Paul','Williams','Charleston','WV','hat',100,'red','2014-05-20','10340','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Ruth','Jackson','Oklahoma City','OK','hat',80,'blue','2016-02-29','10341','Koch, Prohaska and Kunze');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Jesse','Morris','Jefferson City','MO','shirt',80,'green','2014-02-11','10342','Cruickshank-Cummerata');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Katherine','Holmes','El Paso','TX','hat',90,'red','2015-08-24','10343','Kessler, Walter and Haag');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Catherine','Garrett','Memphis','TN','hat',60,'blue','2016-01-30','10344','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Carlos','Owens','Fort Wayne','IN','shirt',60,'green','2015-09-21','10345','Kerluke, Hartmann and Trantow');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Diane','Kelly','Charleston','WV','shirt',90,'red','2015-12-07','10346','Berge Inc');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Amy','Hudson','Savannah','GA','shirt',80,'blue','2014-08-30','10347','Haag and Sons');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Thomas','Reyes','Erie','PA','shirt',100,'green','2014-07-03','10348','Stanton, Veum and Homenick');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Russell','Stephens','Green Bay','WI','shirt',80,'red','2016-10-27','10349','Morissette, Bogan and Murphy');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Carolyn','Grant','Alexandria','LA','hat',10,'blue','2016-05-05','10350','Hagenes-Kassulke');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Denise','Hanson','Huntington','WV','shirt',90,'green','2016-04-29','10351','McKenzie-Simonis');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Eric','Nguyen','Dallas','TX','shirt',90,'red','2014-06-20','10352','Kunze, Hirthe and Nader');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Amy','Lane','Richmond','VA','hat',100,'blue','2014-05-14','10353','Morar and Sons');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Christina','Gardner','Springfield','MA','shirt',100,'green','2016-05-26','10354','Quigley-Bradtke');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Steve','Cooper','Montgomery','AL','hat',80,'red','2016-03-14','10355','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Martha','Riley','Peoria','IL','shirt',20,'blue','2015-08-30','10356','Balistreri, Friesen and Ziemann');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Timothy','Payne','Indianapolis','IN','shirt',60,'green','2016-08-18','10357','Franecki-Yundt');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Harry','Jones','New Orleans','LA','shirt',90,'red','2015-04-29','10358','Kshlerin LLC');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Emily','James','Saint Louis','MO','shirt',50,'blue','2015-10-18','10359','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Paul','Walker','El Paso','TX','hat',50,'green','2015-05-16','10360','Kub-Schmitt');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Nicholas','Barnes','Pittsburgh','PA','hat',100,'red','2016-06-18','10361','Sawayn and Sons');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Steve','Pierce','Oklahoma City','OK','shirt',100,'blue','2015-05-06','10362','Gorczany Group');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Mildred','Crawford','Burbank','CA','hat',100,'green','2014-10-26','10363','Muller Group');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Jason','Mitchell','San Francisco','CA','shirt',70,'red','2016-04-01','10364','Krajcik-Gorczany');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Russell','Dixon','Buffalo','NY','hat',70,'blue','2014-05-25','10365','Schuppe-Crona');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Douglas','Boyd','Denver','CO','hat',60,'green','2014-12-22','10366','Olson and Sons');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Michael','Gonzalez','Louisville','KY','shirt',50,'red','2015-01-28','10367','Stiedemann, Lynch and Lowe');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Christina','Burke','Charlotte','NC','shirt',40,'blue','2014-02-28','10368','Barrows, Prohaska and Bogan');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Ernest','Reed','Virginia Beach','VA','hat',20,'green','2016-08-22','10369','Kuhn-Pfannerstill');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Walter','Burns','Greeley','CO','shirt',90,'red','2014-11-12','10370','Waelchi, Kemmer and Rutherford');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Ronald','Bishop','Waco','TX','hat',100,'blue','2014-03-18','10371','Von, Littel and Bergstrom');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Norma','Morales','Macon','GA','hat',90,'green','2016-02-05','10372','Kuvalis, Weimann and Jerde');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Melissa','Franklin','Mobile','AL','hat',30,'red','2016-10-09','10373','Rohan, Denesik and Luettgen');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Carol','Ross','Newton','MA','shirt',70,'blue','2014-03-21','10374','Pfeffer-Lynch');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Clarence','Morales','Decatur','IL','shirt',90,'green','2014-07-04','10375','Thompson-Bogisich');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Christina','Burns','Atlanta','GA','hat',90,'red','2014-03-27','10376','Price, Connelly and Goyette');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Jimmy','Gutierrez','San Jose','CA','hat',20,'blue','2015-01-05','10377','Waelchi, Gerhold and Cremin');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Doris','Chavez','Alexandria','LA','shirt',80,'green','2015-05-14','10378','Wolff Inc');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Martha','Perez','Richmond','VA','shirt',90,'red','2015-12-02','10379','Gulgowski-Herman');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Andrea','Butler','Shawnee Mission','KS','hat',40,'blue','2016-09-14','10380','Effertz, Harber and Roob');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Roy','Black','Reading','PA','hat',60,'green','2014-02-25','10381','Howell LLC');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Carlos','Hanson','San Francisco','CA','shirt',50,'red','2014-01-26','10382','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Timothy','Fernandez','Houston','TX','shirt',100,'blue','2014-09-05','10383','Hartmann-Kilback');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Mary','Richards','Aurora','CO','hat',70,'green','2014-11-28','10384','Crooks-Walker');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Peter','Hawkins','Littleton','CO','hat',90,'red','2014-12-27','10385','Walker, Lockman and Kuhic');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Christopher','Walker','Topeka','KS','hat',100,'blue','2016-04-08','10386','Botsford, Senger and Littel');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Rose','Rivera','Raleigh','NC','shirt',70,'green','2015-10-22','10387','Crist, Lindgren and Bogan');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Frances','Miller','New Orleans','LA','shirt',80,'red','2015-05-19','10388','Kirlin LLC');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Deborah','Snyder','Fort Wayne','IN','hat',100,'blue','2016-09-26','10389','Veum LLC');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('John','Myers','Topeka','KS','hat',20,'green','2014-04-10','10390','MacGyver Group');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('David','Thomas','Evansville','IN','hat',70,'red','2016-01-24','10391','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Adam','Gonzales','Kansas City','MO','hat',80,'blue','2015-03-11','10392','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Annie','Turner','Charlotte','NC','hat',10,'green','2015-07-20','10393','Gerlach-Dicki');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Bonnie','Willis','Saint Petersburg','FL','shirt',80,'red','2016-07-11','10394','Howell Inc');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Bonnie','Olson','Rochester','NY','hat',80,'blue','2015-07-29','10395','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Phillip','Stone','Inglewood','CA','hat',50,'green','2014-07-25','10396','O''Conner, Zboncak and Hyatt');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Frances','Austin','Las Vegas','NV','shirt',100,'red','2014-09-20','10397','Altenwerth-Pfeffer');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Margaret','Myers','Salinas','CA','hat',80,'blue','2015-10-18','10398','Toy-Hills');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Irene','Watkins','Saginaw','MI','hat',80,'green','2015-06-05','10399','Stoltenberg, Sawayn and Schulist');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Charles','Edwards','Des Moines','IA','shirt',40,'red','2016-03-31','10400','Nitzsche, Barrows and Stamm');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Martha','Hudson','Tacoma','WA','shirt',90,'blue','2016-07-30','10401','Mraz, Bartell and Volkman');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Carolyn','Kelly','Bronx','NY','shirt',90,'green','2016-10-30','10402','O''Reilly-Toy');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Adam','Garcia','Fort Worth','TX','hat',90,'red','2015-09-20','10403','Erdman, Reilly and Zieme');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Wayne','Stevens','Bethesda','MD','hat',90,'blue','2016-11-08','10404','Okuneva-Dickens');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Gloria','Diaz','Austin','TX','shirt',90,'green','2014-12-01','10405','Mayer-Connelly');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Anthony','Warren','Crawfordsville','IN','hat',80,'red','2014-05-31','10406','Hessel, Sawayn and Wolff');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Ann','Harrison','Wilmington','DE','shirt',80,'blue','2016-08-06','10407','Reilly-Friesen');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Ashley','Franklin','Ventura','CA','shirt',90,'green','2014-11-01','10408','Bahringer LLC');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Melissa','Hughes','Kansas City','MO','hat',20,'red','2016-03-23','10409','Kris, Labadie and Buckridge');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Lawrence','Washington','Austin','TX','hat',100,'blue','2016-09-03','10410','Waelchi and Sons');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Carl','Matthews','Boise','ID','shirt',90,'green','2015-08-19','10411','Medhurst, Casper and Towne');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Donna','Johnston','New York City','NY','hat',40,'red','2015-03-09','10412','Aufderhar Group');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Donna','Hernandez','Sacramento','CA','shirt',80,'blue','2016-03-21','10413','Schmitt-Swift');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Brian','Bowman','Pompano Beach','FL','hat',80,'green','2014-11-22','10414','Dickinson-Daugherty');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Cheryl','Wallace','Evansville','IN','hat',40,'red','2014-08-14','10415','DuBuque-Keebler');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Dorothy','Cole','Stamford','CT','hat',30,'blue','2014-07-19','10416','Bartell-Schaden');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Jacqueline','Dixon','Athens','GA','hat',100,'green','2016-01-25','10417','Schroeder and Sons');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Edward','Mcdonald','Greenville','SC','hat',90,'red','2014-08-26','10418','Klocko, Altenwerth and Huels');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Juan','Morgan','San Antonio','TX','hat',90,'blue','2013-12-25','10419','Zieme-Smith');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Carol','Robinson','Fresno','CA','shirt',80,'green','2015-01-20','10420','Bauch, Rohan and Davis');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Victor','Hunt','Rochester','NY','hat',90,'red','2013-12-20','10421','Streich-Marvin');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Christine','Murray','Houston','TX','shirt',90,'blue','2015-06-10','10422','Adams LLC');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Denise','White','Newton','MA','hat',70,'green','2015-06-15','10423','Walker-Bauch');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Diane','Perry','Detroit','MI','shirt',90,'red','2015-11-23','10424','Hodkiewicz Group');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Angela','Ford','Salt Lake City','UT','shirt',20,'blue','2014-10-03','10425','Frami-Mohr');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Carl','Sanders','Pensacola','FL','shirt',90,'green','2014-10-04','10426','Heller-Satterfield');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Daniel','Alvarez','Spartanburg','SC','shirt',20,'red','2014-05-02','10427','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Mark','Scott','Valdosta','GA','hat',100,'blue','2016-03-18','10428','Ernser, Eichmann and O''Reilly');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Ashley','Washington','Cincinnati','OH','hat',90,'green','2016-01-04','10429','Gerlach, Heaney and Murazik');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Alice','Shaw','Miami','FL','hat',50,'red','2014-03-30','10430','Hane, Jacobi and Lind');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Craig','Turner','Miami','FL','hat',80,'blue','2015-01-11','10431','Hammes, Hauck and Stokes');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Brenda','Owens','Nashville','TN','hat',40,'green','2014-11-30','10432','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Stephen','Wagner','Tampa','FL','shirt',20,'red','2014-09-17','10433','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Brandon','Morris','Jackson','MS','hat',80,'blue','2016-01-05','10434','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Jeremy','Nguyen','Arlington','TX','shirt',40,'green','2013-11-30','10435','Gottlieb, Willms and Kuhn');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Roy','Arnold','Lakeland','FL','hat',90,'red','2014-09-11','10436','Windler-Ryan');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Lois','Cruz','Fullerton','CA','hat',90,'blue','2016-03-20','10437','Reichert-Schultz');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Roger','Harrison','Cumming','GA','hat',90,'green','2015-12-14','10438','Goyette-Johnson');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Jennifer','Burke','Savannah','GA','hat',80,'red','2014-06-11','10439','Will and Sons');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('James','Elliott','Madison','WI','hat',80,'blue','2016-11-11','10440','Roob Inc');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Brenda','Brooks','Wichita','KS','shirt',90,'green','2016-04-06','10441','Will LLC');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Christine','Reyes','Orlando','FL','hat',80,'red','2014-09-03','10442','Stokes-Williamson');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Earl','Burns','Beaverton','OR','shirt',50,'blue','2014-09-21','10443','Wolff, Pfannerstill and Gaylord');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Andrew','Taylor','Silver Spring','MD','hat',80,'green','2016-10-03','10444','Rosenbaum and Sons');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Stephanie','Stevens','Minneapolis','MN','shirt',80,'red','2013-11-17','10445','Little Group');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Robin','Ryan','Tampa','FL','hat',30,'blue','2014-11-28','10446','Collins Inc');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Frank','Hughes','El Paso','TX','shirt',90,'green','2015-08-18','10447','Reinger and Sons');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('William','Fernandez','El Paso','TX','shirt',10,'red','2016-07-11','10448','Rolfson-Goldner');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Jeffrey','Mason','El Paso','TX','hat',70,'blue','2013-12-07','10449','Bernier-Kuphal');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Wayne','Williams','Colorado Springs','CO','hat',70,'green','2014-01-25','10450','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Juan','Bradley','Roanoke','VA','hat',70,'red','2015-11-30','10451','Bogan-Muller');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Kelly','White','Springfield','OH','shirt',90,'blue','2014-04-20','10452','Koelpin, Stokes and Kuhic');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Richard','Stevens','Akron','OH','shirt',60,'green','2016-07-11','10453','Feeney, Conroy and Nikolaus');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Carlos','Chapman','Los Angeles','CA','hat',30,'red','2016-03-27','10454','Bernier, Kling and Lindgren');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Brian','Bradley','Kansas City','MO','hat',80,'blue','2016-06-07','10455','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Laura','Mason','Milwaukee','WI','shirt',100,'green','2015-10-28','10456','Gutkowski-Mraz');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Alice','Roberts','Montgomery','AL','shirt',80,'red','2015-08-25','10457','Langosh Group');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Anna','Jackson','Visalia','CA','hat',80,'blue','2013-11-30','10458','Jakubowski Inc');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Stephanie','Gomez','Orlando','FL','hat',90,'green','2014-08-31','10459','Marquardt-Ziemann');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Maria','Palmer','San Francisco','CA','hat',80,'red','2016-04-04','10460','Williamson-Bradtke');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Richard','Russell','Bloomington','IN','hat',70,'blue','2015-12-03','10461','Murray Inc');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Theresa','Torres','Austin','TX','hat',40,'green','2015-11-26','10462','Schamberger, Williamson and Casper');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Carol','Campbell','Greenville','SC','hat',80,'red','2016-01-02','10463','Mosciski, Haag and Hyatt');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Christina','Perry','Austin','TX','shirt',90,'blue','2014-12-11','10464','Schmitt and Sons');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Douglas','Peterson','Youngstown','OH','hat',80,'green','2013-11-24','10465','Littel Group');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Marilyn','Hall','Memphis','TN','hat',100,'red','2014-01-14','10466','Moore-Cormier');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Kenneth','Black','Myrtle Beach','SC','hat',20,'blue','2015-08-03','10467','Williamson-Moen');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Melissa','Richardson','Sioux Falls','SD','hat',60,'green','2016-04-08','10468','Deckow, Cole and Kassulke');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Kevin','Garcia','Arlington','VA','hat',30,'red','2015-08-04','10469','Kemmer, Dietrich and Predovic');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Dorothy','Boyd','Fairfax','VA','hat',50,'blue','2014-08-01','10470','Stracke-Osinski');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Julie','Day','Gilbert','AZ','shirt',20,'green','2014-02-12','10471','Kris, Shields and Mills');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Catherine','Anderson','Amarillo','TX','shirt',80,'red','2014-07-10','10472','Wisozk and Sons');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Andrea','Johnson','Memphis','TN','hat',90,'blue','2013-11-15','10473','Lockman-Renner');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Brenda','Brooks','Pittsburgh','PA','hat',100,'green','2015-09-20','10474','Marks-Hintz');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Randy','Cox','Flint','MI','shirt',100,'red','2016-02-08','10475','Feeney Inc');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Ronald','Henry','Arlington','VA','shirt',10,'blue','2015-08-28','10476','Halvorson Inc');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Judith','Cole','Minneapolis','MN','hat',80,'green','2015-02-13','10477','Roberts-Goldner');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Randy','Larson','Jamaica','NY','hat',100,'red','2014-12-17','10478','Schimmel, Nikolaus and Lehner');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Thomas','Jones','Columbia','SC','hat',90,'blue','2014-03-20','10479','D''Amore, Harvey and Wehner');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Brandon','Jackson','Alhambra','CA','shirt',90,'green','2015-04-15','10480','Wyman-Hintz');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Andrew','Baker','Fort Wayne','IN','shirt',100,'red','2015-04-24','10481','Marks Inc');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Jimmy','Simmons','San Francisco','CA','hat',70,'blue','2015-05-19','10482','Hayes-Wyman');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Antonio','Romero','Phoenix','AZ','shirt',80,'green','2014-03-25','10483','Ryan Inc');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Fred','Lane','Suffolk','VA','shirt',100,'red','2014-03-10','10484','');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Elizabeth','Murphy','Memphis','TN','hat',80,'blue','2014-01-26','10485','Morar, Botsford and Crona');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Donald','Woods','San Jose','CA','hat',70,'green','2016-04-26','10486','Adams Inc');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Peter','Snyder','Sioux Falls','SD','shirt',80,'red','2016-09-04','10487','Wolf-Rodriguez');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Jimmy','Foster','Colorado Springs','CO','shirt',100,'blue','2015-01-18','10488','Aufderhar-Bosco');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Marilyn','Payne','Los Angeles','CA','hat',90,'green','2014-10-15','10489','Torp-Kilback');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Julie','Turner','Houston','TX','shirt',90,'red','2015-12-22','10490','Rogahn, Mosciski and Johnston');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Frances','Hunter','Indianapolis','IN','hat',30,'blue','2015-10-24','10491','Marvin, Schamberger and Purdy');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Willie','Olson','Las Vegas','NV','hat',50,'green','2014-01-20','10492','Rogahn, Shields and Fay');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Jesse','Gardner','San Antonio','TX','hat',90,'red','2014-04-14','10493','Crist LLC');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('John','Gray','El Paso','TX','hat',30,'blue','2016-10-27','10494','Schmidt, Greenholt and Hodkiewicz');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Rachel','Jackson','Beaumont','TX','shirt',80,'green','2016-07-10','10495','Terry LLC');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Nancy','Roberts','Houston','TX','shirt',70,'red','2015-04-04','10496','Hackett Inc');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Frances','Hunter','Madison','WI','shirt',50,'blue','2014-12-14','10497','Bergnaum, Goodwin and Schneider');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('Mary','Washington','Farmington','MI','shirt',40,'green','2016-03-05','10498','Eichmann, Kozey and Abbott');
INSERT INTO `people` (first_name,last_name,city,state,shirt_or_hat,quiz_points,team,signup,id_number,company) VALUES ('James','Payne','Amarillo','TX','hat',90,'red','2015-09-01','10499','Kuhic Group');