blp104-090525

docker-compose.yml

services:
  db:
    image: postgres:latest
    container_name: postgres_db
    environment:
      POSTGRES_DB: mydatabase
      POSTGRES_USER: myuser
      POSTGRES_PASSWORD: mypassword
    ports:
      - "5432:5432"
    volumes:
      - ./init-slayt.sql:/docker-entrypoint-initdb.d/init.sql

init-slayt.sql

create table staff (
	id INT,
	first_name VARCHAR(50),
	last_name VARCHAR(50),
	email VARCHAR(50),
	gender VARCHAR(50),
	title VARCHAR(50),
	branch_id INT,
  salary DECIMAL(10,2),
  PRIMARY KEY(id)
);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (1, 'Powell', 'Charle', 'pcharle0@dagondesign.com', 'Male', 'Supervisor', 4,108919);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (2, 'Ellie', 'Arguile', 'earguile1@infoseek.co.jp', 'Non-binary', 'Supervisor',4,115733);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (3, 'Sunny', 'Padbury', 'spadbury2@smugmug.com', 'Female', 'Assistant', 4,52966);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (4, 'Washington', 'Antognozzii', 'wantognozzii3@creativecommons.org', 'Male', 'Supervisor', 5,60422);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (5, 'Tilda', 'Graver', 'tgraver4@elegantthemes.com', 'Female', 'Assistant', 1,125026);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (6, 'Chaim', 'Reaper', 'creaper5@gmpg.org', 'Male', 'Assistant', 4,97184);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (7, 'Burke', 'Bockler', 'bbockler6@shutterfly.com', 'Male', 'Supervisor', 5,55615);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (8, 'Yorgo', 'Candy', 'ycandy7@webs.com', 'Male', 'Assistant', 2,118321);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (9, 'Ermin', 'Posselt', 'eposselt8@stumbleupon.com', 'Male', 'Manager', 3,57293);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (10, 'Dennet', 'Conre', 'dconre9@ebay.co.uk', 'Male', 'Assistant', 4,61779);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (11, 'Vinson', 'Joutapavicius', 'vjoutapaviciusa@techcrunch.com', 'Male', 'Assistant', 4,126071);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (12, 'Ernest', 'Buyers', 'ebuyersb@hp.com', 'Male', 'Assistant', 3,111751);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (13, 'Cristin', 'Mew', 'cmewc@berkeley.edu', 'Female', 'Supervisor', 2,65360);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (14, 'Vidovik', 'Sibbons', 'vsibbonsd@themeforest.net', 'Male', 'Manager', 3,98824);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (15, 'Darwin', 'Grayling', 'dgraylinge@blogs.com', 'Male', 'Assistant', 1,121624);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (16, 'Elden', 'Showers', 'eshowersf@delicious.com', 'Male', 'Supervisor', 3,102550);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (17, 'Shem', 'Touson', 'stousong@tmall.com', 'Male', 'Manager', 2,112828);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (18, 'Hally', 'Jewett', 'hjewetth@whitehouse.gov', 'Female', 'Assistant', 4,79578);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (19, 'Darbie', 'Diack', 'ddiacki@kickstarter.com', 'Genderqueer', 'Assistant', 2,46150);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (20, 'Ellary', 'Le Galle', 'elegallej@naver.com', 'Male', 'Assistant', 5,95990);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (21, 'Joelly', 'Liggins', 'jligginsk@princeton.edu', 'Female', 'Assistant', 1,122884);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (22, 'Imelda', 'Franies', 'ifraniesl@techcrunch.com', 'Female', 'Assistant', 4,111920);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (23, 'Lev', 'Storck', 'lstorckm@lulu.com', 'Male', 'Manager', 1,74334);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (24, 'Rozalie', 'Hector', 'rhectorn@comcast.net', 'Female', 'Assistant', 1,69348);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (25, 'Paulina', 'Basham', 'pbashamo@e-recht24.de', 'Female', 'Assistant', 4,90758);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (26, 'Beverlie', 'Bleyman', 'bbleymanp@bloglines.com', 'Female', 'Assistant', 1,123643);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (27, 'Roth', 'Tripcony', 'rtripconyq@biblegateway.com', 'Male', 'Supervisor', 3,83446);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (28, 'Launce', 'Ebbens', 'lebbensr@themeforest.net', 'Male', 'Assistant', 5,123810);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (29, 'Wells', 'Bushnell', 'wbushnells@japanpost.jp', 'Male', 'Assistant', 2,125928);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (30, 'Lelia', 'McGarva', 'lmcgarvat@php.net', 'Female', 'Supervisor', 3,94983);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (31, 'Ettore', 'Lanchberry', 'elanchberryu@usnews.com', 'Male', 'Assistant', 2,94240);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (32, 'Andra', 'MacMarcuis', 'amacmarcuisv@dmoz.org', 'Female', 'Assistant', 5,49190);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (33, 'Dorian', 'Klemmt', 'dklemmtw@theglobeandmail.com', 'Male', 'Assistant', 2,86588);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (34, 'Morry', 'O''Regan', 'moreganx@jugem.jp', 'Male', 'Assistant', 4,124610);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (35, 'Britt', 'Domanek', 'bdomaneky@stanford.edu', 'Male', 'Manager', 1,67097);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (36, 'Andris', 'Tansey', 'atanseyz@nytimes.com', 'Male', 'Manager', 2,62015);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (37, 'Kim', 'Bittlestone', 'kbittlestone10@va.gov', 'Female', 'Assistant', 4,63274);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (38, 'Jennette', 'Tregona', 'jtregona11@soup.io', 'Female', 'Supervisor', 4,98284);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (39, 'Dory', 'McKeaveney', 'dmckeaveney12@51.la', 'Male', 'Assistant', 5,52281);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (40, 'Edgard', 'Charsley', 'echarsley13@skype.com', 'Male', 'Assistant', 4,73392);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (41, 'Noah', 'Eddleston', 'neddleston14@usa.gov', 'Male', 'Supervisor', 1,111055);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (42, 'Rochester', 'Schwandt', 'rschwandt15@example.com', 'Male', 'Assistant', 1,66162);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (43, 'Noach', 'Ledwitch', 'nledwitch16@angelfire.com', 'Male', 'Assistant', 2,77759);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (44, 'Kristina', 'Francioli', 'kfrancioli17@dion.ne.jp', 'Female', 'Assistant', 5,120063);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (45, 'Anthony', 'Tailby', 'atailby18@walmart.com', 'Male', 'Assistant', 3,66941);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (46, 'Malinde', 'Lartice', 'mlartice19@angelfire.com', 'Female', 'Assistant', 5,73034);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (47, 'Noah', 'Chasteney', 'nchasteney1a@bloglines.com', 'Male', 'Assistant', 3,108827);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (48, 'Blanche', 'Grayling', 'bgrayling1b@ucoz.ru', 'Female', 'Assistant', 4,95336);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (49, 'Baryram', 'Mowling', 'bmowling1c@gravatar.com', 'Male', 'Manager', 4,90821);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (50, 'Fanni', 'Maestrini', 'fmaestrini1d@github.io', 'Female', 'Assistant', 4,54578);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (51, 'Lulu', 'Mayhead', 'lmayhead1e@livejournal.com', 'Female', 'Manager', 2,54321);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (52, 'Konstanze', 'Kyngdon', 'kkyngdon1f@flickr.com', 'Female', 'Assistant', 1,78846);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (53, 'Viv', 'Llorens', 'vllorens1g@mail.ru', 'Female', 'Manager', 2,74082);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (54, 'Nobe', 'Rigby', 'nrigby1h@livejournal.com', 'Male', 'Assistant', 1,127428);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (55, 'Danit', 'Fairbeard', 'dfairbeard1i@theatlantic.com', 'Female', 'Manager', 5,53524);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (56, 'Adora', 'Bown', 'abown1j@4shared.com', 'Female', 'Manager', 5,54563);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (57, 'Benny', 'Canaan', 'bcanaan1k@biblegateway.com', 'Male', 'Manager', 4,54375);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (58, 'Rori', 'Maffei', 'rmaffei1l@furl.net', 'Female', 'Assistant', 3,95999);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (59, 'Lacee', 'Duffield', 'lduffield1m@redcross.org', 'Genderfluid', 'Supervisor', 4,76694);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (60, 'Aldus', 'Simeons', 'asimeons1n@meetup.com', 'Male', 'Assistant', 1,80744);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (61, 'Dido', 'Wathan', 'dwathan1o@biblegateway.com', 'Female', 'Assistant', 3,85085);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (62, 'Raymond', 'Weinmann', 'rweinmann1p@craigslist.org', 'Male', 'Assistant', 2,100138);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (63, 'Vivyanne', 'Robjents', 'vrobjents1q@usa.gov', 'Female', 'Supervisor', 4,103203);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (64, 'Mateo', 'Foucher', 'mfoucher1r@ucsd.edu', 'Male', 'Assistant', 4,69346);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (65, 'Gauthier', 'Smaile', 'gsmaile1s@oakley.com', 'Male', 'Manager', 2,120662);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (66, 'Forester', 'Dilliway', 'fdilliway1t@diigo.com', 'Male', 'Assistant', 1,97041);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (67, 'Rooney', 'Gregori', 'rgregori1u@uiuc.edu', 'Male', 'Supervisor', 3,116412);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (68, 'Otto', 'Neljes', 'oneljes1v@netlog.com', 'Male', 'Assistant', 1,100570);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (69, 'Randell', 'Pile', 'rpile1w@paypal.com', 'Male', 'Supervisor', 3,90618);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (70, 'Rhodia', 'Darrigrand', 'rdarrigrand1x@rediff.com', 'Female', 'Assistant', 1,63908);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (71, 'Felicia', 'Pryn', 'fpryn1y@rakuten.co.jp', 'Female', 'Assistant', 3,94545);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (72, 'Christean', 'Montfort', 'cmontfort1z@earthlink.net', 'Female', 'Supervisor', 5,85039);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (73, 'Bell', 'Torrent', 'btorrent20@sina.com.cn', 'Female', 'Assistant', 1,74860);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (74, 'Joanie', 'Pittendreigh', 'jpittendreigh21@prweb.com', 'Female', 'Supervisor', 2,74442);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (75, 'Tandy', 'Scrauniage', 'tscrauniage22@netscape.com', 'Female', 'Manager', 2,77969);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (76, 'Dan', 'Mewett', 'dmewett23@wired.com', 'Male', 'Assistant', 4,112557);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (77, 'Giuseppe', 'Roscher', 'groscher24@sourceforge.net', 'Male', 'Assistant', 4,108245);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (78, 'Worthy', 'Jeannet', 'wjeannet25@jiathis.com', 'Male', 'Manager', 2,91964);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (79, 'Alvera', 'MacGovern', 'amacgovern26@prweb.com', 'Female', 'Assistant', 4,109340);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (80, 'Brion', 'Schapero', 'bschapero27@angelfire.com', 'Male', 'Assistant', 4,59605);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (81, 'Zedekiah', 'Attride', 'zattride28@msn.com', 'Male', 'Manager', 3,94057);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (82, 'Baldwin', 'Marmion', 'bmarmion29@usda.gov', 'Male', 'Assistant', 2,102188);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (83, 'Kayne', 'Bretland', 'kbretland2a@noaa.gov', 'Male', 'Manager', 2,105817);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (84, 'Hebert', 'Danilishin', 'hdanilishin2b@ning.com', 'Male', 'Assistant', 4,55117);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (85, 'Hayden', 'Romeo', 'hromeo2c@studiopress.com', 'Male', 'Assistant', 5,70848);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (86, 'Ariana', 'Robathon', 'arobathon2d@hp.com', 'Bigender', 'Supervisor', 2,54472);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (87, 'Bryanty', 'Davidowsky', 'bdavidowsky2e@cdc.gov', 'Male', 'Assistant', 3,119705);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (88, 'Trudie', 'Cromarty', 'tcromarty2f@newsvine.com', 'Female', 'Assistant', 3,87827);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (89, 'Faye', 'Tommasuzzi', 'ftommasuzzi2g@angelfire.com', 'Female', 'Manager', 4,59499);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (90, 'Retha', 'Geraud', 'rgeraud2h@rambler.ru', 'Female', 'Assistant', 5,117247);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (91, 'Beckie', 'Giamitti', 'bgiamitti2i@ted.com', 'Female', 'Manager', 2,125905);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (92, 'Damian', 'Dreossi', 'ddreossi2j@yellowbook.com', 'Male', 'Supervisor', 1,105833);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (93, 'Pammie', 'Weiss', 'pweiss2k@symantec.com', 'Female', 'Manager', 4,92449);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (94, 'Adi', 'Oxton', 'aoxton2l@examiner.com', 'Female', 'Supervisor', 3,83190);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (95, 'Dennis', 'Jilkes', 'djilkes2m@g.co', 'Male', 'Assistant', 3,79198);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (96, 'Lynelle', 'Briston', 'lbriston2n@ca.gov', 'Female', 'Assistant', 2,82385);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (97, 'Pate', 'Barensen', 'pbarensen2o@nymag.com', 'Male', 'Assistant', 5,50041);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (98, 'Jonas', 'Counter', 'jcounter2p@salon.com', 'Male', 'Manager', 1,54431);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (99, 'Gigi', 'Ivanikov', 'givanikov2q@berkeley.edu', 'Female', 'Assistant', 1,122365);
insert into staff (id, first_name, last_name, email, gender, title, branch_id, salary) values (100, 'Arlette', 'Rapson', 'arapson2r@merriam-webster.com', 'Female', 'Supervisor', 5,61160);


