demo postgresql database for learning sql

learn-sql-demo-db.sql

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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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