/* || Script: LoadSalesAgents.sql || Object: Loads randomly-generated data for Sales Agents table || (SH.SALES_AGENTS) for demonstration of Oracle 11g || SQL Performance Analyzer and SQL Plan Management features */ SET ECHO OFF SET FEEDBACK OFF insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (1, 'Venora', 'Gino', '94 Bedfordshire Road', 'Saitama', '39810', 'Japan'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (2, 'Baker', 'Wade', '93rd Street', 'Prague', '18602', 'Czech republic'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (3, 'Loggia', 'Candice', '49 Wellington Blvd', 'Fairview Heights', 'IL', '2298', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (4, 'Keener', 'Emily', '40 Jake Drive', 'Milpitas', 'CA', '35830', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (5, 'Marin', 'Larenz', '61 Adrien Ave', 'Colombo', '6526', 'Sri lanka'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (6, 'Bragg', 'Fairuza', '391 Peebles Ave', 'Spresiano', '11757', 'Italy'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (7, 'Dreyfuss', 'Ashton', '16 Shorter Street', 'Valencia', 'CA', '35342', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (8, 'Todd', 'Bobbi', '71 Gracie', 'Michendorf', '26918', 'Germany'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (9, 'Reid', 'Terri', '47 Stewart Street', 'Melrose park', 'IL', '14243', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (10, 'Jackman', 'Rosanna', '795 Rade Street', 'Salem', 'NH', '2513', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (11, 'Garza', 'Catherine', '68 Johnette Street', 'Melrose', 'MA', '33628', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (12, 'Coolidge', 'LeVar', '24 McNeice Ave', 'Jakarta', '4887', 'Indonesia'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (13, 'Tanon', 'Gena', '76 Sydney Road', 'Fleet', '5C3 0M3', 'United Kingdom'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (14, 'McLean', 'Gavin', '11 Woodland Hills Road', 'Victoria', '4A0 9J3', 'Canada'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (15, 'Bright', 'Kirsten', '60 Mars Drive', 'Borger', 'TX', '37702', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (16, 'Kretschmann', 'Beverley', '25 Garth Street', 'Harahan', 'LA', '13256', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (17, 'MacDowell', 'Blair', '1 Courtney Road', 'Fair Lawn', 'NJ', '12723', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (18, 'Thurman', 'Lance', '556 Boulogne Road', 'Manaus', '38753', 'Brazil'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (19, 'Cumming', 'Hugh', '68 Sevenfold Drive', 'Aracruz', '30504', 'Brazil'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (20, 'Schwarzenegger', 'Joaquin', '51 Caguas Drive', 'Maarssen', '8654NE', 'Netherlands'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (21, 'Gayle', 'Taye', '14 Eugene Drive', 'Paraju', '28938', 'Brazil'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (22, 'Noseworthy', 'Armin', '575 Cervine Street', 'Ithaca', 'NY', '15595', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (23, 'Van Der Beek', 'Ruth', '88 Etta Drive', 'Nizhnevartovsk', '26102', 'Russia'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (24, 'Jay', 'Michelle', '35 Juliet Road', 'Haverhill', '0K3 4H7', 'United Kingdom'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (25, 'Klein', 'Chris', '422 Bentley', 'Nashua', 'NH', '36403', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (26, 'Delta', 'Wes', '31 Perlman Ave', 'San Francisco', 'CA', '10492', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (27, 'Duvall', 'Randall', '15 Pelvic Street', 'Springfield', '32700', 'Australia'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (28, 'Drive', 'Carrie-Anne', '65 Greg Blvd', 'Angers', '37915', 'France'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (29, 'Macht', 'Kylie', '65 Giraldo Drive', 'Chapel hill', 'NC', '3445', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (30, 'Parm', 'Tobey', '718 Heche Street', 'Newcastle upon Tyne', '7W2 5Z6', 'United Kingdom'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (31, 'Abraham', 'Alan', '76 Nelly Road', 'Rockford', 'IL', '31446', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (32, 'Robinson', 'Roscoe', '31st Street', 'Mito', '30723', 'Japan'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (33, 'Mewes', 'Warren', '261 Heubach Blvd', 'Mito', '35859', 'Japan'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (34, 'Fisher', 'Laurie', '31 Coughlan Ave', 'Ilmenau', '29418', 'Germany'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (35, 'Lightfoot', 'Chet', '519 Lund Ave', 'Fuchstal-asch', '7464', 'Germany'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (36, 'Hartnett', 'Bruce', '15 Benbrook Street', 'Brasília', '26148', 'Brazil'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (37, 'Steiger', 'Cornell', '28 Rollins Blvd', 'Akron', 'OH', '5257', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (38, 'Fogerty', 'Gates', '10 Diffie Street', 'Burgess Hill', '1D8 0O8', 'United Kingdom'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (39, 'Satriani', 'Emilio', '62nd Street', 'Mapo-gu', '14591', 'South Korea'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (40, 'Addy', 'Geoffrey', '71 Emma Street', 'Pottendorf', '29909', 'Austria'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (41, 'Holly', 'Howard', '14 Eddie Drive', 'Houma', 'LA', '9086', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (42, 'Affleck', 'Rueben', '20 Boyle Road', 'Santa Cruz', 'CA', '13859', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (43, 'Cook', 'Maceo', '787 Albuquerque Blvd', 'Dubai', '20146', 'UAE'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (44, 'Sorvino', 'Jonny Lee', '99 Bay Shore Road', 'Dardilly', '8248', 'France'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (45, 'Tucci', 'Diane', '22nd Street', 'Delafield', 'WI', '16627', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (46, 'Gambon', 'Jonatha', '71 New Fairfield Blvd', 'Fort Lee', 'NJ', '37522', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (47, 'Gordon', 'Roscoe', '182 Gagnon Drive', 'Woodbridge', 'NJ', '24868', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (48, 'Black', 'Luis', '96 Josh Drive', 'Eiksmarka', '28729', 'Norway'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (49, 'Griggs', 'Pete', '68 Jacksonville Drive', 'Chemnitz', '27538', 'Germany'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (50, 'Sewell', 'Diane', '14 Kapanka Road', 'Media', 'PA', '4132', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (51, 'Dorff', 'Ed', '11 Portland Road', 'Neuchâtel', '4240', 'Switzerland'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (52, 'Burke', 'Uma', '31 McCracken Street', 'Bay Shore', 'NY', '10452', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (53, 'Wariner', 'Stellan', '292 Gleeson', 'Ft. Leavenworth', 'KS', '10622', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (54, 'Kinski', 'Patti', '99 Franks Blvd', 'Londrina', '39790', 'Brazil'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (55, 'Preston', 'Holly', '16 Sophie Drive', 'Duesseldorf', '3003', 'Germany'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (56, 'MacIsaac', 'Juan', '26 Curfman Road', 'Hiroshima', '1443', 'Japan'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (57, 'Cara', 'Jason', '312 Gene Blvd', 'Framingaham', 'MA', '11322', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (58, 'Todd', 'Tilda', '25 Bentley Road', 'Lublin', '39377', 'Poland'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (59, 'Teng', 'Lois', '65 Charlton Drive', 'Kaiserslautern', '6096', 'Germany'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (60, 'Scaggs', 'Ben', '21st Street', 'Dortmund', '35212', 'Germany'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (61, 'Greene', 'Ben', '819 California Street', 'Bethesda', 'MD', '4540', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (62, 'Holliday', 'Ashton', '56 Humphrey Road', 'West Lafayette', 'IN', '14063', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (63, 'Adams', 'Timothy', '32 Mary-Louise Road', 'New York City', 'NY', '40680', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (64, 'Shatner', 'Chanté', '281 Suchet Drive', 'Edison', 'NJ', '11210', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (65, 'Gough', 'Meredith', '33rd Street', 'Kobe', '29146', 'Japan'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (66, 'Pitt', 'Katrin', '66 Harary Street', 'Tadley', '6I8 4I7', 'United Kingdom'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (67, 'Beckinsale', 'Keith', '71 Hynde Road', 'Cape town', '9328', 'South Africa'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (68, 'Alexander', 'Red', '805 Wellington Road', 'Recife', '24043', 'Brazil'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (69, 'Posey', 'Halle', '32nd Street', 'Lisboa', '23234', 'Portugal'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (70, 'Callow', 'Machine', '6 Winslet Drive', 'Edmonton', '7U5 3M2', 'Canada'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (71, 'Assante', 'Allison', '41 Kweller Street', 'Ashland', 'MO', '14172', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (72, 'Stuart', 'Matthew', '988 Osborne Drive', 'Beaverton', 'OR', '2389', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (73, 'Janssen', 'Max', '91st Street', 'Oklahoma city', 'OK', '24241', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (74, 'Bridges', 'Kevn', '59 Steven Drive', 'Torino', '21090', 'Italy'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (75, 'Brothers', 'Tcheky', '519 Kristin Drive', 'Chapeco', '26617', 'Brazil'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (76, 'Easton', 'Rhett', '965 Rio', 'Bad Camberg', '7655', 'Germany'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (77, 'Quinn', 'Petula', '38 Saucedo Street', 'Odense', '25568', 'Denmark'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (78, 'Ramirez', 'Courtney', '4 Angelina Blvd', 'Lexington', 'KY', '10811', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (79, 'Gibbons', 'Kenneth', '3 Zagreb Blvd', 'Las Vegas', 'NV', '24764', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (80, 'Devine', 'Glen', '23 Makowicz Street', 'Pusan-city', '28443', 'South Korea'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (81, 'Hatchet', 'Gwyneth', '26 Orleans Road', 'Parma', '2151', 'Italy'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (82, 'Spacey', 'Collective', '97 Dustin Road', 'Akron', 'OH', '16296', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (83, 'Pacino', 'Josh', '86 Cantrell Road', 'Eindhoven', '9583CM', 'Netherlands'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (84, 'MacDowell', 'Victor', '982 Weaving Blvd', 'Lummen', '33579', 'Belgium'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (85, 'Apple', 'Annette', '662 Overstreet Drive', 'Koblenz', '11394', 'Germany'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (86, 'Withers', 'Andie', '23 Bekescsaba Blvd', 'Stanford', 'CA', '10225', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (87, 'Levin', 'Ed', '24 Nordhausen Street', 'Bkk', '10940', 'Thailand'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (88, 'Suvari', 'Earl', '6 Begley Drive', 'Joinville', '14128', 'Brazil'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (89, 'O''Donnell', 'Pat', '62nd Street', 'Butner', 'NC', '4376', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (90, 'Culkin', 'Hal', '94 Waite Blvd', 'Lyon', '34578', 'France'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (91, 'Costello', 'Patricia', '80 Oak Park Road', 'Paramus', 'NJ', '4266', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (92, 'Mraz', 'Wes', '85 Osmond', 'Ludbreg', '11794', 'Croatia'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (93, 'Donelly', 'Night', '73 Marshall Street', 'Eden prairie', 'MN', '26909', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (94, 'Bean', 'Nik', '49 Albert Street', 'Olympia', 'WA', '27772', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (95, 'Russo', 'Ramsey', '529 McClinton', 'Seatle', 'WA', '22075', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (96, 'Mantegna', 'Annie', '23 McDormand Ave', 'Vienna', 'VA', '5761', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (97, 'Hunt', 'Colleen', '3 Allen', 'Rockland', 'ME', '26415', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (98, 'Taha', 'Robbie', '93 Chestnut Blvd', 'Suwon-city', '32148', 'South Korea'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (99, 'Newton', 'Kirsten', '63 Denny Street', 'Buffalo', '6N2 4Z1', 'Canada'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (100, 'Garfunkel', 'Suzi', '71st Street', 'Holts Summit', 'MO', '1404', 'USA'); commit; insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (101, 'Cantrell', 'Howard', '31 Hershey Drive', 'Manchester', '0W7 9R6', 'United Kingdom'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (102, 'Alexander', 'Kirk', '41st Street', 'Oshkosh', 'WI', '16997', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (103, 'Sartain', 'Sinead', '97 Cuenca Street', 'Goteborg', '12906', 'Sweden'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (104, 'Broza', 'Willem', '442 St. Petersburg Street', 'San Ramon', 'CA', '28626', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (105, 'Shelton', 'Hugh', '297 Kane Street', 'Ehningen', '3658', 'Germany'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (106, 'Payton', 'Wesley', '43rd Street', 'Sidney', '3E1 8D8', 'Canada'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (107, 'Palmieri', 'Hank', '39 Firenze Street', 'Orange', 'CA', '7069', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (108, 'Dukakis', 'Joshua', '35 Illeana Street', 'O''fallon', 'IL', '18638', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (109, 'McCormack', 'Lucy', '49 Ankara Street', 'Reisterstown', 'MD', '26138', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (110, 'Cazale', 'Harvey', '21st Street', 'Noumea', '27452', 'New Caledonia'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (111, 'Wells', 'Colleen', '7 Jodie Drive', 'Kongserbg', '26792', 'Norway'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (112, 'Slater', 'Dar', '45 Jean-Luc Street', 'Wageningen', '8490YO', 'Netherlands'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (113, 'McCracken', 'Xander', '58 Horsham Road', 'Brisbane', '27886', 'Australia'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (114, 'Cube', 'Helen', '36 Gerald Drive', 'Bruxelles', '18615', 'Belgium'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (115, 'Vega', 'Stephen', '25 Klein Street', 'Bad Camberg', '4601', 'Germany'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (116, 'LaMond', 'Paul', '74 Swank Road', 'Rimini', '5730', 'Italy'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (117, 'Day-Lewis', 'Jimmie', '67 Foxx', 'Tottori', '22300', 'Japan'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (118, 'Huston', 'Hope', '13 Atlas Street', 'Di Savigliano', '5479', 'Italy'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (119, 'Gershon', 'Geoff', '244 Eiksmarka Drive', 'Archbold', 'OH', '5158', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (120, 'Mathis', 'Ving', '2 McLean Road', 'Kwun Tong', '22075', 'Hong Kong'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (121, 'Freeman', 'Juliet', '69 Russell', 'Waterloo', '0R5 9V3', 'Canada'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (122, 'Apple', 'Sheryl', '10 Hall Road', 'Maserada sul Piave', '39504', 'Italy'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (123, 'Baez', 'Miriam', '53 Rapaport Road', 'Turku', '23851', 'Finland'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (124, 'Stanton', 'Sammy', '602 El Segundo Street', 'Trento', '26454', 'Italy'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (125, 'Almond', 'Dylan', '60 Rifkin Street', 'Valladolid', '30045', 'Spain'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (126, 'Randal', 'Katrin', '855 Minogue Street', 'Snoqualmie', 'WA', '8197', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (127, 'Kadison', 'Geraldine', '93 Avalon Street', 'Macclesfield', '0F3 4E3', 'United Kingdom'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (128, 'Strathairn', 'Brad', '69 Rhys Road', 'Ulsteinvik', '27979', 'Norway'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (129, 'Bruce', 'Pelvic', '73rd Street', 'Belmont', 'CA', '9195', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (130, 'McCormack', 'Natalie', '967 Griggs Road', 'Ann Arbor', 'MI', '26488', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (131, 'Perlman', 'Harrison', '50 Hynde Drive', 'Colorado Springs', 'CO', '30503', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (132, 'Brooks', 'Jason', '42 Newton Street', 'Dorval', '7O4 9X4', 'Canada'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (133, 'Chestnut', 'Sonny', '45 Anjelica Blvd', 'Barksdale afb', 'LA', '20891', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (134, 'Keeslar', 'Ernest', '73 Shawn Road', 'Budapest', '3635', 'Hungary'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (135, 'Pullman', 'Tilda', '7 Satriani Road', 'Cuiabá', '15384', 'Brazil'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (136, 'McDowell', 'King', '350 Jonze Drive', 'Ohita', '35783', 'Japan'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (137, 'Langella', 'Bonnie', '99 San Francisco Street', 'Glen Cove', 'NY', '33895', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (138, 'Lemmon', 'Elvis', '41 Thurman Ave', 'Amsterdam', '8211OS', 'Netherlands'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (139, 'Law', 'Breckin', '56 Warburton Street', 'Hercules', 'CA', '30060', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (140, 'Jeter', 'Bradley', '24 Melba Road', 'Peine', '40129', 'Germany'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (141, 'Hughes', 'Wallace', '62nd Street', 'Doncaster', '9Z4 1M2', 'United Kingdom'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (142, 'Richter', 'Ossie', '782 Ivan Road', 'Richmond Hill', '1A9 5O7', 'Canada'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (143, 'Van Der Beek', 'Ryan', '32 First Drive', 'San Francisco', 'CA', '25307', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (144, 'O''Keefe', 'Marianne', '50 Garfunkel Street', 'Sant Cugat Del Valle', '26376', 'Spain'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (145, 'Morton', 'Danni', '15 Burke Street', 'Rocklin', 'CA', '21271', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (146, 'Jordan', 'Hex', '53 Bonnie Street', 'New Delhi', '36763', 'India'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (147, 'Tanon', 'Jesus', '72 Burton Blvd', 'Regina', '1J0 1J2', 'Canada'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (148, 'Affleck', 'Illeana', '3 Kitty Blvd', 'Sant Cugat Del Valle', '23633', 'Spain'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (149, 'Flemyng', 'Stockard', '9 Nielsen Blvd', 'Lublin', '22973', 'Poland'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (150, 'Overstreet', 'Emmylou', '95 Posey Blvd', 'Fairview Heights', 'IL', '10793', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (151, 'Holeman', 'Kimberly', '18 Giannini Drive', 'Bellerose', 'NY', '39458', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (152, 'Farrow', 'Raul', '31st Street', 'Sutton', 'MA', '3307', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (153, 'Shorter', 'Stellan', '56 Alana Ave', 'Lisboa', '2728', 'Portugal'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (154, 'Shaye', 'Andre', '12 Elisabeth Drive', 'Leawood', 'KS', '39271', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (155, 'Sutherland', 'Randall', '888 Blackwell Road', 'Pirmasens', '15837', 'Germany'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (156, 'Williamson', 'Donal', '78 Colman Street', 'Samrand', '14845', 'South Africa'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (157, 'Benson', 'Bridget', '63rd Street', 'Berwyn', 'IL', '32483', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (158, 'Borgnine', 'Michael', '17 Williamson Drive', 'Ft. Leavenworth', 'KS', '31978', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (159, 'Chilton', 'Loreena', '46 Christmas Street', 'Irkutsk', '33194', 'Russia'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (160, 'Downey', 'Joey', '598 Zevon Street', 'Brisbane', '19407', 'Australia'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (161, 'Chappelle', 'Norm', '470 Gdansk Road', 'New York City', 'NY', '39219', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (162, 'Baranski', 'Ed', '56 Denny Drive', 'Wakayama', '20728', 'Japan'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (163, 'Beck', 'Loretta', '39 Pirmasens', 'Itu', '13373', 'Brazil'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (164, 'Butler', 'Rick', '32 Weston Drive', 'Gliwice', '5470', 'Poland'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (165, 'MacIsaac', 'Oded', '12 California Street', 'North Point', '31292', 'Hong Kong'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (166, 'Goodall', 'Miguel', '68 Visnjic', 'Paderborn', '40670', 'Germany'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (167, 'Cozier', 'Ted', '11 Don Drive', 'Bloomington', 'MN', '24253', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (168, 'Pigott-Smith', 'Yaphet', '89 Concordville Blvd', 'Pasadena', 'CA', '28233', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (169, 'Isaak', 'Stephanie', '20 Russell Drive', 'Recife', '3210', 'Brazil'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (170, 'Armstrong', 'Lou', '139 Xander Road', 'Bartlesville', 'OK', '8333', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (171, 'Krabbe', 'Clay', '44 Williamson Road', 'Fort Saskatchewan', '1Z0 3I4', 'Canada'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (172, 'Travers', 'Roger', '4 Dzundza', 'Farmington Hills', 'MI', '36751', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (173, 'Bogguss', 'Spencer', '59 Robin Road', 'Hochwald', '23318', 'Switzerland'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (174, 'Osmond', 'Moe', '42 Farrow Street', 'Peachtree City', 'GA', '3309', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (175, 'Braugher', 'Maggie', '101 Kelly Drive', 'Goslar', '20726', 'Germany'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (176, 'Steagall', 'Larnelle', '82 Loveland Street', 'Köln', '24461', 'Germany'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (177, 'Hartnett', 'Edie', '34 Carlyle', 'Sihung-si', '9183', 'South Korea'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (178, 'Harmon', 'Alex', '88 Tooele Street', 'Hillerød', '27376', 'Denmark'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (179, 'Swank', 'Thelma', '5 England Street', 'Orlando', 'FL', '8669', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (180, 'Spiner', 'Mena', '30 Visselhövede Road', 'Knoxville', 'TN', '8763', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (181, 'Young', 'Lara', '21st Street', 'Morioka', '22594', 'Japan'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (182, 'Foster', 'Lara', '94 Nakai Street', 'Royston', '2R3 0V5', 'United Kingdom'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (183, 'Raybon', 'Herbie', '53 Gellar Road', 'Genève', '6499', 'Switzerland'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (184, 'Moffat', 'Dionne', '22nd Street', 'Bautzen', '25016', 'Germany'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (185, 'Vinton', 'Trini', '97 O''Connor Street', 'Portland', 'OR', '27086', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (186, 'Botti', 'Joshua', '556 Suwon Ave', 'Rio Rancho', 'NM', '13543', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (187, 'Heston', 'Jose', '835 Ludbreg Road', 'Englewood', 'CO', '28467', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (188, 'Coughlan', 'Quentin', '6 Winger Road', 'Eisenhüttenstadt', '24898', 'Germany'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (189, 'Joli', 'Cheech', '18 Fiorentino Street', 'Istanbul', '30907', 'Turkey'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (190, 'Garza', 'Madeline', '61 Rooker', 'Ulsteinvik', '15156', 'Norway'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (191, 'Cube', 'Kay', '27 Angie Road', 'Lubbock', 'TX', '11128', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (192, 'Danes', 'Rhea', '78 Carrington Street', 'St Jean de Soudain', '10616', 'France'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (193, 'McIntosh', 'Brendan', '8 Zahn Road', 'Tartu', '13098', 'Estonia'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (194, 'Gibson', 'Christmas', '56 Farnham Road', 'Jakarta', '34132', 'Indonesia'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (195, 'McGriff', 'Chris', '77 Michaels Ave', 'Tucson', 'AZ', '31314', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (196, 'Vincent', 'Anita', '23 Tillis Street', 'Gauteng', '27215', 'South Africa'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (197, 'Favreau', 'Mili', '97 Eat World Road', 'Kaiserslautern', '31564', 'Germany'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (198, 'Teng', 'Allan', '206 Plummer', 'Utsunomiya', '13536', 'Japan'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (199, 'Plowright', 'Curt', '65 Pigott-Smith Street', 'Wageningen', '7432RW', 'Netherlands'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (200, 'Weaver', 'Adrien', '64 Rock', 'Pusan', '35710', 'South Korea'); commit; insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (201, 'McBride', 'Denny', '98 Reese Road', 'Archbold', 'OH', '33332', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (202, 'English', 'Renee', '51 Gattico Street', 'Orlando', 'FL', '32552', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (203, 'Dillon', 'Ronnie', '6 Nizhnevartovsk Drive', 'Montreal', '2E6 6P2', 'Canada'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (204, 'Crowe', 'Adrien', '88 Daniels Street', 'Winnipeg', '5Q9 9X6', 'Canada'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (205, 'Farris', 'Lauren', '73 Himmelman Road', 'Mountain View', 'CA', '6899', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (206, 'Vassar', 'Vern', '100 Almond Drive', 'Sapporo', '19910', 'Japan'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (207, 'Pacino', 'Moe', '96 Jovovich Road', 'Carlingford', '28567', 'Australia'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (208, 'Reid', 'Ethan', '18 Aracruz Blvd', 'Highton', '32128', 'Australia'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (209, 'Goldberg', 'Chaka', '35 Shocked Ave', 'St Kilda', '37330', 'Australia'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (210, 'Holy', 'Casey', '32nd Street', 'Rancho Palos Verdes', 'CA', '12060', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (211, 'Richardson', 'Alana', '11 Lexington Street', 'Kingston', '1C0 6D9', 'Canada'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (212, 'Soul', 'Tilda', '14 Leipzig Blvd', 'Belo Horizonte', '31010', 'Brazil'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (213, 'LuPone', 'Demi', '91st Street', 'Richardson', 'TX', '40807', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (214, 'Bassett', 'Wayman', '96 Ricardo Road', 'Paal Beringen', '29012', 'Belgium'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (215, 'Jessee', 'Randy', '22 McIntyre Ave', 'Fort Lewis', 'WA', '18425', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (216, 'Lopez', 'Trini', '58 Bo Street', 'Matsue', '9435', 'Japan'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (217, 'Diddley', 'Rosanna', '564 Crewson Drive', 'Marlboro', 'MA', '22021', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (218, 'Brock', 'Darren', '37 Pepper Road', 'Bristol', 'TN', '16756', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (219, 'Woodward', 'Chad', '77 McFadden Street', 'Sale', '1D6 7Z8', 'United Kingdom'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (220, 'Sledge', 'Kris', '94 Ricci Street', 'Leawood', 'KS', '16668', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (221, 'Wakeling', 'Christine', '80 Westerberg', 'Rotterdam', '8386SH', 'Netherlands'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (222, 'Yankovic', 'Glen', '55 Heath Ave', 'Genève', '22215', 'Switzerland'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (223, 'Garza', 'Devon', '918 Hynde', 'Burgess Hill', '3L0 2S9', 'United Kingdom'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (224, 'Shandling', 'Andie', '63 Kathleen Blvd', 'Canberra', '22794', 'Australia'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (225, 'Nunn', 'Benjamin', '91st Street', 'West Lafayette', 'IN', '40633', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (226, 'Busey', 'Garry', '59 Robbins Road', 'Madrid', '1943', 'Spain'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (227, 'Brock', 'Rachel', '99 Mantegna Street', 'Laredo', 'TX', '38107', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (228, 'Foxx', 'Andy', '11 Johansen Ave', 'Birmensdorf', '7923', 'Switzerland'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (229, 'Ricci', 'Lindsay', '327 DeGraw Street', 'Sihung-si', '5812', 'South Korea'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (230, 'Caine', 'Jennifer', '33 Perez Street', 'Kaohsiung', '30506', 'China'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (231, 'Goodman', 'Jerry', '51 Costello', 'West Monroe', 'LA', '39979', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (232, 'Nelson', 'Emily', '40 Garofalo Street', 'Bellevue', 'NE', '37555', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (233, 'Rauhofer', 'Frankie', '33 Tisdale Street', 'Melrose', 'MA', '27669', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (234, 'Hewitt', 'Miriam', '59 Novara Street', 'Venice', '5955', 'Italy'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (235, 'Carr', 'Karen', '94 Stanley Road', 'Milan', '31355', 'Italy'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (236, 'Bachman', 'Vertical', '81st Street', 'Brugherio', '21733', 'Italy'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (237, 'Crystal', 'Terri', '96 Martin Road', 'Rancho Palos Verdes', 'CA', '22686', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (238, 'Choice', 'Franz', '11st Street', 'Derwood', 'MD', '37287', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (239, 'Yorn', 'Dan', '10 Abraham Drive', 'Thame', '6T6 0V6', 'United Kingdom'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (240, 'Hewett', 'Balthazar', '22 Franco Drive', 'Gennevilliers', '5398', 'France'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (241, 'Viterelli', 'Colm', '16 McCain', 'Saint-vincent-de-dur', '8767', 'France'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (242, 'Ball', 'Catherine', '211 Chemnitz Street', 'Matsuyama', '23387', 'Japan'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (243, 'Mellencamp', 'Mike', '61 Kagoshima Street', 'Canberra', '33092', 'Australia'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (244, 'Cassidy', 'Marina', '3 Kevelaer', 'Olympia', 'WA', '19632', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (245, 'McDowell', 'Dorry', '52 Haggard Road', 'Rheinfelden', '5137', 'Switzerland'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (246, 'Van Helden', 'Wayman', '1 Flack Blvd', 'Bedfordshire', '6S5 4O3', 'United Kingdom'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (247, 'Imbruglia', 'Rosco', '34 Parker Street', 'Bloomington', 'IN', '1438', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (248, 'Finney', 'Elvis', '14 Telford Drive', 'Blacksburg', 'VA', '15927', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (249, 'Weston', 'Morris', '88 Sandoval Street', 'Elche', '5545', 'Spain'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (250, 'Ceasar', 'Saffron', '29 Lake Forest Road', 'Mönchengladbach', '35136', 'Germany'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (251, 'Makeba', 'Dennis', '67 Rebecca Ave', 'Durban', '14184', 'South Africa'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (252, 'Lewis', 'Carl', '85 Lange Blvd', 'Berkshire', '5B3 6D3', 'United Kingdom'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (253, 'Oszajca', 'Harrison', '23 Schock Drive', 'New Delhi', '15922', 'India'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (254, 'Miles', 'Busta', '73rd Street', 'Oklahoma city', 'OK', '40771', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (255, 'Romijn-Stamos', 'Miles', '40 Weir Road', 'Thames Ditton', '3L5 5X4', 'United Kingdom'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (256, 'De Niro', 'Renee', '75 Alannah Ave', 'Saint Paul', 'MN', '19630', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (257, 'O''Keefe', 'Diane', '41 Coverdale Ave', 'Durban', '4377', 'South Africa'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (258, 'Weller', 'Gabriel', '95 Reinhold Road', 'Oshkosh', 'WI', '9599', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (259, 'Hedaya', 'Oliver', '61st Street', 'Vanderbijlpark', '31592', 'South Africa'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (260, 'Shorter', 'Tramaine', '13 Eisenhüttenstadt Drive', 'Bellevue', 'WA', '16092', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (261, 'Travolta', 'Jesse', '86 Stone Mountain Street', 'Odense', '16837', 'Denmark'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (262, 'Summer', 'Ty', '83 Gagnon', 'Lancaster', 'SC', '24753', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (263, 'Burke', 'Jose', '3 Ripley', 'Erpe-Mere', '22984', 'Belgium'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (264, 'Ramirez', 'Chloe', '67 Lena Street', 'Santa Cruz', 'CA', '3622', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (265, 'Dern', 'Rory', '26 Deschanel Street', 'Durham', 'NC', '8907', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (266, 'McClinton', 'Alannah', '4 Leimen Blvd', 'Lake Bluff', 'IL', '6227', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (267, 'Arthur', 'Cloris', '288 Jay Road', 'Torino', '2932', 'Italy'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (268, 'Aniston', 'Philip', '783 Utada Street', 'Slidel', 'LA', '8975', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (269, 'Apple', 'Stellan', '55 Sonny Street', 'Birmingham', '6H2 3Z2', 'United Kingdom'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (270, 'Curtis', 'Lorraine', '18 Bancroft Road', 'Hines', 'IL', '10583', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (271, 'MacIsaac', 'Brent', '545 Kline Drive', 'North Wales', 'PA', '19693', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (272, 'Crimson', 'Keanu', '77 Horton Street', 'St Kilda', '38204', 'Australia'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (273, 'Deejay', 'Kyle', '23 Udine Street', 'Oyten', '20958', 'Germany'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (274, 'Eldard', 'Sonny', '100 Giraldo Street', 'Sao roque', '26604', 'Brazil'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (275, 'Wen', 'Gloria', '94 Hector Street', 'Schaumburg', 'IL', '35296', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (276, 'Kristofferson', 'Freddy', '11st Street', 'Wellington', '12752', 'New Zealand'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (277, 'Myles', 'Rhona', '92nd Street', 'Pointe-claire', '9S4 3L1', 'Canada'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (278, 'Coyote', 'Debbie', '59 Heald Road', 'Milton Keynes', '0F0 3I4', 'United Kingdom'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (279, 'Humphrey', 'Amy', '72 Timonium Road', 'Warrington', '9T5 3X5', 'United Kingdom'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (280, 'Gunton', 'Ben', '227 Malone Blvd', 'Nagasaki', '27970', 'Japan'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (281, 'Garfunkel', 'Whoopi', '980 McLachlan Street', 'Barueri', '38541', 'Brazil'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (282, 'Sartain', 'Johnny', '495 Dickinson Road', 'Nordhausen', '36067', 'Germany'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (283, 'Randal', 'Robin', '671 Pulheim-brauweiler Street', 'Lexington', 'MA', '35576', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (284, 'Frakes', 'Rhett', '13 Francis Ave', 'Buenos Aires', '20472', 'Argentina'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (285, 'Abraham', 'Eddie', '853 Miles Drive', 'West Sussex', '9W4 9L7', 'United Kingdom'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (286, 'Lightfoot', 'Mykelti', '829 Natacha Drive', 'Boulder', 'CO', '22820', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (287, 'Hutton', 'Davey', '12 Union Street', 'Gaithersburg', 'MD', '39773', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (288, 'Ronstadt', 'Harris', '996 Avital Drive', 'Guadalajara', '29061', 'Mexico'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (289, 'Mazzello', 'Hugh', '39 Carlingford Road', 'Soest', '9884SA', 'Netherlands'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (290, 'Kirkwood', 'Ming-Na', '30 Meyer Road', 'Crete', 'IL', '6744', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (291, 'Lange', 'Eliza', '472 Holly Street', 'Oklahoma city', 'OK', '19362', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (292, 'Cozier', 'Derrick', '12nd Street', 'Seoul', '2426', 'South Korea'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (293, 'LaMond', 'Neil', '7 Day', 'Ulsteinvik', '9818', 'Norway'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (294, 'Latifah', 'Roger', '65 Beckham Road', 'Magstadt', '7292', 'Germany'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (295, 'Clinton', 'Colm', '15 Sayer Ave', 'Riverdale', 'MD', '20021', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (296, 'Molina', 'Bridget', '82 Friedrichshafe Ave', 'Irkutsk', '2124', 'Russia'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (297, 'Durning', 'Grace', '697 Rebecca', 'Glenshaw', 'PA', '25877', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (298, 'Busey', 'Daryl', '319 Brooke Road', 'Snoqualmie', 'WA', '18941', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (299, 'Hurley', 'Sharon', '83 Roy Parnell Drive', 'Hillerød', '5054', 'Denmark'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (300, 'McCain', 'Edie', '1 Julia Street', 'Ramat Gan', '11667', 'Israel'); commit; insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (301, 'Lemmon', 'Jonny Lee', '957 Baker Road', 'Fort gordon', 'GA', '14236', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (302, 'Ryder', 'Phil', '492 Regensburg Drive', 'Rochester', 'MN', '31515', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (303, 'Kane', 'Mindy', '89 Taha Street', 'Horsham', '5V0 1L5', 'United Kingdom'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (304, 'Reed', 'Vin', '376 Humphrey Road', 'Warsaw', '10164', 'Poland'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (305, 'Shannon', 'Terri', '568 Haynes Drive', 'Frederiksberg', '8518', 'Denmark'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (306, 'Garfunkel', 'Davy', '54 Lubbock Street', 'Chambery', '18670', 'France'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (307, 'Vance', 'Alec', '49 Rourke Road', 'Mantova', '14801', 'Italy'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (308, 'Coburn', 'Meg', '56 Koblenz Blvd', 'Québec', '8L3 9W1', 'Canada'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (309, 'DeVita', 'Clive', '87 Colton Road', 'Pottendorf', '25351', 'Austria'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (310, 'Chaplin', 'Quentin', '100 Hayek Street', 'Victoria', '0H5 4I4', 'Canada'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (311, 'Stevenson', 'Chet', '48 Sampson', 'Hochwald', '26450', 'Switzerland'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (312, 'Pollack', 'Solomon', '33 Bonham Road', 'Vista', 'CA', '37461', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (313, 'Silverman', 'Dwight', '16 Rubinek Street', 'Joinville', '6728', 'Brazil'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (314, 'Rickman', 'Stephen', '15 Budapest Street', 'Bautzen', '28115', 'Germany'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (315, 'Kirkwood', 'Donal', '72 Anières Street', 'Sendai', '23759', 'Japan'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (316, 'Haysbert', 'Hilton', '731 Klein', 'Harsum', '15503', 'Germany'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (317, 'Raitt', 'Hilton', '862 Winstone Street', 'Redding', 'CA', '25148', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (318, 'Griggs', 'Burt', '34 Hank Blvd', 'Borger', 'TX', '27864', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (319, 'Heche', 'Ozzy', '15 Porto alegre Street', 'Sapulpa', 'OK', '3091', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (320, 'McGregor', 'Bernard', '23rd Street', 'Taoyuan', '10223', 'Taiwan'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (321, 'Cleary', 'Reese', '49 Michael Drive', 'Charlottesville', 'VA', '9742', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (322, 'Loring', 'Frederic', '906 Shalhoub Ave', 'Narrows', 'VA', '1571', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (323, 'urban', 'Joaquin', '40 Dern Drive', 'Luzern', '24856', 'Switzerland'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (324, 'McClinton', 'Garry', '81st Street', 'Runcorn', '5E3 7Z5', 'United Kingdom'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (325, 'Everett', 'Julio', '72 Mitchell Street', 'Dublin', '29967', 'Ireland'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (326, 'Lovitz', 'Chet', '128 Woodward Street', 'Jakarta', '12873', 'Indonesia'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (327, 'Cube', 'Manu', '85 O''Sullivan Street', 'Naestved', '23134', 'Denmark'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (328, 'Dutton', 'Graham', '48 Pelvic Road', 'Takamatsu', '33325', 'Japan'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (329, 'Statham', 'Tim', '86 Tanon', 'Herndon', 'VA', '12608', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (330, 'Kennedy', 'Tara', '1 Melba Road', 'Courbevoie', '19769', 'France'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (331, 'Van Damme', 'Ceili', '16 Thornton Road', 'Saitama', '19886', 'Japan'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (332, 'Harrison', 'Nikki', '77 LaBelle Road', 'Leverkusen', '15687', 'Germany'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (333, 'Myers', 'Jeroen', '47 Horace Street', 'København', '37420', 'Denmark'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (334, 'Laurie', 'Miki', '53rd Street', 'Portland', 'OR', '27666', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (335, 'Farrell', 'Eric', '978 Daryl Drive', 'Milford', 'NH', '39078', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (336, 'Perez', 'Gary', '96 Watson Road', 'Guadalajara', '22485', 'Mexico'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (337, 'Horton', 'Carol', '61st Street', 'Peine', '23113', 'Germany'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (338, 'Conroy', 'Gladys', '742 Cassel Street', 'Neustadt', '15651', 'Germany'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (339, 'Kleinenberg', 'Chet', '80 Birmensdorf Road', 'Herzogenrath', '12798', 'Germany'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (340, 'Gatlin', 'Garland', '487 Bernex Ave', 'Grand-mere', '3M2 9W1', 'Canada'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (341, 'Cole', 'Natasha', '38 Wolf Road', 'Germantown', 'MD', '17352', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (342, 'Butler', 'Lynette', '55 Reeves', 'Bradenton', 'FL', '36387', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (343, 'Westerberg', 'Allison', '52nd Street', 'Ismaning', '12373', 'Germany'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (344, 'Benet', 'Gino', '819 Fraser Ave', 'Sheffield', '2J7 6N1', 'United Kingdom'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (345, 'Pleasence', 'Sean', '12 Minogue Drive', 'Kobe', '38077', 'Japan'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (346, 'Branch', 'Bette', '31 Lehi', 'Wellington', '9208', 'New Zealand'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (347, 'Forrest', 'Holland', '319 Jon Road', 'Morioka', '33748', 'Japan'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (348, 'Feuerstein', 'Gord', '94 Brooks Blvd', 'Ciudad del Este', '34288', 'Paraguay'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (349, 'Scaggs', 'Ellen', '55 Schneider', 'El Paso', 'TX', '38914', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (350, 'Payne', 'Keanu', '22nd Street', 'Augst', '37791', 'Switzerland'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (351, 'Delta', 'Vendetta', '44 Thorton Street', 'Kerava', '14747', 'Finland'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (352, 'Tucci', 'Sander', '793 Richard Street', 'Olsztyn', '21253', 'Poland'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (353, 'McKean', 'Rich', '58 Preston Road', 'Reno', 'NV', '5905', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (354, 'Savage', 'Mike', '12 Quaid Drive', 'Yomgok-dong', '6621', 'South Korea'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (355, 'Lawrence', 'Randall', '65 Nikka Road', 'Carlin', 'NV', '25930', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (356, 'Zahn', 'Chet', '87 Meniketti Road', 'Cle Elum', 'WA', '30213', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (357, 'Gaynor', 'Buffy', '7 Zafferana Etnea Road', 'Istanbul', '18023', 'Turkey'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (358, 'Williamson', 'Bret', '94 Tilly', 'Cedar Rapids', 'IA', '8137', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (359, 'Vance', 'Nile', '80 Hubbard Road', 'Miyazaki', '15967', 'Japan'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (360, 'Baker', 'Ray', '65 Kleinenberg', 'Bergen', '30796', 'Denmark'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (361, 'Gates', 'Geraldine', '563 Borden Road', 'Victoria', '6J0 4H8', 'Canada'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (362, 'Shocked', 'Cuba', '570 Allan Drive', 'Gersthofen', '17453', 'Germany'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (363, 'Favreau', 'Jimmy', '7 Koyana Street', 'Irati', '28245', 'Brazil'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (364, 'Balin', 'Daniel', '589 Larter Road', 'Redding', 'CA', '25363', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (365, 'Wells', 'Gailard', '53 Jean-Claude Street', 'Ternitz', '39019', 'Austria'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (366, 'Rain', 'Rachid', '83 McKennitt Road', 'Luzern', '7686', 'Switzerland'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (367, 'Cattrall', 'Alan', '84 Portman Road', 'Research Triangle', 'NC', '12504', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (368, 'McCready', 'Frankie', '13 Crouse Drive', 'Edinburgh', '5Z9 2M5', 'United Kingdom'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (369, 'Winans', 'Denny', '83 Sirtis Street', 'Oulu', '36516', 'Finland'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (370, 'Head', 'Merillee', '9 Hurley Drive', 'Eindhoven', '3499BJ', 'Netherlands'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (371, 'Union', 'Donal', '47 Conlee Road', 'Lowell', 'MA', '34234', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (372, 'Northam', 'Debby', '879 Framingham Drive', 'Geneve', '20516', 'Switzerland'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (373, 'Abraham', 'Andrae', '71 Horizon Blvd', 'Ben-Gurion', '7730', 'Israel'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (374, 'King', 'Vince', '28 Klein Blvd', 'Huntington', 'WV', '1760', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (375, 'Winwood', 'Alana', '12nd Street', 'Bruxelles', '21063', 'Belgium'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (376, 'Zellweger', 'Dick', '628 Spine Drive', 'Santa rita sapucaí', '37947', 'Brazil'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (377, 'Cagle', 'Lydia', '51st Street', 'Rheinfelden', '23352', 'Switzerland'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (378, 'Christie', 'Hope', '12 Gettysburg Blvd', 'Matsuyama', '23025', 'Japan'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (379, 'Colin Young', 'Morgan', '91 Hillerød', 'Ellicott City', 'MD', '40460', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (380, 'Short', 'Terrence', '93 Livermore', 'Shizuoka', '6728', 'Japan'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (381, 'Wells', 'Billy', '88 Jeremy Road', 'West Chester', 'OH', '34066', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (382, 'Lynn', 'Heather', '9 Emma', 'Niigata', '16950', 'Japan'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (383, 'Waits', 'Juan', '92nd Street', 'Immenstaad', '11536', 'Germany'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (384, 'Brosnan', 'Tommy', '58 Walter Street', 'Offenburg', '11537', 'Germany'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (385, 'Holeman', 'Merle', '90 Harrison Drive', 'Oldham', '8A0 9U5', 'United Kingdom'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (386, 'Skerritt', 'Jann', '525 Sutherland Drive', 'Flower mound', 'TX', '18125', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (387, 'Williamson', 'Mary Beth', '98 Carlingford Street', 'Zuerich', '28237', 'Switzerland'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (388, 'Dushku', 'Russell', '837 Rip Road', 'Ebersberg', '2225', 'Germany'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (389, 'Crystal', 'Tara', '90 Schwarzenegger Road', 'Peterborough', 'NH', '7286', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (390, 'Burstyn', 'Carlene', '49 Haggard Street', 'Seatle', 'WA', '20092', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (391, 'Whitaker', 'Nile', '92 Lopez Street', 'El Paso', 'TX', '21318', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (392, 'Cochran', 'Jim', '88 Pamela Street', 'Golden', 'CO', '30471', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (393, 'Nicholson', 'Giovanni', '24 Seth Road', 'Milton Keynes', '4P9 9D4', 'United Kingdom'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (394, 'Patton', 'Kasey', '80 Brussel Drive', 'Rancho Palos Verdes', 'CA', '36748', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (395, 'Woods', 'Anita', '74 Gliwice Ave', 'Calgary', '7R5 0G6', 'Canada'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (396, 'Jamal', 'Catherine', '40 Chao', 'Soroe', '10242', 'Denmark'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (397, 'Cetera', 'Maureen', '39 Kirsten Ave', 'Miami', 'FL', '1637', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (398, 'Marin', 'Casey', '20 Avital Drive', 'Framingaham', 'MA', '26903', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (399, 'Diggs', 'Sheena', '7 Teena Ave', 'Louisville', 'KY', '26118', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (400, 'Studi', 'Lydia', '38 Chubby Street', 'Netanya', '13703', 'Israel'); commit; insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (401, 'Vai', 'Lara', '592 McElhone', 'Eindhoven', '0300JJ', 'Netherlands'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (402, 'Estevez', 'Orlando', '88 Allan Street', 'Hayward', 'CA', '36856', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (403, 'Bugnon', 'Natalie', '91 Heiligenhaus Ave', 'Hohenfels', '22100', 'Germany'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (404, 'Caldwell', 'Larry', '65 Arjona Road', 'Chapeco', '31657', 'Brazil'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (405, 'Evett', 'Danni', '55 Gino Street', 'Pusan-city', '14848', 'South Korea'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (406, 'Watley', 'Nick', '88 Squier Ave', 'Münster', '39752', 'Germany'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (407, 'Shatner', 'Thomas', '28 Hurley Street', 'Salvador', '2990', 'Brazil'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (408, 'Katt', 'Christine', '34 Secada Street', 'Fukui', '15506', 'Japan'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (409, 'White', 'Milla', '205 Judd Ave', 'Paço de Arcos', '31522', 'Portugal'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (410, 'Stanton', 'Brenda', '42nd Street', 'Reykjavik', '3461', 'Iceland'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (411, 'Lee', 'Rob', '77 New Castle Drive', 'Waterloo', '3C8 6O1', 'Canada'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (412, 'Church', 'Christine', '20 Bergen Blvd', 'Concordville', 'PA', '19293', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (413, 'Collins', 'Stephen', '70 Miyazaki Street', 'Birmingham', '5X3 9J0', 'United Kingdom'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (414, 'Ferrell', 'Ann', '787 Essen Street', 'Knutsford', '9I9 2J9', 'United Kingdom'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (415, 'Nivola', 'Vivica', '51 Ankara Road', 'Stone Mountain', 'GA', '32024', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (416, 'Ingram', 'Andrae', '100 Cartlidge Street', 'Oyten', '14901', 'Germany'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (417, 'Pleasence', 'Marina', '118 Algermissen Blvd', 'Fukushima', '28001', 'Japan'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (418, 'Cruz', 'Amy', '92 Billund Road', 'Double Oak', 'TX', '36374', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (419, 'Salonga', 'Gil', '75 Porto alegre Street', 'Bologna', '40962', 'Ireland'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (420, 'Caviezel', 'Radney', '79 Springfield Drive', 'Burlington', '2G0 6P1', 'Canada'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (421, 'Ceasar', 'Harris', '72nd Street', 'Carlin', 'NV', '18806', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (422, 'Biggs', 'Roger', '13 Caroline Road', 'Debary', 'FL', '39950', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (423, 'Marx', 'Winona', '661 Curtis-Hall Drive', 'Farnham', '0T8 2I3', 'United Kingdom'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (424, 'Scaggs', 'Rory', '27 Jackson Street', 'San Diego', 'CA', '39374', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (425, 'Lewin', 'Leo', '94 Burt Street', 'New Castle', 'DE', '14517', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (426, 'Whitley', 'Ray', '839 Changwon-si Blvd', 'Bielefeld', '9425', 'Germany'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (427, 'Hall', 'Teena', '128 La Plata Blvd', 'Steyr', '21094', 'Austria'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (428, 'Wainwright', 'Steven', '14 Thomas Drive', 'Vienna', 'VA', '9864', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (429, 'Candy', 'Nikka', '870 Sayer Road', 'Redwood Shores', 'CA', '31678', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (430, 'Shocked', 'Meryl', '18 Gellar', 'Immenstaad', '20948', 'Germany'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (431, 'Cruz', 'Debby', '41st Street', 'Nagasaki', '37593', 'Japan'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (432, 'Warden', 'Mili', '48 Jeffreys Road', 'Oshkosh', 'WI', '36888', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (433, 'Channing', 'Derrick', '81st Street', 'Rochester', 'NY', '29812', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (434, 'Idol', 'Stevie', '40 Aiken Ave', 'Pottendorf', '2661', 'Austria'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (435, 'Chan', 'Kenny', '18 Worrell Street', 'Neuchâtel', '20715', 'Switzerland'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (436, 'Strathairn', 'Devon', '99 Derringer Road', 'Lancaster', 'SC', '28470', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (437, 'Gooding', 'Jena', '84 Visnjic Street', 'Warszawa', '40607', 'Poland'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (438, 'Worrell', 'Keith', '38 Las Vegas Street', 'Forest Park', 'IL', '8184', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (439, 'Neeson', 'Julia', '57 Cummings Street', 'Redhill', '9J3 7Q1', 'United Kingdom'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (440, 'Mueller-Stahl', 'Taryn', '61 Rifkin Drive', 'Olivette', 'MO', '9045', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (441, 'Coltrane', 'Davis', '90 Bedford Drive', 'Ankara', '24370', 'Turkey'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (442, 'Byrne', 'Lenny', '46 Night Blvd', 'Münster', '16864', 'Germany'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (443, 'Lightfoot', 'Eugene', '80 Blair', 'West Launceston', '6356', 'Australia'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (444, 'Aglukark', 'Katie', '948 Chalee Street', 'Stellenbosch', '30116', 'South Africa'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (445, 'Weiland', 'Danny', '26 O''Sullivan Road', 'San Francisco', 'CA', '4814', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (446, 'McDowall', 'Mia', '240 Delbert Street', 'Rockland', 'ME', '13956', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (447, 'Craven', 'Hugh', '11st Street', 'Nizhnevartovsk', '29470', 'Russia'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (448, 'Supernaw', 'Cherry', '83 Tamala Street', 'Edison', 'NJ', '16539', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (449, 'Child', 'Boz', '62 Swoosie Blvd', 'Alpharetta', 'GA', '35684', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) values (450, 'Utada', 'Art', '77 Hersh Street', 'Melrose park', 'IL', '33363', 'USA'); insert into SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, POSTAL_CODE, COUNTRY) values (451, 'Chao', 'Andrae', '9 Connery Street', 'Runcorn', '2H1 5S8', 'United Kingdom'); commit; SET FEEDBACK ON SET ECHO ON ----- -- Now, create additional entries by adding to the primary key value ----- INSERT INTO SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) SELECT (salesperson_id + 1000), last_name, first_name, address_line_3, city, state, postal_code, country from sh.sales_agents; COMMIT; INSERT INTO SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) SELECT (salesperson_id + 2000), last_name, first_name, address_line_3, city, state, postal_code, country from sh.sales_agents; COMMIT; INSERT INTO SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) SELECT (salesperson_id + 4000), last_name, first_name, address_line_3, city, state, postal_code, country from sh.sales_agents; COMMIT; INSERT INTO SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) SELECT (salesperson_id + 8000), last_name, first_name, address_line_3, city, state, postal_code, country from sh.sales_agents; COMMIT; INSERT INTO SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) SELECT (salesperson_id + 16000), last_name, first_name, address_line_3, city, state, postal_code, country from sh.sales_agents; COMMIT; INSERT INTO SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) SELECT (salesperson_id + 32000), last_name, first_name, address_line_3, city, state, postal_code, country from sh.sales_agents; COMMIT; INSERT INTO SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) SELECT (salesperson_id + 64000), last_name, first_name, address_line_3, city, state, postal_code, country from sh.sales_agents; COMMIT; INSERT INTO SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) SELECT (salesperson_id + 128000), last_name, first_name, address_line_3, city, state, postal_code, country from sh.sales_agents; COMMIT; INSERT INTO SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) SELECT (salesperson_id + 256000), last_name, first_name, address_line_3, city, state, postal_code, country from sh.sales_agents; COMMIT; INSERT INTO SH.SALES_AGENTS (SALESPERSON_ID, LAST_NAME, FIRST_NAME, ADDRESS_LINE_3, CITY, STATE, POSTAL_CODE, COUNTRY) SELECT (salesperson_id + 512000), last_name, first_name, address_line_3, city, state, postal_code, country from sh.sales_agents; COMMIT; ----- -- Refresh table and index statistics ----- BEGIN DBMS_STATS.GATHER_TABLE_STATS( ownname => 'SH' ,tabname => 'SALES_AGENTS' ,cascade => TRUE ); END; /