create table branch (
  id INT,
  name VARCHAR(50),
  address VARCHAR(50),
  city VARCHAR(50),
  country VARCHAR(50),
  postal_code VARCHAR(50),
  phone_number VARCHAR(50),
  PRIMARY KEY(id)
);
insert into branch (id, name, address, city, country, postal_code, phone_number) values (1, 'Nlounge', '330 Carioca Hill', 'Ovacik', 'Turkey', '35890', '994-621-1522');
insert into branch (id, name, address, city, country, postal_code, phone_number) values (2, 'Riffpath', '664 High Crossing Pass', 'Merkezköy', 'Turkey', '34829', '411-387-5233');
insert into branch (id, name, address, city, country, postal_code, phone_number) values (3, 'Blogtag', '39 Raven Hill', 'Yeniköy', 'Turkey', '09400', '383-889-1709');
insert into branch (id, name, address, city, country, postal_code, phone_number) values (4, 'Vinte', '07 Acker Crossing', 'Yeniköy', 'Turkey', '45600', '503-439-5454');
insert into branch (id, name, address, city, country, postal_code, phone_number) values (5, 'Wikido', '89 Rieder Court', 'Yeniköy', 'Turkey', '09400', '928-551-6920');

create table customer (
	id INT,
	first_name VARCHAR(50),
	last_name VARCHAR(50),
	gender VARCHAR(50),
	email VARCHAR(50),
	phone_number VARCHAR(50)
);
insert into customer (id, first_name, last_name, gender, email, phone_number) values (1, 'Rube', 'Siebart', 'Male', 'rsiebart0@china.com.cn', '519-800-0437');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (2, 'Noni', 'Brocks', 'Female', 'nbrocks1@tmall.com', '266-372-0468');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (3, 'Rafaelia', 'Bestwall', 'Female', 'rbestwall2@alexa.com', '387-548-3541');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (4, 'Phineas', 'Teissier', 'Male', 'pteissier3@java.com', '768-429-6537');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (5, 'Hastie', 'Stanton', 'Male', 'hstanton4@bigcartel.com', '496-562-2822');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (6, 'Sutton', 'Gauche', 'Agender', 'sgauche5@ovh.net', '364-465-3377');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (7, 'Gianni', 'Alekhov', 'Male', 'galekhov6@chron.com', '213-557-6331');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (8, 'Willa', 'Silverwood', 'Agender', 'wsilverwood7@amazon.co.uk', '272-955-9642');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (9, 'Saundra', 'MacCurtain', 'Female', 'smaccurtain8@google.cn', '673-363-4118');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (10, 'Westleigh', 'Willerson', 'Agender', 'wwillerson9@smugmug.com', '222-581-0601');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (11, 'Pepi', 'Kopfen', 'Female', 'pkopfena@elpais.com', '809-405-2233');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (12, 'Kent', 'Kenway', 'Non-binary', 'kkenwayb@kickstarter.com', '263-553-3398');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (13, 'Ruddy', 'Mohammed', 'Male', 'rmohammedc@so-net.ne.jp', '909-974-0102');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (14, 'Ddene', 'Tomblett', 'Female', 'dtomblettd@imgur.com', '450-693-1062');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (15, 'Hayward', 'Sherborne', 'Bigender', 'hsherbornee@reference.com', '431-959-9600');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (16, 'Kent', 'Thaxton', 'Male', 'kthaxtonf@youtube.com', '212-349-6569');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (17, 'Jerrilee', 'Khoter', 'Female', 'jkhoterg@theguardian.com', '242-387-1413');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (18, 'Benjamen', 'Kerfod', 'Male', 'bkerfodh@mit.edu', '897-586-4385');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (19, 'Wanids', 'Pomfret', 'Female', 'wpomfreti@ycombinator.com', '313-386-5285');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (20, 'Trenna', 'Daventry', 'Non-binary', 'tdaventryj@amazon.de', '293-136-7157');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (21, 'Nancy', 'Thurby', 'Female', 'nthurbyk@ibm.com', '673-322-6942');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (22, 'Cornela', 'Chin', 'Female', 'cchinl@digg.com', '467-255-8843');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (23, 'Galina', 'De Laspee', 'Female', 'gdelaspeem@yahoo.co.jp', '102-838-5539');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (24, 'Marketa', 'Radclyffe', 'Female', 'mradclyffen@wsj.com', '474-640-1845');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (25, 'Alfie', 'Veel', 'Male', 'aveelo@tumblr.com', '403-218-5159');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (26, 'Mag', 'Fairbairn', 'Female', 'mfairbairnp@nbcnews.com', '151-505-8438');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (27, 'Pinchas', 'Sergent', 'Genderqueer', 'psergentq@hc360.com', '206-541-1339');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (28, 'Noby', 'MacGahey', 'Male', 'nmacgaheyr@columbia.edu', '368-389-1544');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (29, 'Alexander', 'Bierton', 'Male', 'abiertons@ifeng.com', '853-508-4887');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (30, 'Janaya', 'Grise', 'Female', 'jgriset@epa.gov', '141-310-4311');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (31, 'Benito', 'Arnowicz', 'Male', 'barnowiczu@nsw.gov.au', '740-735-4010');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (32, 'Trudi', 'Plaschke', 'Female', 'tplaschkev@drupal.org', '259-696-7594');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (33, 'Pasquale', 'Olliff', 'Male', 'polliffw@tumblr.com', '914-763-9325');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (34, 'Harris', 'McIntosh', 'Male', 'hmcintoshx@aol.com', '863-253-3658');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (35, 'Stavro', 'Vaneev', 'Male', 'svaneevy@t.co', '307-613-2237');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (36, 'Horton', 'Chardin', 'Male', 'hchardinz@sohu.com', '599-529-7777');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (37, 'Karmen', 'Rosita', 'Female', 'krosita10@flickr.com', '205-185-1206');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (38, 'Lennard', 'Creggan', 'Male', 'lcreggan11@last.fm', '581-447-1075');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (39, 'Naoma', 'Slogrove', 'Female', 'nslogrove12@seattletimes.com', '985-932-7664');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (40, 'Marjory', 'Hritzko', 'Female', 'mhritzko13@de.vu', '210-348-7897');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (41, 'Jorge', 'Renfrew', 'Bigender', 'jrenfrew14@sourceforge.net', '623-194-5211');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (42, 'Eduardo', 'Surmeyers', 'Male', 'esurmeyers15@craigslist.org', '725-719-2506');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (43, 'Elyssa', 'Pfaffel', 'Female', 'epfaffel16@who.int', '286-265-6769');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (44, 'Elie', 'Venney', 'Non-binary', 'evenney17@state.tx.us', '199-548-2188');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (45, 'Sandro', 'Rainey', 'Male', 'srainey18@nps.gov', '131-125-3745');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (46, 'Jacqueline', 'Ragsdall', 'Female', 'jragsdall19@dailymotion.com', '823-286-2064');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (47, 'Darwin', 'Reding', 'Male', 'dreding1a@house.gov', '693-808-7779');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (48, 'Germaine', 'Menlow', 'Male', 'gmenlow1b@jugem.jp', '526-967-4407');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (49, 'Barri', 'Ambler', 'Male', 'bambler1c@nationalgeographic.com', '770-818-2266');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (50, 'Robinson', 'Sponer', 'Male', 'rsponer1d@earthlink.net', '945-730-4978');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (51, 'Jilli', 'Broggio', 'Female', 'jbroggio1e@nasa.gov', '344-783-6612');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (52, 'Anneliese', 'Eskrigg', 'Female', 'aeskrigg1f@51.la', '261-393-5140');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (53, 'Ailbert', 'Jaquet', 'Male', 'ajaquet1g@wp.com', '191-184-2837');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (54, 'Olivero', 'Wringe', 'Male', 'owringe1h@google.co.uk', '924-764-5697');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (55, 'Innis', 'Hogbin', 'Male', 'ihogbin1i@apple.com', '763-856-8949');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (56, 'Barbee', 'Pepperd', 'Female', 'bpepperd1j@domainmarket.com', '610-603-0923');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (57, 'Joey', 'Abramcik', 'Male', 'jabramcik1k@plala.or.jp', '420-873-4512');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (58, 'Denise', 'Abden', 'Female', 'dabden1l@themeforest.net', '424-378-0954');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (59, 'Ric', 'Esherwood', 'Male', 'resherwood1m@yellowpages.com', '353-600-3001');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (60, 'Marion', 'Ferrino', 'Female', 'mferrino1n@google.com.au', '699-593-8127');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (61, 'Jesus', 'Sawl', 'Male', 'jsawl1o@google.de', '977-373-1877');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (62, 'Rowen', 'Wesgate', 'Male', 'rwesgate1p@cyberchimps.com', '772-333-3295');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (63, 'Dorene', 'Kidston', 'Female', 'dkidston1q@de.vu', '695-819-6635');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (64, 'Katey', 'Stott', 'Female', 'kstott1r@auda.org.au', '371-850-8630');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (65, 'Fania', 'Holmyard', 'Female', 'fholmyard1s@nifty.com', '405-250-2025');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (66, 'Barthel', 'Andrys', 'Male', 'bandrys1t@usda.gov', '642-169-0839');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (67, 'Osbert', 'McIlrath', 'Male', 'omcilrath1u@cocolog-nifty.com', '890-168-5785');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (68, 'Bendix', 'Reyna', 'Male', 'breyna1v@joomla.org', '502-483-9956');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (69, 'Meridith', 'Tugman', 'Female', 'mtugman1w@who.int', '849-785-1265');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (70, 'Barney', 'Rankling', 'Male', 'brankling1x@pinterest.com', '577-221-9676');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (71, 'Carver', 'Essery', 'Male', 'cessery1y@time.com', '434-547-3491');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (72, 'Phil', 'Beckhurst', 'Female', 'pbeckhurst1z@chron.com', '366-849-5461');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (73, 'Sile', 'Gherardini', 'Female', 'sgherardini20@oakley.com', '852-809-9502');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (74, 'Berkley', 'Pantry', 'Bigender', 'bpantry21@over-blog.com', '103-688-6716');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (75, 'Alistair', 'Harmes', 'Male', 'aharmes22@pcworld.com', '318-958-6272');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (76, 'Alden', 'Wickenden', 'Male', 'awickenden23@usa.gov', '580-206-9721');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (77, 'Janella', 'Letrange', 'Female', 'jletrange24@prlog.org', '519-468-1420');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (78, 'Oates', 'Stockney', 'Male', 'ostockney25@dell.com', '291-184-5336');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (79, 'Vern', 'Corwin', 'Male', 'vcorwin26@blogger.com', '406-653-5924');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (80, 'Cybil', 'Powlesland', 'Female', 'cpowlesland27@webnode.com', '396-247-0929');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (81, 'Elberta', 'Pybus', 'Female', 'epybus28@japanpost.jp', '689-672-2881');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (82, 'Druci', 'Kitcat', 'Female', 'dkitcat29@cdbaby.com', '393-192-0338');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (83, 'Collie', 'Radbourne', 'Female', 'cradbourne2a@cocolog-nifty.com', '526-765-7493');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (84, 'Kissiah', 'O''Fogarty', 'Female', 'kofogarty2b@storify.com', '862-856-2021');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (85, 'Ronda', 'Burg', 'Female', 'rburg2c@java.com', '477-295-3519');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (86, 'Salomi', 'Sertin', 'Female', 'ssertin2d@thetimes.co.uk', '182-466-1713');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (87, 'Andee', 'Hitzke', 'Female', 'ahitzke2e@bbb.org', '529-418-0224');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (88, 'Tiertza', 'Bogey', 'Female', 'tbogey2f@xinhuanet.com', '810-886-5796');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (89, 'Debbie', 'Gianotti', 'Female', 'dgianotti2g@geocities.jp', '870-101-5059');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (90, 'Madelene', 'Granville', 'Female', 'mgranville2h@newyorker.com', '630-266-3770');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (91, 'Reggis', 'Trebilcock', 'Male', 'rtrebilcock2i@pagesperso-orange.fr', '381-163-4140');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (92, 'Lou', 'Rubinovici', 'Male', 'lrubinovici2j@example.com', '214-686-6844');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (93, 'Wit', 'Bowshire', 'Male', 'wbowshire2k@usda.gov', '689-357-5751');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (94, 'Hubey', 'Bryning', 'Male', 'hbryning2l@barnesandnoble.com', '424-709-5454');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (95, 'Valeria', 'Maddra', 'Female', 'vmaddra2m@example.com', '666-710-8289');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (96, 'Camile', 'Clegg', 'Female', 'cclegg2n@miibeian.gov.cn', '979-853-2955');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (97, 'Jaquenette', 'Mordaunt', 'Female', 'jmordaunt2o@comsenz.com', '496-830-3290');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (98, 'Audrye', 'Stefanovic', 'Female', 'astefanovic2p@tripod.com', '829-587-6244');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (99, 'Tracie', 'Arnaut', 'Female', 'tarnaut2q@prweb.com', '314-113-3656');
insert into customer (id, first_name, last_name, gender, email, phone_number) values (100, 'Yul', 'Exley', 'Male', 'yexley2r@state.tx.us', '625-255-5212');


