1,'US Postal Service','Attn: Supt. Window Services','PO Box 7005','Madison','WI','53707','(800) 555-1205','Alberto','Francesco', 1,552), 12, 'National Information Data Ctr','PO Box 96621',NULL,'Washington','DC','20120','(301) 555-8950','Irvin', 'Ania',3,540), (3,'Register of Copyrights', 'Library Of Congress',NULL,'Washington','DC', '20559',NULL,'Liana', 'Lukas',3,403), (4,'Jobtrak','1990 Westwood Blvd Ste 260',NULL,'Los Angeles','CA','90025','(800) 555-8725', 'Quinn','Kenzie',3,572), (5,'Newbrige Book Clubs','3000 Cindel Drive',NULL,'Washington', 'NJ','07882','(800) 555-9980', 'Marks', 'Michelle',4,394), (6,'California Chamber Of Commerce','3255 Ramos Cir',NULL,'Sacramento','CA','95827','(916) 555-6670', 'Mauro', 'Anton',3,572), (7,'Towne Advertiser's Mailing Svcs','Kevin Minder','3441 W Macarthur Blvd','Santa Ana','CA','92704',NULL,' Maegen','Ted',3,540), (8,'BFI Industries','PO Box 9369',NULL,'Fresno','CA','93792','(559) 555-1551','Kaleigh','Erick',3,521), (9,'Pacific Gas & Electric','Box 52001',NULL,'San Francisco','CA','94152','(800) 555-6081','Anthoni','Kaitlyn',3,521), (10,'Robbins Mobile Lock And Key','4669 N Fresno',NULL,'Fresno','CA','93726','(559) 555-9375','Leigh', 'Bill',2,523), (11,'Bill Marvin Electric Inc', '4583 E Home',NULL,'Fresno','CA','93703','(559) 555-5106','Hostlery','Kaitlin',2,523), (12,'City Of Fresno','PO Box 2069',NULL,'Fresno','CA','93718','(559) 555-9999','Mayte','Kendall',3,574), (13,'Golden Eagle Insurance Co','PO Box 85826',NULL,'San Diego', 'CA','92186',NULL,'Blanca','Korah',3,590), (14,'Expedata Inc','4420 N. First Street, Suite 108',NULL,'Fresno','CA','93726','(559) 555-9586','Quintin', 'Marvin', 3,589), (25, 'California Data Marketing', '2818 E Hamilton',NULL,'Fresno', 'CA','93721','(559) 555-3801','Jonessen', 'Moises',4,540), (26,'Small Press', '121 E Front St - 4th Floor',NULL,'Traverse City', 'MI','49684',NULL,'Colette', 'Dusty',3,540), (27,'Rich Advertising','12 Daniel Road',NULL,'Fairfield', 'NJ','07004','(201) 555-9742','Neil', 'Ingrid', 3,540), (29,'Vision Envelope & Printing','PO Box 3100',NULL,'Gardena','CA','90247','(310) 555-7062','Raven', Jamari',3,551), (30,'Costco','Fresno Warehouse', 4500 W Shaw', 'Fresno', 'CA','93711',NULL,'Jaquan', 'Aaron',3,570), (31,'Enterprise Communications Inc','1483 Chain Bridge Rd, Ste 202',NULL,'Mclean',"VA','22101','(770) 555-9558', 'Lawrence','Eileen',2,536), (32, 'RR Bowker','PO Box 31',NULL,'East Brunswick','NJ','08810','(800) 555-8110','Essence','Marjorie',3,532), (33, 'Nielson', 'Ohio Valley Litho Division', 'Location #0470','Cincinnati', 'OH', 45264',NULL,'Brooklynn','Keely',2,541), (34,'IBM','PO Box 61000',NULL,'San Francisco', 'CA','94161','(800) 555-4426','Camron','Trentin', 1,160), (35,'Cal State Termite','PO Box 956',NULL,'Selma', 'CA','93662','(559) 555-1534','Hunter', 'Demetrius',2,523), (36,'Graylift', 'PO Box 2808',NULL,'Fresno', 'CA','93745','(559) 555-6621','Sydney','Deangelo',3,532), (37,'Blue Cross','PO Box 9061',NULL,'Oxnard', 'CA','93031','(800) 555-0912','Eliana', 'Nikolas',3,510), (38,"Venture Communications Int'l','60 Madison Ave',NULL, 'New York','NY','10010','(212) 555-4800', 'Neftaly','Thalia',3,540), (39,'Custom Printing Company','PO Box 7028',NULL,'St Louis', 'MO','63177','(301) 555-1494', 'Myles','Harley',3,540), (40,'Nat Assoc of College Stores','500 East Lorain Street',NULL,'Oberlin', 'OH", 44074',NULL,'Bernard', 'Lucy',3,572), (41,'Shields Design', '415 E Olive Ave',NULL,'Fresno','CA','93728','(559) 555-8060','Kerry', 'Rowan',2,403), (42, 'Opamp Technical Books','1033 N Sycamore Ave.',NULL,'Los Angeles','CA','90038','(213) 555-4322','Paris','Gideon',3,572), (43, 'Capital Resource Credit', 'PO Box 39046',NULL,'Minneapolis', 'MN','55439','(612) 555-0057','Maxwell',Jayda',3,589), (44, 'Courier Companies, Inc','PO Box 5317',NULL,'Boston', 'MA','02206','(508) 555-6351','Antavius','Troy',4,400), (45, 'Naylor Publications Inc','PO Box 40513',NULL,'Jacksonville','FL','32231','(800) 555-6041','Gerald','Kristofer',3,572), (46, 'Open Horizons Publishing','Book Marketing Update','PO Box 205','Fairfield', 'IA','52556','(515) 555-6130','Damien', 'Deborah',2,540), (47,'Baker & Taylor Books','Five Lakepointe Plaza, Ste 500','2709 Water Ridge Parkway','Charlotte', 'NC', '28217','(704) 555-3500','Bernardo', 'Brittnee',3,572), (48,'Fresno County Tax Collector','PO Box 1192',NULL,'Fresno', 'CA','93715','(559) 555-3482','Brenton','Kila',3,574), (49,'Mcgraw Hill Companies','PO Box 87373',NULL,'Chicago', 'IL', '60680','(614) 555-3663','Holbrooke','Rashad',3,572), (50,'Publishers Weekly','Box 1979',NULL,'Marion', 'OH', 43305','(800) 555-1669','Carrollton','Priscilla',3,572), (51,'Blue Shield of California','PO Box 7021',NULL,'Anaheim','CA','92850','(415) 555-5103','Smith', 'Kylie', 3,510), (52, 'Aztek Label', Accounts Payable','1150 N Tustin Ave', Anaheim','CA','92807','(714) 555-9000','Griffin','Brian',3,551), (53,'Gary McKeighan Insurance','3649 W Beechwood Ave #101',NULL,'Fresno', 'CA','93711','(559) 555-2420','Jair', 'Caitlin',3,590), (54,'Ph Photographic Services', '2384 E Gettysburg',NULL,'Fresno','CA','93726','(559) 555-0765','Cheyenne','Kaylea',3,540), 155,'Quality Education Data','PO Box 95857',NULL,'Chicago', 'IL', '60694','(800) 555-5811','Misael','Kayle',2,540), (56,'Springhouse Corp', 'PO Box 7247-7051',NULL,'Philadelphia', 'PA','19170','(215) 555-8700', 'Maeve','Clarence',3,523), (57,'The Windows Deck','117 W Micheltorena Top Floor',NULL,'Santa Barbara','CA','93101','(800) 555-3353','Wood', 'Liam',3,536), (58,'Fresno Rack & Shelving Inc', 4718 N Bendel Ave',NULL,'Fresno', 'CA','93722',NULL,'Baylee', 'Dakota',2,523), (59,'Publishers Marketing Assoc', '627 Aviation Way',NULL,'Manhatttan Beach', 'CA','90266','(310) 555-2732','Walker', 'Jovon',3,572), (60, 'The Mailers Guide Co', 'PO Box 1550',NULL, 'New Rochelle','NY','10802',NULL,'Lacy','Karina',3,540), (61,'American Booksellers Assoc','828 S Broadway',NULL,'Tarrytown', 'NY', '10591','(800) 555-0037','Angelica', 'Nashalie',3,574), (62, 'Cmg Information Services','PO Box 2283',NULL,'Boston', 'MA','02107','(508) 555-7000','Randall','Yash',3,540), (63, 'Lou Gentile's Flower Basket', '722 E Olive Ave',NULL,'Fresno', 'CA','93728','(559) 555-6643', 'Anum', 'Trisha', 1,570), (64, 'Texaco', 'PO Box 6070',NULL,'Inglewood','CA','90312',NULL,'Oren','Grace',3,582), (65, 'The Drawing Board','PO Box 4758',NULL,'Carol Stream','IL','60197',NULL,'Mckayla','Jeffery,2,551), (66, 'Ascom Hasler Mailing Systems', 'PO Box 895',NULL,'Shelton','CT','06484',NULL, 'Lewis', 'Darnell',3,532), (67,'Bill Jones','Secretary of State','PO Box 944230','Sacramento','CA','94244',NULL,'Deasia', 'Tristin',3,589), (68,'Computer Library','3502 W Greenway #7',NULL,'Phoenix', 'AZ','85023','(602) 547-0331','Aryn', 'Leroy',3,540), (69,'Frank E Wilber Co','2437 N Sunnyside',NULL,'Fresno', 'CA','93727','(559) 555-1881', 'Millerton','Johnathon',3,532), (70,'Fresno Credit Bureau','PO Box 942',NULL,'Fresno', 'CA','93714','(559) 555-7900', 'Braydon', 'Anne',2,555), (71,'The Fresno Bee', '1626 E Street',NULL,'Fresno','CA','93786','(559) 555-4442','Colton', 'Leah',2,572), (72, 'Data Reproductions Corp', 4545 Glenmeade Lane',NULL,'Auburn Hills', 'MI', '48326','(810) 555-3700','Arodondo','Cesar',3,400), (73, 'Executive Office Products','353 E Shaw Ave',NULL,'Fresno','CA','93710','(559) 555-1704', 'Danielson','Rachael',2,570), (74,'Leslie Company','PO Box 610',NULL,'Olathe','KS','66061','(800) 255-6210','Alondra', Zev',3,570), (75, 'Retirement Plan Consultants','6435 North Palm Ave, Ste 101',NULL,'Fresno','CA','93704', (559) 555-7070','Edgardo','Salina',3,589), (76, 'Simon Direct Inc','4 Cornwall Dr Ste 102',NULL,'East Brunswick', 'NJ','08816','(908) 555-7222','Bradlee','Daniel', 2,540), (77,'State Board Of Equalization','PO Box 942808',NULL,'Sacramento', 'CA','94208','(916) 555-4911', 'Dean', Julissa', 1,631), (78, 'The Presort Center','1627 "E" Street',NULL,'Fresno','CA','93706','(559) 555-6151','Marissa','Kyle',3,540), (79, Valprint','PO Box 12332',NULL,'Fresno', 'CA','93777','(559) 555-3112','Warren', 'Quentin',3,551), (80, 'Cardinal Business Media, Inc.','P O Box 7247-7844',NULL,'Philadelphia','PA','19170','(215) 555-1500','Eulalia','Kelsey',2,540), (81,'Wang Laboratories, Inc.','P.O. Box 21209',NULL,'Pasadena','CA','91185','(800) 555-0344','Kapil','Robert',2,160), (82,'Reiter's Scientific & Pro Books', '2021 K Street NW',NULL,'Washington','DC', 20006', (202) 555-5561','Rodolfo', 'Carlee,2,572), (83,'Ingram', 'PO Box 845361',NULL,'Dallas', 'TX','75284',NULL, 'Yobani','Trey',2,541), (84,'Boucher Communications Inc','1300 Virginia Dr. Ste 400',NULL,'Fort Washington','PA','19034','(215) 555-8000','Carson','Julian',3,540), (85,'Champion Printing Company','3250 Spring Grove Ave',NULL,'Cincinnati', 'OH', 45225','(800) 555-1957','Clifford', Jillian',3,540), (86,'Computerworld','Department #1872','PO Box 61000','San Francisco', 'CA','94161','(617) 555-0700', 'Lloyd','Angel', 1,572), (87,'DMV Renewal','PO Box 942894',NULL,'Sacramento', 'CA','94294',NULL,'Josey', 'Lorena',4,568), (88,'Edward Data Services',4775 E Miami River Rd',NULL,'Cleves','OH', 45002','(513) 555-3043', 'Helena','Jeanette', 1,540), (89,'Evans Executone Inc', '4918 Taylor Ct',NULL,'Turlock', 'CA','95380',NULL, 'Royce','Hannah', 1,522), (90,'Wakefield Co','295 W Cromwell Ave Ste 106',NULL,'Fresno', 'CA','93711','(559) 555-4744', 'Rothman', 'Nathanael',2,170), (91,'McKesson Water Products','P O Box 7126',NULL,'Pasadena','CA','91109','(800) 555-7009', 'Destin', 'Luciano',2,570), (92,'Zip Print & Copy Center', 'PO Box 12332',NULL,'Fresno', 'CA','93777','(233) 555-6400','Javen','Justin',2,540), (93,'AT&T','PO Box 78225',NULL,'Phoenix','AZ','85062',NULL,'Wesley', 'Alisha',3,522), (94,'Abbey Office Furnishings', 4150 W Shaw Ave',NULL,'Fresno', 'CA','93722','(559) 555-8300','Francis','Kyra',2,150), (95,'Pacific Bell',NULL,NULL,'Sacramento', 'CA','95887','(209) 555-7500', 'Nickalus','Kurt',2,522), (96,"Wells Fargo Bank','Business Mastercard','P.O. Box 29479','Phoenix','AZ','85038','(947) 555-3900', 'Damion', 'Mikayla',2,160), (97,'Compuserve', 'Dept L-742',NULL,'Columbus', 'OH","43260','(614) 555-8600', 'Armando','Jan',2,572), (98, American Express','Box 0001',NULL, 'Los Angeles', 'CA','90096','(800) 555-3344','Story','Kirsten',2,160), (99,'Bertelsmann Industry Svcs. Inc', '28210 N Avenue Stanford',NULL,"Valencia','CA','91355','(805) 555-0584','Potter', 'Lance',3,400), (100,'Cahners Publishing Company','Citibank Lock Box 4026','8725 W Sahara Zone 1127','The Lake','NV','89163','(301) 555-2162','Jacobsen','Samuel',4,540), (101,'California Business Machines','Gallery Plz','5091 Fresno', 'Fresno', 'CA','93710','(559) 555-5570','Rohansen', 'Anders',2,170), (102,'Coffee Break Service','PO Box 1091',NULL,'Fresno', 'CA','93714','(559) 555-8700','Smitzen', Jeffrey',4,570), (103,'Dean Witter Reynolds','9 River Pk PI E 400',NULL,'Boston', 'MA','02134','(508) 555-8737','Johnson', 'Vance',5,589), (104, 'Digital Dreamworks','5070 N Sixth Ste. 71',NULL,'Fresno','CA','93711',NULL,'Elmert','Ron',3,589), (105, 'Dristas Groom & McCormick','7112 N Fresno St Ste 200',NULL,'Fresno','CA','93720','(559) 555-8484', Aaronsen', 'Thom',3,591), (106,'Ford Motor Credit Company','Dept 0419',NULL, 'Los Angeles','CA','90084','(800) 555-7000','Snyder','Karen',3,582), (107,'Franchise Tax Board', 'PO Box 942857',NULL,'Sacramento', 'CA','94257',NULL,'Prado', 'Anita',4,507), (108,'Gostanian General Building','427 W Bedford #102',NULL,'Fresno','CA','93711','(559) 555-5100','Bragg','Walter',4,523), (109,'Kent H Landsberg Co','File No 72686','PO Box 61000','San Francisco','CA','94160','(916) 555-8100','Stevens','Wendy',3,540), (110,'Malloy Lithographing Inc','5411 Jackson Road','PO Box 1124','Ann Arbor','MI','48106','(313) 555-6113','Regging','Abe',3,400), (111,'Net Asset, Lic','1315 Van Ness Ave Ste. 103',NULL,'Fresno','CA','93721',NULL,'Kraggin','Laura', 1,572), (112, 'Office Depot','File No 81901',NULL,'Los Angeles','CA','90074','(800) 555-1711','Pinsippi', 'Val',3,570), (113,'Pollstar','4697 W Jacquelyn Ave',NULL,'Fresno', 'CA','93722','(559) 555-2631', 'Aranovitch','Robert',5,520), (114, 'Postmaster','Postage Due Technician','1900 E Street', 'Fresno', 'CA','93706','(559) 555-7785','Finklestein','Fyodor', 1,552), (115,'Roadway Package System, Inc', 'Dept La 21095',NULL,'Pasadena','CA','91185',NULL,'Smith','Sam',4,553), (116,'State of California','Employment Development Dept','PO Box 826276','Sacramento','CA','94230','(209) 555-5132','Articunia', 'Mercedez', 1,631), (117,'Suburban Propane','2874 S Cherry Ave',NULL,'Fresno','CA','93706','(559) 555-2770','Spivak','Harold',3,521), (118,'Unocal','P.O. Box 860070',NULL,'Pasadena','CA','91186','(415) 555-7600','Bluzinski','Rachael',3,582), (119,'Yesmed, Inc','PO Box 2061',NULL,'Fresno','CA','93718','(559) 555-0600','Hernandez','Reba',2,589), (120,'Dataforms/West','1617 W. Shaw Avenue','Suite F','Fresno','CA','93711',NULL,'Church','Charlie',3,551), (121,'Zylka Design','3467 W Shaw Ave #103',NULL,'Fresno', 'CA','93711','(559) 555-8625','Ronaldsen','Jaime',3,403), (122,'United Parcel Service','P.O. Box 505820',NULL,'Reno', 'NV",88905','(800) 555-0855','Beauregard', 'Violet',3,553), (123,'Federal Express Corporation','P.O. Box 1140', 'Dept A','Memphis','TN','38101','(800) 555-4091','Bucket','Charlie',3,553); Q1.) (25 points) Use the ap database for this question. Write a query that selects vendors from California and replicates the result set shown below, matching all data and format aspects, including column headers. Pay special attention to the order of rows. NULL Vendor Phone Number Aztek Label Phone #: (714) 555-9000 Blue Shield of California Phone #: (415) 555-5103 Diversified Printing & Pub Phone #: (714) 555-4541 Abbey Office Furnishings Phone #: (559) 555-8300 ASC Signs BFI Industries Phone #: (559) 555-1551 Bill Marvin Electric Inc Phone #: (559) 555-5106 California Business Machines Phone #: (559) 555-5570 California Data Marketing Phone #: (559) 555-3801 City Of Fresno Phone #: (559) 555-9999 Coffee Break Service Phone #: (559) 555-8700 Costco Crown Printing Phone #: (559) 555-7473 Dataforms/West Digital Dreamworks Dristas Groom & McCormick Phone #: (559) 555-8484 Executive Office Products Phone #: (559) 555-1704 Expedata Inc Phone #: (559) 555-9586 City Anaheim Anaheim Brea Fresno Fresno Fresno Fresno Fresno Fresno Fresno Fresno Fresno Fresno Fresno Fresno Fresno Fresno Fresno Address Accounts Payable PO Box 7021 2632 Saturn St 4150 W Shaw Ave 1528 N Sierra Vista PO Box 9369 4583 E Home Gallery Plz 2818 E Hamilton PO Box 2069 PO Box 1091 Fresno Warehouse 1730 H" St 1617 W. Shaw Av... 5070 N Sixth Ste. 71 7112 N Fresno St... 353 E Shaw Ave 4420 N. First Stre... NULL NULL NULL 1,'US Postal Service','Attn: Supt. Window Services','PO Box 7005','Madison','WI','53707','(800) 555-1205','Alberto','Francesco', 1,552), 12, 'National Information Data Ctr','PO Box 96621',NULL,'Washington','DC','20120','(301) 555-8950','Irvin', 'Ania',3,540), (3,'Register of Copyrights', 'Library Of Congress',NULL,'Washington','DC', '20559',NULL,'Liana', 'Lukas',3,403), (4,'Jobtrak','1990 Westwood Blvd Ste 260',NULL,'Los Angeles','CA','90025','(800) 555-8725', 'Quinn','Kenzie',3,572), (5,'Newbrige Book Clubs','3000 Cindel Drive',NULL,'Washington', 'NJ','07882','(800) 555-9980', 'Marks', 'Michelle',4,394), (6,'California Chamber Of Commerce','3255 Ramos Cir',NULL,'Sacramento','CA','95827','(916) 555-6670', 'Mauro', 'Anton',3,572), (7,'Towne Advertiser's Mailing Svcs','Kevin Minder','3441 W Macarthur Blvd','Santa Ana','CA','92704',NULL,' Maegen','Ted',3,540), (8,'BFI Industries','PO Box 9369',NULL,'Fresno','CA','93792','(559) 555-1551','Kaleigh','Erick',3,521), (9,'Pacific Gas & Electric','Box 52001',NULL,'San Francisco','CA','94152','(800) 555-6081','Anthoni','Kaitlyn',3,521), (10,'Robbins Mobile Lock And Key','4669 N Fresno',NULL,'Fresno','CA','93726','(559) 555-9375','Leigh', 'Bill',2,523), (11,'Bill Marvin Electric Inc', '4583 E Home',NULL,'Fresno','CA','93703','(559) 555-5106','Hostlery','Kaitlin',2,523), (12,'City Of Fresno','PO Box 2069',NULL,'Fresno','CA','93718','(559) 555-9999','Mayte','Kendall',3,574), (13,'Golden Eagle Insurance Co','PO Box 85826',NULL,'San Diego', 'CA','92186',NULL,'Blanca','Korah',3,590), (14,'Expedata Inc','4420 N. First Street, Suite 108',NULL,'Fresno','CA','93726','(559) 555-9586','Quintin', 'Marvin', 3,589), (25, 'California Data Marketing', '2818 E Hamilton',NULL,'Fresno', 'CA','93721','(559) 555-3801','Jonessen', 'Moises',4,540), (26,'Small Press', '121 E Front St - 4th Floor',NULL,'Traverse City', 'MI','49684',NULL,'Colette', 'Dusty',3,540), (27,'Rich Advertising','12 Daniel Road',NULL,'Fairfield', 'NJ','07004','(201) 555-9742','Neil', 'Ingrid', 3,540), (29,'Vision Envelope & Printing','PO Box 3100',NULL,'Gardena','CA','90247','(310) 555-7062','Raven', Jamari',3,551), (30,'Costco','Fresno Warehouse', 4500 W Shaw', 'Fresno', 'CA','93711',NULL,'Jaquan', 'Aaron',3,570), (31,'Enterprise Communications Inc','1483 Chain Bridge Rd, Ste 202',NULL,'Mclean',"VA','22101','(770) 555-9558', 'Lawrence','Eileen',2,536), (32, 'RR Bowker','PO Box 31',NULL,'East Brunswick','NJ','08810','(800) 555-8110','Essence','Marjorie',3,532), (33, 'Nielson', 'Ohio Valley Litho Division', 'Location #0470','Cincinnati', 'OH', 45264',NULL,'Brooklynn','Keely',2,541), (34,'IBM','PO Box 61000',NULL,'San Francisco', 'CA','94161','(800) 555-4426','Camron','Trentin', 1,160), (35,'Cal State Termite','PO Box 956',NULL,'Selma', 'CA','93662','(559) 555-1534','Hunter', 'Demetrius',2,523), (36,'Graylift', 'PO Box 2808',NULL,'Fresno', 'CA','93745','(559) 555-6621','Sydney','Deangelo',3,532), (37,'Blue Cross','PO Box 9061',NULL,'Oxnard', 'CA','93031','(800) 555-0912','Eliana', 'Nikolas',3,510), (38,"Venture Communications Int'l','60 Madison Ave',NULL, 'New York','NY','10010','(212) 555-4800', 'Neftaly','Thalia',3,540), (39,'Custom Printing Company','PO Box 7028',NULL,'St Louis', 'MO','63177','(301) 555-1494', 'Myles','Harley',3,540), (40,'Nat Assoc of College Stores','500 East Lorain Street',NULL,'Oberlin', 'OH", 44074',NULL,'Bernard', 'Lucy',3,572), (41,'Shields Design', '415 E Olive Ave',NULL,'Fresno','CA','93728','(559) 555-8060','Kerry', 'Rowan',2,403), (42, 'Opamp Technical Books','1033 N Sycamore Ave.',NULL,'Los Angeles','CA','90038','(213) 555-4322','Paris','Gideon',3,572), (43, 'Capital Resource Credit', 'PO Box 39046',NULL,'Minneapolis', 'MN','55439','(612) 555-0057','Maxwell',Jayda',3,589), (44, 'Courier Companies, Inc','PO Box 5317',NULL,'Boston', 'MA','02206','(508) 555-6351','Antavius','Troy',4,400), (45, 'Naylor Publications Inc','PO Box 40513',NULL,'Jacksonville','FL','32231','(800) 555-6041','Gerald','Kristofer',3,572), (46, 'Open Horizons Publishing','Book Marketing Update','PO Box 205','Fairfield', 'IA','52556','(515) 555-6130','Damien', 'Deborah',2,540), (47,'Baker & Taylor Books','Five Lakepointe Plaza, Ste 500','2709 Water Ridge Parkway','Charlotte', 'NC', '28217','(704) 555-3500','Bernardo', 'Brittnee',3,572), (48,'Fresno County Tax Collector','PO Box 1192',NULL,'Fresno', 'CA','93715','(559) 555-3482','Brenton','Kila',3,574), (49,'Mcgraw Hill Companies','PO Box 87373',NULL,'Chicago', 'IL', '60680','(614) 555-3663','Holbrooke','Rashad',3,572), (50,'Publishers Weekly','Box 1979',NULL,'Marion', 'OH', 43305','(800) 555-1669','Carrollton','Priscilla',3,572), (51,'Blue Shield of California','PO Box 7021',NULL,'Anaheim','CA','92850','(415) 555-5103','Smith', 'Kylie', 3,510), (52, 'Aztek Label', Accounts Payable','1150 N Tustin Ave', Anaheim','CA','92807','(714) 555-9000','Griffin','Brian',3,551), (53,'Gary McKeighan Insurance','3649 W Beechwood Ave #101',NULL,'Fresno', 'CA','93711','(559) 555-2420','Jair', 'Caitlin',3,590), (54,'Ph Photographic Services', '2384 E Gettysburg',NULL,'Fresno','CA','93726','(559) 555-0765','Cheyenne','Kaylea',3,540), 155,'Quality Education Data','PO Box 95857',NULL,'Chicago', 'IL', '60694','(800) 555-5811','Misael','Kayle',2,540), (56,'Springhouse Corp', 'PO Box 7247-7051',NULL,'Philadelphia', 'PA','19170','(215) 555-8700', 'Maeve','Clarence',3,523), (57,'The Windows Deck','117 W Micheltorena Top Floor',NULL,'Santa Barbara','CA','93101','(800) 555-3353','Wood', 'Liam',3,536), (58,'Fresno Rack & Shelving Inc', 4718 N Bendel Ave',NULL,'Fresno', 'CA','93722',NULL,'Baylee', 'Dakota',2,523), (59,'Publishers Marketing Assoc', '627 Aviation Way',NULL,'Manhatttan Beach', 'CA','90266','(310) 555-2732','Walker', 'Jovon',3,572), (60, 'The Mailers Guide Co', 'PO Box 1550',NULL, 'New Rochelle','NY','10802',NULL,'Lacy','Karina',3,540), (61,'American Booksellers Assoc','828 S Broadway',NULL,'Tarrytown', 'NY', '10591','(800) 555-0037','Angelica', 'Nashalie',3,574), (62, 'Cmg Information Services','PO Box 2283',NULL,'Boston', 'MA','02107','(508) 555-7000','Randall','Yash',3,540), (63, 'Lou Gentile's Flower Basket', '722 E Olive Ave',NULL,'Fresno', 'CA','93728','(559) 555-6643', 'Anum', 'Trisha', 1,570), (64, 'Texaco', 'PO Box 6070',NULL,'Inglewood','CA','90312',NULL,'Oren','Grace',3,582), (65, 'The Drawing Board','PO Box 4758',NULL,'Carol Stream','IL','60197',NULL,'Mckayla','Jeffery,2,551), (66, 'Ascom Hasler Mailing Systems', 'PO Box 895',NULL,'Shelton','CT','06484',NULL, 'Lewis', 'Darnell',3,532), (67,'Bill Jones','Secretary of State','PO Box 944230','Sacramento','CA','94244',NULL,'Deasia', 'Tristin',3,589), (68,'Computer Library','3502 W Greenway #7',NULL,'Phoenix', 'AZ','85023','(602) 547-0331','Aryn', 'Leroy',3,540), (69,'Frank E Wilber Co','2437 N Sunnyside',NULL,'Fresno', 'CA','93727','(559) 555-1881', 'Millerton','Johnathon',3,532), (70,'Fresno Credit Bureau','PO Box 942',NULL,'Fresno', 'CA','93714','(559) 555-7900', 'Braydon', 'Anne',2,555), (71,'The Fresno Bee', '1626 E Street',NULL,'Fresno','CA','93786','(559) 555-4442','Colton', 'Leah',2,572), (72, 'Data Reproductions Corp', 4545 Glenmeade Lane',NULL,'Auburn Hills', 'MI', '48326','(810) 555-3700','Arodondo','Cesar',3,400), (73, 'Executive Office Products','353 E Shaw Ave',NULL,'Fresno','CA','93710','(559) 555-1704', 'Danielson','Rachael',2,570), (74,'Leslie Company','PO Box 610',NULL,'Olathe','KS','66061','(800) 255-6210','Alondra', Zev',3,570), (75, 'Retirement Plan Consultants','6435 North Palm Ave, Ste 101',NULL,'Fresno','CA','93704', (559) 555-7070','Edgardo','Salina',3,589), (76, 'Simon Direct Inc','4 Cornwall Dr Ste 102',NULL,'East Brunswick', 'NJ','08816','(908) 555-7222','Bradlee','Daniel', 2,540), (77,'State Board Of Equalization','PO Box 942808',NULL,'Sacramento', 'CA','94208','(916) 555-4911', 'Dean', Julissa', 1,631), (78, 'The Presort Center','1627 "E" Street',NULL,'Fresno','CA','93706','(559) 555-6151','Marissa','Kyle',3,540), (79, Valprint','PO Box 12332',NULL,'Fresno', 'CA','93777','(559) 555-3112','Warren', 'Quentin',3,551), (80, 'Cardinal Business Media, Inc.','P O Box 7247-7844',NULL,'Philadelphia','PA','19170','(215) 555-1500','Eulalia','Kelsey',2,540), (81,'Wang Laboratories, Inc.','P.O. Box 21209',NULL,'Pasadena','CA','91185','(800) 555-0344','Kapil','Robert',2,160), (82,'Reiter's Scientific & Pro Books', '2021 K Street NW',NULL,'Washington','DC', 20006', (202) 555-5561','Rodolfo', 'Carlee,2,572), (83,'Ingram', 'PO Box 845361',NULL,'Dallas', 'TX','75284',NULL, 'Yobani','Trey',2,541), (84,'Boucher Communications Inc','1300 Virginia Dr. Ste 400',NULL,'Fort Washington','PA','19034','(215) 555-8000','Carson','Julian',3,540), (85,'Champion Printing Company','3250 Spring Grove Ave',NULL,'Cincinnati', 'OH', 45225','(800) 555-1957','Clifford', Jillian',3,540), (86,'Computerworld','Department #1872','PO Box 61000','San Francisco', 'CA','94161','(617) 555-0700', 'Lloyd','Angel', 1,572), (87,'DMV Renewal','PO Box 942894',NULL,'Sacramento', 'CA','94294',NULL,'Josey', 'Lorena',4,568), (88,'Edward Data Services',4775 E Miami River Rd',NULL,'Cleves','OH', 45002','(513) 555-3043', 'Helena','Jeanette', 1,540), (89,'Evans Executone Inc', '4918 Taylor Ct',NULL,'Turlock', 'CA','95380',NULL, 'Royce','Hannah', 1,522), (90,'Wakefield Co','295 W Cromwell Ave Ste 106',NULL,'Fresno', 'CA','93711','(559) 555-4744', 'Rothman', 'Nathanael',2,170), (91,'McKesson Water Products','P O Box 7126',NULL,'Pasadena','CA','91109','(800) 555-7009', 'Destin', 'Luciano',2,570), (92,'Zip Print & Copy Center', 'PO Box 12332',NULL,'Fresno', 'CA','93777','(233) 555-6400','Javen','Justin',2,540), (93,'AT&T','PO Box 78225',NULL,'Phoenix','AZ','85062',NULL,'Wesley', 'Alisha',3,522), (94,'Abbey Office Furnishings', 4150 W Shaw Ave',NULL,'Fresno', 'CA','93722','(559) 555-8300','Francis','Kyra',2,150), (95,'Pacific Bell',NULL,NULL,'Sacramento', 'CA','95887','(209) 555-7500', 'Nickalus','Kurt',2,522), (96,"Wells Fargo Bank','Business Mastercard','P.O. Box 29479','Phoenix','AZ','85038','(947) 555-3900', 'Damion', 'Mikayla',2,160), (97,'Compuserve', 'Dept L-742',NULL,'Columbus', 'OH","43260','(614) 555-8600', 'Armando','Jan',2,572), (98, American Express','Box 0001',NULL, 'Los Angeles', 'CA','90096','(800) 555-3344','Story','Kirsten',2,160), (99,'Bertelsmann Industry Svcs. Inc', '28210 N Avenue Stanford',NULL,"Valencia','CA','91355','(805) 555-0584','Potter', 'Lance',3,400), (100,'Cahners Publishing Company','Citibank Lock Box 4026','8725 W Sahara Zone 1127','The Lake','NV','89163','(301) 555-2162','Jacobsen','Samuel',4,540), (101,'California Business Machines','Gallery Plz','5091 Fresno', 'Fresno', 'CA','93710','(559) 555-5570','Rohansen', 'Anders',2,170), (102,'Coffee Break Service','PO Box 1091',NULL,'Fresno', 'CA','93714','(559) 555-8700','Smitzen', Jeffrey',4,570), (103,'Dean Witter Reynolds','9 River Pk PI E 400',NULL,'Boston', 'MA','02134','(508) 555-8737','Johnson', 'Vance',5,589), (104, 'Digital Dreamworks','5070 N Sixth Ste. 71',NULL,'Fresno','CA','93711',NULL,'Elmert','Ron',3,589), (105, 'Dristas Groom & McCormick','7112 N Fresno St Ste 200',NULL,'Fresno','CA','93720','(559) 555-8484', Aaronsen', 'Thom',3,591), (106,'Ford Motor Credit Company','Dept 0419',NULL, 'Los Angeles','CA','90084','(800) 555-7000','Snyder','Karen',3,582), (107,'Franchise Tax Board', 'PO Box 942857',NULL,'Sacramento', 'CA','94257',NULL,'Prado', 'Anita',4,507), (108,'Gostanian General Building','427 W Bedford #102',NULL,'Fresno','CA','93711','(559) 555-5100','Bragg','Walter',4,523), (109,'Kent H Landsberg Co','File No 72686','PO Box 61000','San Francisco','CA','94160','(916) 555-8100','Stevens','Wendy',3,540), (110,'Malloy Lithographing Inc','5411 Jackson Road','PO Box 1124','Ann Arbor','MI','48106','(313) 555-6113','Regging','Abe',3,400), (111,'Net Asset, Lic','1315 Van Ness Ave Ste. 103',NULL,'Fresno','CA','93721',NULL,'Kraggin','Laura', 1,572), (112, 'Office Depot','File No 81901',NULL,'Los Angeles','CA','90074','(800) 555-1711','Pinsippi', 'Val',3,570), (113,'Pollstar','4697 W Jacquelyn Ave',NULL,'Fresno', 'CA','93722','(559) 555-2631', 'Aranovitch','Robert',5,520), (114, 'Postmaster','Postage Due Technician','1900 E Street', 'Fresno', 'CA','93706','(559) 555-7785','Finklestein','Fyodor', 1,552), (115,'Roadway Package System, Inc', 'Dept La 21095',NULL,'Pasadena','CA','91185',NULL,'Smith','Sam',4,553), (116,'State of California','Employment Development Dept','PO Box 826276','Sacramento','CA','94230','(209) 555-5132','Articunia', 'Mercedez', 1,631), (117,'Suburban Propane','2874 S Cherry Ave',NULL,'Fresno','CA','93706','(559) 555-2770','Spivak','Harold',3,521), (118,'Unocal','P.O. Box 860070',NULL,'Pasadena','CA','91186','(415) 555-7600','Bluzinski','Rachael',3,582), (119,'Yesmed, Inc','PO Box 2061',NULL,'Fresno','CA','93718','(559) 555-0600','Hernandez','Reba',2,589), (120,'Dataforms/West','1617 W. Shaw Avenue','Suite F','Fresno','CA','93711',NULL,'Church','Charlie',3,551), (121,'Zylka Design','3467 W Shaw Ave #103',NULL,'Fresno', 'CA','93711','(559) 555-8625','Ronaldsen','Jaime',3,403), (122,'United Parcel Service','P.O. Box 505820',NULL,'Reno', 'NV",88905','(800) 555-0855','Beauregard', 'Violet',3,553), (123,'Federal Express Corporation','P.O. Box 1140', 'Dept A','Memphis','TN','38101','(800) 555-4091','Bucket','Charlie',3,553); Q1.) (25 points) Use the ap database for this question. Write a query that selects vendors from California and replicates the result set shown below, matching all data and format aspects, including column headers. Pay special attention to the order of rows. NULL Vendor Phone Number Aztek Label Phone #: (714) 555-9000 Blue Shield of California Phone #: (415) 555-5103 Diversified Printing & Pub Phone #: (714) 555-4541 Abbey Office Furnishings Phone #: (559) 555-8300 ASC Signs BFI Industries Phone #: (559) 555-1551 Bill Marvin Electric Inc Phone #: (559) 555-5106 California Business Machines Phone #: (559) 555-5570 California Data Marketing Phone #: (559) 555-3801 City Of Fresno Phone #: (559) 555-9999 Coffee Break Service Phone #: (559) 555-8700 Costco Crown Printing Phone #: (559) 555-7473 Dataforms/West Digital Dreamworks Dristas Groom & McCormick Phone #: (559) 555-8484 Executive Office Products Phone #: (559) 555-1704 Expedata Inc Phone #: (559) 555-9586 City Anaheim Anaheim Brea Fresno Fresno Fresno Fresno Fresno Fresno Fresno Fresno Fresno Fresno Fresno Fresno Fresno Fresno Fresno Address Accounts Payable PO Box 7021 2632 Saturn St 4150 W Shaw Ave 1528 N Sierra Vista PO Box 9369 4583 E Home Gallery Plz 2818 E Hamilton PO Box 2069 PO Box 1091 Fresno Warehouse 1730 H" St 1617 W. Shaw Av... 5070 N Sixth Ste. 71 7112 N Fresno St... 353 E Shaw Ave 4420 N. First Stre... NULL NULL NULL
