Lab 02: Data Manipulation Part 1 1- Copy and paste the content of the text file Lab02_Data.txt into any SQL Editor, then execute it. This code will create the table Agents and insert sample data into it. Provide the SQL statements that perform the following tasks: 2- List full details of all agents. 3- List full details of all agents sorted in the descending order of the date of birth. 4- List the agent number, the first and last names, the state, and the salary of all agents. 5- List the agent number, the first and last names, the state, and the salary of all agents sorted in the ascending order of the state and the descending order of the salary. 6- Produce a list for all agents, showing the agent number, the first and last names, and the monthly salaries (salary/12). Use the AS clause to name the last column monthlySalary. 7- List the state attribute of all agents. 8- Use the DISTINCT keyword to list the state values without duplications. 9- List the agent number, the first and last names, the address, the city, the state, and the salary of all agents with a salary greater than $50000. 10- List the agent number, the first and last names, the address, the city, the state, and the salary of all agents with a salary greater than $50000 and live in NY state. 11- List the agent number, the first and last names, the address, the city, the state, and the salary of all agents with a salary greater than $50000 and live in either NY state or MI state. Note: In this task, parenthesis should be used appropriately. 12- Use the BETWEEN keyword to list the agent number, the first and last names, the address, the city, the state, and the salary of all agents with a salary greater than $47000 and les than $50000. 13- Use the IN keyword to list full details of all agents living in any of the following states: CT, OH, or TX. 14- Use the NOT IN keyword to list full details of all agents who do not work in the branches B002 and B005. 15- Use the LIKE keyword to list full details of all agents with phone1 starting with '212-'. 16- List full details of all agents with the string 'Highway' in their address. 17- Use the LIKE keyword to list full details of all agents with first name having exactly 4 letters. 18- Use the LIKE keyword to list full details of all agents with email addresses not from yahoo.com. 19- List details of agents with empty phone1 numbers. 20- List details of agents with valid phone2 numbers (values are not empty)

lab 2.txt

CREATE TABLE Agents ( agentNo VARCHAR2(4), fName VARCHAR2(20), lName VARCHAR2(20), branchNo VARCHAR2(4), salary NUMBER(8,2), dob DATE, address VARCHAR2(50), city VARCHAR2(30), county VARCHAR2(30), state VARCHAR2(2), zip VARCHAR2(5), phone1 VARCHAR2(20), phone2 VARCHAR2(20), email VARCHAR2(50), CONSTRAINT agents_pk PRIMARY KEY (agentNo)); INSERT INTO Agents VALUES('A011','Minna','Amigon','B002','33000','01-SEP-1981','2371 Jerrold Ave','Kulpsville','Montgomery','PA','19443','215-874-1229',NULL,'minna_amigon@yahoo.com'); INSERT INTO Agents VALUES('A053','Sabra','Uyetake','B002','33000','06-JUL-1973','98839 Hawthorne Blvd #6101','Columbia','Richland','SC','29201','803-925-5213','803-681-3678','sabra@uyetake.org'); INSERT INTO Agents VALUES('A083','Arlette','Honeywell','B002','26000','09-JUL-1985','11279 Loytan St','Jacksonville','Duval','FL','32254','904-775-4480','904-514-9918','ahoneywell@honeywell.com'); INSERT INTO Agents VALUES('A094','Wilda','Giguere','B002','43000','02-APR-1988','1747 Calle Amanecer #2','Anchorage','Anchorage','AK','99501','907-870-5536','907-914-9482','wilda@cox.net'); INSERT INTO Agents VALUES('A102','Louisa','Cronauer','B002','48000','03-MAR-1993','524 Louisiana Ave Nw','San Leandro','Alameda','CA','94577','510-828-7047','510-472-7758','louisa@cronauer.com'); INSERT INTO Agents VALUES('A115','Pamella','Schmierer','B002','29000','21-JUL-1955','5161 Dorsett Rd','Homestead','Miami-Dade','FL','33030','305-420-8970','305-575-8481','pamella.schmierer@schmierer.org'); INSERT INTO Agents VALUES('A123','Lindsey','Dilello','B002','30000','05-MAR-1957','52777 Leaders Heights Rd','Ontario','San Bernardino','CA','91761','909-639-9887','909-589-1693','lindsey.dilello@hotmail.com'); INSERT INTO Agents VALUES('A135','Becky','Mirafuentes','B002','41000','08-JAN-1991','30553 Washington Rd','Plainfield','Union','NJ','07062','908-877-8409',NULL,'becky.mirafuentes@mirafuentes.com'); INSERT INTO Agents VALUES('A142','Sheridan','Zane','B002','36000','19-MAY-1971','2409 Alabama Rd','Riverside','Riverside','CA','92501','951-645-3605',NULL,'sheridan.zane@zane.com'); INSERT INTO Agents VALUES('A167','Fannie','Lungren','B002','32000','25-JUL-1985','17 Us Highway 111','Round Rock','Williamson','TX','78664','512-587-5746','512-528-9933','fannie.lungren@yahoo.com'); INSERT INTO Agents VALUES('A181','Marguerita','Hiatt','B002','47000','01-JAN-1991','82 N Highway 67','Oakley','Contra Costa','CA','94561','925-634-7158','925-541-8521',); INSERT INTO Agents VALUES('A185','Benton','Skursky','B002','48000','03-APR-1988','47939 Porter Ave','Gardena','Los Angeles','CA','90248','310-579-2907',NULL,'benton.skursky@aol.com'); INSERT INTO Agents VALUES('A202','Helga','Fredicks','B002','30000','09-MAR-1993','42754 S Ash Ave','Buffalo','Erie','NY','14228','716-752-4114',NULL,NULL); INSERT INTO Agents VALUES('A208','Aliza','Baltimore','B002','46000','14-FEB-1962','1128 Delaware St','San Jose','Santa Clara','CA','95132','408-504-3552','408-425-1994','aliza@aol.com'); INSERT INTO Agents VALUES('A226','Tiera','Frankel','B002','19200','04-FEB-1956','87 Sierra Rd','El Monte','Los Angeles','CA','91731','626-636-4117','626-638-4241','tfrankel@aol.com'); INSERT INTO Agents VALUES('A231','Justine','Mugnolo','B002','27000','16-AUG-1962','38062 E Main St','New York','New York','NY','10048',NULL,NULL,'jmugnolo@yahoo.com'); INSERT INTO Agents VALUES('A233','Chaya','Malvin','B002','41000','06-AUG-1974','560 Civic Center Dr','Ann Arbor','Washtenaw','MI','48103','734-928-5182','734-408-8174','chaya@malvin.com'); INSERT INTO Agents VALUES('A257','Deandrea','Hughey','B002','30000','27-NOV-1965','33 Lewis Rd #46','Burlington','Alamance','NC','27215','336-822-7652',NULL,'deandrea@yahoo.com'); INSERT INTO Agents VALUES('A262','Charlene','Hamilton','B002','35000','16-APR-1964','985 E 6th Ave','Santa Rosa','Sonoma','CA','95407','707-300-1771','707-821-8037','charlene.hamilton@hotmail.com'); INSERT INTO Agents VALUES('A285','Lavonda','Hengel','B002','45000','01-MAY-1965','87 Imperial Ct #79','Fargo','Cass','ND','58102','701-898-2154','701-421-7080','lavonda@cox.net'); INSERT INTO Agents VALUES('A288','Casie','Good','B002','26000','08-NOV-1971','5221 Bear Valley Rd','Nashville','Davidson','TN','37211','615-390-2251','615-825-4297','casie.good@aol.com'); INSERT INTO Agents VALUES('A293','Raul','Upthegrove','B002','32000','08-JUN-1960','4 E Colonial Dr','La Mesa','San Diego','CA','91942','619-509-5282',NULL,NULL); INSERT INTO Agents VALUES('A305','Ligia','Reiber','B002','56000','15-MAY-1983','206 Main St #2804','Lansing','Ingham','MI','48933','517-906-1108','517-747-7664','lreiber@cox.net'); INSERT INTO Agents VALUES('A314','Kattie','Vonasek','B002','43000','19-JUL-1991','2845 Boulder Crescent St','Cleveland','Cuyahoga','OH','44103','216-923-3715',NULL,'kattie@vonasek.org'); INSERT INTO Agents VALUES('A326','Adelina','Nabours','B002','32000','20-AUG-1992','80 Pittsford Victor Rd #9','Cleveland','Cuyahoga','OH','44103','216-230-4892','216-937-5320',NULL); INSERT INTO Agents VALUES('A337','Dulce','Labreche','B002','41000','11-JAN-1979','9581 E Arapahoe Rd','Rochester','Oakland','MI','48307','248-357-8718','248-811-5696','dulce_labreche@yahoo.com'); INSERT INTO Agents VALUES('A349','Samira','Heintzman','B002','43000','03-AUG-1980','8772 Old County Rd #5410','Kent','King','WA','98032','206-311-4137','206-923-6042','sheintzman@hotmail.com'); INSERT INTO Agents VALUES('A354','Denise','Patak','B002','34000','13-NOV-1989','2139 Santa Rosa Ave','Orlando','Orange','FL','32801','407-446-4358','407-808-3254','denise@patak.org'); INSERT INTO Agents VALUES('A377','Markus','Lukasik','B002','31000','12-FEB-1980','89 20th St E #779','Sterling Heights','Macomb','MI','48310','586-970-7380','586-247-1614','markus@yahoo.com'); INSERT INTO Agents VALUES('A380','Gayla','Schnitzler','B002','30000','08-NOV-1989','38 Pleasant Hill Rd','Hayward','Alameda','CA','94545',NULL,NULL,); INSERT INTO Agents VALUES('A396','Annelle','Tagala','B002','41000','16-DEC-1996','5 W 7th St','Parkville','Baltimore','MD','21234','410-757-1035','410-234-2267','annelle@yahoo.com'); INSERT INTO Agents VALUES('A419','Merissa','Tomblin','B002','27000','07-AUG-1992','34 Raritan Center Pky','Bellflower','Los Angeles','CA','90706',NULL,NULL,'merissa.tomblin); INSERT INTO Agents VALUES('A442','Shonda','Greenbush','B002','28000','01-JUN-1984','82 Us Highway 46','Clifton','Passaic','NJ','07011','973-482-2430','973-644-2974','shonda_greenbush@cox.net'); INSERT INTO Agents VALUES('A453','Cristal','Samara','B002','42000','27-NOV-1983','4119 Metropolitan Dr','Los Angeles','Los Angeles','CA','90021','213-975-8026',NULL,NULL); INSERT INTO Agents VALUES('A454','Kenneth','Grenet','B002','29000','14-APR-1982','2167 Sierra Rd','East Lansing','Ingham','MI','48823','517-499-2322','517-867-8077','kenneth.grenet@grenet.org'); INSERT INTO Agents VALUES('A458','Nu','Mcnease','B002','31000','02-JUL-1985','88 Sw 28th Ter','Harrison','Hudson','NJ','07029','973-751-9003','973-903-4175',); INSERT INTO Agents VALUES('A462','Nan','Koppinger','B002','36000','01-JAN-1967','88827 Frankford Ave','Greensboro','Guilford','NC','27401','336-370-5333','336-564-1492','nan@koppinger.com'); INSERT INTO Agents VALUES('A477','Glory','Schieler','B002','26000','03-FEB-1992','5 E Truman Rd','Abilene','Taylor','TX','79602','325-869-2649',NULL,'glory@yahoo.com'); INSERT INTO Agents VALUES('A487','Dorothy','Chesterfield','B002','31000','15-JAN-1967','469 Outwater Ln','San Diego','San Diego','CA','92126','858-617-7834',NULL,'dorothy@cox.net'); INSERT INTO Agents VALUES('A492','Thaddeus','Ankeny','B002','37000','18-JUN-1966','5 Washington St #1','Roseville','Placer','CA','95678','916-920-3571','916-459-2433','tankeny@ankeny.org'); INSERT INTO Agents VALUES('A493','Jovita','Oles','B002','45000','07-MAY-1983','8 S Haven St','Daytona Beach','Volusia','FL','32114','386-248-4118','386-208-6976',NULL); INSERT INTO Agents VALUES('A495','Lai','Harabedian','B002','37000','08-AUG-1956','1933 Packer Ave #2','Novato','Marin','CA','94945','415-423-3294','415-926-6089',' ); INSERT INTO Agents VALUES('A020','Fletcher','Flosi','B005','60000','17-SEP-1981','394 Manchester Blvd','Rockford','Winnebago','IL','61109',NULL,NULL,'fletcher.flosi@yahoo.com'); INSERT INTO Agents VALUES('A029','Willow','Kusko','B005','40000','07-NOV-1995','90991 Thorburn Ave','New York','New York','NY','10011','212-582-4976','212-934-5167','wkusko@yahoo.com'); INSERT INTO Agents VALUES('A036','Solange','Shinko','B005','43000','01-SEP-1993','426 Wolf St','Metairie','Jefferson','LA','70002','504-979-9175',NULL,NULL); INSERT INTO Agents VALUES('A056','Tonette','Wenner','B005','51000','03-DEC-1978','4545 Courthouse Rd','Westbury','Nassau','NY','11590','516-968-6051',NULL,'twenner@aol.com'); INSERT INTO Agents VALUES('A072','Johnetta','Abdallah','B005','26000','02-MAR-1969','1088 Pinehurst St','Chapel Hill','Orange','NC','27514','919-225-9345','919-715-3791','johnetta_abdallah@aol.com'); INSERT INTO Agents VALUES('A091','Tammara','Wardrip','B005','45000','25-NOV-1977','4800 Black Horse Pike','Burlingame','San Mateo','CA','94010','650-803-1936',NULL,'twardrip@cox.net'); INSERT INTO Agents VALUES('A143','Bulah','Padilla','B005','50000','15-SEP-1975','8927 Vandever Ave','Waco','McLennan','TX','76707','254-463-4368','254-816-8417','bulah_padilla@hotmail.com'); INSERT INTO Agents VALUES('A180','Nelida','Sawchuk','B005','48000','14-APR-1964','3 State Route 35 S','Paramus','Bergen','NJ','07652','201-971-1638',NULL,'); INSERT INTO Agents VALUES('A190','Georgene','Montezuma','B005','47000','04-APR-1994','98 University Dr','San Ramon','Contra Costa','CA','94583','925-615-5185','925-943-3449','gmontezuma@cox.net'); INSERT INTO Agents VALUES('A199','Gracia','Melnyk','B005','36000','08-JUN-1984','97 Airport Loop Dr','Jacksonville','Duval','FL','32216','904-235-3633','904-627-4341','gracia@melnyk.com'); INSERT INTO Agents VALUES('A247','Marvel','Raymo','B005','54000','20-FEB-1980','9 Vanowen St','College Station','Brazos','TX','77840','979-718-8968','979-809-5770','mraymo@yahoo.com'); INSERT INTO Agents VALUES('A258','Kimberlie','Duenas','B005','38000','26-JUN-1990','8100 Jacksonville Rd #7','Hays','Ellis','KS','67601','785-629-8542','785-616-1685','kimberlie_duenas@yahoo.com'); INSERT INTO Agents VALUES('A277','Detra','Coyier','B005','46000','06-FEB-1986','96950 Hidden Ln','Aberdeen','Harford','MD','21001','410-739-9277','410-259-2118','detra@aol.com'); INSERT INTO Agents VALUES('A295','Lucy','Treston','B005','29000','03-MAR-1957','57254 Brickell Ave #372','Worcester','Worcester','MA','01602','508-769-5250','508-502-5634','lucy@cox.net'); INSERT INTO Agents VALUES('A302','Jenelle','Regusters','B005','55000','03-JUN-1966','3211 E Northeast Loop','Tampa','Hillsborough','FL','33619','813-932-8715',NULL,'jregusters@regusters.com'); INSERT INTO Agents VALUES('A306','Christiane','Eschberger','B005','46000','16-DEC-1972','96541 W Central Blvd','Phoenix','Maricopa','AZ','85034','602-390-4944','602-330-6894','christiane.eschberger@yahoo.com'); INSERT INTO Agents VALUES('A312','Erinn','Canlas','B005','57000','05-OCT-1988','13 S Hacienda Dr','Livingston','Essex','NJ','07039','973-767-3008','973-563-9502','erinn.canlas@canlas.com'); INSERT INTO Agents VALUES('A331','Aja','Gehrett','B005','21800','05-JUL-1955','993 Washington Ave','Nutley','Essex','NJ','07110','973-544-2677','973-986-4456','aja_gehrett@hotmail.com'); INSERT INTO Agents VALUES('A339','Kaitlyn','Ogg','B005','42000','15-NOV-1995','2 S Biscayne Blvd','Baltimore','Baltimore City','MD','21230','410-665-4903','410-773-3862','kaitlyn.); INSERT INTO Agents VALUES('A345','Lashaunda','Lizama','B005','58000','09-MAY-1989','3387 Ryan Dr','Hanover','Anne Arundel','MD','21076','410-678-2473',NULL,'llizama@cox.net'); INSERT INTO Agents VALUES('A370','Regenia','Kannady','B005','47000','19-MAR-1975','10759 Main St','Scottsdale','Maricopa','AZ','85260','480-726-1280','480-205-5121','regenia.kannady@cox.net'); INSERT INTO Agents VALUES('A376','Paz','Sahagun','B005','40000','09-SEP-1981','919 Wall Blvd','Meridian','Lauderdale','MS','39307','601-927-8287','601-249-4511','paz_sahagun@cox.net'); INSERT INTO Agents VALUES('A379','Cyril','Daufeldt','B005','61000','11-MAR-1957','3 Lawton St','New York','New York','NY','10013','212-745-8484',NULL,'cyril_daufeldt@daufeldt.com'); INSERT INTO Agents VALUES('A390','Lizbeth','Kohl','B005','32000','05-JUN-1990','35433 Blake St #588','Gardena','Los Angeles','CA','90248',NULL,NULL,'lizbeth@yahoo.com'); INSERT INTO Agents VALUES('A393','Lenna','Newville','B005','37000','04-MAY-1971','987 Main St','Raleigh','Wake','NC','27601','919-623-2524','919-254-5987','lnewville@newville.com'); INSERT INTO Agents VALUES('A406','Hubert','Walthall','B005','44000','24-DEC-1996','95 Main Ave #2','Barberton','Summit','OH','44203','330-903-1345','330-566-8898','hubert@walthall.org'); INSERT INTO Agents VALUES('A407','Arthur','Farrow','B005','50000','13-MAR-1963','28 S 7th St #2824','Englewood','Bergen','NJ','07631','201-238-5688',NULL,'arthur.farrow@yahoo.com'); INSERT INTO Agents VALUES('A408','Vilma','Berlanga','B005','56000','18-AUG-1986','79 S Howell Ave','Grand Rapids','Kent','MI','49546','616-737-3085','616-568-4113',NULL); INSERT INTO Agents VALUES('A417','Eden','Jayson','B005','37000','11-JUL-1991','4 Iwaena St','Baltimore','Baltimore City','MD','21202','410-890-7866',NULL,NULL); INSERT INTO Agents VALUES('A421','Catarina','Gleich','B005','46000','17-JUL-1967','78 Maryland Dr #146','Denville','Morris','NJ','07834','973-210-3994','973-491-8723',NULL); INSERT INTO Agents VALUES('A430','Selma','Husser','B005','31000','08-OCT-1958','9 State Highway 57 #22','Jersey City','Hudson','NJ','07306','201-991-8369','201-772-7699','selma.husser@cox.net'); INSERT INTO Agents VALUES('A479','Alpha','Palaia','B005','27000','22-DEC-1972','43496 Commercial Dr #29','Cherry Hill','Camden','NJ','08003','856-312-2629',NULL,'alpha@yahoo.com'); INSERT INTO Agents VALUES('A037','Jose','Stockham','B010','29000','08-DEC-1996','128 Bransten Rd','New York','New York','NY','10011','212-675-8570','212-569-4233','jose@yahoo.com'); INSERT INTO Agents VALUES('A043','Roxane','Campain','B010','59700','05-JUL-1991','1048 Main St','Fairbanks','Fairbanks North Star','AK','99708','907-231-4722','907-335-6568','roxane@hotmail.com'); INSERT INTO Agents VALUES('A076','Moon','Parlato','B010','19400','10-APR-1994','74989 Brandon St','Wellsville','Allegany','NY','14895','585-866-8313','585-498-4278','moon@yahoo.com'); INSERT INTO Agents VALUES('A089','Stephen','Emigh','B010','42000','25-JAN-1955','3777 E Richmond St #900','Akron','Summit','OH','44302',NULL,NULL,'stephen_emigh@hotmail.com'); INSERT INTO Agents VALUES('A107','Twana','Felger','B010','52000','27-MAR-1975','1 Commerce Way','Portland','Washington','OR','97224','503-939-3153','503-909-7167','twana.felger@felger.org'); INSERT INTO Agents VALUES('A130','Bok','Isaacs','B010','33000','18-OCT-1964','6 Gilson St','Bronx','Bronx','NY','10468','718-809-3762','718-478-8568','bok.isaacs@aol.com'); INSERT INTO Agents VALUES('A173','Eun','Coody','B010','39000','08-SEP-1975','84 Bloomfield Ave','Spartanburg','Spartanburg','SC','29301','864-256-3620','864-594-4578','eun@yahoo.com'); INSERT INTO Agents VALUES('A215','Frederica','Blunk','B010','29000','07-JAN-1967','99586 Main St','Dallas','Dallas','TX','75207','214-428-2285','214-529-1949','frederica_blunk); INSERT INTO Agents VALUES('A220','Glendora','Sarbacher','B010','46000','07-JUL-1955','2140 Diamond Blvd','Rohnert Park','Sonoma','CA','94928','707-653-8214','707-881-3154','gsarbacher); INSERT INTO Agents VALUES('A225','Virgina','Tegarden','B010','43000','24-FEB-1992','755 Harbor Way','Milwaukee','Milwaukee','WI','53226','414-214-8697','414-411-5744','virgina_tegarden@tegarden.com'); INSERT INTO Agents VALUES('A236','Yoko','Fishburne','B010','58000','23-NOV-1977','9122 Carpenter Ave','New Haven','New Haven','CT','06511','203-506-4706','203-840-8634','yoko@fishburne.com'); INSERT INTO Agents VALUES('A239','Rickie','Plumer','B010','44000','17-MAY-1989','3 N Groesbeck Hwy','Toledo','Lucas','OH','43613','419-693-1334',NULL,'rickie.plumer@aol.com'); INSERT INTO Agents VALUES('A249','An','Fritz','B010','33000','27-MAY-1977','506 S Hacienda Dr','Atlantic City','Atlantic','NJ','08401','609-228-5265','609-854-7156','an_fritz@hotmail.com'); INSERT INTO Agents VALUES('A255','Carey','Dopico','B010','34000','07-DEC-1966','87393 E Highland Rd','Indianapolis','Marion','IN','46220','317-578-2453','317-441-5848','carey_dopico@dopico.org'); INSERT INTO Agents VALUES('A271','Haydee','Denooyer','B010','59000','12-APR-1958','25346 New Rd','New York','New York','NY','10016','212-792-8658',NULL,'hdenooyer@denooyer.org'); INSERT INTO Agents VALUES('A283','Noah','Kalafatis','B010','44000','21-NOV-1989','1950 5th Ave','Milwaukee','Milwaukee','WI','53209','414-263-5287','414-660-9766','noah.kalafatis@aol.com'); INSERT INTO Agents VALUES('A317','Barbra','Adkin','B010','29000','28-AUG-1974','4 Kohler Memorial Dr','Brooklyn','Kings','NY','11230','718-201-3751',NULL,NULL); INSERT INTO Agents VALUES('A361','Kasandra','Semidey','B010','35000','19-NOV-1983','369 Latham St #500','Saint Louis','Saint Louis City','MO','63102',NULL,NULL,'kasandra_semidey@semidey.com'); INSERT INTO Agents VALUES('A404','Teddy','Pedrozo','B010','37000','25-JAN-1979','46314 Route 130','Bridgeport','Fairfield','CT','06610','203-892-3863',NULL,'teddy_pedrozo@aol.com'); INSERT INTO Agents VALUES('A457','Sharika','Eanes','B010','39000','16-FEB-1992','75698 N Fiesta Blvd','Orlando','Orange','FL','32806','407-312-1691','407-472-1332',NULL); INSERT INTO Agents VALUES('A461','Leslie','Threets','B010','45000','19-NOV-1965','2 A Kelley Dr','Katonah','Westchester','NY','10536','914-861-9748','914-396-2615','leslie@cox.net'); INSERT INTO Agents VALUES('A463','Izetta','Dewar','B010','26000','13-SEP-1993','2 W Scyene Rd #3','Baltimore','Baltimore City','MD','21217','410-473-1708','410-522-7621','idewar@dewar.com'); INSERT INTO Agents VALUES('A468','Colette','Kardas','B010','48000','27-JUL-1991','21575 S Apple Creek Rd','Omaha','Douglas','NE','68124','402-896-5943','402-707-1602','colette.kardas@yahoo.com'); INSERT INTO Agents VALUES('A469','Malcolm','Tromblay','B010','30000','20-APR-1958','747 Leonis Blvd','Annandale','Fairfax','VA','22003','703-221-5602','703-874-4248','malcolm_tromblay@cox.net'); INSERT INTO Agents VALUES('A471','Jess','Chaffins','B010','29000','13-MAY-1959','18 3rd Ave','New York','New York','NY','10016','212-510-4633','212-428-9538','jess.chaffins@chaffins.org'); INSERT INTO Agents VALUES('A494','Alesia','Hixenbaugh','B010','50000','02-OCT-1982','9 Front St','Washington','District of Columbia','DC','20001','202-646-7516','202-276-6826','alesia_hixenbaugh@hixenbaugh.org');