create table private_owner(
  owner_no VARCHAR(5),
  first_name VARCHAR(15),
  last_name VARCHAR(15),
  address VARCHAR(30),
  district VARCHAR(30),
  city VARCHAR(30),
  post_code VARCHAR(5),
  telephone VARCHAR(15),
  PRIMARY KEY(owner_no));


DROP TABLE IF EXISTS "private_owner";

CREATE TABLE "private_owner" (
  id SERIAL PRIMARY KEY,
  owner_no varchar(255),
  first_name varchar(255) default NULL,
  last_name varchar(255) default NULL,
  address varchar(255) default NULL,
  city varchar(255),
  postalZip varchar(20) default NULL
);

INSERT INTO private_owner (owner_no,first_name,last_name,address,city,postalZip)
VALUES
  ('owner_527','Gülsüm','Özkaya','6322 Rutrum Rd.','Hard','735567'),
  ('owner_216','Berki̇n','Ünal','Ap #351-8209 Consectetuer Avenue','Mount Gambier','36157'),
  ('owner_370','Alphan','Gür','900-6109 Arcu. Avenue','Vienna','682364'),
  ('owner_123','Tuğba','Demir','Ap #630-501 Sed St.','Sint-Jans-Molenbeek','163726'),
  ('owner_510','Abuzer','Kutlu','Ap #418-4441 Malesuada Rd.','Hofors','46145-60782'),
  ('owner_131','Kadi̇r','Aktaş','Ap #937-7034 Magna Rd.','Kimberley','765639'),
  ('owner_765','Alp','Sezer','Ap #581-1679 A Street','Angoulême','190482'),
  ('owner_074','Berkcan','Sarıkaya','P.O. Box 647, 2579 Ac St.','Leticia','68641'),
  ('owner_160','Ali̇','Ertaş','P.O. Box 175, 7516 Ante. Road','Alajuela','7443'),
  ('owner_067','Menderes','Ercan','6662 Ut Av.','Hunan','717258');
INSERT INTO private_owner (owner_no,first_name,last_name,address,city,postalZip)
VALUES
  ('owner_833','Sudenaz','Durmuş','Ap #427-7106 Porttitor St.','Mokpo','52774'),
  ('owner_244','Meral','Akpınar','P.O. Box 278, 1991 Hendrerit Road','Harnai','86559'),
  ('owner_171','Ali̇m','Akdeniz','Ap #793-7638 Nulla. Av.','Åkersberga','2215-8214'),
  ('owner_464','Fadime','Akbulut','753-3910 Eu Av.','Tarma','81272'),
  ('owner_802','Nisa','Ekinci','P.O. Box 734, 3883 Lobortis Ave','Guangxi','169393'),
  ('owner_124','Nazi̇re','Akdağ','844-2757 Pellentesque Road','Bergen','85-35'),
  ('owner_647','Berker','Aksu','Ap #870-9835 Vulputate Av.','Vienna','54-72'),
  ('owner_240','Ayşegül','Önal','519-8451 Sed, Av.','Sicuani','5057-9083'),
  ('owner_930','Gülşen','Çakar','P.O. Box 806, 694 Ac Rd.','Waren','12230'),
  ('owner_237','Ömer','Önal','Ap #807-115 Libero St.','Thalassery','31-802');
INSERT INTO private_owner (owner_no,first_name,last_name,address,city,postalZip)
VALUES
  ('owner_897','Alparslan','Demir','Ap #746-4521 Lacus. Street','Bakal','76774-610'),
  ('owner_396','Atakan','Gün','P.O. Box 398, 6749 Et Rd.','Dadu','88751'),
  ('owner_676','Nisa','Eren','P.O. Box 144, 8413 Nulla Rd.','Spokane','735756'),
  ('owner_485','Alphan','Ergin','626-7977 Erat Avenue','Juliaca','43408-88372'),
  ('owner_623','Ataberk','Çakmak','5922 Blandit Street','Xinjiang','21602'),
  ('owner_878','Atacan','Gürsoy','Ap #983-2549 Ullamcorper Rd.','Gansu','21264'),
  ('owner_388','İlknur','Uyar','Ap #115-9513 Nisl St.','Orhangazi','3253'),
  ('owner_227','Sultan','Fırat','867-8462 Pretium St.','Brampton','38780-64579'),
  ('owner_896','Sümeyra','Ünal','508-1450 Ornare, Road','Murcia','425100'),
  ('owner_155','Esra','Karadağ','Ap #143-1207 Arcu Av.','Bagh','8149');
INSERT INTO private_owner (owner_no,first_name,last_name,address,city,postalZip)
VALUES
  ('owner_593','Berkehan','Taşçi','4062 Fusce Rd.','Arequipa','755856'),
  ('owner_719','Esra','Bulut','P.O. Box 680, 8054 Bibendum St.','Hamburg','672144'),
  ('owner_913','Sunay','Demircan','Ap #565-9137 Feugiat Av.','Quillota','4416'),
  ('owner_075','Suna','Ünsal','P.O. Box 318, 4640 Cum Rd.','Pachuca','272768'),
  ('owner_728','Sonat','Çam','Ap #324-5728 Amet, Road','Camarones','445113'),
  ('owner_433','Ataman','Aras','3524 Cras Road','Sokoto','14984'),
  ('owner_033','Manolya','Ateş','Ap #427-2551 Lectus St.','Jilin','35248668'),
  ('owner_434','Melike','Çınar','931-6832 Facilisis Street','Itajaí','41743'),
  ('owner_826','Nazi̇k','Taşdemir','912-4467 Mattis Rd.','Paradise','639647'),
  ('owner_335','İlknur','Gün','Ap #512-4530 Et, Rd.','Hard','7044');
