Last active
December 10, 2020 15:46
-
-
Save jhackett1/fa87808a8305f3c85205fb4cfe7c4cf4 to your computer and use it in GitHub Desktop.
demo postgresql database for learning sql
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| create table employees ( | |
| id SERIAL PRIMARY KEY, | |
| first_name VARCHAR(50), | |
| last_name VARCHAR(50), | |
| email VARCHAR(50), | |
| street_address VARCHAR(50), | |
| postcode VARCHAR(50), | |
| department VARCHAR(50), | |
| currently_employed VARCHAR(50), | |
| employed_from DATE, | |
| employed_to DATE | |
| ); | |
| create table services ( | |
| id SERIAL PRIMARY KEY, | |
| name VARCHAR(50), | |
| street_address VARCHAR(50), | |
| postcode VARCHAR(50), | |
| free BOOLEAN, | |
| created_at DATE | |
| ); | |
| create table locations ( | |
| id SERIAL PRIMARY KEY, | |
| service_id INT, | |
| latitude FLOAT, | |
| longitude FLOAT, | |
| created_at DATE, | |
| CONSTRAINT fk_service FOREIGN KEY(service_id) REFERENCES services(id) | |
| ); | |
| create table posts ( | |
| id INT, | |
| post_name TEXT, | |
| post_content TEXT, | |
| created_at DATE | |
| ); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Letitia', 'Sayward', 'lsayward0@symantec.com', '3 Mandrake Crossing', null, 'Training', true, '3/17/2020', '12/2/2020'); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Stephen', 'Baignard', 'sbaignard1@omniture.com', '95 Larry Point', null, 'Marketing', null, '7/1/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Taryn', 'Yosifov', 'tyosifov2@ca.gov', '4770 Lukken Trail', '94174 CEDEX', 'Training', false, '7/22/2020', '1/6/2020'); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Shane', 'Lettington', 'slettington3@drupal.org', '5 Mcbride Plaza', null, 'Product Management', null, '4/24/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Agneta', 'Yurkin', 'ayurkin4@sphinn.com', '7 Grover Court', '184358', 'Engineering', null, '12/26/2019', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Rori', 'Buist', 'rbuist5@qq.com', '570 Mccormick Trail', '55530', 'Marketing', null, '11/2/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Ardyce', 'Jude', 'ajude6@yale.edu', '759 Hazelcrest Alley', '352552', 'Sales', null, '10/11/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Justine', 'Harses', 'jharses7@nba.com', '239 Lakewood Gardens Crossing', null, 'Business Development', null, '9/16/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Padget', 'Bernadzki', 'pbernadzki8@printfriendly.com', '49157 Pennsylvania Place', null, 'Research and Development', true, '7/7/2020', '6/22/2020'); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Wylma', 'Cullivan', 'wcullivan9@google.cn', '1 Norway Maple Center', '24129', 'Support', true, '3/28/2020', '5/9/2020'); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Upton', 'Ransley', 'uransleya@aboutads.info', '3057 Marcy Terrace', null, 'Research and Development', null, '5/6/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Karel', 'Pley', 'kpleyb@house.gov', '93 Butternut Point', '363731', 'Accounting', false, '5/30/2020', '11/30/2020'); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Leodora', 'Brand', 'lbrandc@moonfruit.com', '74 Muir Circle', null, 'Legal', false, '2/24/2020', '1/31/2020'); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Seka', 'Gifford', 'sgiffordd@ocn.ne.jp', '74 Hermina Avenue', null, 'Human Resources', null, '9/25/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Othilia', 'Edscer', 'oedscere@ow.ly', '35 Cardinal Plaza', '6844', 'Services', true, '8/11/2020', '11/23/2020'); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Luther', 'Farherty', 'lfarhertyf@cnet.com', '6177 American Trail', null, 'Research and Development', null, '11/21/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Octavia', 'Elfitt', 'oelfittg@whitehouse.gov', '0 Hooker Drive', '06105', 'Product Management', true, '4/25/2020', '3/2/2020'); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Ravid', 'Nitto', 'rnittoh@phoca.cz', '2 Emmet Alley', null, 'Research and Development', false, '12/25/2019', '5/19/2020'); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Lia', 'Bigglestone', 'lbigglestonei@blogtalkradio.com', '5 Manufacturers Terrace', '346536', 'Legal', null, '12/3/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Roscoe', 'Moynihan', 'rmoynihanj@nsw.gov.au', '0 1st Crossing', '22120', 'Engineering', null, '3/21/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Etan', 'Bootherstone', 'ebootherstonek@tiny.cc', '14 Dottie Pass', null, 'Training', null, '4/23/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Rayshell', 'Baldinotti', 'rbaldinottil@flickr.com', '0402 Dryden Point', '2435-609', 'Training', null, '12/21/2019', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Stafford', 'Sundin', 'ssundinm@msn.com', '8727 Forster Avenue', null, 'Engineering', null, '3/13/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Sandra', 'Cutting', 'scuttingn@icq.com', '34597 Dixon Lane', '4618', 'Human Resources', true, '8/2/2020', '7/11/2020'); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Nike', 'Hames', 'nhameso@etsy.com', '84 Fallview Park', null, 'Legal', null, '9/25/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Hestia', 'Reford', 'hrefordp@nps.gov', '4 Corscot Point', null, 'Training', null, '8/2/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Carry', 'Gowdie', 'cgowdieq@live.com', '17863 Sachs Parkway', null, 'Marketing', false, '7/17/2020', '1/1/2020'); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Krissie', 'Daid', 'kdaidr@soup.io', '059 Nova Trail', '257 21', 'Sales', null, '6/23/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Leeland', 'Dawid', 'ldawids@prlog.org', '935 Merchant Plaza', null, 'Business Development', null, '2/10/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Tim', 'Trenbey', 'ttrenbeyt@163.com', '5 Loftsgordon Park', null, 'Services', null, '8/14/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Joellyn', 'Joinson', 'jjoinsonu@feedburner.com', '85485 Paget Trail', '3362', 'Research and Development', null, '3/17/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Happy', 'Cowlin', 'hcowlinv@merriam-webster.com', '10735 Monica Road', null, 'Sales', null, '12/16/2019', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Stephana', 'Dummett', 'sdummettw@facebook.com', '46 Green Ridge Way', '86430-000', 'Support', false, '10/20/2020', '9/10/2020'); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Elisabet', 'North', 'enorthx@ihg.com', '4 Tennessee Way', '4785-210', 'Training', false, '7/18/2020', '7/22/2020'); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Julian', 'Greed', 'jgreedy@reverbnation.com', '7787 Oxford Court', '8300', 'Human Resources', null, '6/19/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Baird', 'Paxman', 'bpaxmanz@mashable.com', '845 Buhler Point', '4950-840', 'Training', true, '6/1/2020', '10/10/2020'); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Robinet', 'Hourston', 'rhourston10@hp.com', '52 Delaware Junction', '5160-218', 'Accounting', null, '7/10/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Ayn', 'Shelbourne', 'ashelbourne11@home.pl', '9991 Carey Way', null, 'Marketing', null, '12/10/2019', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Madelena', 'Scullard', 'mscullard12@kickstarter.com', '658 Portage Center', null, 'Support', true, '11/18/2020', '5/17/2020'); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Caresa', 'Labeuil', 'clabeuil13@jimdo.com', '80 Florence Drive', null, 'Research and Development', true, '3/3/2020', '3/14/2020'); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Elisabet', 'Goodhand', 'egoodhand14@bing.com', '9797 Riverside Park', '171 78', 'Engineering', null, '4/11/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Hillery', 'Muzzillo', 'hmuzzillo15@imdb.com', '6867 Blaine Terrace', null, 'Engineering', false, '7/18/2020', '10/21/2020'); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Jocko', 'Elliott', 'jelliott16@squidoo.com', '31679 Russell Street', null, 'Training', null, '10/23/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Selie', 'Surplice', 'ssurplice17@amazon.de', '1 Anzinger Drive', null, 'Legal', true, '7/29/2020', '6/12/2020'); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Forrester', 'Rothermel', 'frothermel18@ning.com', '0851 Fieldstone Avenue', '50990', 'Marketing', false, '8/29/2020', '4/2/2020'); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Wallace', 'Figgures', 'wfiggures19@alibaba.com', '56 Dwight Trail', null, 'Human Resources', null, '8/1/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Essy', 'Symington', 'esymington1a@reuters.com', '3558 Sugar Court', '549 81', 'Support', null, '12/28/2019', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Beverie', 'Fairebrother', 'bfairebrother1b@zdnet.com', '3618 Grayhawk Way', '2405', 'Research and Development', null, '4/17/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Kenyon', 'Capnerhurst', 'kcapnerhurst1c@ezinearticles.com', '1360 Badeau Street', '81720', 'Accounting', null, '2/21/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Andras', 'Biasioni', 'abiasioni1d@godaddy.com', '1369 Canary Parkway', null, 'Legal', null, '12/26/2019', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Starlin', 'Dodson', 'sdodson1e@cornell.edu', '75563 Transport Hill', '1114', 'Research and Development', null, '10/6/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Guilbert', 'Maylam', 'gmaylam1f@printfriendly.com', '99500 Debra Point', null, 'Business Development', null, '7/25/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Gertrud', 'Gianelli', 'ggianelli1g@elegantthemes.com', '05 Shoshone Circle', null, 'Legal', true, '6/11/2020', '4/18/2020'); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Shauna', 'Cronin', 'scronin1h@symantec.com', '3 Summerview Parkway', '563 32', 'Sales', null, '5/8/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Kerrin', 'Priest', 'kpriest1i@nature.com', '59 Superior Place', null, 'Accounting', null, '8/17/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Caressa', 'Forson', 'cforson1j@woothemes.com', '8722 Melvin Trail', null, 'Support', true, '12/19/2019', '3/26/2020'); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Gregor', 'Whear', 'gwhear1k@mapquest.com', '1586 Dryden Point', '68-120', 'Services', false, '8/23/2020', '6/18/2020'); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Dolf', 'Leadbeater', 'dleadbeater1l@prweb.com', '791 Mockingbird Hill', '2423', 'Product Management', null, '1/15/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Nomi', 'Cobden', 'ncobden1m@clickbank.net', '8424 Talmadge Alley', '4514', 'Product Management', null, '4/20/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Eada', 'Bartosiak', 'ebartosiak1n@nydailynews.com', '1070 Dayton Park', null, 'Accounting', true, '1/16/2020', '11/21/2020'); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Oralia', 'Mustill', 'omustill1o@addtoany.com', '16 Hagan Park', '05001', 'Marketing', null, '11/2/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Walden', 'Dirkin', 'wdirkin1p@canalblog.com', '918 Sunbrook Place', '686 05', 'Product Management', false, '4/3/2020', '4/28/2020'); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Ilka', 'Poe', 'ipoe1q@mozilla.org', '4104 Tony Center', null, 'Legal', null, '4/5/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('North', 'Alvy', 'nalvy1r@topsy.com', '06249 Schmedeman Hill', '76-230', 'Business Development', null, '11/16/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Davide', 'Roubay', 'droubay1s@squarespace.com', '6 Kim Circle', '5964', 'Sales', true, '11/1/2020', '12/7/2019'); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Jules', 'Skpsey', 'jskpsey1t@virginia.edu', '911 Cordelia Street', null, 'Research and Development', null, '6/4/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Dieter', 'Wilds', 'dwilds1u@rakuten.co.jp', '29281 Monica Center', null, 'Training', null, '11/15/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Leontyne', 'Crutcher', 'lcrutcher1v@acquirethisname.com', '813 Dapin Terrace', null, 'Research and Development', true, '3/6/2020', '12/5/2020'); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Callida', 'Whittle', 'cwhittle1w@bloglines.com', '232 Fuller Alley', null, 'Engineering', null, '11/23/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Sofie', 'Bakhrushin', 'sbakhrushin1x@addthis.com', '63178 Fair Oaks Plaza', '2380', 'Training', null, '2/17/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Karisa', 'Cruden', 'kcruden1y@nsw.gov.au', '4 Eagan Way', null, 'Human Resources', false, '12/18/2019', '8/26/2020'); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Tiertza', 'Martlew', 'tmartlew1z@freewebs.com', '745 Starling Terrace', null, 'Legal', false, '9/10/2020', '12/13/2019'); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Florette', 'Rousell', 'frousell20@blogspot.com', '0119 Redwing Place', '17622', 'Services', true, '9/26/2020', '7/3/2020'); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Keelia', 'Grafhom', 'kgrafhom21@arstechnica.com', '7 Portage Point', '13002', 'Human Resources', true, '10/2/2020', '11/4/2020'); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Karola', 'Torrecilla', 'ktorrecilla22@furl.net', '82725 Summit Road', null, 'Support', null, '1/19/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Elroy', 'Iwanczyk', 'eiwanczyk23@icq.com', '4 Sycamore Plaza', '29500-000', 'Support', null, '4/16/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Saunders', 'Espasa', 'sespasa24@mashable.com', '99 Morning Parkway', null, 'Product Management', null, '11/18/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Juliana', 'Morsom', 'jmorsom25@microsoft.com', '94042 Oxford Lane', null, 'Legal', null, '5/16/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Bealle', 'Vasilik', 'bvasilik26@patch.com', '01507 Swallow Road', null, 'Accounting', null, '2/2/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Russ', 'Lucien', 'rlucien27@independent.co.uk', '859 Grim Point', '8423', 'Business Development', null, '12/1/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Morgen', 'Pilger', 'mpilger28@typepad.com', '19 Lotheville Pass', '347890', 'Sales', null, '11/9/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Lissy', 'Williment', 'lwilliment29@gov.uk', '7 Mallard Place', '309509', 'Training', null, '9/28/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Doria', 'Baumann', 'dbaumann2a@devhub.com', '7 Mallory Alley', null, 'Support', null, '10/7/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Davidde', 'Haydock', 'dhaydock2b@ycombinator.com', '76 Eggendart Avenue', '3707', 'Support', true, '6/25/2020', '11/29/2020'); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Aylmer', 'O''Hagerty', 'aohagerty2c@yahoo.co.jp', '8 Mendota Crossing', '10105', 'Engineering', true, '3/10/2020', '5/25/2020'); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Brander', 'Bacop', 'bbacop2d@nba.com', '0757 Sauthoff Street', '976 33', 'Training', true, '1/11/2020', '12/11/2019'); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Dilan', 'Beden', 'dbeden2e@princeton.edu', '2676 Grim Lane', null, 'Accounting', false, '6/12/2020', '3/16/2020'); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Barbey', 'Sharkey', 'bsharkey2f@gnu.org', '609 Oxford Place', 'G8H', 'Legal', false, '3/6/2020', '9/8/2020'); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Wye', 'Peaddie', 'wpeaddie2g@washington.edu', '39 Kropf Point', '4516', 'Sales', null, '12/31/2019', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Rubetta', 'Lghan', 'rlghan2h@rediff.com', '04 Dovetail Avenue', null, 'Sales', false, '8/29/2020', '5/5/2020'); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Lianna', 'Gorry', 'lgorry2i@imgur.com', '38 Birchwood Drive', null, 'Business Development', null, '3/13/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Tab', 'Eshmade', 'teshmade2j@barnesandnoble.com', '77 Dottie Parkway', '055428', 'Marketing', null, '2/16/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Jaye', 'Hackett', 'ckalberer2k@biglobe.ne.jp', '3 Ronald Regan Junction', '412954', 'Design', true, '12/11/2019', '4/7/2020'); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Leland', 'Gotter', 'lgotter2l@e-recht24.de', '5281 Northwestern Circle', '7008', 'Marketing', true, '6/27/2020', '9/13/2020'); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Almeta', 'Quemby', 'aquemby2m@abc.net.au', '79 Cambridge Street', null, 'Accounting', true, '5/15/2020', '6/1/2020'); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Delora', 'Tillard', 'dtillard2n@mediafire.com', '56 Morning Center', '69820-000', 'Human Resources', true, '12/21/2019', '8/24/2020'); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Gaile', 'Shrimpton', 'gshrimpton2o@paginegialle.it', '44545 Jana Pass', '79300-000', 'Training', null, '3/25/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Lambert', 'Borrow', 'lborrow2p@google.ca', '31907 Shelley Lane', '55660-000', 'Business Development', null, '10/13/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Morly', 'Dobby', 'mdobby2q@kickstarter.com', '24977 Green Ridge Terrace', null, 'Business Development', null, '11/26/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Sharron', 'Leguey', 'sleguey2r@wikimedia.org', '527 1st Terrace', null, 'Training', false, '8/12/2020', '9/22/2020'); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Annabell', 'Pearman', 'apearman2s@purevolume.com', '28223 Colorado Parkway', null, 'Sales', null, '7/1/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Ricardo', 'Dale', 'rdale2t@tumblr.com', '84192 Lunder Lane', null, 'Legal', false, '9/11/2020', '10/1/2020'); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Ulrick', 'Thirtle', 'uthirtle2u@time.com', '460 Red Cloud Court', null, 'Human Resources', true, '7/20/2020', '1/16/2020'); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Aryn', 'O''Flannery', 'aoflannery2v@unblog.fr', '2845 Ludington Street', null, 'Accounting', null, '6/17/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Fabian', 'Eckels', 'feckels2w@abc.net.au', '1354 Spenser Pass', null, 'Sales', false, '2/9/2020', '11/10/2020'); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Hamil', 'MacDiarmond', 'hmacdiarmond2x@google.com.br', '506 Londonderry Alley', '2189', 'Business Development', false, '9/7/2020', '9/8/2020'); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Kacie', 'Sigge', 'ksigge2y@seattletimes.com', '7 Hudson Circle', null, 'Training', false, '10/28/2020', '3/17/2020'); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Pyotr', 'Ten Broek', 'ptenbroek2z@discovery.com', '7 Hansons Circle', '437-0026', 'Support', false, '1/18/2020', '11/3/2020'); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Erskine', 'Plose', 'eplose30@stanford.edu', '632 Prairieview Trail', null, 'Training', true, '5/21/2020', '6/18/2020'); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Lowe', 'Gerren', 'lgerren31@businessinsider.com', '72 Mariners Cove Road', '11401', 'Engineering', null, '11/23/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Luigi', 'Bladen', 'lbladen32@amazon.co.jp', '45 Marcy Terrace', null, 'Legal', null, '4/26/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Aime', 'Dormon', 'adormon33@1und1.de', '0743 Pankratz Point', '71150', 'Engineering', null, '8/2/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Korney', 'Chopin', 'kchopin34@miibeian.gov.cn', '45 Steensland Terrace', '02480', 'Legal', false, '8/11/2020', '4/27/2020'); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Nicolas', 'Flint', 'nflint35@tinyurl.com', '7 Petterle Terrace', '369273', 'Services', true, '9/12/2020', '1/20/2020'); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Gustaf', 'Hunnywell', 'ghunnywell36@soundcloud.com', '0422 Autumn Leaf Plaza', '46000', 'Accounting', false, '7/24/2020', '12/19/2019'); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Halimeda', 'Whitebread', 'hwhitebread37@ovh.net', '202 Schmedeman Avenue', '31000', 'Support', null, '4/16/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Spencer', 'Silwood', 'ssilwood38@flavors.me', '1 Dorton Road', '79165', 'Research and Development', null, '1/3/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Raychel', 'Bainbridge', 'rbainbridge39@answers.com', '76782 Schiller Center', '23-302', 'Research and Development', null, '4/17/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Bradly', 'Lintot', 'blintot3a@usnews.com', '29195 Waxwing Alley', null, 'Engineering', true, '10/10/2020', '9/25/2020'); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Sansone', 'Hitzschke', 'shitzschke3b@myspace.com', '14168 Bartillon Lane', '59208 CEDEX', 'Support', true, '12/29/2019', '7/17/2020'); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Jervis', 'Sichardt', 'jsichardt3c@gnu.org', '3532 Bashford Circle', '5070-227', 'Services', true, '2/24/2020', '11/14/2020'); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Olvan', 'Buffham', 'obuffham3d@aol.com', '21054 Porter Park', null, 'Accounting', false, '7/25/2020', '4/10/2020'); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Townsend', 'Colbourne', 'tcolbourne3e@lulu.com', '8 Emmet Avenue', '732 46', 'Accounting', false, '6/17/2020', '4/6/2020'); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Robert', 'Selesnick', 'rselesnick3f@china.com.cn', '47204 Prairieview Parkway', null, 'Sales', null, '3/17/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Kiri', 'Moffet', 'kmoffet3g@freewebs.com', '87967 Lakewood Center', null, 'Training', null, '4/28/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Sarena', 'Huggin', 'shuggin3h@vk.com', '15 Corry Center', '84605', 'Support', false, '8/7/2020', '12/26/2019'); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Beckie', 'Hubatsch', 'bhubatsch3i@ibm.com', '42042 Walton Drive', '739 51', 'Business Development', null, '10/24/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Codi', 'Mantione', 'cmantione3j@wordpress.com', '61 Forster Lane', '3025-353', 'Marketing', null, '10/12/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Jessy', 'Bunclark', 'jbunclark3k@squidoo.com', '2340 Anhalt Drive', null, 'Accounting', null, '2/26/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Marius', 'Summerskill', 'msummerskill3l@reference.com', '6262 Green Ridge Terrace', null, 'Research and Development', null, '10/28/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Arlana', 'Surgeon', 'asurgeon3m@mashable.com', '06 Vidon Avenue', null, 'Sales', null, '2/12/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Constancia', 'Gwin', 'cgwin3n@state.tx.us', '3424 Swallow Hill', null, 'Engineering', true, '5/26/2020', '2/18/2020'); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Cally', 'MacDaid', 'cmacdaid3o@github.com', '1996 Trailsway Junction', null, 'Human Resources', null, '12/12/2019', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Leonelle', 'Osmund', 'losmund3p@sphinn.com', '006 Elmside Alley', null, 'Research and Development', null, '11/22/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Tresa', 'Culmer', 'tculmer3q@feedburner.com', '8 Del Mar Lane', null, 'Legal', null, '11/15/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Claudianus', 'Botterill', 'cbotterill3r@ameblo.jp', '744 Golf Course Lane', null, 'Engineering', null, '7/19/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Junie', 'Goodyer', 'jgoodyer3s@nhs.uk', '447 Northland Lane', null, 'Engineering', null, '6/20/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Carleen', 'Morland', 'cmorland3t@fda.gov', '81 Lighthouse Bay Center', null, 'Training', false, '7/26/2020', '4/12/2020'); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Guinevere', 'Lenglet', 'glenglet3u@google.com.br', '78606 Messerschmidt Drive', null, 'Product Management', true, '3/17/2020', '1/8/2020'); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Bev', 'Fullegar', 'bfullegar3v@soundcloud.com', '726 Linden Road', null, 'Business Development', null, '3/17/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Caty', 'Spieck', 'cspieck3w@skype.com', '24 2nd Center', '57955-000', 'Legal', null, '4/17/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Zitella', 'MacPaike', 'zmacpaike3x@people.com.cn', '208 Glacier Hill Lane', '6270', 'Product Management', true, '8/20/2020', '8/1/2020'); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Laurette', 'Dignon', 'ldignon3y@wp.com', '70583 Fremont Center', null, 'Support', null, '6/19/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Neila', 'Prangle', 'nprangle3z@blinklist.com', '9 Pierstorff Way', null, 'Engineering', true, '5/25/2020', '1/27/2020'); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Jethro', 'Klagges', 'jklagges40@ucoz.com', '9090 Pearson Place', '7026', 'Legal', true, '11/22/2020', '5/4/2020'); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Leshia', 'Carley', 'lcarley41@lulu.com', '1613 Pierstorff Road', null, 'Services', true, '12/15/2019', '6/26/2020'); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Nariko', 'Ovendale', 'novendale42@t-online.de', '5719 Corscot Place', '48335', 'Sales', null, '11/22/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Tilda', 'Hallmark', 'thallmark43@vimeo.com', '06903 Dexter Alley', null, 'Business Development', true, '11/5/2020', '9/23/2020'); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Sophie', 'Coyett', 'scoyett44@comsenz.com', '893 Vidon Lane', null, 'Services', null, '3/27/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Shep', 'MacMurray', 'smacmurray45@sakura.ne.jp', '0431 Eagle Crest Pass', '671834', 'Product Management', null, '12/25/2019', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Lonni', 'Kliement', 'lkliement46@techcrunch.com', '43014 Packers Park', '75200-000', 'Training', null, '11/16/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Anastasie', 'Klees', 'aklees47@seattletimes.com', '421 Evergreen Place', '5505', 'Training', null, '2/21/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Garry', 'Dow', 'gdow48@bloomberg.com', '42279 Everett Hill', null, 'Research and Development', false, '2/17/2020', '2/6/2020'); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Chiquia', 'Bubbins', 'cbubbins49@bbc.co.uk', '270 Manitowish Road', null, 'Product Management', false, '10/26/2020', '8/9/2020'); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Corabella', 'Weatherburn', 'cweatherburn4a@smh.com.au', '1 Hanson Trail', null, 'Research and Development', true, '11/11/2020', '10/15/2020'); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Douglass', 'Matschoss', 'dmatschoss4b@shop-pro.jp', '0984 Novick Plaza', '442009', 'Marketing', null, '12/2/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Stern', 'Coaten', 'scoaten4c@who.int', '61925 Sauthoff Drive', null, 'Engineering', null, '5/20/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Dal', 'Blenkin', 'dblenkin4d@tinypic.com', '452 Memorial Avenue', '8410', 'Human Resources', false, '5/15/2020', '2/13/2020'); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Chiarra', 'Murname', 'cmurname4e@vkontakte.ru', '2 Columbus Street', null, 'Product Management', null, '7/2/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Terri', 'Iwanowski', 'tiwanowski4f@businesswire.com', '932 Hazelcrest Road', '63-417', 'Product Management', null, '11/18/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Aline', 'Smitherham', 'asmitherham4g@cnet.com', '00 Lillian Way', null, 'Services', null, '12/26/2019', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Bo', 'Brickhill', 'bbrickhill4h@seattletimes.com', '8757 East Lane', '97-306', 'Engineering', null, '12/19/2019', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Aarika', 'Dabel', 'adabel4i@earthlink.net', '115 Sherman Crossing', '5024', 'Research and Development', false, '8/10/2020', '6/27/2020'); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Adolph', 'Blazi', 'ablazi4j@harvard.edu', '77 Bultman Street', null, 'Marketing', true, '10/20/2020', '11/29/2020'); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Robbi', 'Westgarth', 'rwestgarth4k@yolasite.com', '62780 Corry Way', '603098', 'Human Resources', true, '3/19/2020', '7/5/2020'); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Antonin', 'Colleymore', 'acolleymore4l@scribd.com', '0597 Thackeray Hill', '580 01', 'Accounting', null, '2/27/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Margot', 'Ferne', 'mferne4m@nifty.com', '006 Westport Circle', null, 'Business Development', null, '1/11/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Elayne', 'MacMurray', 'emacmurray4n@live.com', '8 Lyons Hill', null, 'Support', false, '4/22/2020', '6/2/2020'); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Babbie', 'Bennit', 'bbennit4o@naver.com', '7 Ridge Oak Avenue', null, 'Sales', false, '5/25/2020', '4/9/2020'); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Modesta', 'Vakhrushev', 'mvakhrushev4p@com.com', '98645 Dawn Point', '81700', 'Training', null, '3/12/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Leontyne', 'Brezlaw', 'lbrezlaw4q@wunderground.com', '727 Esker Parkway', null, 'Research and Development', null, '1/31/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Meyer', 'Roja', 'mroja4r@wikia.com', '59526 Morning Park', null, 'Research and Development', false, '5/19/2020', '5/15/2020'); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Gannon', 'Egarr', 'gegarr4s@yolasite.com', '3 Sherman Place', '678944', 'Human Resources', null, '8/30/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Penny', 'Cretney', 'pcretney4t@a8.net', '269 Lien Avenue', '658741', 'Sales', null, '3/18/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Far', 'Tims', 'ftims4u@storify.com', '59 Truax Point', null, 'Training', null, '1/18/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Gizela', 'Sorrel', 'gsorrel4v@youku.com', '84 Delladonna Road', null, 'Support', null, '8/27/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Jeff', 'Stoke', 'jstoke4w@smugmug.com', '6950 Brickson Park Parkway', null, 'Sales', null, '5/24/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Stefanie', 'Templeman', 'stempleman4x@marriott.com', '981 Paget Trail', null, 'Services', null, '2/12/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Moselle', 'Gostling', 'mgostling4y@smugmug.com', '0932 Fallview Crossing', null, 'Research and Development', null, '4/28/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Zena', 'Insley', 'tinsley4z@merriam-webster.com', '52 Hooker Pass', '438 01', 'Training', null, '6/15/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Herbert', 'Howarth', 'hhowarth50@blogspot.com', '69 Clarendon Plaza', null, 'Product Management', null, '5/27/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Christi', 'Metzig', 'cmetzig51@seattletimes.com', '5239 Bayside Crossing', null, 'Training', null, '1/14/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Sauncho', 'Ormshaw', 'sormshaw52@netscape.com', '7 Union Circle', '44-290', 'Services', null, '1/31/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Kati', 'Thyer', 'kthyer53@cisco.com', '04057 Lawn Lane', null, 'Services', null, '12/24/2019', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Laure', 'Cutchey', 'lcutchey54@etsy.com', '1 Florence Street', null, 'Services', false, '5/29/2020', '11/9/2020'); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Maddi', 'Boutellier', 'mboutellier55@statcounter.com', '79 Buhler Hill', null, 'Product Management', true, '5/10/2020', '6/27/2020'); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Kally', 'Blythe', 'kblythe56@icio.us', '3964 Chive Avenue', null, 'Accounting', true, '4/17/2020', '1/20/2020'); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Pall', 'Soal', 'pduckering57@spiegel.de', '92 Barby Trail', null, 'Human Resources', null, '2/24/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Chico', 'Dionsetto', 'cdionsetto58@fastcompany.com', '30 Manitowish Point', null, 'Research and Development', null, '3/15/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Kendal', 'Soans', 'ksoans59@fda.gov', '621 Mosinee Place', null, 'Marketing', null, '1/18/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Mikkel', 'Matieu', 'mmatieu5a@techcrunch.com', '9 Kennedy Trail', '62-090', 'Support', false, '9/29/2020', '6/15/2020'); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Sherman', 'Leborgne', 'sleborgne5b@cocolog-nifty.com', '21013 Kipling Park', '98-105', 'Training', false, '10/11/2020', '3/2/2020'); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Prudence', 'Ciciura', 'pciciura5c@indiatimes.com', '68 Grim Avenue', '4610', 'Sales', null, '1/10/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Oralle', 'Hannay', 'ohannay5d@yale.edu', '3 Prairie Rose Point', null, 'Sales', true, '6/14/2020', '2/7/2020'); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Mattheus', 'Slator', 'mslator5e@wsj.com', '584 1st Junction', null, 'Research and Development', null, '11/17/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Sebastian', 'Sabatini', 'ssabatini5f@a8.net', '107 Rockefeller Pass', '3714', 'Research and Development', true, '5/20/2020', '1/10/2020'); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Ceil', 'Dragon', 'cdragon5g@unicef.org', '13948 Marquette Circle', '47-232', 'Training', true, '8/24/2020', '6/17/2020'); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Guido', 'Southey', 'gsouthey5h@geocities.jp', '16 Loomis Road', null, 'Support', null, '9/21/2020', null); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Zena', 'Soal', 'zsoal5i@ca.gov', '18 Heffernan Circle', '83-425', 'Accounting', true, '7/27/2020', '6/26/2020'); | |
| insert into employees (first_name, last_name, email, street_address, postcode, department, currently_employed, employed_from, employed_to) values ('Darci', 'Sorrill', 'dsorrill5j@dyndns.org', '091 Meadow Vale Drive', null, 'Business Development', null, '2/11/2020', null); | |
| insert into services (name, street_address, postcode, free, created_at) values ('Fliptune', 'Buckingham Palace, London', 'SW1A 1AA', false, '2/17/2020'); | |
| insert into services (name, street_address, postcode, free, created_at) values ('Aivee', 'Broadcasting House, Peel Wing, Portland Pl, London', 'W1A 1AA', false, '6/22/2020'); | |
| insert into services (name, street_address, postcode, free, created_at) values ('Skyba', 'Town Hall Pinstone Street, Sheffield, GB', 'S1 2HH', false, '6/17/2020'); | |
| insert into services (name, street_address, postcode, free, created_at) values ('Feednation', 'Motorpoint Arena Cardiff, Mary Ann St, Cardiff', 'CF10 2EQ', false, '9/12/2020'); | |
| insert into services (name, street_address, postcode, free, created_at) values ('Quatz', '20 St Thomas Street, London', 'SE1 9RG', true, '4/27/2020'); | |
| insert into services (name, street_address, postcode, free, created_at) values ('Eare', 'Edinburgh Waverley Station, Edinburgh', 'EH8 8DL', false, '5/17/2020'); | |
| insert into services (name, street_address, postcode, free, created_at) values ('Jabbercube', 'Brindleyplace, The Waters Edge, Birmingham, GB', 'B1 2HL', true, '2/24/2020'); | |
| insert into services (name, street_address, postcode, free, created_at) values ('Gevee', 'The Upper Mill, Kingston Road, Ewell, Surrey', 'KT17 2AF', true, '3/9/2020'); | |
| insert into services (name, street_address, postcode, free, created_at) values ('Quamba', 'Alexandra Palace, Wood Green, London, GB', 'N22 7AY', true, '10/23/2020'); | |
| insert into services (name, street_address, postcode, free, created_at) values ('Jetpulse', '55 Norfolk Street Sheffield', 'S1 1DA', true, '3/18/2020'); | |
| insert into locations (service_id, latitude, longitude, created_at) VALUES (1, 51.501009, -0.141588,'12/10/2020'); | |
| insert into locations (service_id, latitude, longitude, created_at) VALUES (2, 51.518561, -0.143799,'12/10/2020'); | |
| insert into locations (service_id, latitude, longitude, created_at) VALUES (3, 53.380384, -1.470006,'12/10/2020'); | |
| insert into locations (service_id, latitude, longitude, created_at) VALUES (4, 51.478914, -3.171759,'12/10/2020'); | |
| insert into locations (service_id, latitude, longitude, created_at) VALUES (5, 51.504642, -0.08899,'12/10/2020'); | |
| insert into locations (service_id, latitude, longitude, created_at) VALUES (6, 55.952623, -3.18135,'12/10/2020'); | |
| insert into locations (service_id, latitude, longitude, created_at) VALUES (7, 52.478182, -1.912008,'12/10/2020'); | |
| insert into locations (service_id, latitude, longitude, created_at) VALUES (8, 51.352525, -0.251579,'12/10/2020'); | |
| insert into locations (service_id, latitude, longitude, created_at) VALUES (9, 51.594481, -0.130527,'12/10/2020'); | |
| insert into locations (service_id, latitude, longitude, created_at) VALUES (10, 53.38108, -1.466765,'12/10/2020'); | |
| insert into posts (id, post_name, post_content, created_at) values (1, 'quis odio consequat varius integer ac leo pellentesque', 'Proin eu mi. Nulla ac enim. In tempor, turpis nec euismod scelerisque, quam turpis adipiscing lorem, vitae mattis nibh ligula nec sem. | |
| Duis aliquam convallis nunc. Proin at turpis a pede posuere nonummy. Integer non velit. | |
| Donec diam neque, vestibulum eget, vulputate ut, ultrices vel, augue. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Donec pharetra, magna vestibulum aliquet ultrices, erat tortor sollicitudin mi, sit amet lobortis sapien sapien non mi. Integer ac neque.', '6/10/2020'); | |
| insert into posts (id, post_name, post_content, created_at) values (2, 'amet diam in magna bibendum imperdiet', 'Aenean fermentum. Donec ut mauris eget massa tempor convallis. Nulla neque libero, convallis eget, eleifend luctus, ultricies eu, nibh. | |
| Quisque id justo sit amet sapien dignissim vestibulum. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Nulla dapibus dolor vel est. Donec odio justo, sollicitudin ut, suscipit a, feugiat et, eros. | |
| Vestibulum ac est lacinia nisi venenatis tristique. Fusce congue, diam id ornare imperdiet, sapien urna pretium nisl, ut volutpat sapien arcu sed augue. Aliquam erat volutpat. | |
| In congue. Etiam justo. Etiam pretium iaculis justo.', '9/25/2020'); | |
| insert into posts (id, post_name, post_content, created_at) values (3, 'convallis nunc proin at turpis', 'Phasellus sit amet erat. Nulla tempus. Vivamus in felis eu sapien cursus vestibulum. | |
| Proin eu mi. Nulla ac enim. In tempor, turpis nec euismod scelerisque, quam turpis adipiscing lorem, vitae mattis nibh ligula nec sem. | |
| Duis aliquam convallis nunc. Proin at turpis a pede posuere nonummy. Integer non velit. | |
| Donec diam neque, vestibulum eget, vulputate ut, ultrices vel, augue. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Donec pharetra, magna vestibulum aliquet ultrices, erat tortor sollicitudin mi, sit amet lobortis sapien sapien non mi. Integer ac neque. | |
| Duis bibendum. Morbi non quam nec dui luctus rutrum. Nulla tellus. | |
| In sagittis dui vel nisl. Duis ac nibh. Fusce lacus purus, aliquet at, feugiat non, pretium quis, lectus.', '1/23/2020'); | |
| insert into posts (id, post_name, post_content, created_at) values (4, 'nisi vulputate nonummy maecenas tincidunt lacus at velit vivamus vel', 'Aenean lectus. Pellentesque eget nunc. Donec quis orci eget orci vehicula condimentum. | |
| Curabitur in libero ut massa volutpat convallis. Morbi odio odio, elementum eu, interdum eu, tincidunt in, leo. Maecenas pulvinar lobortis est. | |
| Phasellus sit amet erat. Nulla tempus. Vivamus in felis eu sapien cursus vestibulum. | |
| Proin eu mi. Nulla ac enim. In tempor, turpis nec euismod scelerisque, quam turpis adipiscing lorem, vitae mattis nibh ligula nec sem. | |
| Duis aliquam convallis nunc. Proin at turpis a pede posuere nonummy. Integer non velit. | |
| Donec diam neque, vestibulum eget, vulputate ut, ultrices vel, augue. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Donec pharetra, magna vestibulum aliquet ultrices, erat tortor sollicitudin mi, sit amet lobortis sapien sapien non mi. Integer ac neque.', '7/27/2020'); | |
| insert into posts (id, post_name, post_content, created_at) values (5, 'pretium quis lectus suspendisse potenti in eleifend', 'Integer tincidunt ante vel ipsum. Praesent blandit lacinia erat. Vestibulum sed magna at nunc commodo placerat. | |
| Praesent blandit. Nam nulla. Integer pede justo, lacinia eget, tincidunt eget, tempus vel, pede.', '8/25/2020'); | |
| insert into posts (id, post_name, post_content, created_at) values (6, 'massa id nisl venenatis lacinia aenean sit amet justo morbi', 'Curabitur in libero ut massa volutpat convallis. Morbi odio odio, elementum eu, interdum eu, tincidunt in, leo. Maecenas pulvinar lobortis est. | |
| Phasellus sit amet erat. Nulla tempus. Vivamus in felis eu sapien cursus vestibulum. | |
| Proin eu mi. Nulla ac enim. In tempor, turpis nec euismod scelerisque, quam turpis adipiscing lorem, vitae mattis nibh ligula nec sem. | |
| Duis aliquam convallis nunc. Proin at turpis a pede posuere nonummy. Integer non velit. | |
| Donec diam neque, vestibulum eget, vulputate ut, ultrices vel, augue. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Donec pharetra, magna vestibulum aliquet ultrices, erat tortor sollicitudin mi, sit amet lobortis sapien sapien non mi. Integer ac neque. | |
| Duis bibendum. Morbi non quam nec dui luctus rutrum. Nulla tellus. | |
| In sagittis dui vel nisl. Duis ac nibh. Fusce lacus purus, aliquet at, feugiat non, pretium quis, lectus. | |
| Suspendisse potenti. In eleifend quam a odio. In hac habitasse platea dictumst. | |
| Maecenas ut massa quis augue luctus tincidunt. Nulla mollis molestie lorem. Quisque ut erat.', '11/8/2020'); | |
| insert into posts (id, post_name, post_content, created_at) values (7, 'faucibus rosebud orci luctus et ultrices', 'Praesent blandit. Nam nulla. Integer pede justo, lacinia eget, tincidunt eget, tempus vel, pede.', '6/18/2020'); | |
| insert into posts (id, post_name, post_content, created_at) values (8, 'ut rhoncus aliquet pulvinar sed nisl nunc rhoncus', 'Integer tincidunt ante vel ipsum. Praesent blandit lacinia erat. Vestibulum sed magna at nunc commodo placerat. | |
| Praesent blandit. Nam nulla. Integer pede justo, lacinia eget, tincidunt eget, tempus vel, pede.', '1/6/2020'); | |
| insert into posts (id, post_name, post_content, created_at) values (9, 'pharetra magna ac consequat metus sapien ut nunc', 'Quisque porta volutpat erat. Quisque erat eros, viverra eget, congue eget, semper rutrum, nulla. Nunc purus. | |
| Phasellus in felis. Donec semper sapien a libero. Nam dui. | |
| Proin leo odio, porttitor id, consequat in, consequat ut, nulla. Sed accumsan felis. Ut at dolor quis odio consequat varius. | |
| Integer ac leo. Pellentesque ultrices mattis odio. Donec vitae nisi. | |
| Nam ultrices, libero non mattis pulvinar, nulla pede ullamcorper augue, a suscipit nulla elit ac nulla. Sed vel enim sit amet nunc viverra dapibus. Nulla suscipit ligula in lacus. | |
| Curabitur at ipsum ac tellus semper interdum. Mauris ullamcorper purus sit amet nulla. Quisque arcu libero, rutrum ac, lobortis vel, dapibus at, diam.', '9/9/2020'); | |
| insert into posts (id, post_name, post_content, created_at) values (10, 'est congue elementum in hac habitasse platea', 'Nulla ut erat id mauris vulputate elementum. Nullam varius. Nulla facilisi. | |
| Cras non velit nec nisi vulputate nonummy. Maecenas tincidunt lacus at velit. Vivamus vel nulla eget eros elementum pellentesque.', '1/25/2020'); | |
| insert into posts (id, post_name, post_content, created_at) values (11, 'in tempus sit amet sem', 'Sed sagittis. Nam congue, risus semper porta volutpat, quam pede lobortis ligula, sit amet eleifend pede libero quis orci. Nullam molestie nibh in lectus. | |
| Pellentesque at nulla. Suspendisse potenti. Cras in purus eu magna vulputate luctus. | |
| Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Vivamus vestibulum sagittis sapien. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. | |
| Etiam vel augue. Vestibulum rutrum rutrum neque. Aenean auctor gravida sem. | |
| Praesent id massa id nisl venenatis lacinia. Aenean sit amet justo. Morbi ut odio. | |
| Cras mi pede, malesuada in, imperdiet et, commodo vulputate, justo. In blandit ultrices enim. Lorem ipsum dolor sit amet, consectetuer adipiscing elit. | |
| Proin interdum mauris non ligula pellentesque ultrices. Phasellus id sapien in sapien iaculis congue. Vivamus metus arcu, adipiscing molestie, hendrerit at, vulputate vitae, nisl.', '6/9/2020'); | |
| insert into posts (id, post_name, post_content, created_at) values (12, 'magnis dis parturient montes nascetur ridiculus', 'Curabitur gravida nisi at nibh. In hac habitasse platea dictumst. Aliquam augue quam, sollicitudin vitae, consectetuer eget, rutrum at, lorem. | |
| Integer tincidunt ante vel ipsum. Praesent blandit lacinia erat. Vestibulum sed magna at nunc commodo placerat. | |
| Praesent blandit. Nam nulla. Integer pede justo, lacinia eget, tincidunt eget, tempus vel, pede. | |
| Morbi porttitor lorem id ligula. Suspendisse ornare consequat lectus. In est risus, auctor sed, tristique in, tempus sit amet, sem. | |
| Fusce consequat. Nulla nisl. Nunc nisl. | |
| Duis bibendum, felis sed interdum venenatis, turpis enim blandit mi, in porttitor pede justo eu massa. Donec dapibus. Duis at velit eu est congue elementum. | |
| In hac habitasse platea dictumst. Morbi vestibulum, velit id pretium iaculis, diam erat fermentum justo, nec condimentum neque sapien placerat ante. Nulla justo. | |
| Aliquam quis turpis eget elit sodales scelerisque. Mauris sit amet eros. Suspendisse accumsan tortor quis turpis.', '2/16/2020'); | |
| insert into posts (id, post_name, post_content, created_at) values (13, 'fusce lacus purus aliquet at feugiat non pretium quis lectus', 'Pellentesque at nulla. Suspendisse potenti. Cras in purus eu magna vulputate luctus. | |
| Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Vivamus vestibulum sagittis sapien. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. | |
| Etiam vel augue. Vestibulum rutrum rutrum neque. Aenean auctor gravida sem. | |
| Praesent id massa id nisl venenatis lacinia. Aenean sit amet justo. Morbi ut odio. | |
| Cras mi pede, malesuada in, imperdiet et, commodo vulputate, justo. In blandit ultrices enim. Lorem ipsum dolor sit amet, consectetuer adipiscing elit. | |
| Proin interdum mauris non ligula pellentesque ultrices. Phasellus id sapien in sapien iaculis congue. Vivamus metus arcu, adipiscing molestie, hendrerit at, vulputate vitae, nisl. | |
| Aenean lectus. Pellentesque eget nunc. Donec quis orci eget orci vehicula condimentum.', '8/8/2020'); | |
| insert into posts (id, post_name, post_content, created_at) values (14, 'in quis justo maecenas rhoncus aliquam lacus morbi quis', 'In quis justo. Maecenas rhoncus aliquam lacus. Morbi quis tortor id nulla ultrices aliquet. | |
| Maecenas leo odio, condimentum id, luctus nec, molestie sed, justo. Pellentesque viverra pede ac diam. Cras pellentesque volutpat dui. | |
| Maecenas tristique, est et tempus semper, est quam pharetra magna, ac consequat metus sapien ut nunc. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Mauris viverra diam vitae quam. Suspendisse potenti. | |
| Nullam porttitor lacus at turpis. Donec posuere metus vitae ipsum. Aliquam non mauris. | |
| Morbi non lectus. Aliquam sit amet diam in magna bibendum imperdiet. Nullam orci pede, venenatis non, sodales sed, tincidunt eu, felis.', '3/2/2020'); | |
| insert into posts (id, post_name, post_content, created_at) values (15, 'at velit eu est congue elementum in hac', 'Nulla ut erat id mauris vulputate elementum. Nullam varius. Nulla facilisi.', '6/17/2020'); | |
| insert into posts (id, post_name, post_content, created_at) values (16, 'arcu libero rutrum ac lobortis vel dapibus at', 'Duis bibendum, felis sed interdum venenatis, turpis enim blandit mi, in porttitor pede justo eu massa. Donec dapibus. Duis at velit eu est congue elementum. | |
| In hac habitasse platea dictumst. Morbi vestibulum, velit id pretium iaculis, diam erat fermentum justo, nec condimentum neque sapien placerat ante. Nulla justo. | |
| Aliquam quis turpis eget elit sodales scelerisque. Mauris sit amet eros. Suspendisse accumsan tortor quis turpis. | |
| Sed ante. Vivamus tortor. Duis mattis egestas metus. | |
| Aenean fermentum. Donec ut mauris eget massa tempor convallis. Nulla neque libero, convallis eget, eleifend luctus, ultricies eu, nibh. | |
| Quisque id justo sit amet sapien dignissim vestibulum. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Nulla dapibus dolor vel est. Donec odio justo, sollicitudin ut, suscipit a, feugiat et, eros. | |
| Vestibulum ac est lacinia nisi venenatis tristique. Fusce congue, diam id ornare imperdiet, sapien urna pretium nisl, ut volutpat sapien arcu sed augue. Aliquam erat volutpat. | |
| In congue. Etiam justo. Etiam pretium iaculis justo. | |
| In hac habitasse platea dictumst. Etiam faucibus cursus urna. Ut tellus. | |
| Nulla ut erat id mauris vulputate elementum. Nullam varius. Nulla facilisi. | |
| Cras non velit nec nisi vulputate nonummy. Maecenas tincidunt lacus at velit. Vivamus vel nulla eget eros elementum pellentesque. | |
| Quisque porta volutpat erat. Quisque erat eros, viverra eget, congue eget, semper rutrum, nulla. Nunc purus.', '12/2/2020'); | |
| insert into posts (id, post_name, post_content, created_at) values (17, 'pede malesuada in imperdiet et commodo', 'Suspendisse potenti. In eleifend quam a odio. In hac habitasse platea dictumst. | |
| Maecenas ut massa quis augue luctus tincidunt. Nulla mollis molestie lorem. Quisque ut erat. | |
| Curabitur gravida nisi at nibh. In hac habitasse platea dictumst. Aliquam augue quam, sollicitudin vitae, consectetuer eget, rutrum at, lorem. | |
| Integer tincidunt ante vel ipsum. Praesent blandit lacinia erat. Vestibulum sed magna at nunc commodo placerat. | |
| Praesent blandit. Nam nulla. Integer pede justo, lacinia eget, tincidunt eget, tempus vel, pede.', '5/10/2020'); | |
| insert into posts (id, post_name, post_content, created_at) values (18, 'pede malesuada in imperdiet et commodo vulputate justo in blandit', 'Vestibulum quam sapien, varius ut, blandit non, interdum in, ante. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Duis faucibus accumsan odio. Curabitur convallis. | |
| Duis consequat dui nec nisi volutpat eleifend. Donec ut dolor. Morbi vel lectus in quam fringilla rhoncus. | |
| Mauris enim leo, rhoncus sed, vestibulum sit rosebud amet, cursus id, turpis. Integer aliquet, massa id lobortis convallis, tortor risus dapibus augue, vel accumsan tellus nisi eu orci. Mauris lacinia sapien quis libero. | |
| Nullam sit amet turpis elementum ligula vehicula consequat. Morbi a ipsum. Integer a nibh. | |
| In quis justo. Maecenas rhoncus aliquam lacus. Morbi quis tortor id nulla ultrices aliquet. | |
| Maecenas leo odio, condimentum id, luctus nec, molestie sed, justo. Pellentesque viverra pede ac diam. Cras pellentesque volutpat dui. | |
| Maecenas tristique, est et tempus semper, est quam pharetra magna, ac consequat metus sapien ut nunc. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Mauris viverra diam vitae quam. Suspendisse potenti.', '12/23/2019'); | |
| insert into posts (id, post_name, post_content, created_at) values (19, 'nisl venenatis lacinia aenean sit amet justo morbi ut odio', 'Curabitur in libero ut massa volutpat convallis. Morbi odio odio, elementum eu, interdum eu, tincidunt in, leo. Maecenas pulvinar lobortis est. | |
| Phasellus sit amet erat. Nulla tempus. Vivamus in felis eu sapien cursus vestibulum. | |
| Proin eu mi. Nulla ac enim. In tempor, turpis nec euismod scelerisque, quam turpis adipiscing lorem, vitae mattis nibh ligula nec sem. | |
| Duis aliquam convallis nunc. Proin at turpis rosebud a pede posuere nonummy. Integer non velit. | |
| Donec diam neque, vestibulum eget, vulputate ut, ultrices vel, augue. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Donec pharetra, magna vestibulum aliquet ultrices, erat tortor sollicitudin mi, sit amet lobortis sapien sapien non mi. Integer ac neque. | |
| Duis bibendum. Morbi non quam nec dui luctus rutrum. Nulla tellus. | |
| In sagittis dui vel nisl. Duis ac nibh. Fusce lacus purus, aliquet at, feugiat non, pretium quis, lectus. | |
| Suspendisse potenti. In eleifend quam a odio. In hac habitasse platea dictumst. | |
| Maecenas ut massa quis augue luctus tincidunt. Nulla mollis molestie lorem. Quisque ut erat.', '9/4/2020'); | |
| insert into posts (id, post_name, post_content, created_at) values (20, 'ligula suspendisse rosebud ornare consequat lectus in est risus auctor sed', 'Cras mi pede, malesuada in, imperdiet et, commodo vulputate, justo. In blandit ultrices enim. Lorem ipsum dolor sit amet, consectetuer adipiscing elit. | |
| Proin interdum mauris non ligula pellentesque ultrices. Phasellus id sapien in sapien iaculis congue. Vivamus metus arcu, adipiscing molestie, hendrerit at, vulputate vitae, nisl. | |
| Aenean lectus. Pellentesque eget nunc. Donec quis orci eget orci vehicula condimentum. | |
| Curabitur in libero ut massa volutpat convallis. Morbi odio odio, elementum eu, interdum eu, tincidunt in, leo. Maecenas pulvinar lobortis est. | |
| Phasellus sit amet erat. Nulla tempus. Vivamus in felis eu sapien cursus vestibulum. | |
| Proin eu mi. Nulla ac enim. In tempor, turpis nec euismod scelerisque, quam turpis adipiscing lorem, vitae mattis nibh ligula nec sem. | |
| Duis aliquam convallis nunc. Proin at turpis a pede posuere nonummy. Integer non velit. | |
| Donec diam neque, vestibulum eget, vulputate ut, ultrices vel, augue. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Donec pharetra, magna vestibulum aliquet ultrices, erat tortor sollicitudin mi, sit amet lobortis sapien sapien non mi. Integer ac neque. | |
| Duis bibendum. Morbi non quam nec dui luctus rutrum. Nulla tellus. | |
| In sagittis dui vel nisl. Duis rosebud ac nibh. Fusce lacus purus, aliquet at, feugiat non, pretium quis, lectus.', '9/13/2020'); | |
| -- -------------------- | |
| -- SOLUTIONS BELOW HERE | |
| -- -------------------- | |
| -- ------------------------------------- | |
| -- REALLY, YOU'RE ABOUT TO SPOIL THE FUN | |
| -- ------------------------------------- | |
| -- -------------------- | |
| -- OKAY, YOU WERE WARNED | |
| -- -------------------- | |
| -- 1. | |
| -- SELECT * FROM employees | |
| -- 2. | |
| -- SELECT * FROM employees | |
| -- WHERE first_name='Jaye' | |
| -- 3. | |
| -- SELECT DISTINCT department FROM employees | |
| -- 4. | |
| -- INSERT INTO employees (first_name, last_name) | |
| -- VALUES ('My', 'Name here'); | |
| -- SELECT * FROM employees | |
| -- WHERE first_name='My'; | |
| -- 5. | |
| -- UPDATE employees | |
| -- SET department='Technology' | |
| -- WHERE first_name='Jaye'; | |
| -- SELECT * FROM employees | |
| -- WHERE first_name='Jaye'; | |
| -- 6. | |
| -- DELETE FROM employees | |
| -- WHERE first_name='Zena' | |
| -- AND last_name='Soal'; | |
| -- SELECT * FROM employees | |
| -- WHERE first_name='Zena' | |
| -- AND last_name='Soal'; | |
| -- 7. | |
| -- SELECT services.*, locations.* | |
| -- FROM services | |
| -- INNER JOIN locations ON services.id=locations.service_id; | |
| -- 8. | |
| -- we'll pretend we're at: 8 Southwark St, London SE1 1TL | |
| -- the lat/lng coordinates are: | |
| -- 51.50548, -0.090756 | |
| -- SELECT | |
| -- services.*, | |
| -- locations.latitude AS latitude, | |
| -- locations.longitude AS longitude, | |
| -- ( 3959 * acos( | |
| -- cos( radians( 51.50548 ) ) | |
| -- * cos( radians( locations.latitude ) ) | |
| -- * cos( radians( locations.longitude ) - radians( -0.090756 ) ) | |
| -- + sin( radians( 51.50548 ) ) | |
| -- * sin( radians( locations.latitude ) ) | |
| -- ) ) | |
| -- AS distance | |
| -- FROM services | |
| -- INNER JOIN locations ON services.id=locations.service_id; | |
| -- 9. | |
| -- as above, but add this line to the bottom of the query: | |
| -- ORDER BY distance ASC; | |
| -- 10. | |
| -- you're on your own for this one | |
| -- take a look at: https://www.postgresql.org/docs/9.5/textsearch-tables.html#TEXTSEARCH-TABLES-SEARCH |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment