/oracle-plsql/java-pl-sql-jdbc/db/create_student_tabs.sql

Large files files are truncated, but you can click here to view the full file

-- Must do this to run script in SQL*Plus, to avoid interpretation
-- of & as substitution character:
SET ESCAPE ON

-- DROP USER &&user CASCADE;

-- CREATE USER &&user
--   IDENTIFIED BY &&user
--   DEFAULT TABLESPACE users
--   QUOTA 4M ON users
--   TEMPORARY TABLESPACE temp;

-- GRANT CREATE SESSION, CREATE PROCEDURE, CREATE TRIGGER, ADMINISTER DATABASE TRIGGER,
--   QUERY REWRITE, CREATE ANY DIRECTORY, DROP ANY DIRECTORY TO &&user;

-- CONNECT &&user/&&user

CREATE SEQUENCE person_id_seq START WITH 11000;

CREATE TABLE ACCOUNT
(
  ACCOUNT_NUMBER NUMBER,
  ACCOUNT_NAME VARCHAR2(25),
  ACCOUNT_TYPE_CODE CHAR(1),
  CUSTOMER_ID NUMBER,
  CREDIT_LIMIT NUMBER(9,2),
  BALANCE NUMBER(9,2),
  STREET VARCHAR2(45),
  CITY VARCHAR2(25),
  STATE CHAR(2),
  ZIP CHAR(9),
  AREA_CODE CHAR(3),
  PHONE_NUMBER CHAR(7)
) ;

INSERT INTO ACCOUNT VALUES (
'1000','Kong, Larry','E','6434','5000','2268.22','1591 South Union Blvd','Seattle','WA','98134    ','206','5557905'
);
INSERT INTO ACCOUNT VALUES (
'1001','Kilker, Barbara','P','8336','700','162.14','6432 One Bell Center','Tacoma','WA','98494    ','206','5558485'
);
INSERT INTO ACCOUNT VALUES (
'1002','Fugazzi, Jeffrey','P','9645','800','316.26','5748 Airport Boulevard','Seattle','WA','98181    ','206','5551251'
);
INSERT INTO ACCOUNT VALUES (
'1003','Scott, Robert','P','9353','800','537.33','4108 175th','Tacoma','WA','98403    ','206','5550832'
);
INSERT INTO ACCOUNT VALUES (
'1004','Beesley, Jaime','P','8638','500','227.91','6897 W 95th St','Tacoma','WA','98430    ','206','5557093'
);
INSERT INTO ACCOUNT VALUES (
'1005','McClain, Richard','P','6727','800','51.76','1758 Wayzata Blvd','Tacoma','WA','98418    ','206','5559117'
);
INSERT INTO ACCOUNT VALUES (
'1006','Anderson, Richard','P','6837','600','526.25','7238 S. Cherry Circle Dr','Tacoma','WA','98401    ','206','5552939'
);
INSERT INTO ACCOUNT VALUES (
'1007','Wertz, Jeanne','P','6976','600','312.21','8876 Main','Bellevue','WA','98004    ','206','5553582'
);
INSERT INTO ACCOUNT VALUES (
'1008','Sandoval, Richard','P','8092','600','29.72','9766 DTC Parkway','Seattle','WA','98121    ','206','5550870'
);
INSERT INTO ACCOUNT VALUES (
'1009','Hartmann, Donna','P','6480','600','147.51','875 Inverness','Tacoma','WA','98443    ','206','5555968'
);
INSERT INTO ACCOUNT VALUES (
'1010','Nielsen, Ernie','P','8877','600','448.37','2184 Flat Iron Pkwy','Tacoma','WA','98498    ','206','5553002'
);
INSERT INTO ACCOUNT VALUES (
'1011','Gatt, Dwight','P','7729','900','197.31','759 SW Boeman Rd','Tacoma','WA','98450    ','206','5559313'
);
INSERT INTO ACCOUNT VALUES (
'1012','Dotson, Ryan','P','9202','800','200.95','4379 Grant St GR','Seattle','WA','98132    ','206','5552183'
);
INSERT INTO ACCOUNT VALUES (
'1013','Ruzyla, Burdette','P','8104','800','675.05','8106 Caqulin Dr','Seattle','WA','98124    ','206','5553140'
);
INSERT INTO ACCOUNT VALUES (
'1014','Keller, Patrick','P','9159','900','853.28','110 Flat Iron Pkwy','Bellevue','WA','98008    ','206','5552652'
);
INSERT INTO ACCOUNT VALUES (
'1015','Lage, Sandy','P','7058','600','478.53','4446 S Fiddler''s Green Circle','Seattle','WA','98132    ','206','5559431'
);
INSERT INTO ACCOUNT VALUES (
'1016','Rasper, J.B.','P','6947','700','637','5687 Quebec St','Tacoma','WA','98445    ','206','5556014'
);
INSERT INTO ACCOUNT VALUES (
'1017','Schmidt, Lisa','P','9740','800','63.09','497 E Dry Creek Rd','Tacoma','WA','98466    ','206','5554038'
);
INSERT INTO ACCOUNT VALUES (
'1018','Irangi, Sandi','P','6673','700','297.36','520 Airways Blvd','Bellevue','WA','98015    ','206','5557791'
);
INSERT INTO ACCOUNT VALUES (
'1019','Quigley, John','P','9744','500','370.21','564 East Union Ave','Tacoma','WA','98493    ','206','5550369'
);
INSERT INTO ACCOUNT VALUES (
'1020','Kakani, Craig','P','7073','700','126.76','8305 Rural Route 2, Box','Tacoma','WA','98464    ','206','5559963'
);
INSERT INTO ACCOUNT VALUES (
'1021','Dewey, Jere','P','9593','700','259.32','7342 S Parker Rd','Bellevue','WA','98009    ','206','5557287'
);
INSERT INTO ACCOUNT VALUES (
'1022','Shank, Terry','P','9738','600','410.5','5849 Champa','Bellevue','WA','98015    ','206','5552209'
);
INSERT INTO ACCOUNT VALUES (
'1023','Jamour, Arun','E','6719','1000','768.92','4949 S.W. Park','Seattle','WA','98118    ','206','5552803'
);
INSERT INTO ACCOUNT VALUES (
'1024','Vernon, Savannah','P','7974','900','464.89','5119 W 115 Circle','Bellevue','WA','98009    ','206','5559846'
);
INSERT INTO ACCOUNT VALUES (
'1025','Abba, Clay','P','7880','700','347.22','5277 E Girard','Tacoma','WA','98409    ','206','5558457'
);
INSERT INTO ACCOUNT VALUES (
'1026','Plank, Scott','P','7170','900','512.32','8075 East Colfax','Tacoma','WA','98499    ','206','5557046'
);
INSERT INTO ACCOUNT VALUES (
'1027','Montoya, Mary','P','8859','900','276.91','6803 W. 4th St','Tacoma','WA','98413    ','206','5557305'
);
INSERT INTO ACCOUNT VALUES (
'1028','Resman, Eileen','P','9374','700','349.49','6229 E Bijou St','Seattle','WA','98171    ','206','5550412'
);
INSERT INTO ACCOUNT VALUES (
'1029','Leck, Ellen','P','9023','800','756.37','2218 E Girard','Tacoma','WA','98418    ','206','5552841'
);
INSERT INTO ACCOUNT VALUES (
'1030','Gallams, Dan','P','7317','500','364.47','8370 S Maple Ave','Seattle','WA','98028    ','206','5550426'
);
INSERT INTO ACCOUNT VALUES (
'1031','Whittington, Dave','P','9841','500','421.81','3026 W. 38th Ave','Seattle','WA','98110    ','206','5552967'
);
INSERT INTO ACCOUNT VALUES (
'1032','Barrows, Mark','P','6758','600','70.94','3106 N Glenville Dr','Tacoma','WA','98412    ','206','5553549'
);
INSERT INTO ACCOUNT VALUES (
'1033','Estrada, John','P','9833','900','751.22','6770 Concourse Pkwy','Tacoma','WA','98408    ','206','5559615'
);
INSERT INTO ACCOUNT VALUES (
'1034','Medal, Jody','P','6417','700','128.52','6065 Kelly Johnson Blvd','Tacoma','WA','98455    ','206','5552559'
);
INSERT INTO ACCOUNT VALUES (
'1035','Fluke, James','P','7901','800','187.45','7333 Corporate','Tacoma','WA','98406    ','206','5556311'
);
INSERT INTO ACCOUNT VALUES (
'1036','Schroeder, Mala','P','8077','900','726.69','2181 Mark Dabling Blvd','Tacoma','WA','98493    ','206','5558076'
);
INSERT INTO ACCOUNT VALUES (
'1037','Loundagin, Ronald','P','7689','500','40.94','1284 Califiorna','Tacoma','WA','98477    ','206','5559200'
);
INSERT INTO ACCOUNT VALUES (
'1038','Brown, Peter','P','7243','500','288.79','525 W 37th St','Seattle','WA','98191    ','206','5558572'
);
INSERT INTO ACCOUNT VALUES (
'1039','Linna, Bonnie','P','8295','800','485.11','8736 N. We Chicago','Tacoma','WA','98405    ','206','5552569'
);
INSERT INTO ACCOUNT VALUES (
'1040','Claridge, Charles','P','8772','800','222.17','2815 E Thomas Rd 22nd Fl','Seattle','WA','98158    ','206','5558630'
);
INSERT INTO ACCOUNT VALUES (
'1041','Sjoblom, M. Susan','P','8059','900','832.19','5396 Telstar Dr','Seattle','WA','98184    ','206','5555897'
);
INSERT INTO ACCOUNT VALUES (
'1042','Penneck, Mike','P','7140','800','306.91','4756 Beltline','Tacoma','WA','98445    ','206','5551027'
);
INSERT INTO ACCOUNT VALUES (
'1043','Buck, Ann','P','7450','600','257.04','2259 E Rochelle Blvd','Seattle','WA','98105    ','206','5551857'
);
INSERT INTO ACCOUNT VALUES (
'1044','Gibbons, David','P','7430','800','65.7','5766 South Trenton','Tacoma','WA','98431    ','206','5554329'
);
INSERT INTO ACCOUNT VALUES (
'1045','Uhle, Donna','P','9672','800','127.91','976 W 69th Pl','Tacoma','WA','98434    ','206','5556707'
);
INSERT INTO ACCOUNT VALUES (
'1046','Myers, Robert','E','8991','1000','221.22','1979 W 32nd Ave','Seattle','WA','98195    ','206','5555154'
);
INSERT INTO ACCOUNT VALUES (
'1047','Lerry, Mike','P','9020','800','241.55','2126 Maruick Dr','Tacoma','WA','98411    ','206','5551822'
);
INSERT INTO ACCOUNT VALUES (
'1048','Bala, Carole','P','8654','800','628.34','1885 Jackson','Tacoma','WA','98465    ','206','5555225'
);
INSERT INTO ACCOUNT VALUES (
'1049','Loftin, Gary','P','9433','700','508.27','6187 Twin Oaks Dr','Tacoma','WA','98494    ','206','5555017'
);
INSERT INTO ACCOUNT VALUES (
'1050','Washington, Sharon','P','7962','600','501.07','3919 W 37th St','Tacoma','WA','98445    ','206','5559008'
);
INSERT INTO ACCOUNT VALUES (
'1051','Manahan, Bradley','P','8275','700','108.05','3454 East Ha Rd','Tacoma','WA','98401    ','206','5555762'
);
INSERT INTO ACCOUNT VALUES (
'1052','Hansen, Robert','P','7727','600','111.02','2973 W. Rainbow Blvd','Seattle','WA','98188    ','206','5553292'
);
INSERT INTO ACCOUNT VALUES (
'1053','McDonald, Wendy','P','6677','900','466.86','4908 Tech Center Dr','Seattle','WA','98124    ','206','5552032'
);
INSERT INTO ACCOUNT VALUES (
'1054','Mack, Mina','P','9955','700','8.97','3105 Caqulin Dr','Tacoma','WA','98445    ','206','5551599'
);
INSERT INTO ACCOUNT VALUES (
'1055','Pollard, Cindy','P','7007','900','379.58','8384 S. Monaco','Seattle','WA','98168    ','206','5559704'
);
INSERT INTO ACCOUNT VALUES (
'1056','Romero, Allen','P','8832','500','78.34','6253 Lawrence','Tacoma','WA','98447    ','206','5551496'
);
INSERT INTO ACCOUNT VALUES (
'1057','Wei, Pat','P','7955','700','5.38','3089 NW Front Ave','Seattle','WA','98177    ','206','5550413'
);
INSERT INTO ACCOUNT VALUES (
'1058','Haydt, Alex','P','9197','700','300.38','8473 S Ul St','Seattle','WA','98114    ','206','5554059'
);
INSERT INTO ACCOUNT VALUES (
'1059','Johnson, Laverne','P','8363','700','687.14','7037 E. Thomas Rd','Seattle','WA','98122    ','206','5557403'
);
INSERT INTO ACCOUNT VALUES (
'1060','Rooney, Sarah','P','8716','700','442.56','104 S Cherry St','Seattle','WA','98124    ','206','5558921'
);
INSERT INTO ACCOUNT VALUES (
'1061','Stum, Juan','P','9324','500','327.45','5835 West 9th St','Tacoma','WA','98499    ','206','5553572'
);
INSERT INTO ACCOUNT VALUES (
'1062','Garza, Vince','P','7341','500','487.03','2248 Califiorna','Seattle','WA','98191    ','206','5553327'
);
INSERT INTO ACCOUNT VALUES (
'1063','VO, Craig','P','7592','900','332.56','3297 S. 119th St','Bellevue','WA','98009    ','206','5557515'
);
INSERT INTO ACCOUNT VALUES (
'1064','Carter, Steve','P','8871','800','391.87','748 E. Mulberry','Seattle','WA','98140    ','206','5559486'
);
INSERT INTO ACCOUNT VALUES (
'1065','Falvey, Chris','P','9077','700','232.38','1678 Farnam','Seattle','WA','98132    ','206','5555316'
);
INSERT INTO ACCOUNT VALUES (
'1066','Hodge, Rick','P','8748','800','593.46','7746 Lake Plaza Dr','Seattle','WA','98150    ','206','5558085'
);
INSERT INTO ACCOUNT VALUES (
'1067','Goldstein, Mel','P','6406','800','114.58','7501 E Bijou St','Tacoma','WA','98477    ','206','5552945'
);
INSERT INTO ACCOUNT VALUES (
'1068','Hua, Buffy','E','6553','5000','826.11','3166 Maple Ave','San Francisco','CA','94116    ','510','5557264'
);
INSERT INTO ACCOUNT VALUES (
'1069','Organo, Trish','P','7721','500','149.49','5526 E. 62nd Ave','San Jose','CA','95193    ','408','5557158'
);
INSERT INTO ACCOUNT VALUES (
'1070','Munanka, Ousmane','P','8213','800','52.98','9504 Inverness Place East','Glendale','CA','91224    ','818','5558555'
);
INSERT INTO ACCOUNT VALUES (
'1071','Granrud, Steve','P','9957','600','380.53','496 Pierce','San Jose','CA','95119    ','408','5555522'
);
INSERT INTO ACCOUNT VALUES (
'1072','Hillringhaus, Steven','P','7207','500','436.29','5097 Willow Dr','San Francisco','CA','94105    ','510','5552942'
);
INSERT INTO ACCOUNT VALUES (
'1073','Whitehorne, Kevin','P','9260','600','456.54','2575 Ranch Elsie','San Francisco','CA','94127    ','510','5550389'
);
INSERT INTO ACCOUNT VALUES (
'1074','Grote, Will','P','8428','900','327.91','6189 Greenwood Plaza Blvd','Los Angeles','CA','90025    ','213','5556984'
);
INSERT INTO ACCOUNT VALUES (
'1075','Weber, Diamond','P','7956','500','157.36','806 Mark Dabling Rd','San Jose','CA','95110    ','408','5556246'
);
INSERT INTO ACCOUNT VALUES (
'1076','Lehner, Manjo','P','9437','600','255.32','7237 Metcalf Ave','San Jose','CA','95112    ','408','5553256'
);
INSERT INTO ACCOUNT VALUES (
'1077','Ragole, David','P','8137','600','45.9','8118 SW Stark','Los Angeles','CA','90024    ','213','5554137'
);
INSERT INTO ACCOUNT VALUES (
'1078','Villegas, Udo','P','7623','700','191.68','7234 110th Ave NE','Pasadena','CA','91101    ','818','5556992'
);
INSERT INTO ACCOUNT VALUES (
'1079','Eliason, Nancy','P','9904','900','193.36','938 Inverness Circle East','Los Angeles','CA','90038    ','213','5550179'
);
INSERT INTO ACCOUNT VALUES (
'1080','Pittock, Richard','P','9383','600','475.87','3002 S. Syracuse','San Francisco','CA','94154    ','510','5559548'
);
INSERT INTO ACCOUNT VALUES (
'1081','Walker, Vicki','P','6514','700','252.37','7348 South Liverpool','San Francisco','CA','94128    ','510','5557581'
);
INSERT INTO ACCOUNT VALUES (
'1082','Fields, Mark','P','9795','900','176.3','6729 High St','Pasadena','CA','91109    ','818','5556137'
);
INSERT INTO ACCOUNT VALUES (
'1083','Williamson, Bill','P','9217','600','402.83','2021 East Union','Los Angeles','CA','90093    ','213','5558191'
);
INSERT INTO ACCOUNT VALUES (
'1084','Camann, Chuck','P','7236','600','265.94','7087 17th Ave','Los Angeles','CA','90094    ','213','5553011'
);
INSERT INTO ACCOUNT VALUES (
'1085','Gaughan, Mike','P','7883','900','249.99','2439 Airport Boulevard','San Jose','CA','95172    ','408','5555547'
);
INSERT INTO ACCOUNT VALUES (
'1086','Lynner, Gary','P','9429','700','644.42','4438 S 97th','Oakland','CA','94619    ','510','5550039'
);
INSERT INTO ACCOUNT VALUES (
'1087','McMillan, Jeff','P','7741','900','786.21','6361 Neil Rd','Los Angeles','CA','90012    ','213','5556954'
);
INSERT INTO ACCOUNT VALUES (
'1088','Terrones, Mark','P','6397','600','232.62','9567 1st St Code','San Jose','CA','95127    ','408','5557568'
);
INSERT INTO ACCOUNT VALUES (
'1089','Parreco, Ross','P','8980','600','362.57','678 Tucson Way','Los Angeles','CA','90003    ','213','5550254'
);
INSERT INTO ACCOUNT VALUES (
'1090','Evans, Dean','P','7425','800','456.96','2807 S Fiddler''s Green Circle','Oakland','CA','94614    ','510','5556442'
);
INSERT INTO ACCOUNT VALUES (
'1091','Welch, Connie','P','7952','900','616.42','3066 S. Devin Court','Pasadena','CA','91191    ','818','5552086'
);
INSERT INTO ACCOUNT VALUES (
'1092','Flannery, Jerri','P','6627','800','256.81','8107 East Rochelle Blvd','Pasadena','CA','91118    ','818','5556308'
);
INSERT INTO ACCOUNT VALUES (
'1093','Liptak, Ed','P','8294','900','201.63','4842 Work Parkway','Pasadena','CA','91114    ','818','5552343'
);
INSERT INTO ACCOUNT VALUES (
'1094','Walz, David','P','6946','900','344.45','808 S. Vaughn Way 4-North','Los Angeles','CA','90068    ','213','5559449'
);
INSERT INTO ACCOUNT VALUES (
'1095','Gavaldoz, Sam','P','8449','500','208.16','4167 Winche Circle','San Jose','CA','95139    ','408','5552092'
);
INSERT INTO ACCOUNT VALUES (
'1096','Rodenburg, Julie','P','8114','900','829.22','5856 12th South St','San Jose','CA','95109    ','408','5554646'
);
INSERT INTO ACCOUNT VALUES (
'1097','Spiers, Wendy','P','7612','500','233.76','6237 E Bijou St','Los Angeles','CA','90094    ','213','5557717'
);
INSERT INTO ACCOUNT VALUES (
'1098','McIntosh, Michael','P','9760','500','172.79','3186 W. 95th','Berkeley','CA','94704    ','510','5550346'
);
INSERT INTO ACCOUNT VALUES (
'1099','Rounsavell, Pat','P','7888','800','165.28','9075 Zuni St','San Jose','CA','95124    ','408','5557504'
);
INSERT INTO ACCOUNT VALUES (
'1100','Platt, Denny','P','8157','500','47.35','4741 S. 19th St','San Francisco','CA','94147    ','510','5550437'
);
INSERT INTO ACCOUNT VALUES (
'1101','Richter, Maureen','P','8121','700','138.79','7286 E. Rochelle','Los Angeles','CA','90009    ','213','5554692'
);
INSERT INTO ACCOUNT VALUES (
'1102','Srinidhi, Chris','P','7764','600','147.47','2209 Pearl E Circle','San Jose','CA','95127    ','408','5551030'
);
INSERT INTO ACCOUNT VALUES (
'1103','Danforth, Liz','P','6467','500','83.28','8413 South Pierce','Berkeley','CA','94712    ','510','5558327'
);
INSERT INTO ACCOUNT VALUES (
'1104','Gonzales, Mike','P','9876','500','221.89','1407 W 38th','San Jose','CA','95116    ','408','5551729'
);
INSERT INTO ACCOUNT VALUES (
'1105','Dang, Steve','P','9094','600','332.19','6722 E. Nichols Ave','Pasadena','CA','91114    ','818','5554454'
);
INSERT INTO ACCOUNT VALUES (
'1106','Feuer, David','P','8480','900','119.42','8180 Albion St','San Jose','CA','95125    ','408','5550829'
);
INSERT INTO ACCOUNT VALUES (
'1107','Aona, J. Paul','P','8781','900','848.83','6897 N 40 St','Los Angeles','CA','90001    ','213','5553723'
);
INSERT INTO ACCOUNT VALUES (
'1108','Mestas, Mary Ann','P','8242','600','445.68','8719 S Valentia Way','San Jose','CA','95112    ','408','5553854'
);
INSERT INTO ACCOUNT VALUES (
'1109','Nelson, Gene','P','8199','600','447.71','7181 South Trenton','Los Angeles','CA','90070    ','213','5551410'
);
INSERT INTO ACCOUNT VALUES (
'1110','Olsen, Max','P','7412','500','373.03','2774 N Covtrah','San Jose','CA','95160    ','408','5554029'
);
INSERT INTO ACCOUNT VALUES (
'1111','Winter-Reeves, James','P','7929','600','515.79','4358 East Union','Los Angeles','CA','90010    ','213','5553091'
);
INSERT INTO ACCOUNT VALUES (
'1112','Forbes, Leroy','P','8470','900','629.32','4119 W Mineral Dr.','Berkeley','CA','94704    ','510','5557592'
);
INSERT INTO ACCOUNT VALUES (
'1113','Hamann,  Sr.','P','7376','900','748.75','8760 Roosevelt','Palo Alto','CA','94309    ','408','5557650'
);
INSERT INTO ACCOUNT VALUES (
'1114','Gilbert, Ken','P','6416','500','466.54','5653 Lake Plaza Dr','San Jose','CA','95118    ','408','5554444'
);
INSERT INTO ACCOUNT VALUES (
'1115','Davis, Jane','P','8536','600','173.11','589 Washington','Pasadena','CA','91117    ','818','5557903'
);
INSERT INTO ACCOUNT VALUES (
'1116','Chow, Mike','P','8576','700','548.95','1613 Miller Dr','Palo Alto','CA','94308    ','408','5555507'
);
INSERT INTO ACCOUNT VALUES (
'1117','Hamilton, Tony','P','8416','700','596.16','9865 W. Mineral Ave','Los Angeles','CA','90037    ','213','5555610'
);
INSERT INTO ACCOUNT VALUES (
'1118','Strong, George','P','8027','800','469.6','310 Bell Plaza','Palo Alto','CA','94309    ','408','5555079'
);
INSERT INTO ACCOUNT VALUES (
'1119','Woodward, Dale','P','9286','600','247.5','5824 DTC Parkway 1NB','San Francisco','CA','94137    ','510','5554343'
);
INSERT INTO ACCOUNT VALUES (
'1120','Martino, Janet','P','9418','900','370.79','8699 Metcalf Ave','Los Angeles','CA','90073    ','213','5552899'
);
INSERT INTO ACCOUNT VALUES (
'1121','Conover, Dennis','P','9803','800','200.98','4511 S Che St','San Jose','CA','95125    ','408','5559807'
);
INSERT INTO ACCOUNT VALUES (
'1122','Kancir, John','P','9039','600','83.07','9001 One Bell Center','San Francisco','CA','94141    ','510','5556100'
);
INSERT INTO ACCOUNT VALUES (
'1123','Dacoscos, Henry','P','8544','600','18.71','1440 Valley Dr','San Jose','CA','95141    ','408','5552613'
);
INSERT INTO ACCOUNT VALUES (
'1124','Stubbs, Bob','P','9220','800','200.76','8067 Winche Circle','Berkeley','CA','94706    ','510','5557726'
);
INSERT INTO ACCOUNT VALUES (
'1125','Eshete, Paul','P','7551','800','790.28','3148 Parker Rd Waterpark III, CIS','Berkeley','CA','94702    ','510','5550272'
);
INSERT INTO ACCOUNT VALUES (
'1126','Downey, Zora','P','9648','900','117.61','4900 Chapel Hill Dr','San Jose','CA','95157    ','408','5556684'
);
INSERT INTO ACCOUNT VALUES (
'1127','McAnally, L. E.','P','6873','700','397.7','1789 12th South St','Los Angeles','CA','90052    ','213','5551887'
);
INSERT INTO ACCOUNT VALUES (
'1128','Schorzman, Julius','P','9356','600','567.7','1753 West 9th St','San Jose','CA','95111    ','408','5555473'
);
INSERT INTO ACCOUNT VALUES (
'1129','Kvoppinca, Roger','P','7311','800','182.3','4504 Metclaf Ave','Berkeley','CA','94709    ','510','5552795'
);
INSERT INTO ACCOUNT VALUES (
'1130','Chervenak, Richard','P','7615','500','455.15','4321 Russell Ave','Glendale','CA','91226    ','818','5553542'
);
INSERT INTO ACCOUNT VALUES (
'1131','Maxwell, James','P','7371','800','748.83','5056 W. 190th St','San Francisco','CA','94157    ','510','5556423'
);
INSERT INTO ACCOUNT VALUES (
'1132','Poferl, Ruth','P','6594','500','17.85','3928 SW Stark','San Francisco','CA','94105    ','510','5555705'
);
INSERT INTO ACCOUNT VALUES (
'1133','Young, Phil','E','6860','1000','247.74','5669 17th','San Francisco','CA','94125    ','510','5557247'
);
INSERT INTO ACCOUNT VALUES (
'1134','Moss, Valarie','P','6537','900','643.69','1742 W 115 Circle','Pasadena','CA','91191    ','818','5556711'
);
INSERT INTO ACCOUNT VALUES (
'1135','Jaquez, Andy','P','9872','600','76.32','8449 E Girard','Los Angeles','CA','90102    ','213','5554540'
);
INSERT INTO ACCOUNT VALUES (
'1136','Le Bouef, Joseph','P','7826','900','8.68','6231 Chapel Hills Dr L','Pasadena','CA','91124    ','818','5552582'
);
INSERT INTO ACCOUNT VALUES (
'1137','Tito, Dennis','P','7568','600','416.8','55 17th St','San Francisco','CA','94145    ','510','5556232'
);
INSERT INTO ACCOUNT VALUES (
'1138','Muskin, Peggy','P','6427','500','341.63','9072 S Ul St','San Francisco','CA','94114    ','510','5553013'
);
INSERT INTO ACCOUNT VALUES (
'1139','Hofman, Jonathan','P','9777','800','641.11','768 Snyder Mtn. Rd','Los Angeles','CA','90017    ','213','5557167'
);
INSERT INTO ACCOUNT VALUES (
'1140','Cadwell, Dick','P','7070','600','591.28','2283 N Oak Trafficway PO Box','San Francisco','CA','94104    ','510','5555264'
);
INSERT INTO ACCOUNT VALUES (
'1141','Butts, Doug','P','8594','800','392.19','2640 E. Thomas, 22nd Fl','Los Angeles','CA','90012    ','213','5557679'
);
INSERT INTO ACCOUNT VALUES (
'1142','Mager, Paul','P','6813','500','313.32','233 Denver West Dr','San Jose','CA','95111    ','408','5552549'
);
INSERT INTO ACCOUNT VALUES (
'1143','Krause, Mike','P','9445','800','558.91','1899 Zuni St','Oakland','CA','94643    ','510','5558990'
);
INSERT INTO ACCOUNT VALUES (
'1144','Buss, Dan','P','9205','700','482.55','7914 S. Cole Court','Los Angeles','CA','90023    ','213','5555780'
);
INSERT INTO ACCOUNT VALUES (
'1145','Nathan, Magorie','P','8985','900','408.47','9045 E Thomas Rd','San Francisco','CA','94131    ','510','5554945'
);
INSERT INTO ACCOUNT VALUES (
'1146','Fogarty, McKillip','P','9703','800','368.12','2902 Tijeras NW','San Francisco','CA','94115    ','510','5551110'
);
INSERT INTO ACCOUNT VALUES (
'1147','Knutson, Catherine','P','8327','500','343.8','1129 DTC Parkway 1NB','San Jose','CA','95170    ','408','5559148'
);
INSERT INTO ACCOUNT VALUES (
'1148','Fernalld, Pam','P','9242','600','78.59','8502 Lawrence St','Pasadena','CA','91126    ','818','5557605'
);
INSERT INTO ACCOUNT VALUES (
'1149','Niessen, Vlerinria','P','6887','800','219.09','3647 West 1200 South MS','Oakland','CA','94612    ','510','5553020'
);
INSERT INTO ACCOUNT VALUES (
'1150','Ferguson, David','P','7113','900','202.07','3617 E Mississippi Apt 21-','Los Angeles','CA','90003    ','213','5556755'
);
INSERT INTO ACCOUNT VALUES (
'1151','Waleri, John','P','9989','800','455.98','69 Filmore St','Los Angeles','CA','90087    ','213','5552536'
);
INSERT INTO ACCOUNT VALUES (
'1152','Payton, Richard','P','8166','500','133.18','8871 Garden of the Gods Rd','San Jose','CA','95192    ','408','5556930'
);
INSERT INTO ACCOUNT VALUES (
'1153','Rachakonda, Larry','P','6675','500','498.46','606 Democrat','Beverly Hills','CA','90211    ','310','5559816'
);
INSERT INTO ACCOUNT VALUES (
'1154','Fletcher, Craig','P','7902','500','269.61','5903 Douglas','Palo Alto','CA','94308    ','408','5550887'
);
INSERT INTO ACCOUNT VALUES (
'1155','Eiben, Don','P','7231','800','324.12','3597 Beltline','Los Angeles','CA','90012    ','213','5557429'
);
INSERT INTO ACCOUNT VALUES (
'1156','Kennedy, Ann','P','8682','600','347.11','8841 Lawrence St','Los Angeles','CA','90007    ','213','5551174'
);
INSERT INTO ACCOUNT VALUES (
'1157','Gurnett, George','P','9789','800','406.05','4949 17th Ave','Los Angeles','CA','90040    ','213','5552112'
);
INSERT INTO ACCOUNT VALUES (
'1158','Adragna, Bryan','P','9147','700','201.34','6281 South Quebec','San Francisco','CA','94126    ','510','5559381'
);
INSERT INTO ACCOUNT VALUES (
'1159','Kotoski, Peggy','P','9446','800','722.14','4084 W Orion St','San Jose','CA','95192    ','408','5558993'
);
INSERT INTO ACCOUNT VALUES (
'1160','Franz, Prasad','P','8466','900','28.15','9236 South Ul St, Ste','Los Angeles','CA','90011    ','213','5558569'
);
INSERT INTO ACCOUNT VALUES (
'1161','Westling, Mary','P','7949','800','423.44','8498 SW 4th','Oakland','CA','94607    ','510','5554605'
);
INSERT INTO ACCOUNT VALUES (
'1162','Larew, JIm','P','7235','700','483.62','5257 S. Galena','Oakland','CA','94620    ','510','5550311'
);
INSERT INTO ACCOUNT VALUES (
'1163','Johnson, Gary','P','8359','600','98.79','1678 Russell Ave','San Jose','CA','95112    ','408','5555656'
);
INSERT INTO ACCOUNT VALUES (
'1164','Gato, Diane','P','9064','800','241.8','5029 W Mineral Dr','Pasadena','CA','91186    ','818','5556213'
);
INSERT INTO ACCOUNT VALUES (
'1165','Banks, Lewis','P','7431','800','142.87','4241 Democrat','Oakland','CA','94613    ','510','5550345'
);
INSERT INTO ACCOUNT VALUES (
'1166','Slickers, Terry','P','6650','800','341.36','7244 Kelly Johnson Blvd','San Jose','CA','95152    ','408','5551453'
);
INSERT INTO ACCOUNT VALUES (
'1167','MacCue, Shelley','P','6488','900','502.95','3944 S Pennsylvania St','Los Angeles','CA','90017    ','213','5557638'
);
INSERT INTO ACCOUNT VALUES (
'1168','Pumpernickel, Bill','P','6990','500','350.68','6513 E. Dry Creek Rd','Palo Alto','CA','94309    ','408','5556385'
);
INSERT INTO ACCOUNT VALUES (
'1169','Kelpin, Evan','P','7833','900','542.23','4914 NW Science Park Dr','Los Angeles','CA','90050    ','213','5558550'
);
INSERT INTO ACCOUNT VALUES (
'1170','Oldson, Thresa','P','6571','700','664.41','5599 S Holman Way a','Palo Alto','CA','94305    ','408','5556246'
);
INSERT INTO ACCOUNT VALUES (
'1171','Reid, Chris','P','7452','900','3.65','4352 Hearthwood Lane','Oakland','CA','94611    ','510','5556317'
);
INSERT INTO ACCOUNT VALUES (
'1172','Amys, Veena','P','6730','800','545.09','5170 S. Devon Ct','Berkeley','CA','94709    ','510','5552003'
);
INSERT INTO ACCOUNT VALUES (
'1173','Peterson, Howard','P','9187','600','439.05','2357 E. Rochelle','Los Angeles','CA','90049    ','213','5551041'
);
INSERT INTO ACCOUNT VALUES (
'1174','Breckenridge, Jim \& Eddie','P','8613','700','466.45','3212 Deer Trail Rd','Los Angeles','CA','90088    ','213','5550500'
);
INSERT INTO ACCOUNT VALUES (
'1175','Prodehl, Thayne','P','9610','900','403.86','973 S. Valentia Way','Los Angeles','CA','90016    ','213','5551738'
);
INSERT INTO ACCOUNT VALUES (
'1176','Morris, Sharon','P','8219','800','276.98','4242 Valley Dr','Pasadena','CA','91188    ','818','5553614'
);
INSERT INTO ACCOUNT VALUES (
'1177','Glabn, George','P','6554','600','408.25','6716 N Oak Trafficway PO Box','San Francisco','CA','94145    ','510','5555108'
);
INSERT INTO ACCOUNT VALUES (
'1178','McCans, Carolyn','P','7545','500','65.55','8336 S. Vantia Way','Berkeley','CA','94706    ','510','5554581'
);
INSERT INTO ACCOUNT VALUES (
'1179','Caner, Michael','P','7162','800','659.3','7299 E Alameda Dr Police Sys. Mgmt','San Francisco','CA','94115    ','510','5551810'
);
INSERT INTO ACCOUNT VALUES (
'1180','Johnson, Rick','P','8364','800','690.97','1941 Airways Blvd','San Jose','CA','95196    ','408','5556819'
);
INSERT INTO ACCOUNT VALUES (
'1181','Mellin, Barbara','P','9000','700','576.12','2588 E Union Ave','San Francisco','CA','94135    ','510','5556164'
);
INSERT INTO ACCOUNT VALUES (
'1182','Murphy, Michael','P','7137','700','631.53','7797 N Glenville Dr','San Francisco','CA','94175    ','510','5552054'
);
INSERT INTO ACCOUNT VALUES (
'1183','McCarty, Tammy','P','7257','600','152.11','2064 Bell Plaza','Los Angeles','CA','90185    ','213','5559405'
);
INSERT INTO ACCOUNT VALUES (
'1184','Huckfeldt, Ellen','P','8867','800','151','9656 14th St','Los Angeles','CA','90074    ','213','5553469'
);
INSERT INTO ACCOUNT VALUES (
'1185','Decker, Kathleen','P','6986','600','48.56','9411 S Valentia','Pasadena','CA','91182    ','818','5550149'
);
INSERT INTO ACCOUNT VALUES (
'1186','Cole, Yvonne','P','9804','600','138.83','4910 S. Research Parkway','San Francisco','CA','94155    ','510','5552653'
);
INSERT INTO ACCOUNT VALUES (
'1187','Hintz, Cheryl','P','9920','900','718.51','4435 Mark Dabling Rd','Los Angeles','CA','90004    ','213','5552210'
);
INSERT INTO ACCOUNT VALUES (
'1188','Okinczyc, Kathy','P','8185','800','2.91','3736 South 88th St','Oakland','CA','94624    ','510','5550783'
);
INSERT INTO ACCOUNT VALUES (
'1189','Mathew, Alan','P','7390','800','358.98','143 Inverness Place East','San Francisco','CA','94166    ','510','5558208'
);
INSERT INTO ACCOUNT VALUES (
'1190','Price, Nancy','P','6697','500','116.46','1080 N. Prospect','San Jose','CA','95116    ','408','5552440'
);
INSERT INTO ACCOUNT VALUES (
'1191','Watterson, Koch','P','8706','900','470.57','5755 Mark Dabling Blvd','Los Angeles','CA','90061    ','213','5558010'
);
INSERT INTO ACCOUNT VALUES (
'1192','Enter, Mark','P','7189','600','168.48','3569 2nd Ave SE','Palo Alto','CA','94302    ','408','5554539'
);
INSERT INTO ACCOUNT VALUES (
'1193','Weatherley, Dana','P','6541','800','233.76','937 Grant St','San Francisco','CA','94105    ','510','5550517'
);
INSERT INTO ACCOUNT VALUES (
'1194','Buck, Ron','P','8603','900','622.62','6408 S Dayton St','Beverly Hills','CA','90211    ','310','5559043'
);
INSERT INTO ACCOUNT VALUES (
'1195','Miller, Ken','P','8234','800','126.59','5622 E Thomas Rd','Los Angeles','CA','90014    ','213','5554147'
);
INSERT INTO ACCOUNT VALUES (
'1196','Reczek, Patricia','P','8127','700','262.91','5103 West 1200 South MS','Beverly Hills','CA','90210    ','310','5559383'
);
INSERT INTO ACCOUNT VALUES (
'1197','Huffman, Cathy','P','9160','500','224.58','9882 Champa St#B','Oakland','CA','94618    ','510','5557617'
);
INSERT INTO ACCOUNT VALUES (
'1198','Borner, Brenda','P','9129','900','150.38','801 W 37th St','Berkeley','CA','94704    ','510','5550092'
);
INSERT INTO ACCOUNT VALUES (
'1199','Linthicum, Mary','P','9436','900','132.88','5017 Tech Center Dr','San Jose','CA','95134    ','408','5557443'
);
INSERT INTO ACCOUNT VALUES (
'1200','Shakeri, John','P','8951','900','48.56','5405 Work Parkway','Oakland','CA','94662    ','510','5558845'
);
INSERT INTO ACCOUNT VALUES (
'1201','Buck, Dianne','P','7665','800','531.23','6299 E 104th St','Oakland','CA','94659    ','510','5554153'
);
INSERT INTO ACCOUNT VALUES (
'1202','Guarini, Pat','P','7557','700','382.13','9264 E. 104th St','San Francisco','CA','94147    ','510','5553026'
);
INSERT INTO ACCOUNT VALUES (
'1203','Alexander, Steve','P','9581','900','318.11','8528 S Havana St','San Francisco','CA','94106    ','510','5554293'
);
INSERT INTO ACCOUNT VALUES (
'1204','Brozonic, Brian','P','8608','900','326.07','1050 O''Neal Pkwy','Oakland','CA','94650    ','510','5555492'
);
INSERT INTO ACCOUNT VALUES (
'1205','Dave, Dar','P','7508','700','271.43','8470 S Valentia','Berkeley','CA','94720    ','510','5553771'
);
INSERT INTO ACCOUNT VALUES (
'1206','Kissinger, Pauline','P','9631','700','493.83','6277 Union Blvd','San Jose','CA','95192    ','408','5550162'
);
INSERT INTO ACCOUNT VALUES (
'1207','Smith, Gloria','P','9340','600','124.57','3054 South Vaughn Way 6th North','Pasadena','CA','91185    ','818','5558943'
);
INSERT INTO ACCOUNT VALUES (
'1208','White, Tammy','P','6667','600','447.2','5226 S. Cherry Creek','Pasadena','CA','91117    ','818','5551378'
);
INSERT INTO ACCOUNT VALUES (
'1209','Stone, Diana','P','8934','700','332.03','8197 E. Mulberry','Palo Alto','CA','94309    ','408','5557050'
);
INSERT INTO ACCOUNT VALUES (
'1210','Lehman, Linda','P','8305','900','394.52','5059 Metclaf','Pasadena','CA','91124    ','818','5556058'
);
INSERT INTO ACCOUNT VALUES (
'1211','Moore, Glen','P','7230','700','410.84','4154 DTC Parkway','Oakland','CA','94609    ','510','5558690'
);
INSERT INTO ACCOUNT VALUES (
'1212','Hellyer, Tammy','P','9781','600','190.83','9179 Cumberland Circle','San Jose','CA','95116    ','408','5550151'
);
INSERT INTO ACCOUNT VALUES (
'1213','Shrewsbury, Dennis','P','6613','500','402.4','1684 18th St HWM-SM','San Francisco','CA','94171    ','510','5556070'
);
INSERT INTO ACCOUNT VALUES (
'1214','Davis, Tom','P','9800','600','178.73','736 S.W. Park','Oakland','CA','94661    ','510','5554197'
);
INSERT INTO ACCOUNT VALUES (
'1215','Nelson, Mark','P','6565','700','135.76','4948 Chapel Hill Dr','San Francisco','CA','94129    ','510','5552644'
);
INSERT INTO ACCOUNT VALUES (
'1216','Oliver, Beyer','P','9844','600','419.06','4479 W. Mineral Dr','San Francisco','CA','94152    ','510','5552998'
);
INSERT INTO ACCOUNT VALUES (
'1217','Sussenbach, Julie','P','7445','800','296.44','2727 S Valentia Way','Berkeley','CA','94702    ','510','5551917'
);
INSERT INTO ACCOUNT VALUES (
'1218','Mason, Nelson','P','7334','500','259.81','8176 Grant St','San Francisco','CA','94169    ','510','5550040'
);
INSERT INTO ACCOUNT VALUES (
'1219','Paris, Dana','P','8171','600','435.04','7151 Telstar Dr','Los Angeles','CA','90048    ','213','5558873'
);
INSERT INTO ACCOUNT VALUES (
'1220','Cunniff, Moya','P','8549','600','184.15','4153 E. Tufts Ave','San Francisco','CA','94151    ','510','5556838'
);
INSERT INTO ACCOUNT VALUES (
'1221','Jacoby, Thomas','P','8373','800','677.2','620 SW 4th Ave','Los Angeles','CA','90012    ','213','5553370'
);
INSERT INTO ACCOUNT VALUES (
'1222','Subbian, David','P','8930','700','472.71','7648 Van Gordan St','Pasadena','CA','91184    ','818','5552070'
);
INSERT INTO ACCOUNT VALUES (
'1223','Yurkanis, Daniel','P','7278','600','364.22','8936 Grant St GR','Los Angeles','CA','90060    ','213','5555703'
);
INSERT INTO ACCOUNT VALUES (
'1224','Bentley, John','P','9134','700','377.15','9472 SW Willow Dr','San Francisco','CA','94152    ','510','5556385'
);
INSERT INTO ACCOUNT VALUES (
'1225','Deichl, Robert','P','7004','900','167.43','9545 S Valentia','Los Angeles','CA','90035    ','213','5550189'
);
INSERT INTO ACCOUNT VALUES (
'1226','Patrick, Tom','P','6899','900','193.85','7363 Little Kalama River Rd','Pasadena','CA','91051    ','818','5553861'
);
INSERT INTO ACCOUNT VALUES (
'1227','Richard, John Patrick','P','6843','500','291.44','5801 Madison St','San Francisco','CA','94125    ','510','5553353'
);
INSERT INTO ACCOUNT VALUES (
'1228','Satta, Ken','P','6449','900','644.51','2129 Winneden Rd','Los Angeles','CA','90078    ','213','5551942'
);
INSERT INTO ACCOUNT VALUES (
'1229','Shanklin, Michelle','P','8711','700','188.07','1039 Chapel Hill Dr','San Jose','CA','95118    ','408','5550326'
);
INSERT INTO ACCOUNT VALUES (
'1230','Turnquist, David','P','9176','900','501.09','4464 N. 22nd Ave','Los Angeles','CA','90054    ','213','5559177'
);
INSERT INTO ACCOUNT VALUES (
'1231','Newton, Dick','E','7753','1000','31.71','651 Van Gordon','San Francisco','CA','94144    ','510','5557169'
);
INSERT INTO ACCOUNT VALUES (
'1232','McGuffin, Ray','P','9761','800','473.75','6603 Hearthwood Lane','San Francisco','CA','94110    ','510','5553794'
);
INSERT INTO ACCOUNT VALUES (
'1233','Sierra, Lisa','P','7152','800','746.7','9898 Maple Ave','Los Angeles','CA','90018    ','213','5551375'
);
INSERT INTO ACCOUNT VALUES (
'1234','Moore, Maria','P','6856','600','160.58','4810 N Creek III Mark Dabling','Los Angeles','CA','90034    ','213','5551371'
);
INSERT INTO ACCOUNT VALUES (
'1235','Border, Brian','P','9550','600','508.67','6285 Inverness Way East','San Jose','CA','95109    ','408','5554253'
);
INSERT INTO ACCOUNT VALUES (
'1236','Finnegan, Bushra','P','8477','800','467.7','9435 E. Rochelle Blvd. TXIVGQ','Los Angeles','CA','90066    ','213','5550409'
);
INSERT INTO ACCOUNT VALUES (
'1237','Furfari, Scott','P','9069','800','144.56','2616 Birch','San Francisco','CA','94144    ','510','5559616'
);
INSERT INTO ACCOUNT VALUES (
'1238','Schwotzer, Larry','P','9354','800','255.44','3662 Elm','Glendale','CA','91224    ','818','5551659'
);
INSERT INTO ACCOUNT VALUES (
'1239','Pusey, Paul','P','7183','500','249.92','6958 S Yosemite','Pasadena','CA','91124    ','818','5552647'
);
INSERT INTO ACCOUNT VALUES (
'1240','Leiser, Russell','P','9899','900','553.24','2904 Lake Plaza Dr','San Francisco','CA','94134    ','510','5559254'
);
INSERT INTO ACCOUNT VALUES (
'1241','Weed, Randy','P','9912','700','155.2','9562 SW 7th','Los Angeles','CA','90071    ','213','5558429'
);
INSERT INTO ACCOUNT VALUES (
'1242','Courson, Karen','P','7657','800','549.68','9154 S. Vaughn Way 4-North','Los Angeles','CA','90030    ','213','5556009'
);
INSERT INTO ACCOUNT VALUES (
'1243','Voisiap, Gary','P','7328','900','855.4','2410 Douglas on the Mall','Los Angeles','CA','90019    ','213','5550496'
);
INSERT INTO ACCOUNT VALUES (
'1244','Finn, Bill','P','9270','600','449.63','2599 E. Nichols Ave','Los Angeles','CA','90093    ','213','5559957'
);
INSERT INTO ACCOUNT VALUES (
'1245','Ahmad, Jose','P','9146','500','33.94','8118 Pine Rd Box','Los Angeles','CA','90102    ','213','5551147'
);
INSERT INTO ACCOUNT VALUES (
'1246','Tracy, Gerald','P','9914','800','380.62','5067 NE Circle Blvd','San Francisco','CA','94119    ','510','5558260'
);
INSERT INTO ACCOUNT VALUES (
'1247','Williams, Kathy','P','6457','800','700.9','9780 Lincoln St','San Francisco','CA','94122    ','510','5551593'
);
INSERT INTO ACCOUNT VALUES (
'1248','Dingledine, Georgiann','P','8517','800','194.07','8688 O''Neal Pkwy','San Jose','CA','95122    ','408','5557862'
);
INSERT INTO ACCOUNT VALUES (
'1249','Mallen, Jana','P','6601','900','616.94','2860 E. Arkansas','Pasadena','CA','91126    ','818','5558503'
);
INSERT INTO ACCOUNT VALUES (
'1250','Duning, Steve','P','9705','800','797.17','9500 S Hill St','San Jose','CA','95153    ','408','5558815'
);
INSERT INTO ACCOUNT VALUES (
'1251','Barnes, John','P','6518','500','298.89','8531 East Orchard','Beverly Hills','CA','90212    ','310','5553220'
);
INSERT INTO ACCOUNT VALUES (
'1252','Phelps, Eleanor','P','7590','900','264.77','3628 Bell Plaza','Oakland','CA','94603    ','510','5551308'
);
INSERT INTO ACCOUNT VALUES (
'1253','Hutchinson, Catherine','P','8377','600','140.15','1695 N. Prospect','Los Angeles','CA','90003    ','213','5551658'
);
INSERT INTO ACCOUNT VALUES (
'1254','Flageolle, Lam','P','6748','700','143.06','2803 Jackson St','Beverly Hills','CA','90212    ','310','5553315'
);
INSERT INTO ACCOUNT VALUES (
'1255','Filbey, Doug','P','8479','900','148.7','2465 W Mineral Ave','Glendale','CA','91205    ','818','5550127'
);
INSERT INTO ACCOUNT VALUES (
'1256','Palfreeman, David','P','9389','900','663.08','8738 Chapel Hills','San Francisco','CA','94153    ','510','5556397'
);
INSERT INTO ACCOUNT VALUES (
'1257','Proctor, Jonathan','P','8143','500','110.89','3314 Clover Basin Dr','San Jose','CA','95108    ','408','5551794'
);
INSERT INTO ACCOUNT VALUES (
'1258','Anderson, Alan','P','6509','600','385.25','2371 East Union Ave','Oakland','CA','94626    ','510','5552507'
);
INSERT INTO ACCOUNT VALUES (
'1259','Copeland, Doug','P','9598','800','1.88','8305 E Pikes Peak','San Francisco','CA','94103    ','510','5557183'
);
INSERT INTO ACCOUNT VALUES (
'1260','Rogers, Karen','P','7012','500','90.48','4952 S. Syracuse Way','San Francisco','CA','94139    ','510','5553612'
);
INSERT INTO ACCOUNT VALUES (
'1261','Walts, Norma','P','7965','700','521.01','7448 E First Ave','San Jose','CA','95152    ','408','5556813'
);
INSERT INTO ACCOUNT VALUES (
'1262','Engles, Susan','P','9797','500','85.16','6304 Ward Pkwy','Pasadena','CA','91189    ','818','5556949'
);
INSERT INTO ACCOUNT VALUES (
'1263','Hennesey, Carlos','P','7024','600','11.46','53 Winche Circle','Berkeley','CA','94702    ','510','5555120'
);
INSERT INTO ACCOUNT VALUES (
'1264','Plunkett III, Patricia','P','7377','700','456.15','8400 College Blvd','Los Angeles','CA','90061    ','213','5553819'
);
INSERT INTO ACCOUNT VALUES (
'1265','Eldeen, Gary','P','8495','900','401.66','1736 Woodland Park Rd','Oakland','CA','94614    ','510','5553662'
);
INSERT INTO ACCOUNT VALUES (
'1266','Hetterscheidt, Nancy','P','9475','800','213.5','3868 One Williams Center','Los Angeles','CA','90049    ','213','5556515'
);
INSERT INTO ACCOUNT VALUES (
'1267','Fields, Lily','P','9241','800','477.12','5700 Democrat','San Francisco','CA','94123    ','510','5557938'
);
INSERT INTO ACCOUNT VALUES (
'1268','Bakchi, Judy','P','7337','600','147.02','9797 Grant St GR','Los Angeles','CA','90020    ','213','5558533'
);
INSERT INTO ACCOUNT VALUES (
'1269','Rojahn, Mantai','P','7299','700','265.43','7428 W 38th Ave','Glendale','CA','91202    ','818','5553331'
);
INSERT INTO ACCOUNT VALUES (
'1270','Switzer, Norm','P','8020','700','122.49','846 28th St','Los Angeles','CA','90019    ','213','5559727'
);
INSERT INTO ACCOUNT VALUES (
'1271','Clayton, Julie','P','8899','900','315.39','1657 Inverness Circle East','Pasadena','CA','91101    ','818','5559360'
);
INSERT INTO ACCOUNT VALUES (
'1272','Canady, Steve','P','6678','500','419.42','2730 Centennial Blvd','San Francisco','CA','94132    ','510','5553243'
);
INSERT INTO ACCOUNT VALUES (
'1273','Stiles, Scott','P','7571','600','240.25','9617 E Belleview','Los Angeles','CA','90084    ','213','5553211'
);
INSERT INTO ACCOUNT VALUES (
'1274','Trautman, Theresa','P','7992','800','546.46','4309 7th','San Francisco','CA','94103    ','510','5557695'
);
INSERT INTO ACCOUNT VALUES (
'1275','Furlong, Jamie','P','9972','900','74.24','464 S Pennsylvania St','Glendale','CA','91202    ','818','5552433'
);
INSERT INTO ACCOUNT VALUES (
'1276','Sawatzky, Suellen','P','6808','800','309.16','3701 Torbett','Glendale','CA','91224    ','818','5554049'
);
INSERT INTO ACCOUNT VALUES (
'1277','Erlanger, Shauna','P','7045','900','247.36','4438 E Maplewood Ave','Pasadena','CA','91184    ','818','5557750'
);
INSERT INTO ACCOUNT VALUES (
'1278','Fowler, Theresa','P','7022','900','734.38','4095 Cumberland Circle','San Jose','CA','95126    ','408','5557794'
);
INSERT INTO ACCOUNT VALUES (
'1279','Baur, LaRae','P','8641','500','410.34','481 Inverness Place East','San Francisco','CA','94146    ','510','5558701'
);
INSERT INTO ACCOUNT VALUES (
'1280','Sheldon, Steve','P','6460','500','413.04','2450 12th South St','Los Angeles','CA','90089    ','213','5553459'
);
INSERT INTO ACCOUNT VALUES (
'1281','Adamescu, Brad','P','9149','600','79.93','6901 E. Tufts','Oakland','CA','94621    ','510','5553298'
);
INSERT INTO ACCOUNT VALUES (
'1282','Anderson, Gary','P','7652','500','109.99','278 Krameria','Los Angeles','CA','90014    ','213','5554600'
);
INSERT INTO ACCOUNT VALUES (
'1283','Akers, Wasim','P','9584','500','179.7','3429 S. Valentia Way','San Jose','CA','95118    ','408','5556538'
);
INSERT INTO ACCOUNT VALUES (
'1284','Oreskey, Randy','P','8723','500','68.3','754 Lake Plaza Dr','Beverly Hills','CA','90210    ','310','5554586'
);
INSERT INTO ACCOUNT VALUES (
'1285','Hebert, Suzette','P','8403','800','355.66','7075 Neil Rd','Los Angeles','CA','90041    ','213','5557343'
);
INSERT INTO ACCOUNT VALUES (
'1286','Nasser, Cressandra','P','8986','900','470.05','3822 South Ul St. Parkway Ste','Los Angeles','CA','90052    ','213','5554662'
);
INSERT INTO ACCOUNT VALUES (
'1287','Moles, Ron','P','9682','800','162.84','5250 N. Pecos','San Jose','CA','95140    ','408','5556805'
);
INSERT INTO ACCOUNT VALUES (
'1288','Barber, Steven','P','7016','800','456.91','1717 E Belleview','Pasadena','CA','91104    ','818','5556634'
);
INSERT INTO ACCOUNT VALUES (
'1289','Alexander, Linda','P','6691','500','79.22','7418 S Pine Dr','Los Angeles','CA','90087    ','213','5553028'
);
INSERT INTO ACCOUNT VALUES (
'1290','McCann, Byron','P','7256','700','312.45','6658 Rural Route 2, Box','San Francisco','CA','94129    ','510','5555450'
);
INSERT INTO ACCOUNT VALUES (
'1291','Gordon, Jeff','P','9269','500','161.42','203 DTC Blvd','San Francisco','CA','94131    ','510','5554168'
);
INSERT INTO ACCOUNT VALUES (
'1292','Luft, Dennis','P','8283','700','419.62','5906 E Thomas Rd','Pasadena','CA','91182    ','818','5558547'
);
INSERT INTO ACCOUNT VALUES (
'1293','Zumpf, Sharon','P','7912','600','103.89','8914 S Pine Dr','Los Angeles','CA','90049    ','213','5559501'
);
INSERT INTO ACCOUNT VALUES (
'1294','Foley, Bill','P','9509','800','771.58','5414 N Rockwell','Los Angeles','CA','90001    ','213','5556094'
);
INSERT INTO ACCOUNT VALUES (
'1295','Coleman, Fredrick','P','8565','800','498.61','1649 Seventh Ave','Los Angeles','CA','90074    ','213','5556377'
);
INSERT INTO ACCOUNT VALUES (
'1296','Mathis, John','P','9763','800','472.63','3863 South Carefree Circle','San Francisco','CA','94102    ','510','5555101'
);
INSERT INTO ACCOUNT VALUES (
'1297','Griffith, Bassel','P','9061','500','393.33','5851 Wayzata Blvd','Glendale','CA','91225    ','818','5559576'
);
INSERT INTO ACCOUNT VALUES (
'1298','Harlow, Roy','P','7298','900','241.56','2687 S Valentia Way','San Francisco','CA','94166    ','510','5554251'
);
INSERT INTO ACCOUNT VALUES (
'1299','Bevilacqua, Martin','P','8679','700','378.88','3848 Denver West Dr','San Jose','CA','95142    ','408','5553180'
);
INSERT INTO ACCOUNT VALUES (
'1300','Jorgensen, Ardith','P','9458','600','460.82','8355 E Alameda Dr','Glendale','CA','91214    ','818','5556261'
);
INSERT INTO ACCOUNT VALUES (
'1301','Scott, Douglas','P','6634','500','143.07','368 West 106th Place','San Jose','CA','95126    ','408','5558200'
);
INSERT INTO ACCOUNT VALUES (
'1302','Savage, Dileep','P','9608','500','419.97','6940 Dodge Rd','Oakland','CA','94611    ','510','5553230'
);
INSERT INTO ACCOUNT VALUES (
'1303','MacDonald, Karl','P','8279','900','600.9','8503 E. Rochelle','Palo Alto','CA','94307    ','408','5554884'
);
INSERT INTO ACCOUNT VALUES (
'1304','Ketterer, Dale','P','7133','900','418.22','1290 Metcalf Ave','San Francisco','CA','94109    ','510','5552812'
);
INSERT INTO ACCOUNT VALUES (
'1305','Johnson, Doug','P','7663','800','265.75','5453 Greenwood Plaza','Pasadena','CA','91110    ','818','5556638'
);
INSERT INTO ACCOUNT VALUES (
'1306','Schmid, Jon','P','8082','600','241.3','5631 Champa','Berkeley','CA','94705    ','510','5554064'
);
INSERT INTO ACCOUNT VALUES (
'1307','Gates, Cynthia','P','7851','700','564.61','9365 E. Marina DR','San Jose','CA','95101    ','408','5552164'
);
INSERT INTO ACCOUNT VALUES (
'1308','Stewart, Lance','P','6584','800','172.63','9334 S Ul St','Pasadena','CA','91188    ','818','5551916'
);
INSERT INTO ACCOUNT VALUES (
'1309','Martha Anne, Janet','P','7488','600','176.73','821 12th South St','Berkeley','CA','94710    ','510','5550165'
);
INSERT INTO ACCOUNT VALUES (
'1310','Whitney, Corinne','P','7704','600','19.72','2202 Weston Parkway','Los Angeles','CA','90050    ','213','5551546'
);
INSERT INTO ACCOUNT VALUES (
'1311','Turner, Sue','P','8845','800','301.37','4523 Chapell Hills Dr','San Jose','CA','95139    ','408','5555892'
);
INSERT INTO ACCOUNT VALUES (
'1312','Jacobs, Powell','P','7627','600','428.5','1397 E First Ave','San Francisco','CA','94165    ','510','5557940'
);
INSERT INTO ACCOUNT VALUES (
'1313','O''Neil, Arghya','P','8186','800','156.1','8991 18th St HWM-SM','Los Angeles','CA','90020    ','213','5558871'
);
INSERT INTO ACCOUNT VALUES (
'1314','Kane, Shirley','P','9772','500','110.64','744 Beltline','Berkeley','CA','94710    ','510','5557203'
);
INSERT INTO ACCOUNT VALUES (
'1315','Bowen, Mike','P','8620','500','280.04','1436 South Vaughn Way 6th North','Oakland','CA','94643    ','510','5559464'
);
INSERT INTO ACCOUNT VALUES (
'1316','Rymill, Eric','P','8103','700','114.12','7086 Metclaf','Los Angeles','CA','90047    ','213','5556077'
);
INSERT INTO ACCOUNT VALUES (
'1317','McCalebb, Danny','P','9416','700','290.12','1340 E. Mulberry','Berkeley','CA','94706    ','510','5559488'
);
INSERT INTO ACCOUNT VALUES (
'1318','Solano, Martin','P','7413','500','74.77','9111 E. 104th','San Francisco','CA','94124    ','510','5559583'
);
INSERT INTO ACCOUNT VALUES (
'1319','Kmetz, Brad','P','8328','500','52.83','460 Inverness Dr South','Pasadena','CA','91126    ','818','5555724'
);
INSERT INTO ACCOUNT VALUES (
'1320','Schrank, Carole','P','6542','500','28.18','5339 N Pecos St','Beverly Hills','CA','90213    ','310','5559323'
);
INSERT INTO ACCOUNT VALUES (
'1321','Donnahoo, Bob','P','7859','500','409.24','666 River Way','San Francisco','CA','94108    ','510','5558296'
);
INSERT INTO ACCOUNT VALUES (
'1322','Javor, Margaret','P','9461','700','685.79','5615 E Sixth Ave','Palo Alto','CA','94309    ','408','5551334'
);
INSERT INTO ACCOUNT VALUES (
'1323','Perkins, Bryan','P','8162','700','135.12','6033 Flatiron Parkway','Pasadena','CA','91106    ','818','5551139'
);
INSERT INTO ACCOUNT VALUES (
'1324','Rivers, Delf','P','6704','500','459.17','9998 S. Vaughn Way','San Francisco','CA','94171    ','510','5552312'
);
INSERT INTO ACCOUNT VALUES (
'1325','Geneve, Deb','P','7196','500','230.64','7553 W Inverness','Oakland','CA','94621    ','510','5555751'
);
INSERT INTO ACCOUNT VALUES (
'1326','Murphy, Ralph','P','8211','900','385.57','3129 Creede Ranger District','Los Angeles','CA','90017    ','213','5554986'
);
INSERT INTO ACCOUNT VALUES (
'1327','Angeles, Steve','P','7647','600','157.98','9723 S. Quebec St','San Jose','CA','95196    ','408','5559649'
);
INSERT INTO ACCOUNT VALUES (
'1328','Elliott, Kirk','P','9798','600','19.76','3518 Inverness Circle','Los Angeles','CA','90046    ','213','5552259'
);
INSERT INTO ACCOUNT VALUES (
'1329','Porter, Connie','P','8150','600','312.08','6726 Sunrise Valley Dr','San Jose','CA','95137    ','408','5556691'
);
INSERT INTO ACCOUNT VALUES (
'1330','Jacobson, Karen','P','7778','900','368.32','3756 Bell Center','Oakland','CA','94643    ','510','5559137'
);
INSERT INTO ACCOUNT VALUES (
'1331','Happ, Bill','P','7157','500','111.31','7153 E. Mulberry','Los Angeles','CA','90079    ','213','5553366'
);
INSERT INTO ACCOUNT VALUES (
'1332','Harvey, Kathie','P','8408','700','486.46','2417 S. Quebec St','San Jose','CA','95136    ','408','5559502'
);
INSERT INTO ACCOUNT VALUES (
'1333','Culver, Chad','P','6523','900','557.56','474 Harney RD HC 87 Box','San Jose','CA','95102    ','408','5558074'
);
INSERT INTO ACCOUNT VALUES (
'1334','Sannerud, Johnny','P','8958','500','12.65','9755 One Bell Center','Oakland','CA','94615    ','510','5558695…