INSERT INTO private_owner (owner_no,first_name,last_name,address,city,postalZip)
VALUES
  ('owner_768','Sevi̇n','Karakuş','191-3121 Ac St.','Antakya','T5L 4P1'),
  ('owner_763','Alpteki̇n','Kaya','621-1835 A Rd.','Pamplona','2479'),
  ('owner_571','Menekşe','Parlak','Ap #127-3502 Urna Road','Częstochowa','2023'),
  ('owner_767','Atacan','Kutlu','Ap #220-6152 Nibh Rd.','Jayapura','726451'),
  ('owner_704','Menekşe','Altay','734-516 Sit Rd.','Duitama','29516'),
  ('owner_263','Ataberk','Keleş','764-2112 Ridiculus Ave','Assen','660572'),
  ('owner_438','Aynur','Kuru','3580 Adipiscing Av.','Mahikeng','38168'),
  ('owner_019','Nazi̇k','Yalçınkaya','P.O. Box 464, 2317 Egestas Avenue','Vigo','50503'),
  ('owner_749','İlknur','Aslan','Ap #748-9822 Cum Rd.','Shaanxi','H3A 4M6'),
  ('owner_767','Hanife','Ay','302-2884 Blandit Avenue','Shandong','2514');
INSERT INTO private_owner (owner_no,first_name,last_name,address,city,postalZip)
VALUES
  ('owner_631','İbrahi̇m','Ertürk','Ap #263-7392 Purus, Road','Bajaur Agency','52782'),
  ('owner_121','Ayşenaz','Uğurlu','P.O. Box 166, 5436 Ipsum. Rd.','Port Blair','59768'),
  ('owner_281','Ahmet','Karabulut','P.O. Box 398, 6687 Nec, Avenue','Oslo','48-138'),
  ('owner_461','Ahmet','Atalay','P.O. Box 941, 6845 Pharetra Avenue','Mykolaiv','785942'),
  ('owner_394','Cem','Topçu','Ap #985-7331 Massa St.','Kidderminster','92V 8M4'),
  ('owner_621','Cemi̇l','Kahraman','442-8211 Elit. Rd.','Wanaka','30701'),
  ('owner_166','Berkcan','Şenol','Ap #558-694 Orci Rd.','Çarşamba','3768'),
  ('owner_626','Sevi̇m','Kaçar','5962 Ac St.','Bila Tserkva','0484-7734'),
  ('owner_865','Alpteki̇n','Doğru','709-4125 Gravida Avenue','Kitscoty','84-45'),
  ('owner_449','Nazi̇fe','Koca','659-5021 Ornare Rd.','Galway','2769');
INSERT INTO private_owner (owner_no,first_name,last_name,address,city,postalZip)
VALUES
  ('owner_035','Candan','Demirci','Ap #534-9862 Aenean Ave','Empangeni','19831'),
  ('owner_758','Cemal','İpek','271-6016 Elit, St.','Daly','5612'),
  ('owner_752','Nazan','Akay','Ap #904-4772 Pede. Rd.','Itapipoca','676993'),
  ('owner_247','Fi̇li̇z','Sevinç','P.O. Box 449, 3290 Sit Road','Beypazarı','665737'),
  ('owner_716','Kemal','Durmuş','P.O. Box 817, 9262 Ligula. Rd.','Denpasar','21671'),
  ('owner_388','Hacer','Kahraman','Ap #260-6643 Pharetra Ave','Bydgoszcz','563165'),
  ('owner_011','Serkan','Gürsoy','320-4738 Ligula. Road','Yunnan','8511'),
  ('owner_802','Hasan','Şeker','Ap #457-8953 Curabitur Avenue','Oleksandriia','2535'),
  ('owner_988','Cemaletti̇n','Türk','291-5128 Magna Avenue','Krems an der Donau','27317'),
  ('owner_742','Nuretti̇n','Türkoğlu','P.O. Box 665, 6533 Velit St.','Toruń','37866');
INSERT INTO private_owner (owner_no,first_name,last_name,address,city,postalZip)
VALUES
  ('owner_255','Şengül','Gül','9218 Ultrices St.','Quedlinburg','26659'),
  ('owner_878','Nur','Kaplan','6359 Erat. Rd.','Alexandra','3789'),
  ('owner_825','Şeni̇z','Arslan','500-4376 Sed St.','Águas Lindas de Goiás','214565'),
  ('owner_597','Osman','Tuna','P.O. Box 905, 8975 Mattis. Avenue','Grand-Reng','15325'),
  ('owner_708','Emre','Doğru','Ap #372-4678 A Av.','Adana','7563'),
  ('owner_547','Müge','Deniz','Ap #843-6472 Mauris, Rd.','Waiuku','30304'),
  ('owner_847','Temel','Duman','Ap #880-1988 Arcu Road','North Waziristan','4551'),
  ('owner_417','Şenel','Akgül','Ap #160-593 Suspendisse St.','Pınarbaşı','319476'),
  ('owner_250','Alparslan','Kuş','Ap #528-3094 Pede, Ave','Hà Tĩnh','337288'),
  ('owner_867','Emine','İpek','Ap #513-1924 Eget Avenue','Abingdon','43627');
INSERT INTO private_owner (owner_no,first_name,last_name,address,city,postalZip)
VALUES
  ('owner_412','Berke','Çınar','324-1325 Lacus. Street','Apartadó','322534'),
  ('owner_613','Hatice','Demirbaş','Ap #371-3636 Mi Rd.','Jelenia Góra','8598 WY'),
  ('owner_387','Canberk','Şeker','6121 Habitant Rd.','Madiun','97-430'),
  ('owner_714','Güler','Yaman','731-5702 Bibendum Avenue','San Demetrio Corone','3141'),
  ('owner_353','Can','Işık','Ap #620-9623 Gravida Street','Elx','42678'),
  ('owner_866','Ali̇şan','Mutlu','302-9938 Integer St.','Marawi','2553'),
  ('owner_394','Can','Özkaya','P.O. Box 824, 9135 Ante St.','Chulucanas','276875'),
  ('owner_981','Bedirhan','Özden','5817 Malesuada. St.','Salihli','14731'),
  ('owner_084','Sali̇h','Bolat','P.O. Box 410, 3056 Eu Av.','Flekkefjord','85-48'),
  ('owner_271','Nazan','Aydoğan','6006 Natoque Rd.','Villahermosa','A1W 3N8');
