CREATE TABLE companies ( company TEXT, category TEXT); INSERT INTO companies (company,category) VALUES ('Best Western','Hotels'); INSERT INTO companies (company,category) VALUES ('Samsung USA','Electronics Manufacturing'); INSERT INTO companies (company,category) VALUES ('Food Lion','Grocery'); INSERT INTO companies (company,category) VALUES ('The Apple Store','Electronics'); INSERT INTO companies (company,category) VALUES ('Microsoft Corp','Software'); INSERT INTO companies (company,category) VALUES ('Good Year Tire & Rubber','Manufacturing'); INSERT INTO companies (company,category) VALUES ('IBM','Software and Services'); INSERT INTO companies (company,category) VALUES ('Hillton Resorts Inc.','Hotels and Resorts'); INSERT INTO companies (company,category) VALUES ('JPMorgan Chase','Financial Services'); INSERT INTO companies (company,category) VALUES ('Costco','Retail'); INSERT INTO companies (company,category) VALUES ('The Tee Shop','Small Business'); INSERT INTO companies (company,category) VALUES ('7-Eleven','Retail'); INSERT INTO companies (company,category) VALUES ('The Ford Motor Corporation','Automobile'); INSERT INTO companies (company,category) VALUES ('Apple Corp','Electronics/Software'); INSERT INTO companies (company,category) VALUES ('Johnston Cofee','Beverage'); INSERT INTO companies (company,category) VALUES ('FIRST MERIT BANK','Finacial Services and Banking'); INSERT INTO companies (company,category) VALUES ('COST-CO STORES','Retail'); INSERT INTO companies (company,category) VALUES ('JP Morgan','Investment banking'); INSERT INTO companies (company,category) VALUES ('Adobe Systems','Software'); INSERT INTO companies (company,category) VALUES ('US AIR','Aviation'); INSERT INTO companies (company,category) VALUES ('johnsonrealtors','Real Estate'); INSERT INTO companies (company,category) VALUES ('University of Notre dame','Education'); INSERT INTO companies (company,category) VALUES ('foodlion','Grocery Stores'); INSERT INTO companies (company,category) VALUES ('San Francisco Chronicle','Newspapers'); INSERT INTO companies (company,category) VALUES ('Johnsen Realty','Real Estate'); INSERT INTO companies (company,category) VALUES ('UHAUL','Moving'); INSERT INTO companies (company,category) VALUES ('UC Davis','Education'); INSERT INTO companies (company,category) VALUES ('FORD INC.','Auto Manufacturing'); INSERT INTO companies (company,category) VALUES ('ABC Inc.','General Products'); INSERT INTO companies (company,category) VALUES ('Seven Eleven Stores','Retail'); INSERT INTO companies (company,category) VALUES ('International Business Machines','Enterprise Software'); INSERT INTO companies (company,category) VALUES ('Best Western Hotels','Hotel Management'); INSERT INTO companies (company,category) VALUES ('Ferry Building Market','Retail'); INSERT INTO companies (company,category) VALUES ('The Tea Shop','Small Business'); INSERT INTO companies (company,category) VALUES ('Pederson Tooling Inc.','Services'); INSERT INTO companies (company,category) VALUES ('San Diego State','Educational'); INSERT INTO companies (company,category) VALUES ('Wesson Products','Generic Products'); INSERT INTO companies (company,category) VALUES ('U-haul trailers','Moving Supplies'); INSERT INTO companies (company,category) VALUES ('Kmart','Retail'); INSERT INTO companies (company,category) VALUES ('New York Times','Newspaper'); INSERT INTO companies (company,category) VALUES ('Souvla Restaurants','Food Service'); INSERT INTO companies (company,category) VALUES ('McKesson','Healthcare'); INSERT INTO companies (company,category) VALUES ('Light Builders','Construction'); INSERT INTO companies (company,category) VALUES ('Milton Square Inc','Electronics'); INSERT INTO companies (company,category) VALUES ('Goodyear Tire inc','Transportaions'); INSERT INTO companies (company,category) VALUES ('Hostess Inc.','Bakeries'); INSERT INTO companies (company,category) VALUES ('Johnson Coffee Shop','Food Service'); INSERT INTO companies (company,category) VALUES ('Plain Dealer','Newspaper Publisher'); INSERT INTO companies (company,category) VALUES ('Wilson Sporting Goods','Sports Equipment'); INSERT INTO companies (company,category) VALUES ('Best western hotels corp.','Hotels'); INSERT INTO companies (company,category) VALUES ('The Lite Builder Corp','Builders'); INSERT INTO companies (company,category) VALUES ('Notre Dame','Education'); INSERT INTO companies (company,category) VALUES ('Mackeson Corp','Health Care'); INSERT INTO companies (company,category) VALUES ('Capital Real Estate','Real Estate'); INSERT INTO companies (company,category) VALUES ('Wise Markets','Food Services'); INSERT INTO companies (company,category) VALUES ('1st merit','Banking'); INSERT INTO companies (company,category) VALUES ('Weis markets inc.','Food Services'); INSERT INTO companies (company,category) VALUES ('Horizon Investments','Financial Services'); INSERT INTO companies (company,category) VALUES ('Pacific Bank','Financial Services'); INSERT INTO companies (company,category) VALUES ('US Airways Group','Aviation'); INSERT INTO companies (company,category) VALUES ('Jackson Dentistry','Dentistry'); INSERT INTO companies (company,category) VALUES ('Micro Soft','Software'); INSERT INTO companies (company,category) VALUES ('Peterson Tools','Services'); INSERT INTO companies (company,category) VALUES ('Morningtree Realty','Real Estate'); INSERT INTO companies (company,category) VALUES ('Apple Computer','Software and Electronics'); INSERT INTO companies (company,category) VALUES ('Cleveland Plain Dealer','Newspaper'); INSERT INTO companies (company,category) VALUES ('Montgomery Financial','Financial Services'); INSERT INTO companies (company,category) VALUES ('San Jose Waste Disposal','Waste Services'); INSERT INTO companies (company,category) VALUES ('Biogen Pharma','Healthcare'); INSERT INTO companies (company,category) VALUES ('Xilinx Semiconductors','Electronics'); INSERT INTO companies (company,category) VALUES ('NY TIMES','Newspapers'); INSERT INTO companies (company,category) VALUES ('SDSU','Education'); INSERT INTO companies (company,category) VALUES ('Millton Sqr.','General Products'); INSERT INTO companies (company,category) VALUES ('PPCAP','Services'); INSERT INTO companies (company,category) VALUES ('Hilten hotels','Hotels'); INSERT INTO companies (company,category) VALUES ('Zynga Games','Entertainment'); INSERT INTO companies (company,category) VALUES ('University of California at Davis','Education'); INSERT INTO companies (company,category) VALUES ('Ford Motors','Manufacturing'); INSERT INTO companies (company,category) VALUES ('Facebook Inc.','Software'); INSERT INTO companies (company,category) VALUES ('Red Lion Enterprises','Services'); INSERT INTO companies (company,category) VALUES ('Marys Cookies','Food Services'); INSERT INTO companies (company,category) VALUES ('Jaxon Dental Group','Dentistry'); INSERT INTO companies (company,category) VALUES ('BIOGEN','Pharmaceuticals'); INSERT INTO companies (company,category) VALUES ('The Red Lyon','General Products'); INSERT INTO companies (company,category) VALUES ('Marys Cookie Shop','Restaurants'); INSERT INTO companies (company,category) VALUES ('Arctic Flooring Inc','Services'); INSERT INTO companies (company,category) VALUES ('Apple Inc.','Software'); INSERT INTO companies (company,category) VALUES ('Heffner Beef Products','Food Services'); INSERT INTO companies (company,category) VALUES ('Monsanto','Chemicals'); INSERT INTO companies (company,category) VALUES ('Apple','Software'); INSERT INTO companies (company,category) VALUES ('Arctic Floors','Services');