INSERT INTO private_owner (owner_no,first_name,last_name,address,city,postalZip)
VALUES
  ('owner_745','Berk','Erkan','Ap #651-3276 Vitae Rd.','Palma de Mallorca','54964'),
  ('owner_652','Nursel','Duman','362-232 Laoreet Av.','Mansehra','GC3 7QD'),
  ('owner_667','Zeynep','Aydın','Ap #709-341 Mi. Ave','Greenwich','496654'),
  ('owner_405','Ali̇m','Taşdemir','9011 Est Av.','Maracanaú','21467'),
  ('owner_138','Şenel','Bozkurt','966-523 Quis Street','Juiz de Fora','5248-9517'),
  ('owner_377','Abuzer','Tosun','614-9791 Iaculis Rd.','Launceston','82641'),
  ('owner_509','Ramazan','Bolat','P.O. Box 136, 2712 Nam St.','Upplands Väsby','35-12'),
  ('owner_354','Gülay','Dinçer','858-7636 Nunc Street','Kielce','Z5R 7J3'),
  ('owner_436','Adem','Güler','Ap #421-1837 Aliquam Av.','Panketal','7611'),
  ('owner_078','Nazan','Tuna','9551 Et Street','Pontianak','63966');


create table viewing (
	id INT,
	property_no VARCHAR(50),
	address VARCHAR(50),
	private_owner_id INT,
  PRIMARY KEY (id)
);
insert into viewing (id, property_no, address, private_owner_id) values (1, '62-191-2067', '542 Northport Lane', 23);
insert into viewing (id, property_no, address, private_owner_id) values (2, '36-251-6879', '83 Rowland Circle', 32);
insert into viewing (id, property_no, address, private_owner_id) values (3, '22-356-6734', '8 Pleasure Junction', 67);
insert into viewing (id, property_no, address, private_owner_id) values (4, '91-259-8696', '55 Chinook Center', 61);
insert into viewing (id, property_no, address, private_owner_id) values (5, '33-323-8782', '8 Dottie Park', 49);
insert into viewing (id, property_no, address, private_owner_id) values (6, '50-586-5518', '354 Little Fleur Center', 20);
insert into viewing (id, property_no, address, private_owner_id) values (7, '81-842-4843', '4286 Aberg Avenue', 2);
insert into viewing (id, property_no, address, private_owner_id) values (8, '03-482-9541', '4243 Reinke Junction', 54);
insert into viewing (id, property_no, address, private_owner_id) values (9, '25-830-4628', '498 John Wall Court', 63);
insert into viewing (id, property_no, address, private_owner_id) values (10, '95-780-3489', '77020 Little Fleur Pass', 88);
insert into viewing (id, property_no, address, private_owner_id) values (11, '99-314-2014', '9425 Carey Point', 52);
insert into viewing (id, property_no, address, private_owner_id) values (12, '10-941-5684', '85323 Amoth Road', 18);
insert into viewing (id, property_no, address, private_owner_id) values (13, '58-650-6060', '0 Gulseth Terrace', 28);
insert into viewing (id, property_no, address, private_owner_id) values (14, '66-429-0596', '80 4th Park', 82);
insert into viewing (id, property_no, address, private_owner_id) values (15, '64-294-1976', '787 Kinsman Junction', 11);
insert into viewing (id, property_no, address, private_owner_id) values (16, '59-102-9550', '536 Northwestern Court', 30);
insert into viewing (id, property_no, address, private_owner_id) values (17, '44-245-8122', '2 Moulton Road', 31);
insert into viewing (id, property_no, address, private_owner_id) values (18, '96-316-4088', '86 Carpenter Place', 26);
insert into viewing (id, property_no, address, private_owner_id) values (19, '82-016-8392', '841 Ronald Regan Pass', 66);
insert into viewing (id, property_no, address, private_owner_id) values (20, '19-608-8409', '8043 Tony Drive', 52);
insert into viewing (id, property_no, address, private_owner_id) values (21, '41-079-6085', '48 Summerview Parkway', 26);
insert into viewing (id, property_no, address, private_owner_id) values (22, '00-983-6478', '8 Boyd Hill', 47);
insert into viewing (id, property_no, address, private_owner_id) values (23, '54-705-9908', '196 Monument Place', 26);
insert into viewing (id, property_no, address, private_owner_id) values (24, '93-407-2806', '6597 Victoria Pass', 66);
insert into viewing (id, property_no, address, private_owner_id) values (25, '94-501-7726', '89 Dawn Circle', 25);
insert into viewing (id, property_no, address, private_owner_id) values (26, '75-519-0057', '778 Kropf Hill', 24);
insert into viewing (id, property_no, address, private_owner_id) values (27, '26-328-6780', '74 Spaight Point', 42);
insert into viewing (id, property_no, address, private_owner_id) values (28, '66-543-3055', '59226 Lakeland Drive', 17);
insert into viewing (id, property_no, address, private_owner_id) values (29, '55-578-2835', '36663 Merrick Place', 47);
insert into viewing (id, property_no, address, private_owner_id) values (30, '27-715-4862', '1675 Sutherland Alley', 50);
insert into viewing (id, property_no, address, private_owner_id) values (31, '63-549-1264', '6 American Ash Parkway', 31);
insert into viewing (id, property_no, address, private_owner_id) values (32, '05-188-4160', '53 Melvin Court', 13);
insert into viewing (id, property_no, address, private_owner_id) values (33, '39-683-1718', '213 Jay Way', 96);
insert into viewing (id, property_no, address, private_owner_id) values (34, '96-806-4801', '7881 Dakota Parkway', 27);
insert into viewing (id, property_no, address, private_owner_id) values (35, '70-912-1428', '46 Hauk Junction', 5);
insert into viewing (id, property_no, address, private_owner_id) values (36, '38-743-2818', '4 Talisman Junction', 36);
insert into viewing (id, property_no, address, private_owner_id) values (37, '06-853-8423', '83836 Buena Vista Hill', 58);
insert into viewing (id, property_no, address, private_owner_id) values (38, '30-838-5269', '56 Annamark Park', 17);
insert into viewing (id, property_no, address, private_owner_id) values (39, '47-110-5114', '4704 Shoshone Street', 49);
insert into viewing (id, property_no, address, private_owner_id) values (40, '53-553-6239', '61666 Loeprich Drive', 83);
insert into viewing (id, property_no, address, private_owner_id) values (41, '53-241-7484', '76581 Oxford Plaza', 32);
insert into viewing (id, property_no, address, private_owner_id) values (42, '43-886-2574', '7847 Fairfield Avenue', 66);
insert into viewing (id, property_no, address, private_owner_id) values (43, '48-021-1107', '41 Di Loreto Way', 25);
insert into viewing (id, property_no, address, private_owner_id) values (44, '11-539-3500', '7 Mosinee Pass', 100);
insert into viewing (id, property_no, address, private_owner_id) values (45, '01-780-8315', '56 Rieder Pass', 29);
insert into viewing (id, property_no, address, private_owner_id) values (46, '79-096-4084', '6546 Hooker Pass', 9);
insert into viewing (id, property_no, address, private_owner_id) values (47, '64-100-4737', '0 Birchwood Trail', 18);
insert into viewing (id, property_no, address, private_owner_id) values (48, '43-276-7560', '29147 Kropf Lane', 27);
insert into viewing (id, property_no, address, private_owner_id) values (49, '81-154-7651', '8025 Canary Parkway', 97);
insert into viewing (id, property_no, address, private_owner_id) values (50, '10-114-8090', '6166 Grayhawk Court', 41);
insert into viewing (id, property_no, address, private_owner_id) values (51, '23-798-4932', '8 Red Cloud Center', 62);
insert into viewing (id, property_no, address, private_owner_id) values (52, '04-559-5403', '35 Briar Crest Court', 76);
insert into viewing (id, property_no, address, private_owner_id) values (53, '88-309-7630', '96 Swallow Trail', 12);
insert into viewing (id, property_no, address, private_owner_id) values (54, '33-544-2150', '3 Commercial Point', 71);
insert into viewing (id, property_no, address, private_owner_id) values (55, '16-918-6102', '41300 Walton Circle', 35);
insert into viewing (id, property_no, address, private_owner_id) values (56, '30-738-7277', '41 Kinsman Park', 68);
insert into viewing (id, property_no, address, private_owner_id) values (57, '77-867-5269', '0 Corry Place', 26);
insert into viewing (id, property_no, address, private_owner_id) values (58, '60-099-8588', '4 Lien Junction', 82);
insert into viewing (id, property_no, address, private_owner_id) values (59, '40-853-9672', '5539 American Ash Place', 40);
insert into viewing (id, property_no, address, private_owner_id) values (60, '06-352-6602', '75 Victoria Crossing', 11);
insert into viewing (id, property_no, address, private_owner_id) values (61, '56-366-9223', '54 Mockingbird Center', 5);
insert into viewing (id, property_no, address, private_owner_id) values (62, '35-606-9090', '248 David Junction', 56);
insert into viewing (id, property_no, address, private_owner_id) values (63, '75-386-7261', '46290 Transport Park', 17);
insert into viewing (id, property_no, address, private_owner_id) values (64, '64-773-9045', '90265 Stephen Trail', 71);
insert into viewing (id, property_no, address, private_owner_id) values (65, '71-748-6332', '0090 Utah Avenue', 7);
insert into viewing (id, property_no, address, private_owner_id) values (66, '10-520-9949', '189 New Castle Point', 80);
insert into viewing (id, property_no, address, private_owner_id) values (67, '20-633-8875', '986 Kipling Park', 96);
insert into viewing (id, property_no, address, private_owner_id) values (68, '07-659-4989', '6436 5th Point', 57);
insert into viewing (id, property_no, address, private_owner_id) values (69, '33-537-9042', '2381 Hudson Pass', 87);
insert into viewing (id, property_no, address, private_owner_id) values (70, '96-128-2078', '079 Westerfield Avenue', 39);
insert into viewing (id, property_no, address, private_owner_id) values (71, '72-140-3534', '66859 Bunting Way', 30);
insert into viewing (id, property_no, address, private_owner_id) values (72, '78-391-6726', '65 Mallory Street', 61);
insert into viewing (id, property_no, address, private_owner_id) values (73, '81-763-1272', '72 Hanson Terrace', 39);
insert into viewing (id, property_no, address, private_owner_id) values (74, '08-912-1151', '4889 Crescent Oaks Avenue', 33);
insert into viewing (id, property_no, address, private_owner_id) values (75, '87-109-1833', '7 Caliangt Terrace', 93);
insert into viewing (id, property_no, address, private_owner_id) values (76, '40-438-2287', '4663 Rieder Road', 19);
insert into viewing (id, property_no, address, private_owner_id) values (77, '48-450-0268', '494 Almo Trail', 66);
insert into viewing (id, property_no, address, private_owner_id) values (78, '24-498-3561', '253 Lighthouse Bay Parkway', 84);
insert into viewing (id, property_no, address, private_owner_id) values (79, '51-935-6010', '6502 Arrowood Place', 74);
insert into viewing (id, property_no, address, private_owner_id) values (80, '69-123-7579', '9 Boyd Parkway', 74);
insert into viewing (id, property_no, address, private_owner_id) values (81, '71-170-8952', '65 Grayhawk Park', 71);
insert into viewing (id, property_no, address, private_owner_id) values (82, '83-561-4912', '010 Dixon Center', 75);
insert into viewing (id, property_no, address, private_owner_id) values (83, '12-062-3266', '391 Victoria Lane', 34);
insert into viewing (id, property_no, address, private_owner_id) values (84, '66-442-0548', '1 Superior Lane', 47);
insert into viewing (id, property_no, address, private_owner_id) values (85, '52-672-2964', '32453 Sloan Street', 75);
insert into viewing (id, property_no, address, private_owner_id) values (86, '08-171-1407', '275 Blaine Junction', 11);
insert into viewing (id, property_no, address, private_owner_id) values (87, '78-326-2926', '61871 Saint Paul Plaza', 43);
insert into viewing (id, property_no, address, private_owner_id) values (88, '54-315-3032', '40 Chive Circle', 39);
insert into viewing (id, property_no, address, private_owner_id) values (89, '00-020-6329', '575 Quincy Lane', 77);
insert into viewing (id, property_no, address, private_owner_id) values (90, '56-195-9636', '1 Melody Hill', 82);
insert into viewing (id, property_no, address, private_owner_id) values (91, '05-887-0820', '7 Blue Bill Park Court', 53);
insert into viewing (id, property_no, address, private_owner_id) values (92, '27-164-1574', '0167 Mcbride Pass', 65);
insert into viewing (id, property_no, address, private_owner_id) values (93, '98-005-0489', '79 Mcbride Center', 11);
insert into viewing (id, property_no, address, private_owner_id) values (94, '40-123-3711', '053 Banding Plaza', 85);
insert into viewing (id, property_no, address, private_owner_id) values (95, '36-680-4154', '5256 Emmet Drive', 51);
insert into viewing (id, property_no, address, private_owner_id) values (96, '50-861-5791', '77018 Oriole Center', 85);
insert into viewing (id, property_no, address, private_owner_id) values (97, '72-456-2268', '7 Forest Dale Lane', 61);
insert into viewing (id, property_no, address, private_owner_id) values (98, '75-067-8033', '08 Lindbergh Terrace', 71);
insert into viewing (id, property_no, address, private_owner_id) values (99, '50-515-1350', '137 Spenser Avenue', 68);
insert into viewing (id, property_no, address, private_owner_id) values (100, '73-809-0439', '05 Kings Crossing', 61);