API tools faq
paste
Guest User

Untitled

a guest
Sep 30th, 2018
922
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 271.07 KB | None | 0 0
raw download clone embed print report
  1. insert into branch (id, location, phone, fax, openingDate, managerId, serviceId) values (1, 'Cote Des Neiges',5148237115,180004563333,'1996-02-28',1,4);
  2. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (1, 'Branch Manager','Benyamin','1770 Joseph Manseau, Montreal Canada','1950-06-28',80000,'11benyamin@bank.com',5148888,Managment,1);
  3. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (2,'Financial Analyst','Adeline','9792 ADA CT, Ottawa–Gatineau, Ontario/Quebec','1962-07-26','106918','5adeline@bank.com',5140064429,'Banking',1);
  4. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (3,'Financial Analyst','Andrea','9357 BEACHMONT DR, Ottawa–Gatineau, Ontario/Quebec','2017-07-24','101390','168andrea@bank.com',5142784927,'Banking',1);
  5. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (4,'Financial Analyst','Eloise','1146 AUGUST ALY, Ottawa–Gatineau, Ontario/Quebec','1977-05-19','44017','260eloise@bank.com',5142044647,'Banking',1);
  6. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (5,'Financial Analyst','Ember','3576 BANNEKER WAY, Ottawa–Gatineau, Ontario/Quebec','1997-03-23','49164','163ember@bank.com',5146119119,'Banking',1);
  7. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (6,'Financial Analyst','Charlotte','1377 ALDER ST, Ottawa–Gatineau, Ontario/Quebec','2010-08-20','94874','132charlotte@bank.com',5141684140,'Banking',1);
  8. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (7,'Financial Analyst','Skyler','7272 AGNON AVE, Ottawa–Gatineau, Ontario/Quebec','2014-04-14','54111','122skyler@bank.com',5140695489,'Banking',1);
  9. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (8,'Financial Analyst','Nina','8942 APPAREL WAY, Ottawa–Gatineau, Ontario/Quebec','2008-11-13','45106','93nina@bank.com',5143473915,'Banking',1);
  10. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (9,'Financial Analyst','Helen','8150 CASTLE ST, Ottawa–Gatineau, Ontario/Quebec','1977-09-1','77475','99helen@bank.com',5146766543,'Banking',1);
  11. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (10,'Financial Analyst','Melanie','4516 05TH ST, Ottawa–Gatineau, Ontario/Quebec','2015-11-25','93606','56melanie@bank.com',5149311034,'Banking',1);
  12. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (11,'Financial Analyst','Morgan','6973 BURNS PL, Ottawa–Gatineau, Ontario/Quebec','1990-10-18','72349','119morgan@bank.com',5144805383,'Banking',1);
  13. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (12,'Bank Teller','Arabella','6879 ALADDIN TER, Ottawa–Gatineau, Ontario/Quebec','2009-11-28','63748','122arabella@bank.com',5145231098,'Banking',1);
  14. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (13,'Bank Teller','Addyson','8401 BONVIEW ST, Ottawa–Gatineau, Ontario/Quebec','1997-07-27','84229','250addyson@bank.com',5143172502,'Banking',1);
  15. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (14,'Bank Teller','Zuri','9517 11TH TI ST, Ottawa–Gatineau, Ontario/Quebec','1954-07-25','55306','172zuri@bank.com',5141119352,'Banking',1);
  16. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (15,'Bank Teller','Sloane','8590 BARTOL ST, Ottawa–Gatineau, Ontario/Quebec','2003-08-10','80453','9sloane@bank.com',5142071468,'Banking',1);
  17. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (16,'Bank Teller','Gemma','4061 BYRON CT, Ottawa–Gatineau, Ontario/Quebec','1953-10-11','90123','148gemma@bank.com',5141682718,'Banking',1);
  18. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (17,'Loan Officer','Arabella','6827 ALVORD ST, Ottawa–Gatineau, Ontario/Quebec','2008-11-13','56893','76arabella@bank.com',5140788839,'Banking',1);
  19. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (18,'Loan Officer','Sadie','5417 05TH TI ST, Ottawa–Gatineau, Ontario/Quebec','1955-03-23','82547','231sadie@bank.com',5149515172,'Banking',1);
  20. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (19,'Loan Officer','Kate','8185 40TH AVE, Ottawa–Gatineau, Ontario/Quebec','1960-10-2','110007','227kate@bank.com',5147544056,'Banking',1);
  21. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (20,'Loan Officer','Allison','2096 ALEMANY BLVD OFF RAMP, Ottawa–Gatineau, Ontario/Quebec','1951-01-12','73824','171allison@bank.com',5147857831,'Banking',1);
  22. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (21,'Loan Officer','Finley','8194 AVENUE F, Ottawa–Gatineau, Ontario/Quebec','1980-08-11','93500','38finley@bank.com',5145555832,'Banking',1);
  23. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (0,'Frances','15/11/1988','2001-12-11','7119 BELLA VISTA WAY, Ottawa–Gatineau, Ontario/Quebec','35frances@gmail.com',5145032366,'Banking',1,'password');
  24. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(1,0,'savings',2,1,1804560292);
  25. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(2,0,'savings',2,1,6366393873);
  26. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(3,0,'checking',1,1,3735611990);
  27. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (1,'Paislee','19/5/1963','1965-07-2','8942 CASCADE WALK, Ottawa–Gatineau, Ontario/Quebec','221paislee@gmail.com',5148353119,'Banking',1,'password');
  28. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(4,1,'checking',1,1,9825279920);
  29. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (2,'Regina','17/1/1907','2013-09-2','4240 21ST AVE, Ottawa–Gatineau, Ontario/Quebec','54regina@gmail.com',5149304336,'Banking',1,'password');
  30. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(5,2,'checking',1,2,1356750538);
  31. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(6,2,'checking',1,2,8665795334);
  32. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (3,'Athena','14/8/1994','1963-03-13','5679 BURLWOOD DR, Ottawa–Gatineau, Ontario/Quebec','135athena@gmail.com',5149768742,'Banking',1,'password');
  33. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(7,3,'checking',1,2,3729461637);
  34. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(8,3,'checking',1,2,288097097);
  35. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(9,3,'savings',2,2,6083966442);
  36. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (4,'Henley','11/4/1973','1981-02-8','7707 ANDERSON ST, Ottawa–Gatineau, Ontario/Quebec','209henley@gmail.com',5148546930,'Banking',1,'password');
  37. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(10,4,'checking',1,1,671493959);
  38. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(11,4,'savings',2,1,4302961414);
  39. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (5,'Eva','28/10/1929','1966-02-27','7185 CARR ST, Ottawa–Gatineau, Ontario/Quebec','183eva@gmail.com',5146596716,'Banking',1,'password');
  40. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(12,5,'checking',1,1,4999180017);
  41. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (6,'Remy','3/1/1950','1967-11-6','7619 10TH TI ST, Ottawa–Gatineau, Ontario/Quebec','6remy@gmail.com',5148743111,'Banking',1,'password');
  42. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (7,'Daphne','7/12/1955','1969-05-9','7682 17TH AVE, Ottawa–Gatineau, Ontario/Quebec','128daphne@gmail.com',5148150418,'Banking',1,'password');
  43. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (8,'Brielle','15/11/1948','1957-05-14','8368 14TH TI ST, Ottawa–Gatineau, Ontario/Quebec','105brielle@gmail.com',5144404283,'Banking',1,'password');
  44. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (9,'Lyric','10/9/1994','1975-11-25','952 07TH AVE, Ottawa–Gatineau, Ontario/Quebec','8lyric@gmail.com',5143504651,'Banking',1,'password');
  45. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(13,9,'savings',2,2,1765040798);
  46. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (10,'Lillie','24/5/1938','1973-06-14','6034 AMBER DR, Ottawa–Gatineau, Ontario/Quebec','113lillie@gmail.com',5141966011,'Banking',1,'password');
  47. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (11,'Zariyah','13/4/1905','1960-03-1','5112 CHAPMAN ST, Ottawa–Gatineau, Ontario/Quebec','48zariyah@gmail.com',5143123185,'Banking',1,'password');
  48. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(14,11,'checking',1,1,6743554979);
  49. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(15,11,'checking',1,1,8676863582);
  50. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (12,'Gwendolyn','29/2/1975','1964-03-23','8547 BRAZIL AVE, Ottawa–Gatineau, Ontario/Quebec','167gwendolyn@gmail.com',5142909343,'Banking',1,'password');
  51. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(16,12,'checking',1,1,2725869372);
  52. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(17,12,'checking',1,1,6373983682);
  53. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(18,12,'savings',2,1,2000748760);
  54. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (13,'Kenya','28/6/1995','1978-09-19','7939 CHARLTON CT, Ottawa–Gatineau, Ontario/Quebec','174kenya@gmail.com',5143086864,'Banking',1,'password');
  55. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(19,13,'checking',1,1,7880044888);
  56. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(20,13,'savings',2,1,301407858);
  57. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(21,13,'savings',2,1,7974670606);
  58. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (14,'Avery','15/6/1949','1960-06-18','9152 ACEVEDO AVE, Ottawa–Gatineau, Ontario/Quebec','60avery@gmail.com',5147818507,'Banking',1,'password');
  59. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(22,14,'checking',1,2,6227464497);
  60. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(23,14,'checking',1,2,6594185795);
  61. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (15,'Zara','14/3/1998','1985-09-4','4470 BECKETT ST, Ottawa–Gatineau, Ontario/Quebec','246zara@gmail.com',5146314305,'Banking',1,'password');
  62. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (16,'Adrienne','4/2/1976','1979-01-19','8679 40TH AVE, Ottawa–Gatineau, Ontario/Quebec','133adrienne@gmail.com',5142275779,'Banking',1,'password');
  63. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(24,16,'checking',1,2,6698958726);
  64. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (17,'Madelynn','21/6/1951','1986-09-8','714 BRANT ALY, Ottawa–Gatineau, Ontario/Quebec','145madelynn@gmail.com',5145462937,'Banking',1,'password');
  65. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(25,17,'checking',1,2,8411077041);
  66. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (18,'Anna','13/7/1921','1992-11-19','9286 AUBURN ST, Ottawa–Gatineau, Ontario/Quebec','257anna@gmail.com',5149358783,'Banking',1,'password');
  67. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(26,18,'checking',1,1,6658068581);
  68. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (19,'Lilyana','14/9/1922','1992-04-21','5246 BEVERLY ST, Ottawa–Gatineau, Ontario/Quebec','124lilyana@gmail.com',5148581925,'Banking',1,'password');
  69. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(27,19,'checking',1,2,6328823998);
  70. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(28,19,'savings',2,2,1327489290);
  71. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(29,19,'checking',1,2,362603950);
  72. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (20,'Kassidy','22/11/1975','2014-07-14','6887 26TH ST, Ottawa–Gatineau, Ontario/Quebec','60kassidy@gmail.com',5142757449,'Banking',1,'password');
  73. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (21,'Dalary','16/2/1933','2013-10-7','6860 BATTERY CRANSTON RD, Ottawa–Gatineau, Ontario/Quebec','191dalary@gmail.com',5142950523,'Banking',1,'password');
  74. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(30,21,'savings',2,1,3643464346);
  75. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(31,21,'savings',2,1,3032484120);
  76. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (22,'Ann','10/7/1944','1989-01-13','915 BURROWS ST, Ottawa–Gatineau, Ontario/Quebec','182ann@gmail.com',5148408183,'Banking',1,'password');
  77. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(32,22,'checking',1,2,5568134769);
  78. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(33,22,'savings',2,2,7321671531);
  79. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(34,22,'checking',1,2,604302052);
  80. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (23,'Ryann','2/10/1911','2015-10-16','9458 AVENUE H, Ottawa–Gatineau, Ontario/Quebec','6ryann@gmail.com',5140338551,'Banking',1,'password');
  81. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(35,23,'checking',1,1,6322333056);
  82. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(36,23,'checking',1,1,8191975464);
  83. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (24,'Marlee','24/12/1923','1973-07-5','5641 CHAVES AVE, Ottawa–Gatineau, Ontario/Quebec','177marlee@gmail.com',5141500151,'Banking',1,'password');
  84. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(37,24,'checking',1,2,8313841466);
  85. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(38,24,'checking',1,2,8752110545);
  86. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (25,'Yasmin','5/10/1953','1959-03-25','6458 CARPENTER CT, Ottawa–Gatineau, Ontario/Quebec','175yasmin@gmail.com',5143335915,'Banking',1,'password');
  87. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(39,25,'checking',1,2,1846490873);
  88. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(40,25,'savings',2,2,7514462622);
  89. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (26,'Sasha','23/5/1928','1952-09-17','7261 ARGONAUT AVE, Ottawa–Gatineau, Ontario/Quebec','13sasha@gmail.com',5148242931,'Banking',1,'password');
  90. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(41,26,'savings',2,2,85643199);
  91. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (27,'Tiana','30/2/1995','2013-11-28','7469 CARGO WAY, Ottawa–Gatineau, Ontario/Quebec','182tiana@gmail.com',5142530604,'Banking',1,'password');
  92. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(42,27,'checking',1,2,6827874112);
  93. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(43,27,'checking',1,2,8302491870);
  94. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(44,27,'savings',2,2,4360015483);
  95. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (28,'Sawyer','29/12/1939','1997-04-17','8173 BEULAH ST, Ottawa–Gatineau, Ontario/Quebec','115sawyer@gmail.com',5143303869,'Banking',1,'password');
  96. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(45,28,'checking',1,1,3560671870);
  97. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(46,28,'checking',1,1,3409483579);
  98. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(47,28,'checking',1,1,6406346356);
  99. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (29,'Nayeli','9/3/1999','1982-01-2','7655 CASTENADA AVE, Ottawa–Gatineau, Ontario/Quebec','205nayeli@gmail.com',5140251856,'Banking',1,'password');
  100. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (30,'Audrina','25/10/1955','1953-05-12','3581 BATTERY CAULFIELD RD, Ottawa–Gatineau, Ontario/Quebec','46audrina@gmail.com',5147438597,'Banking',1,'password');
  101. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(48,30,'savings',2,1,9398186551);
  102. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(49,30,'checking',1,1,5151723424);
  103. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(50,30,'savings',2,1,1864156126);
  104. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (31,'Allyson','2/7/1949','1983-12-20','7097 ANKENY ST, Ottawa–Gatineau, Ontario/Quebec','164allyson@gmail.com',5140801767,'Banking',1,'password');
  105. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(51,31,'checking',1,2,7207741295);
  106. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (32,'Kennedi','19/3/1977','1953-06-2','7567 ALEMANY BLVD, Ottawa–Gatineau, Ontario/Quebec','36kennedi@gmail.com',5145684140,'Banking',1,'password');
  107. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(52,32,'checking',1,1,9467321213);
  108. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(53,32,'checking',1,1,7137022069);
  109. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(54,32,'savings',2,1,7662948675);
  110. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (33,'Mariam','27/5/1933','1958-02-14','5663 BATTERY WAGNER RD, Ottawa–Gatineau, Ontario/Quebec','208mariam@gmail.com',5148985344,'Banking',1,'password');
  111. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (34,'Ximena','17/5/1902','1962-05-15','7990 12TH AVE, Ottawa–Gatineau, Ontario/Quebec','212ximena@gmail.com',5146242911,'Banking',1,'password');
  112. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (35,'Kyleigh','14/3/1919','1970-11-22','6334 ARGUELLO BLVD, Ottawa–Gatineau, Ontario/Quebec','59kyleigh@gmail.com',5143721763,'Banking',1,'password');
  113. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (36,'Maliah','17/2/1989','2008-08-10','5098 29TH AVE, Ottawa–Gatineau, Ontario/Quebec','0maliah@gmail.com',5144305841,'Banking',1,'password');
  114. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(55,36,'savings',2,1,4938658845);
  115. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(56,36,'checking',1,1,6286416710);
  116. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(57,36,'checking',1,1,7446508234);
  117. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (37,'Joy','26/1/1920','1994-08-28','6348 BISHOP ST, Ottawa–Gatineau, Ontario/Quebec','181joy@gmail.com',5145984657,'Banking',1,'password');
  118. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(58,37,'checking',1,2,5945252212);
  119. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (38,'Ana','13/10/1915','1957-01-17','4909 CANBY LN, Ottawa–Gatineau, Ontario/Quebec','268ana@gmail.com',5143999226,'Banking',1,'password');
  120. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(59,38,'savings',2,2,7607392121);
  121. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(60,38,'savings',2,2,6904448676);
  122. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(61,38,'savings',2,2,26644258);
  123. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (39,'Khaleesi','15/12/1965','1996-08-9','8665 01ST ST, Ottawa–Gatineau, Ontario/Quebec','255khaleesi@gmail.com',5147335058,'Banking',1,'password');
  124. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (40,'Halle','5/3/1955','1966-01-16','3739 BEALE ST, Ottawa–Gatineau, Ontario/Quebec','52halle@gmail.com',5140337854,'Banking',1,'password');
  125. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(62,40,'savings',2,1,7403935469);
  126. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (41,'Jasmin','26/10/1989','2011-05-8','1168 BATTERY CAULFIELD RD, Ottawa–Gatineau, Ontario/Quebec','187jasmin@gmail.com',5143546874,'Banking',1,'password');
  127. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(63,41,'savings',2,1,271480161);
  128. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(64,41,'checking',1,1,9670085594);
  129. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(65,41,'checking',1,1,845114322);
  130. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (42,'Elsie','26/10/1910','1960-01-21','1523 ALADDIN TER, Ottawa–Gatineau, Ontario/Quebec','47elsie@gmail.com',5142265662,'Banking',1,'password');
  131. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (43,'Alondra','11/7/1930','2005-08-18','1889 APTOS AVE, Ottawa–Gatineau, Ontario/Quebec','57alondra@gmail.com',5147357018,'Banking',1,'password');
  132. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(66,43,'savings',2,1,8753290024);
  133. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(67,43,'checking',1,1,5615529325);
  134. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(68,43,'checking',1,1,6062023960);
  135. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (44,'Wren','17/10/1923','2000-10-2','7592 ARKANSAS ST, Ottawa–Gatineau, Ontario/Quebec','100wren@gmail.com',5144772150,'Banking',1,'password');
  136. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (45,'Kailani','15/2/1910','1971-11-17','3739 ALABAMA ST, Ottawa–Gatineau, Ontario/Quebec','157kailani@gmail.com',5142392811,'Banking',1,'password');
  137. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(69,45,'checking',1,1,8300585478);
  138. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(70,45,'savings',2,1,9089334002);
  139. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (46,'Naya','8/8/1912','1963-11-12','8753 BANCROFT AVE, Ottawa–Gatineau, Ontario/Quebec','251naya@gmail.com',5148792686,'Banking',1,'password');
  140. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(71,46,'savings',2,1,9561857234);
  141. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (47,'Elisabeth','20/3/1992','1996-05-7','2043 BOARDMAN PL, Ottawa–Gatineau, Ontario/Quebec','39elisabeth@gmail.com',5143337619,'Banking',1,'password');
  142. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(72,47,'savings',2,2,5755904095);
  143. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(73,47,'savings',2,2,5416222672);
  144. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(74,47,'savings',2,2,9796962605);
  145. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (48,'Jessica','23/9/1921','1962-04-23','4780 ATOLL CIR, Ottawa–Gatineau, Ontario/Quebec','30jessica@gmail.com',5144805783,'Banking',1,'password');
  146. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(75,48,'checking',1,1,9621603190);
  147. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(76,48,'savings',2,1,4504455540);
  148. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (49,'Katelyn','2/8/1980','1993-01-18','9177 CANDLESTICK COVE WAY, Ottawa–Gatineau, Ontario/Quebec','13katelyn@gmail.com',5149429550,'Banking',1,'password');
  149. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(77,49,'checking',1,1,6178371944);
  150. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(78,49,'checking',1,1,4996938193);
  151. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(79,49,'checking',1,1,4134957922);
  152. insert into branch (id, location, phone, fax, openingDate, managerId, serviceId) values (2,'4740 01ST ST, Ottawa–Gatineau, Ontario/Quebec',5145175348,18001845940,'1996-02-28',22,1);
  153. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (22, 'Branch Manager','Emma','5566 01ST TI ST, Toronto, Ontario','1992-9-21',247662,'249emma@bank.com',5148160009,'Managment',2);
  154. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (23,'Financial Analyst','Violet','889 ASHTON AVE, Winnipeg, Manitoba','1995-08-7','91948','70violet@bank.com',5142143990,'Banking',2);
  155. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (24,'Financial Analyst','Kenzie','2379 BARNARD AVE, Winnipeg, Manitoba','2002-03-14','89840','96kenzie@bank.com',5140431254,'Banking',2);
  156. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (25,'Financial Analyst','Erin','6337 CHAPMAN ST, Winnipeg, Manitoba','2003-08-18','107735','168erin@bank.com',5149234572,'Banking',2);
  157. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (26,'Financial Analyst','Emma','9073 15TH AVE, Winnipeg, Manitoba','2012-05-2','101322','114emma@bank.com',5148827250,'Banking',2);
  158. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (27,'Financial Analyst','Brielle','2615 AMATISTA LN, Winnipeg, Manitoba','1996-05-19','43327','83brielle@bank.com',5149338809,'Banking',2);
  159. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (28,'Financial Analyst','Gabriela','8798 AVALON AVE, Winnipeg, Manitoba','1950-07-12','66683','46gabriela@bank.com',5146901460,'Banking',2);
  160. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (29,'Financial Analyst','Hadley','7944 ARROYO WAY, Winnipeg, Manitoba','1980-03-1','116060','131hadley@bank.com',5147078364,'Banking',2);
  161. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (30,'Financial Analyst','Leila','3259 ARLINGTON ST, Winnipeg, Manitoba','1964-01-4','79082','205leila@bank.com',5144180092,'Banking',2);
  162. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (31,'Financial Analyst','Isabella','1169 ARELLANO AVE, Winnipeg, Manitoba','2005-08-10','100099','189isabella@bank.com',5145188617,'Banking',2);
  163. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (32,'Financial Analyst','Kimberly','2942 CALEDONIA ST, Winnipeg, Manitoba','1953-09-18','116839','216kimberly@bank.com',5143907561,'Banking',2);
  164. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (33,'Bank Teller','Elsie','6344 ALABAMA ST, Winnipeg, Manitoba','2007-11-1','86432','261elsie@bank.com',5147170859,'Banking',2);
  165. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (34,'Bank Teller','Amina','7056 BROOKS ST, Winnipeg, Manitoba','1953-09-4','105507','57amina@bank.com',5147698136,'Banking',2);
  166. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (35,'Bank Teller','Sadie','2070 BEACHMONT DR, Winnipeg, Manitoba','2018-10-28','42775','116sadie@bank.com',5147212263,'Banking',2);
  167. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (36,'Bank Teller','Norah','4620 AVENUE C, Winnipeg, Manitoba','2005-07-14','62367','101norah@bank.com',5146198275,'Banking',2);
  168. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (37,'Bank Teller','Leslie','6459 BERRY EXTENSION ST, Winnipeg, Manitoba','2017-09-11','40009','65leslie@bank.com',5142343229,'Banking',2);
  169. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (38,'Loan Officer','Nayeli','8993 CANYON DR, Winnipeg, Manitoba','2002-07-2','62071','212nayeli@bank.com',5146985937,'Banking',2);
  170. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (39,'Loan Officer','Esther','4667 CANBY LN, Winnipeg, Manitoba','1966-04-8','54218','118esther@bank.com',5141385440,'Banking',2);
  171. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (40,'Loan Officer','Brianna','5745 ATTRIDGE ALY, Winnipeg, Manitoba','2003-12-28','104463','60brianna@bank.com',5142775808,'Banking',2);
  172. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (41,'Loan Officer','Kennedi','2503 06TH TI ST, Winnipeg, Manitoba','1979-03-28','76895','13kennedi@bank.com',5142401506,'Banking',2);
  173. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (42,'Loan Officer','Tessa','4823 BRAZIL AVE, Winnipeg, Manitoba','1951-05-22','65742','236tessa@bank.com',5142339351,'Banking',2);
  174. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (50,'Rosa','2/10/1916','1988-01-22','6022 BEVERLY ST, Winnipeg, Manitoba','235rosa@gmail.com',5148600553,'Banking',2,'password');
  175. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(80,50,'checking',1,1,4709647973);
  176. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (51,'Jayleen','28/10/1952','1953-07-27','3235 BURGOYNE ST, Winnipeg, Manitoba','150jayleen@gmail.com',5149415221,'Banking',2,'password');
  177. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(81,51,'checking',1,1,6403406305);
  178. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(82,51,'checking',1,1,6307483296);
  179. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (52,'Remi','26/8/1991','2009-02-9','7949 BELDEN ST, Winnipeg, Manitoba','24remi@gmail.com',5149135747,'Banking',2,'password');
  180. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (53,'Justice','28/2/1926','1983-03-28','2994 CAMPTON PL, Winnipeg, Manitoba','260justice@gmail.com',5148172396,'Banking',2,'password');
  181. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(83,53,'savings',2,1,6565272076);
  182. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (54,'Kristina','25/8/1951','2009-03-13','6035 ALOHA AVE, Winnipeg, Manitoba','83kristina@gmail.com',5144964575,'Banking',2,'password');
  183. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(84,54,'checking',1,2,5633021070);
  184. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (55,'Laura','16/3/1948','2017-02-27','7697 APTOS AVE, Winnipeg, Manitoba','4laura@gmail.com',5146128332,'Banking',2,'password');
  185. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(85,55,'savings',2,1,8897809303);
  186. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (56,'Celine','18/12/1967','2006-07-25','8462 AVERY ST, Winnipeg, Manitoba','109celine@gmail.com',5148695812,'Banking',2,'password');
  187. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(86,56,'savings',2,1,1561477717);
  188. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (57,'Antonella','11/12/1975','2007-12-11','7286 BRUSH PL, Winnipeg, Manitoba','94antonella@gmail.com',5142005604,'Banking',2,'password');
  189. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(87,57,'checking',1,1,7969437488);
  190. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(88,57,'investment',3,1,7840860587);
  191. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (58,'Meilani','19/2/1979','1959-06-26','2814 BROADMOOR DR, Winnipeg, Manitoba','255meilani@gmail.com',5146301463,'Banking',2,'password');
  192. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(89,58,'savings',2,2,2233315417);
  193. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(90,58,'checking',1,2,5152153534);
  194. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(91,58,'checking',1,2,5536888806);
  195. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (59,'Vanessa','5/7/1936','2010-03-25','8525 BURR AVE, Winnipeg, Manitoba','75vanessa@gmail.com',5147809125,'Banking',2,'password');
  196. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (60,'Kaelyn','5/10/1938','1958-12-27','2548 BATTERY CAULFIELD RD, Winnipeg, Manitoba','20kaelyn@gmail.com',5140255047,'Banking',2,'password');
  197. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (61,'Paulina','18/4/1972','1989-02-5','6608 13TH ST, Winnipeg, Manitoba','20paulina@gmail.com',5142717194,'Banking',2,'password');
  198. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(92,61,'investment',3,2,8380511699);
  199. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(93,61,'investment',3,2,4886392223);
  200. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(94,61,'savings',2,2,9409277023);
  201. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (62,'Yaretzi','18/7/1941','1969-09-25','3749 BORICA ST, Winnipeg, Manitoba','133yaretzi@gmail.com',5147601505,'Banking',2,'password');
  202. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(95,62,'investment',3,1,2066474183);
  203. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (63,'Nora','5/5/1978','1974-05-6','294 ALLEN ST, Winnipeg, Manitoba','155nora@gmail.com',5146070429,'Banking',2,'password');
  204. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(96,63,'checking',1,2,9604066762);
  205. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (64,'Kaelyn','29/12/1985','1999-06-27','9631 BRUSH LN, Winnipeg, Manitoba','62kaelyn@gmail.com',5144668497,'Banking',2,'password');
  206. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(97,64,'investment',3,1,7345829719);
  207. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(98,64,'savings',2,1,6157679520);
  208. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(99,64,'checking',1,1,3363750597);
  209. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (65,'Ember','1/2/1915','1967-02-15','5809 ASHBURY TER, Winnipeg, Manitoba','55ember@gmail.com',5146390475,'Banking',2,'password');
  210. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(100,65,'checking',1,2,9724661057);
  211. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (66,'Luciana','19/6/1984','2004-07-9','8128 CARSON ST, Winnipeg, Manitoba','0luciana@gmail.com',5145341924,'Banking',2,'password');
  212. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(101,66,'savings',2,2,6704902643);
  213. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (67,'Arianna','14/1/1937','1991-08-22','8581 ALAMEDA ST, Winnipeg, Manitoba','55arianna@gmail.com',5146205816,'Banking',2,'password');
  214. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (68,'Moriah','29/8/1979','2007-09-6','3238 13TH ST, Winnipeg, Manitoba','228moriah@gmail.com',5147687737,'Banking',2,'password');
  215. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(102,68,'checking',1,1,719742864);
  216. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (69,'Matilda','26/11/1969','1974-07-1','1161 CALHOUN TER, Winnipeg, Manitoba','22matilda@gmail.com',5143557178,'Banking',2,'password');
  217. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(103,69,'savings',2,1,4618671918);
  218. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (70,'Beatrice','26/9/1956','1961-06-13','1911 BURGOYNE ST, Winnipeg, Manitoba','154beatrice@gmail.com',5144470693,'Banking',2,'password');
  219. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(104,70,'checking',1,2,6952572709);
  220. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(105,70,'savings',2,2,9270829861);
  221. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(106,70,'checking',1,2,9236117042);
  222. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (71,'Nathaly','12/9/1916','1975-08-16','1848 CASTILLO ST, Winnipeg, Manitoba','19nathaly@gmail.com',5144188820,'Banking',2,'password');
  223. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(107,71,'savings',2,1,1950536041);
  224. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (72,'Brianna','9/9/1972','1997-12-26','5106 BARTOL ST, Winnipeg, Manitoba','202brianna@gmail.com',5145798932,'Banking',2,'password');
  225. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(108,72,'investment',3,1,151907739);
  226. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(109,72,'savings',2,1,1837140300);
  227. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(110,72,'investment',3,1,667478147);
  228. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (73,'Elaina','8/4/1903','2005-11-9','8956 CAMPBELL AVE, Winnipeg, Manitoba','26elaina@gmail.com',5142800933,'Banking',2,'password');
  229. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(111,73,'savings',2,2,4073088385);
  230. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (74,'Annabel','16/6/1960','2012-11-28','6028 24TH AVE, Winnipeg, Manitoba','6annabel@gmail.com',5147404883,'Banking',2,'password');
  231. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (75,'Leah','7/3/1940','2006-03-26','8197 05TH AVE, Winnipeg, Manitoba','113leah@gmail.com',5140039795,'Banking',2,'password');
  232. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(112,75,'savings',2,2,848658698);
  233. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(113,75,'investment',3,2,2810484304);
  234. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(114,75,'checking',1,2,3883087765);
  235. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (76,'Dallas','9/4/1992','2013-01-1','7815 BANBURY DR, Winnipeg, Manitoba','35dallas@gmail.com',5148447047,'Banking',2,'password');
  236. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (77,'Gemma','16/3/1917','2014-10-17','3306 CANDLESTICK COVE WAY, Winnipeg, Manitoba','93gemma@gmail.com',5146940717,'Banking',2,'password');
  237. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(115,77,'savings',2,2,2631234205);
  238. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(116,77,'savings',2,2,3153061957);
  239. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (78,'Aleah','23/1/1951','1952-01-21','3192 CATHERINE CT, Winnipeg, Manitoba','79aleah@gmail.com',5142226943,'Banking',2,'password');
  240. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(117,78,'investment',3,1,584991640);
  241. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(118,78,'savings',2,1,9130260568);
  242. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(119,78,'investment',3,1,5225379612);
  243. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (79,'Celine','30/1/1916','2012-08-3','236 CARNELIAN WAY, Winnipeg, Manitoba','252celine@gmail.com',5148502663,'Banking',2,'password');
  244. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(120,79,'savings',2,1,2829203401);
  245. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(121,79,'savings',2,1,873121888);
  246. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (80,'Ariah','16/4/1957','1956-11-10','5830 AGUA WAY, Winnipeg, Manitoba','170ariah@gmail.com',5149427960,'Banking',2,'password');
  247. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (81,'Macy','13/3/1901','2011-04-21','3043 BURGOYNE ST, Winnipeg, Manitoba','67macy@gmail.com',5148051491,'Banking',2,'password');
  248. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(122,81,'investment',3,2,2083432213);
  249. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(123,81,'investment',3,2,2066235565);
  250. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (82,'Emily','28/7/1932','1999-02-28','4048 CARL ST, Winnipeg, Manitoba','10emily@gmail.com',5148788028,'Banking',2,'password');
  251. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(124,82,'investment',3,1,760332116);
  252. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (83,'Joslyn','3/9/1954','2012-08-18','3358 17TH ST, Winnipeg, Manitoba','124joslyn@gmail.com',5144304242,'Banking',2,'password');
  253. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(125,83,'investment',3,1,7545650605);
  254. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (84,'Gabriella','30/7/1948','1954-03-12','2500 BIRMINGHAM RD, Winnipeg, Manitoba','82gabriella@gmail.com',5147707111,'Banking',2,'password');
  255. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(126,84,'savings',2,2,5095747847);
  256. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(127,84,'checking',1,2,5057040255);
  257. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(128,84,'investment',3,2,4169665627);
  258. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (85,'Mackenzie','17/10/1996','1961-01-2','497 BLISS CT, Winnipeg, Manitoba','202mackenzie@gmail.com',5147223425,'Banking',2,'password');
  259. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(129,85,'investment',3,2,4569670052);
  260. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (86,'Lily','8/12/1994','1973-07-21','2474 BESSIE ST, Winnipeg, Manitoba','225lily@gmail.com',5142141024,'Banking',2,'password');
  261. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(130,86,'savings',2,1,5251497264);
  262. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (87,'Naomi','28/5/1900','1986-11-28','6677 46TH AVE, Winnipeg, Manitoba','7naomi@gmail.com',5140440346,'Banking',2,'password');
  263. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(131,87,'savings',2,1,2032226883);
  264. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (88,'Jessica','27/7/1927','1960-05-23','8127 CASTLE MANOR AVE, Winnipeg, Manitoba','156jessica@gmail.com',5144453146,'Banking',2,'password');
  265. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(132,88,'investment',3,1,410601263);
  266. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (89,'Angie','15/11/1976','1995-02-23','4009 BASS CT, Winnipeg, Manitoba','90angie@gmail.com',5146902390,'Banking',2,'password');
  267. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(133,89,'investment',3,1,9398096353);
  268. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (90,'Annabel','12/2/1918','1950-12-19','1405 BAY SHORE BLVD OFF RAMP, Winnipeg, Manitoba','206annabel@gmail.com',5146734509,'Banking',2,'password');
  269. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (91,'Briar','12/8/1970','2013-03-16','5830 BANCROFT AVE, Winnipeg, Manitoba','105briar@gmail.com',5141807525,'Banking',2,'password');
  270. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(134,91,'checking',1,1,5347332922);
  271. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(135,91,'savings',2,1,5684924521);
  272. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(136,91,'savings',2,1,1108800271);
  273. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (92,'Emmie','28/10/1984','2018-12-27','3065 CEDRO AVE, Winnipeg, Manitoba','58emmie@gmail.com',5146927097,'Banking',2,'password');
  274. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(137,92,'investment',3,2,1428721892);
  275. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (93,'Itzel','26/11/1954','1951-12-13','1728 23RD AVE, Winnipeg, Manitoba','63itzel@gmail.com',5141243227,'Banking',2,'password');
  276. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(138,93,'savings',2,1,2938292870);
  277. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(139,93,'checking',1,1,8173914166);
  278. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(140,93,'investment',3,1,2051044797);
  279. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (94,'Mikayla','27/3/1905','1979-06-1','4389 BREEN PL, Winnipeg, Manitoba','31mikayla@gmail.com',5145269438,'Banking',2,'password');
  280. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(141,94,'checking',1,1,1241466049);
  281. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(142,94,'investment',3,1,1762120493);
  282. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (95,'Emmie','26/9/1935','1993-05-27','8846 BROMLEY PL, Winnipeg, Manitoba','99emmie@gmail.com',5145071161,'Banking',2,'password');
  283. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(143,95,'savings',2,1,5065491274);
  284. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (96,'Makayla','25/10/1939','1979-03-23','437 BEACON ST, Winnipeg, Manitoba','245makayla@gmail.com',5141389834,'Banking',2,'password');
  285. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(144,96,'checking',1,1,3251252551);
  286. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(145,96,'savings',2,1,2314031057);
  287. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (97,'Azalea','26/5/1993','2012-06-2','3180 BANNOCK ST, Winnipeg, Manitoba','221azalea@gmail.com',5143164050,'Banking',2,'password');
  288. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (98,'Rosalyn','14/3/1965','2006-02-1','7347 22ND AVE, Winnipeg, Manitoba','257rosalyn@gmail.com',5148582554,'Banking',2,'password');
  289. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(146,98,'checking',1,2,1567106590);
  290. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(147,98,'checking',1,2,6034406375);
  291. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (99,'Bella','12/1/1993','2014-01-5','7695 A ST, Winnipeg, Manitoba','172bella@gmail.com',5144966893,'Banking',2,'password');
  292. insert into branch (id, location, phone, fax, openingDate, managerId, serviceId) values (3,'2437 02ND AVE, Winnipeg, Manitoba',5141543306,18004177957,'1996-02-28',43,4);
  293. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (43, 'Branch Manager','Olivia','5 02ND ST, Montreal, Quebec','1979-7-12',162294,'39olivia@bank.com',5146082851,'Managment',3);
  294. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (44,'Financial Analyst','Elizabeth','2885 ANGLO ALY, Edmonton, Alberta','2009-08-23','57575','50elizabeth@bank.com',5147998657,'Banking',3);
  295. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (45,'Financial Analyst','Ella','6993 CHARLTON CT, Edmonton, Alberta','1964-05-8','116584','257ella@bank.com',5147535880,'Banking',3);
  296. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (46,'Financial Analyst','Adeline','1810 BARCELONA AVE, Edmonton, Alberta','2000-02-5','61116','171adeline@bank.com',5140856035,'Banking',3);
  297. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (47,'Financial Analyst','Chelsea','8291 CASITAS AVE, Edmonton, Alberta','1971-04-13','46360','59chelsea@bank.com',5140996672,'Banking',3);
  298. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (48,'Financial Analyst','Nadia','7558 22ND ST, Edmonton, Alberta','1981-04-13','107737','84nadia@bank.com',5142479943,'Banking',3);
  299. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (49,'Financial Analyst','Dakota','6494 BROSNAN ST, Edmonton, Alberta','1960-09-5','79202','247dakota@bank.com',5142429570,'Banking',3);
  300. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (50,'Financial Analyst','Ayla','3480 ALLISON ST, Edmonton, Alberta','2015-01-4','106221','50ayla@bank.com',5145216491,'Banking',3);
  301. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (51,'Financial Analyst','Helen','7298 AGUA WAY, Edmonton, Alberta','1951-07-11','56319','251helen@bank.com',5140501619,'Banking',3);
  302. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (52,'Financial Analyst','Marley','8687 28TH ST, Edmonton, Alberta','1952-09-2','90883','79marley@bank.com',5148357125,'Banking',3);
  303. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (53,'Financial Analyst','Kylee','5033 09TH AVE, Edmonton, Alberta','2004-02-14','43048','207kylee@bank.com',5146014709,'Banking',3);
  304. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (54,'Bank Teller','Angelina','7544 BUCARELI DR, Edmonton, Alberta','1968-03-11','105607','177angelina@bank.com',5143348352,'Banking',3);
  305. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (55,'Bank Teller','Kira','4267 05TH ST, Edmonton, Alberta','1994-10-16','101683','193kira@bank.com',5147513984,'Banking',3);
  306. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (56,'Bank Teller','Nova','6333 13TH ST, Edmonton, Alberta','1953-04-27','107005','115nova@bank.com',5145914585,'Banking',3);
  307. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (57,'Bank Teller','Lorelei','269 CANBY ST, Edmonton, Alberta','1979-10-26','81572','86lorelei@bank.com',5148851875,'Banking',3);
  308. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (58,'Bank Teller','Genevieve','5121 CATHERINE CT, Edmonton, Alberta','1964-02-26','47792','212genevieve@bank.com',5140631000,'Banking',3);
  309. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (59,'Loan Officer','Daniela','7369 ARCO WAY, Edmonton, Alberta','1951-01-18','105966','232daniela@bank.com',5140700719,'Banking',3);
  310. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (60,'Loan Officer','Kaia','2714 BALANCE ST, Edmonton, Alberta','1992-11-25','114347','14kaia@bank.com',5144795578,'Banking',3);
  311. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (61,'Loan Officer','Jade','6446 ABBEY ST, Edmonton, Alberta','2002-06-24','72531','89jade@bank.com',5141935219,'Banking',3);
  312. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (62,'Loan Officer','Annie','1122 41ST AVE, Edmonton, Alberta','1962-10-28','110730','214annie@bank.com',5146158159,'Banking',3);
  313. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (63,'Loan Officer','Genevieve','9742 CERRITOS AVE, Edmonton, Alberta','2012-04-20','47398','20genevieve@bank.com',5140286957,'Banking',3);
  314. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (100,'Galilea','11/10/1942','2013-06-14','6826 CAMPUS LN, Edmonton, Alberta','225galilea@gmail.com',5142265171,'Banking',3,'password');
  315. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (101,'Lauryn','9/9/1974','1974-02-3','2441 08TH AVE, Edmonton, Alberta','8lauryn@gmail.com',5144766614,'Banking',3,'password');
  316. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (102,'Elisa','26/2/1913','1958-02-12','8706 37TH AVE, Edmonton, Alberta','142elisa@gmail.com',5142337941,'Banking',3,'password');
  317. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(148,102,'investment',3,1,3483432110);
  318. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(149,102,'savings',2,1,3535330468);
  319. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(150,102,'savings',2,1,1511365011);
  320. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (103,'Rose','14/1/1945','1962-08-9','3499 ALADDIN TER, Edmonton, Alberta','74rose@gmail.com',5145438349,'Banking',3,'password');
  321. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(151,103,'savings',2,1,1686596829);
  322. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (104,'Hadlee','4/5/1924','2001-10-18','1112 BATTERY SAFFORD RD, Edmonton, Alberta','40hadlee@gmail.com',5148245851,'Banking',3,'password');
  323. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (105,'Veda','18/7/1953','1998-01-8','2081 CHARLTON CT, Edmonton, Alberta','132veda@gmail.com',5148621665,'Banking',3,'password');
  324. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(152,105,'investment',3,2,8157114610);
  325. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (106,'Ryann','24/8/1947','1993-02-3','3772 CESAR CHAVEZ ST, Edmonton, Alberta','240ryann@gmail.com',5145601909,'Banking',3,'password');
  326. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(153,106,'savings',2,1,1152653030);
  327. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(154,106,'investment',3,1,8340782651);
  328. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(155,106,'checking',1,1,5921088484);
  329. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (107,'Natalie','7/11/1905','2015-01-25','1674 BANNOCK ST, Edmonton, Alberta','124natalie@gmail.com',5142870805,'Banking',3,'password');
  330. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(156,107,'savings',2,2,7417094414);
  331. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(157,107,'savings',2,2,707402870);
  332. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(158,107,'investment',3,2,7177248163);
  333. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (108,'Lizbeth','2/1/1929','1955-02-4','5045 ARDENWOOD WAY, Edmonton, Alberta','174lizbeth@gmail.com',5143881253,'Banking',3,'password');
  334. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(159,108,'investment',3,1,573849162);
  335. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(160,108,'savings',2,1,5826385722);
  336. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(161,108,'checking',1,1,1334210422);
  337. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (109,'Kinley','7/9/1969','1974-03-12','1767 29TH ST, Edmonton, Alberta','27kinley@gmail.com',5148413330,'Banking',3,'password');
  338. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(162,109,'savings',2,1,9279018697);
  339. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (110,'Carla','29/6/1971','1978-06-10','4119 AHERN WAY, Edmonton, Alberta','101carla@gmail.com',5147750959,'Banking',3,'password');
  340. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(163,110,'investment',3,1,854416591);
  341. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (111,'Lexi','17/4/1923','1993-04-24','553 BAY SHORE BLVD, Edmonton, Alberta','179lexi@gmail.com',5143893678,'Banking',3,'password');
  342. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(164,111,'savings',2,1,3418082215);
  343. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (112,'Emmaline','11/6/1918','1964-01-3','8167 AMITY ALY, Edmonton, Alberta','114emmaline@gmail.com',5145413888,'Banking',3,'password');
  344. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(165,112,'checking',1,2,9643870600);
  345. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (113,'Brooklynn','19/2/1969','2010-10-11','314 ANTONIO ST, Edmonton, Alberta','30brooklynn@gmail.com',5148796995,'Banking',3,'password');
  346. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(166,113,'savings',2,2,3443393344);
  347. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(167,113,'checking',1,2,2094377362);
  348. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (114,'Adalyn','14/12/1943','1994-06-13','957 01ST TI ST, Edmonton, Alberta','131adalyn@gmail.com',5141859521,'Banking',3,'password');
  349. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(168,114,'investment',3,2,2098328340);
  350. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (115,'Jennifer','8/7/1905','1957-12-23','9830 APPLETON AVE, Edmonton, Alberta','151jennifer@gmail.com',5140747170,'Banking',3,'password');
  351. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (116,'Clara','25/7/1923','2000-03-22','2879 AHERN WAY, Edmonton, Alberta','32clara@gmail.com',5142244185,'Banking',3,'password');
  352. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (117,'Ariah','28/8/1981','1999-09-22','9828 BURNSIDE AVE, Edmonton, Alberta','66ariah@gmail.com',5145656976,'Banking',3,'password');
  353. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(169,117,'investment',3,1,6680639982);
  354. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(170,117,'investment',3,1,3644744408);
  355. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(171,117,'checking',1,1,5417501955);
  356. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (118,'Royal','19/2/1942','1951-07-17','3430 BATTERY CHAMBERLIN RD, Edmonton, Alberta','258royal@gmail.com',5144096190,'Banking',3,'password');
  357. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (119,'Paityn','30/11/1914','1968-09-1','286 12TH ST, Edmonton, Alberta','91paityn@gmail.com',5146958821,'Banking',3,'password');
  358. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(172,119,'checking',1,2,6847966428);
  359. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(173,119,'savings',2,2,2192791234);
  360. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (120,'Iris','17/1/1965','2015-01-27','7256 CASTLE MANOR AVE, Edmonton, Alberta','53iris@gmail.com',5146903304,'Banking',3,'password');
  361. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(174,120,'checking',1,1,8523204488);
  362. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(175,120,'checking',1,1,2032112697);
  363. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (121,'Ada','5/4/1996','2003-12-21','7961 ALTA ST, Edmonton, Alberta','88ada@gmail.com',5146658714,'Banking',3,'password');
  364. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (122,'Macy','4/1/1967','1974-02-13','7916 07TH AVE, Edmonton, Alberta','243macy@gmail.com',5146748950,'Banking',3,'password');
  365. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(176,122,'savings',2,2,4913657770);
  366. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(177,122,'checking',1,2,3767860132);
  367. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (123,'Chloe','16/8/1982','1955-04-5','9994 BERNAL HEIGHTS BLVD, Edmonton, Alberta','144chloe@gmail.com',5146269283,'Banking',3,'password');
  368. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(178,123,'investment',3,1,1832939256);
  369. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(179,123,'investment',3,1,2415146966);
  370. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (124,'Kayla','15/11/1923','1975-05-27','1309 ANGELOS ALY, Edmonton, Alberta','22kayla@gmail.com',5145514571,'Banking',3,'password');
  371. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (125,'Emma','26/8/1956','2010-06-16','2711 BERTIE MINOR LN, Edmonton, Alberta','159emma@gmail.com',5143657387,'Banking',3,'password');
  372. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(180,125,'savings',2,1,9284650263);
  373. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(181,125,'investment',3,1,6767540653);
  374. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (126,'Camilla','19/1/1916','1990-02-26','6503 BURR AVE, Edmonton, Alberta','234camilla@gmail.com',5141364115,'Banking',3,'password');
  375. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (127,'Jordyn','4/7/1924','1974-12-3','1511 BRADFORD ST, Edmonton, Alberta','218jordyn@gmail.com',5143800174,'Banking',3,'password');
  376. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (128,'Nadia','28/3/1906','1968-11-15','2465 CHARLES ST, Edmonton, Alberta','166nadia@gmail.com',5149126214,'Banking',3,'password');
  377. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(182,128,'savings',2,1,8261951467);
  378. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(183,128,'investment',3,1,270256238);
  379. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (129,'Imani','11/3/1989','1997-02-8','7588 ANZA ST, Edmonton, Alberta','234imani@gmail.com',5149511781,'Banking',3,'password');
  380. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(184,129,'checking',1,2,4246469889);
  381. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (130,'Keyla','23/9/1900','1993-06-17','9927 ALAMEDA ST, Edmonton, Alberta','209keyla@gmail.com',5148479469,'Banking',3,'password');
  382. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(185,130,'savings',2,2,6958594267);
  383. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(186,130,'savings',2,2,1255914466);
  384. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (131,'Sariyah','12/7/1973','2011-07-8','4234 BAY ST, Edmonton, Alberta','204sariyah@gmail.com',5146442288,'Banking',3,'password');
  385. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(187,131,'investment',3,2,2163492506);
  386. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(188,131,'checking',1,2,682876457);
  387. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (132,'Daniella','17/9/1964','1984-08-27','9439 CARGO WAY, Edmonton, Alberta','117daniella@gmail.com',5149686612,'Banking',3,'password');
  388. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(189,132,'savings',2,1,7275249217);
  389. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (133,'Cara','7/1/1930','2018-01-3','5844 BYRON CT, Edmonton, Alberta','150cara@gmail.com',5142552718,'Banking',3,'password');
  390. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(190,133,'checking',1,1,3212894103);
  391. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(191,133,'checking',1,1,4570593984);
  392. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (134,'Harper','9/9/1967','1959-10-24','3532 ARGENT ALY, Edmonton, Alberta','48harper@gmail.com',5148381749,'Banking',3,'password');
  393. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (135,'Jimena','2/9/1914','1961-06-17','1012 AMATISTA LN, Edmonton, Alberta','34jimena@gmail.com',5141276314,'Banking',3,'password');
  394. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(192,135,'checking',1,1,7492060418);
  395. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (136,'Kendall','3/6/1992','1986-04-17','2004 BERTHA LN, Edmonton, Alberta','163kendall@gmail.com',5141237595,'Banking',3,'password');
  396. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(193,136,'savings',2,1,9491375444);
  397. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(194,136,'checking',1,1,2455601393);
  398. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (137,'Maya','1/5/1908','2015-01-22','2337 09TH AVE, Edmonton, Alberta','34maya@gmail.com',5147634423,'Banking',3,'password');
  399. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(195,137,'checking',1,1,7248040982);
  400. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (138,'Arya','20/7/1995','1979-09-15','7923 06TH TI ST, Edmonton, Alberta','9arya@gmail.com',5147746873,'Banking',3,'password');
  401. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(196,138,'investment',3,1,2519197126);
  402. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(197,138,'savings',2,1,9170083594);
  403. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(198,138,'investment',3,1,5291149232);
  404. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (139,'Rylie','26/9/1979','1993-04-7','9489 CARRIZAL ST, Edmonton, Alberta','161rylie@gmail.com',5148597464,'Banking',3,'password');
  405. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(199,139,'checking',1,1,3133807738);
  406. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(200,139,'savings',2,1,5404018629);
  407. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (140,'Ariah','2/1/1906','2014-03-17','6902 37TH AVE, Edmonton, Alberta','15ariah@gmail.com',5145910236,'Banking',3,'password');
  408. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(201,140,'investment',3,2,1188587175);
  409. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(202,140,'investment',3,2,5562877453);
  410. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(203,140,'savings',2,2,5500663279);
  411. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (141,'Montserrat','17/10/1918','1997-04-10','9839 CANBY ST, Edmonton, Alberta','231montserrat@gmail.com',5141829489,'Banking',3,'password');
  412. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (142,'Millie','30/8/1966','1953-09-6','7106 31ST AVE, Edmonton, Alberta','249millie@gmail.com',5143607935,'Banking',3,'password');
  413. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(204,142,'checking',1,1,5575918468);
  414. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(205,142,'investment',3,1,5318068407);
  415. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(206,142,'investment',3,1,9240892366);
  416. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (143,'Trinity','2/6/1984','2017-02-1','9359 15TH AVE, Edmonton, Alberta','220trinity@gmail.com',5141266810,'Banking',3,'password');
  417. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(207,143,'investment',3,2,9938240037);
  418. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(208,143,'savings',2,2,1417334181);
  419. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(209,143,'checking',1,2,5939240551);
  420. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (144,'Mercy','17/3/1964','2000-03-27','96 ADDISON ST, Edmonton, Alberta','264mercy@gmail.com',5148011749,'Banking',3,'password');
  421. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(210,144,'checking',1,1,2183891353);
  422. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(211,144,'checking',1,1,6657557303);
  423. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(212,144,'checking',1,1,1957229047);
  424. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (145,'Lindsey','15/5/1989','2007-07-15','1224 BURRITT ST, Edmonton, Alberta','143lindsey@gmail.com',5148091144,'Banking',3,'password');
  425. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(213,145,'investment',3,2,2241836334);
  426. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (146,'Rose','2/3/1971','2013-08-11','2180 ALEMANY BLVD, Edmonton, Alberta','238rose@gmail.com',5145540380,'Banking',3,'password');
  427. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (147,'Melissa','25/2/1929','2010-12-16','1369 BRUNSWICK ST, Edmonton, Alberta','153melissa@gmail.com',5147655045,'Banking',3,'password');
  428. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(214,147,'investment',3,1,8608289908);
  429. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(215,147,'savings',2,1,9013179657);
  430. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(216,147,'savings',2,1,4176613415);
  431. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (148,'Alani','25/2/1912','1986-12-12','1509 BERTIE MINOR LN, Edmonton, Alberta','145alani@gmail.com',5141323720,'Banking',3,'password');
  432. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(217,148,'investment',3,1,5198825559);
  433. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (149,'Melody','9/4/1989','1967-08-20','6942 BRENTWOOD AVE, Edmonton, Alberta','40melody@gmail.com',5147868664,'Banking',3,'password');
  434. insert into branch (id, location, phone, fax, openingDate, managerId, serviceId) values (4,'9197 02ND TI ST, Edmonton, Alberta',5143317328,18009280482,'1996-02-28',64,2);
  435. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (64, 'Branch Manager','Ava','7721 03RD AVE, Vancouver, British Columbia','2002-6-15',228761,'157ava@bank.com',5142499904,'Managment',4);
  436. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (65,'Financial Analyst','Mila','6731 CARRIE ST, Vancouver, British Columbia','1987-02-1','55366','66mila@bank.com',5142111771,'Banking',4);
  437. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (66,'Financial Analyst','Alexia','9735 BERGEN ALY, Vancouver, British Columbia','1984-11-15','112249','59alexia@bank.com',5147343723,'Banking',4);
  438. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (67,'Financial Analyst','Janelle','3964 ARLINGTON ST, Vancouver, British Columbia','2001-12-16','70571','97janelle@bank.com',5143881011,'Banking',4);
  439. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (68,'Financial Analyst','Kara','304 BOUTWELL ST, Vancouver, British Columbia','1990-02-27','106839','153kara@bank.com',5146105204,'Banking',4);
  440. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (69,'Financial Analyst','Adelynn','3326 BELLE AVE, Vancouver, British Columbia','1972-11-26','94193','12adelynn@bank.com',5142704673,'Banking',4);
  441. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (70,'Financial Analyst','Anastasia','552 ARGONAUT AVE, Vancouver, British Columbia','1955-01-14','108809','218anastasia@bank.com',5147956438,'Banking',4);
  442. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (71,'Financial Analyst','Malaysia','9375 BURROWS DR, Vancouver, British Columbia','1997-12-12','55090','114malaysia@bank.com',5141873676,'Banking',4);
  443. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (72,'Financial Analyst','Norah','1889 ADELE CT, Vancouver, British Columbia','2013-03-27','50584','22norah@bank.com',5143921336,'Banking',4);
  444. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (73,'Financial Analyst','Allison','3348 BROOKLYN PL, Vancouver, British Columbia','1967-10-26','62041','159allison@bank.com',5141921386,'Banking',4);
  445. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (74,'Financial Analyst','Kamryn','1293 CANBY LN, Vancouver, British Columbia','1978-02-21','114744','15kamryn@bank.com',5144826478,'Banking',4);
  446. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (75,'Bank Teller','Margot','5646 05TH AVE, Vancouver, British Columbia','1974-01-16','49246','84margot@bank.com',5146101705,'Banking',4);
  447. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (76,'Bank Teller','Makayla','7988 BELLEVUE AVE, Vancouver, British Columbia','1966-10-3','112579','101makayla@bank.com',5142975290,'Banking',4);
  448. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (77,'Bank Teller','Faith','6199 BOCANA ST, Vancouver, British Columbia','2008-03-8','101261','97faith@bank.com',5145430326,'Banking',4);
  449. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (78,'Bank Teller','Camille','5167 07TH AVE, Vancouver, British Columbia','1991-05-5','57334','104camille@bank.com',5143627324,'Banking',4);
  450. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (79,'Bank Teller','Izabella','3118 ATALAYA TER, Vancouver, British Columbia','1967-04-23','56937','9izabella@bank.com',5142542973,'Banking',4);
  451. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (80,'Loan Officer','Ariyah','1731 BRYANT ST, Vancouver, British Columbia','2017-04-13','69447','142ariyah@bank.com',5143536367,'Banking',4);
  452. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (81,'Loan Officer','Faith','7278 AVENUE H, Vancouver, British Columbia','1983-03-28','97928','100faith@bank.com',5148957176,'Banking',4);
  453. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (82,'Loan Officer','Amari','6933 16TH AVE, Vancouver, British Columbia','2016-02-19','64371','108amari@bank.com',5141566349,'Banking',4);
  454. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (83,'Loan Officer','Presley','7133 ANNAPOLIS TER, Vancouver, British Columbia','1961-04-28','72983','29presley@bank.com',5148264731,'Banking',4);
  455. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (84,'Loan Officer','Stephanie','7490 CASTLE MANOR AVE, Vancouver, British Columbia','2017-08-12','51418','247stephanie@bank.com',5141356411,'Banking',4);
  456. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (150,'Davina','9/3/1987','2000-08-11','5108 ALEMANY BLVD, Vancouver, British Columbia','145davina@gmail.com',5141210450,'Banking',4,'password');
  457. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(218,150,'checking',1,2,8903840898);
  458. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(219,150,'savings',2,2,9329570666);
  459. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (151,'Paityn','22/2/1923','1980-06-15','8791 BEAVER ST, Vancouver, British Columbia','248paityn@gmail.com',5143638231,'Banking',4,'password');
  460. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(220,151,'savings',2,2,198307442);
  461. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(221,151,'savings',2,2,8888491797);
  462. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(222,151,'checking',1,2,2637058197);
  463. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (152,'Mikayla','28/10/1980','2015-10-27','9096 BERNAL HEIGHTS BLVD, Vancouver, British Columbia','220mikayla@gmail.com',5145956853,'Banking',4,'password');
  464. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(223,152,'checking',1,1,8350082312);
  465. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(224,152,'savings',2,1,4047034696);
  466. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(225,152,'savings',2,1,7225418233);
  467. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (153,'Luna','30/11/1950','1977-10-24','8775 BAY VIEW ST, Vancouver, British Columbia','266luna@gmail.com',5141514122,'Banking',4,'password');
  468. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(226,153,'savings',2,2,8077252606);
  469. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (154,'Dahlia','27/12/1963','1980-12-28','6392 BERNICE RODGERS WAY, Vancouver, British Columbia','32dahlia@gmail.com',5149621199,'Banking',4,'password');
  470. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(227,154,'checking',1,2,666174951);
  471. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(228,154,'checking',1,2,5398234998);
  472. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(229,154,'checking',1,2,4139672082);
  473. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (155,'Crystal','1/5/1950','2017-02-5','6255 43RD AVE, Vancouver, British Columbia','163crystal@gmail.com',5144906918,'Banking',4,'password');
  474. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(230,155,'savings',2,2,7659902159);
  475. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(231,155,'savings',2,2,4225882792);
  476. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (156,'Alisha','2/9/1982','2015-04-7','676 07TH AVE, Vancouver, British Columbia','91alisha@gmail.com',5142073083,'Banking',4,'password');
  477. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(232,156,'checking',1,1,4303111331);
  478. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(233,156,'checking',1,1,7164511179);
  479. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (157,'Sloane','26/10/1967','1957-02-4','3560 AMBROSE BIERCE ST, Vancouver, British Columbia','211sloane@gmail.com',5147982572,'Banking',4,'password');
  480. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(234,157,'checking',1,2,8168132698);
  481. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(235,157,'savings',2,2,5708496867);
  482. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (158,'Sierra','17/12/1995','1966-01-23','4233 CAPITOL AVE, Vancouver, British Columbia','84sierra@gmail.com',5141048565,'Banking',4,'password');
  483. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (159,'Azaria','28/2/1918','1973-05-19','2752 AVON WAY, Vancouver, British Columbia','158azaria@gmail.com',5149355361,'Banking',4,'password');
  484. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(236,159,'savings',2,1,7771270056);
  485. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(237,159,'checking',1,1,9575015356);
  486. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (160,'Brynlee','1/1/1920','2009-03-14','7337 CABRILLO ST, Vancouver, British Columbia','124brynlee@gmail.com',5144592923,'Banking',4,'password');
  487. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (161,'Cheyenne','28/7/1963','2006-11-10','7685 BERTHA LN, Vancouver, British Columbia','23cheyenne@gmail.com',5147961228,'Banking',4,'password');
  488. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(238,161,'savings',2,2,737153371);
  489. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (162,'Dana','21/4/1912','1971-05-10','5013 30TH ST, Vancouver, British Columbia','107dana@gmail.com',5148444429,'Banking',4,'password');
  490. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(239,162,'savings',2,1,3958136078);
  491. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(240,162,'checking',1,1,5653314036);
  492. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(241,162,'checking',1,1,100432479);
  493. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (163,'Lucia','24/7/1966','1955-09-17','8267 CAPITOL AVE, Vancouver, British Columbia','259lucia@gmail.com',5142430579,'Banking',4,'password');
  494. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (164,'Taylor','11/12/1902','1971-05-13','1365 09TH AVE, Vancouver, British Columbia','109taylor@gmail.com',5148113105,'Banking',4,'password');
  495. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (165,'Makenna','7/11/1957','1959-07-5','6821 BOSWORTH ST, Vancouver, British Columbia','151makenna@gmail.com',5141503828,'Banking',4,'password');
  496. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(242,165,'checking',1,2,4247323459);
  497. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(243,165,'checking',1,2,1437713984);
  498. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(244,165,'savings',2,2,3794789836);
  499. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (166,'Giovanna','22/2/1907','1951-04-24','669 BATTERY CAULFIELD RD, Vancouver, British Columbia','7giovanna@gmail.com',5140339808,'Banking',4,'password');
  500. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(245,166,'savings',2,2,877367808);
  501. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (167,'Harlee','30/2/1917','1983-10-5','8727 09TH TI ST, Vancouver, British Columbia','201harlee@gmail.com',5143242327,'Banking',4,'password');
  502. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (168,'Mckinley','12/10/1921','1995-04-9','8472 CASTRO ST, Vancouver, British Columbia','160mckinley@gmail.com',5145470715,'Banking',4,'password');
  503. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (169,'Joslyn','12/5/1967','1990-08-11','771 ARROYO WAY, Vancouver, British Columbia','194joslyn@gmail.com',5147444724,'Banking',4,'password');
  504. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(246,169,'savings',2,2,93359357);
  505. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(247,169,'savings',2,2,890492301);
  506. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (170,'Roselyn','11/4/1952','1955-02-12','3428 CHARLTON CT, Vancouver, British Columbia','154roselyn@gmail.com',5146690966,'Banking',4,'password');
  507. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(248,170,'savings',2,2,3480200667);
  508. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(249,170,'checking',1,2,5097843419);
  509. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (171,'Margaret','16/11/1970','1992-08-17','2084 BOB KAUFMAN ALY, Vancouver, British Columbia','25margaret@gmail.com',5145177632,'Banking',4,'password');
  510. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(250,171,'checking',1,1,7920054937);
  511. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(251,171,'checking',1,1,2877440250);
  512. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (172,'Adelyn','21/12/1991','1983-03-20','459 APPLETON ST, Vancouver, British Columbia','260adelyn@gmail.com',5146796818,'Banking',4,'password');
  513. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (173,'Vienna','12/10/1935','1985-04-6','3901 BRUCE AVE, Vancouver, British Columbia','166vienna@gmail.com',5149130211,'Banking',4,'password');
  514. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(252,173,'checking',1,2,2038951988);
  515. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(253,173,'savings',2,2,5407117773);
  516. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(254,173,'checking',1,2,6014439922);
  517. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (174,'Scarlette','15/3/1935','1993-07-8','6258 BURR AVE, Vancouver, British Columbia','53scarlette@gmail.com',5148514190,'Banking',4,'password');
  518. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(255,174,'savings',2,1,3363010431);
  519. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(256,174,'savings',2,1,3429237781);
  520. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (175,'Tori','4/1/1961','1973-01-17','6219 38TH AVE, Vancouver, British Columbia','246tori@gmail.com',5140741464,'Banking',4,'password');
  521. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(257,175,'savings',2,2,2179451745);
  522. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (176,'Helen','5/3/1950','1985-04-20','1344 AVENUE H, Vancouver, British Columbia','266helen@gmail.com',5148107504,'Banking',4,'password');
  523. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(258,176,'checking',1,2,9810211516);
  524. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(259,176,'checking',1,2,181625718);
  525. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (177,'Noah','29/12/1950','1979-04-27','7382 BOB KAUFMAN ALY, Vancouver, British Columbia','169noah@gmail.com',5148272351,'Banking',4,'password');
  526. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(260,177,'checking',1,2,4038460785);
  527. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(261,177,'checking',1,2,6645436978);
  528. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(262,177,'savings',2,2,3914728023);
  529. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (178,'Karlee','7/9/1917','2009-08-5','9885 BLYTHDALE AVE, Vancouver, British Columbia','110karlee@gmail.com',5148427944,'Banking',4,'password');
  530. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(263,178,'checking',1,1,8755947248);
  531. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (179,'Kyla','5/9/1957','2018-04-15','2116 29TH AVE, Vancouver, British Columbia','20kyla@gmail.com',5148306859,'Banking',4,'password');
  532. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(264,179,'checking',1,1,2772922207);
  533. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(265,179,'savings',2,1,5059441624);
  534. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(266,179,'savings',2,1,5836615395);
  535. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (180,'Kyleigh','30/3/1933','1979-09-23','6899 43RD AVE, Vancouver, British Columbia','88kyleigh@gmail.com',5147430721,'Banking',4,'password');
  536. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(267,180,'checking',1,1,3521211820);
  537. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(268,180,'checking',1,1,5347616887);
  538. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(269,180,'checking',1,1,9007594732);
  539. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (181,'Ivory','2/9/1926','1987-10-11','8485 CAMPBELL AVE, Vancouver, British Columbia','69ivory@gmail.com',5142111679,'Banking',4,'password');
  540. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(270,181,'checking',1,2,2087896024);
  541. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (182,'Aislinn','13/8/1992','1988-01-15','9172 06TH AVE, Vancouver, British Columbia','4aislinn@gmail.com',5146161153,'Banking',4,'password');
  542. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(271,182,'savings',2,2,4579861457);
  543. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (183,'Ember','14/4/1976','1993-10-8','8302 ALANA WAY, Vancouver, British Columbia','155ember@gmail.com',5144700087,'Banking',4,'password');
  544. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(272,183,'savings',2,2,5473903102);
  545. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(273,183,'savings',2,2,5859451089);
  546. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(274,183,'savings',2,2,4499064646);
  547. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (184,'Maya','3/3/1951','1997-10-10','4389 CHABOT TER, Vancouver, British Columbia','159maya@gmail.com',5148565477,'Banking',4,'password');
  548. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(275,184,'savings',2,1,7226969324);
  549. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(276,184,'savings',2,1,8520502650);
  550. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(277,184,'checking',1,1,1808711076);
  551. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (185,'Analia','5/12/1986','1992-03-17','7999 AVENUE F, Vancouver, British Columbia','89analia@gmail.com',5148857795,'Banking',4,'password');
  552. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(278,185,'checking',1,1,7880195232);
  553. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(279,185,'savings',2,1,5522703223);
  554. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (186,'Eileen','3/4/1993','1995-05-2','6161 ALAMEDA ST, Vancouver, British Columbia','115eileen@gmail.com',5140081947,'Banking',4,'password');
  555. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (187,'Julie','10/3/1945','1985-06-6','4138 ALABAMA ST, Vancouver, British Columbia','52julie@gmail.com',5147943167,'Banking',4,'password');
  556. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(280,187,'checking',1,2,3516246091);
  557. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(281,187,'checking',1,2,2606714347);
  558. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (188,'Kailyn','20/5/1992','1992-12-24','1001 BREWSTER ST, Vancouver, British Columbia','253kailyn@gmail.com',5146511959,'Banking',4,'password');
  559. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(282,188,'savings',2,2,8232629289);
  560. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(283,188,'checking',1,2,8122739868);
  561. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(284,188,'checking',1,2,895403841);
  562. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (189,'Nathalie','11/2/1943','1970-12-10','4444 ADA CT, Vancouver, British Columbia','239nathalie@gmail.com',5140086819,'Banking',4,'password');
  563. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(285,189,'checking',1,2,7292127771);
  564. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (190,'Guadalupe','12/3/1994','2002-01-11','3445 13TH ST, Vancouver, British Columbia','58guadalupe@gmail.com',5147476277,'Banking',4,'password');
  565. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(286,190,'savings',2,2,8695008204);
  566. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(287,190,'savings',2,2,8440213229);
  567. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (191,'Adelina','14/7/1906','1982-05-7','4545 BROTHERHOOD WAY, Vancouver, British Columbia','30adelina@gmail.com',5143825502,'Banking',4,'password');
  568. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (192,'Maya','1/11/1961','1965-11-9','6871 ADDISON ST, Vancouver, British Columbia','23maya@gmail.com',5146765481,'Banking',4,'password');
  569. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (193,'Hayley','22/11/1948','2006-06-25','2356 ANNIE ST, Vancouver, British Columbia','117hayley@gmail.com',5144143041,'Banking',4,'password');
  570. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (194,'Alaya','27/12/1964','1969-12-8','1947 BEALE ST, Vancouver, British Columbia','159alaya@gmail.com',5148887753,'Banking',4,'password');
  571. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(288,194,'savings',2,2,8112873505);
  572. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (195,'Alma','17/7/1936','1980-01-1','3129 03RD ST, Vancouver, British Columbia','257alma@gmail.com',5144212741,'Banking',4,'password');
  573. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(289,195,'checking',1,2,7816565705);
  574. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (196,'Sophie','1/4/1950','1976-02-15','487 BERWICK PL, Vancouver, British Columbia','118sophie@gmail.com',5147386579,'Banking',4,'password');
  575. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(290,196,'savings',2,2,1898599624);
  576. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(291,196,'savings',2,2,4591357564);
  577. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(292,196,'savings',2,2,5678173118);
  578. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (197,'Kyla','7/6/1991','1972-08-14','2092 09TH AVE, Vancouver, British Columbia','90kyla@gmail.com',5144264213,'Banking',4,'password');
  579. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(293,197,'savings',2,1,854576783);
  580. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(294,197,'checking',1,1,1240344309);
  581. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (198,'Jewel','28/7/1955','2015-04-2','2855 ASHTON AVE, Vancouver, British Columbia','226jewel@gmail.com',5145025413,'Banking',4,'password');
  582. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(295,198,'savings',2,1,3125948932);
  583. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(296,198,'savings',2,1,8070677680);
  584. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(297,198,'checking',1,1,3942385886);
  585. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (199,'Kenna','2/12/1920','1987-10-6','3093 BRANT ALY, Vancouver, British Columbia','233kenna@gmail.com',5148197801,'Banking',4,'password');
  586. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(298,199,'savings',2,1,6726115040);
  587. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(299,199,'savings',2,1,4197262579);
  588. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(300,199,'savings',2,1,1951213810);
  589. insert into branch (id, location, phone, fax, openingDate, managerId, serviceId) values (5,'6729 03RD ST, Vancouver, British Columbia',5141892450,18009910873,'1996-02-28',85,3);
  590. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (85, 'Branch Manager','Sophia','1833 03RD TI ST, Calgary, Alberta','1962-4-9',121841,'137sophia@bank.com',5141883708,'Managment',5);
  591. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (86,'Financial Analyst','Dylan','2584 BROOKHAVEN LN, Campbell River, British Columbia','2003-03-2','52594','109dylan@bank.com',5148550292,'Banking',5);
  592. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (87,'Financial Analyst','Shelby','8142 CERVANTES BLVD, Campbell River, British Columbia','2006-04-21','63094','229shelby@bank.com',5147262603,'Banking',5);
  593. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (88,'Financial Analyst','Mary','8081 15TH AVE, Campbell River, British Columbia','2012-08-2','112637','126mary@bank.com',5140129350,'Banking',5);
  594. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (89,'Financial Analyst','Sarah','2578 BRONTE ST, Campbell River, British Columbia','1984-05-26','46830','58sarah@bank.com',5147064737,'Banking',5);
  595. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (90,'Financial Analyst','Macy','1168 CAMBRIDGE ST, Campbell River, British Columbia','1991-06-8','106758','0macy@bank.com',5145206158,'Banking',5);
  596. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (91,'Financial Analyst','Quinn','7940 ANNIE ST, Campbell River, British Columbia','2008-03-5','57161','63quinn@bank.com',5148952971,'Banking',5);
  597. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (92,'Financial Analyst','Michelle','9785 ASH ST, Campbell River, British Columbia','1987-08-5','52335','83michelle@bank.com',5141498543,'Banking',5);
  598. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (93,'Financial Analyst','Freya','5987 ALLSTON WAY, Campbell River, British Columbia','1971-10-3','96986','27freya@bank.com',5147861812,'Banking',5);
  599. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (94,'Financial Analyst','Madelynn','8297 11TH ST, Campbell River, British Columbia','1950-01-8','76037','12madelynn@bank.com',5149402061,'Banking',5);
  600. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (95,'Financial Analyst','Madeleine','8830 BURROWS ST, Campbell River, British Columbia','1962-02-21','44786','204madeleine@bank.com',5149070796,'Banking',5);
  601. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (96,'Bank Teller','Amina','3817 CALHOUN TER, Campbell River, British Columbia','1988-10-12','85456','15amina@bank.com',5142092400,'Banking',5);
  602. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (97,'Bank Teller','Kamryn','9546 37TH AVE, Campbell River, British Columbia','1957-07-24','90030','200kamryn@bank.com',5145007964,'Banking',5);
  603. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (98,'Bank Teller','Fatima','2534 ALHAMBRA ST, Campbell River, British Columbia','2003-08-23','99285','79fatima@bank.com',5140480597,'Banking',5);
  604. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (99,'Bank Teller','Kendra','2510 AVENUE B, Campbell River, British Columbia','1951-08-5','84941','228kendra@bank.com',5147053326,'Banking',5);
  605. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (100,'Bank Teller','Esmeralda','1685 11TH ST, Campbell River, British Columbia','1957-11-12','83320','159esmeralda@bank.com',5141705956,'Banking',5);
  606. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (101,'Loan Officer','Natalie','3887 BENGAL ALY, Campbell River, British Columbia','1965-08-24','110145','264natalie@bank.com',5144126647,'Banking',5);
  607. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (102,'Loan Officer','Margaret','7146 ASPEN CT, Campbell River, British Columbia','1963-08-26','93009','181margaret@bank.com',5149961348,'Banking',5);
  608. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (103,'Loan Officer','Scarlett','8220 BANNEKER WAY, Campbell River, British Columbia','1970-11-27','92642','232scarlett@bank.com',5144994891,'Banking',5);
  609. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (104,'Loan Officer','Camille','7019 BELCHER ST, Campbell River, British Columbia','1989-01-13','63219','267camille@bank.com',5142887256,'Banking',5);
  610. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (105,'Loan Officer','Gemma','2781 09TH AVE, Campbell River, British Columbia','2003-04-18','114195','83gemma@bank.com',5140860184,'Banking',5);
  611. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (200,'Emilia','13/2/1940','1971-12-11','1264 BURROWS DR, Campbell River, British Columbia','260emilia@gmail.com',5148174666,'Banking',5,'password');
  612. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(301,200,'savings',2,1,9111643526);
  613. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(302,200,'checking',1,1,5317598509);
  614. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(303,200,'investment',3,1,3704197711);
  615. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (201,'Cherish','27/10/1945','1987-03-10','2641 18TH AVE, Campbell River, British Columbia','119cherish@gmail.com',5146461519,'Banking',5,'password');
  616. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(304,201,'investment',3,2,228805352);
  617. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(305,201,'checking',1,2,247254565);
  618. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(306,201,'investment',3,2,5693220727);
  619. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (202,'Gloria','18/3/1920','1986-10-20','3147 AMITY ALY, Campbell River, British Columbia','112gloria@gmail.com',5148353514,'Banking',5,'password');
  620. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (203,'Kylie','15/12/1992','1951-06-21','2592 C ST, Campbell River, British Columbia','1kylie@gmail.com',5146361977,'Banking',5,'password');
  621. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(307,203,'investment',3,2,6977361292);
  622. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(308,203,'checking',1,2,8660383517);
  623. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(309,203,'checking',1,2,3463896147);
  624. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (204,'Brooke','14/8/1974','1991-06-27','8384 ALLEN ST, Campbell River, British Columbia','208brooke@gmail.com',5149211575,'Banking',5,'password');
  625. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(310,204,'investment',3,2,1853622598);
  626. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(311,204,'investment',3,2,6382727924);
  627. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(312,204,'savings',2,2,8534588219);
  628. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (205,'Chana','12/4/1945','2010-05-22','6905 BARTLETT ST, Campbell River, British Columbia','230chana@gmail.com',5148166811,'Banking',5,'password');
  629. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(313,205,'savings',2,2,574770030);
  630. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(314,205,'checking',1,2,4869793780);
  631. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (206,'Kinley','5/6/1966','1950-03-6','7051 BELLEVUE AVE, Campbell River, British Columbia','254kinley@gmail.com',5144842798,'Banking',5,'password');
  632. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(315,206,'savings',2,2,3814179661);
  633. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(316,206,'investment',3,2,9308152166);
  634. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (207,'Liana','8/9/1989','2016-11-17','7749 ANGELOS ALY, Campbell River, British Columbia','145liana@gmail.com',5143747261,'Banking',5,'password');
  635. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(317,207,'checking',1,1,7411219971);
  636. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(318,207,'savings',2,1,5226028009);
  637. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (208,'Janelle','11/9/1903','2008-06-23','6738 BENNINGTON ST, Campbell River, British Columbia','9janelle@gmail.com',5140894293,'Banking',5,'password');
  638. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(319,208,'investment',3,2,5852198674);
  639. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (209,'Yasmin','15/3/1971','1997-11-1','8129 BLANDY ST, Campbell River, British Columbia','207yasmin@gmail.com',5146333995,'Banking',5,'password');
  640. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(320,209,'checking',1,1,8978147253);
  641. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (210,'Anna','18/3/1972','1968-08-24','6954 BEACON ST, Campbell River, British Columbia','141anna@gmail.com',5144979021,'Banking',5,'password');
  642. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(321,210,'savings',2,2,3877277643);
  643. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(322,210,'investment',3,2,1930406320);
  644. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (211,'Ramona','29/7/1983','2009-03-19','9967 ADDISON ST, Campbell River, British Columbia','208ramona@gmail.com',5144148744,'Banking',5,'password');
  645. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (212,'Collins','11/6/1952','1990-03-8','3552 ATHENS ST, Campbell River, British Columbia','158collins@gmail.com',5143514287,'Banking',5,'password');
  646. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (213,'Victoria','29/3/1992','2004-01-28','464 ALVISO ST, Campbell River, British Columbia','30victoria@gmail.com',5149247909,'Banking',5,'password');
  647. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(323,213,'investment',3,2,521925859);
  648. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(324,213,'checking',1,2,9727840705);
  649. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (214,'Yamileth','12/7/1942','2000-11-5','3059 28TH AVE, Campbell River, British Columbia','103yamileth@gmail.com',5147035867,'Banking',5,'password');
  650. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(325,214,'savings',2,2,9819389004);
  651. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(326,214,'investment',3,2,6857691925);
  652. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (215,'Ivanna','3/1/1996','1998-06-2','7219 BENTON AVE, Campbell River, British Columbia','180ivanna@gmail.com',5141973281,'Banking',5,'password');
  653. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(327,215,'savings',2,1,1002414276);
  654. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(328,215,'checking',1,1,5068880606);
  655. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(329,215,'savings',2,1,9542960229);
  656. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (216,'Cecelia','20/1/1953','1996-01-25','3511 CARROLL AVE, Campbell River, British Columbia','14cecelia@gmail.com',5149407701,'Banking',5,'password');
  657. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (217,'Royal','10/6/1916','1999-05-8','2680 ANZAVISTA AVE, Campbell River, British Columbia','96royal@gmail.com',5148528254,'Banking',5,'password');
  658. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(330,217,'checking',1,2,2851571073);
  659. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(331,217,'savings',2,2,8560526748);
  660. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(332,217,'investment',3,2,1848729462);
  661. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (218,'Mikayla','26/7/1908','1950-07-28','4704 BANK ST, Campbell River, British Columbia','134mikayla@gmail.com',5147976450,'Banking',5,'password');
  662. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(333,218,'investment',3,1,9099153040);
  663. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(334,218,'checking',1,1,8116395921);
  664. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (219,'Giselle','7/9/1900','2008-05-13','4505 ADELE CT, Campbell River, British Columbia','83giselle@gmail.com',5146096936,'Banking',5,'password');
  665. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (220,'Marina','1/6/1965','1998-07-2','2375 03RD TI ST, Campbell River, British Columbia','81marina@gmail.com',5143313861,'Banking',5,'password');
  666. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (221,'Hadley','21/4/1935','1995-06-13','2715 BURR AVE, Campbell River, British Columbia','235hadley@gmail.com',5144201107,'Banking',5,'password');
  667. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(335,221,'savings',2,2,2093646755);
  668. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(336,221,'investment',3,2,5982259757);
  669. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(337,221,'checking',1,2,8382203551);
  670. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (222,'Rylan','4/6/1909','1963-06-3','2461 BALHI CT, Campbell River, British Columbia','152rylan@gmail.com',5142969841,'Banking',5,'password');
  671. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (223,'Kinsley','7/7/1981','2017-02-25','4143 ARELIOUS WALKER DR, Campbell River, British Columbia','100kinsley@gmail.com',5149268497,'Banking',5,'password');
  672. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (224,'Ellison','29/7/1910','1997-02-16','7100 BARNARD AVE, Campbell River, British Columbia','236ellison@gmail.com',5147298092,'Banking',5,'password');
  673. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(338,224,'checking',1,1,2868292000);
  674. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (225,'Hazel','13/10/1966','1973-04-8','4122 AVENUE F, Campbell River, British Columbia','109hazel@gmail.com',5149533024,'Banking',5,'password');
  675. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(339,225,'checking',1,2,927762300);
  676. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (226,'Rowan','4/3/1976','1961-06-7','3314 ALPINE TER, Campbell River, British Columbia','266rowan@gmail.com',5142290810,'Banking',5,'password');
  677. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(340,226,'checking',1,1,868144577);
  678. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(341,226,'investment',3,1,9442588999);
  679. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(342,226,'checking',1,1,5852449204);
  680. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (227,'Kali','5/3/1912','1960-05-18','6155 43RD AVE, Campbell River, British Columbia','38kali@gmail.com',5146485367,'Banking',5,'password');
  681. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(343,227,'checking',1,1,6490820924);
  682. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (228,'Gemma','27/8/1986','1996-12-17','4916 39TH AVE, Campbell River, British Columbia','86gemma@gmail.com',5140855049,'Banking',5,'password');
  683. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(344,228,'checking',1,2,4045055677);
  684. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(345,228,'investment',3,2,8680705250);
  685. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(346,228,'checking',1,2,6738642247);
  686. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (229,'Adrianna','9/7/1945','1977-06-27','1816 BEATRICE LN, Campbell River, British Columbia','174adrianna@gmail.com',5148266875,'Banking',5,'password');
  687. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(347,229,'checking',1,1,6458091151);
  688. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(348,229,'checking',1,1,2600049360);
  689. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(349,229,'checking',1,1,3076868309);
  690. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (230,'Ingrid','10/4/1998','2001-05-16','8365 12TH TI ST, Campbell River, British Columbia','171ingrid@gmail.com',5142719659,'Banking',5,'password');
  691. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(350,230,'investment',3,2,8159269771);
  692. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(351,230,'investment',3,2,1523858626);
  693. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(352,230,'checking',1,2,666107393);
  694. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (231,'Aria','27/12/1903','1965-05-13','3494 01ST ST, Campbell River, British Columbia','202aria@gmail.com',5142545328,'Banking',5,'password');
  695. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(353,231,'investment',3,2,3212039346);
  696. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(354,231,'savings',2,2,3261021521);
  697. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(355,231,'savings',2,2,8270216521);
  698. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (232,'Allison','20/1/1987','1979-10-15','73 ARTHUR AVE, Campbell River, British Columbia','118allison@gmail.com',5141758973,'Banking',5,'password');
  699. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(356,232,'savings',2,1,4210648931);
  700. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(357,232,'investment',3,1,8894538484);
  701. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (233,'Noor','21/6/1908','2017-10-25','78 CHAVES AVE, Campbell River, British Columbia','246noor@gmail.com',5145199921,'Banking',5,'password');
  702. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(358,233,'investment',3,1,7056940960);
  703. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(359,233,'checking',1,1,233030902);
  704. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(360,233,'investment',3,1,4084900418);
  705. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (234,'Eliana','6/11/1924','1998-09-1','3399 ACME ALY, Campbell River, British Columbia','227eliana@gmail.com',5143205434,'Banking',5,'password');
  706. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (235,'Eliana','28/2/1908','2014-07-7','1975 ARKANSAS ST, Campbell River, British Columbia','241eliana@gmail.com',5142898866,'Banking',5,'password');
  707. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(361,235,'checking',1,2,5044088133);
  708. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (236,'Lilah','20/11/1931','1952-01-11','4155 ALPINE TER, Campbell River, British Columbia','256lilah@gmail.com',5143808195,'Banking',5,'password');
  709. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(362,236,'checking',1,1,6056809848);
  710. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (237,'Tatiana','28/3/1998','1973-09-1','4214 ALABAMA ST, Campbell River, British Columbia','134tatiana@gmail.com',5146637344,'Banking',5,'password');
  711. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(363,237,'savings',2,1,9164984784);
  712. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(364,237,'investment',3,1,3725603468);
  713. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(365,237,'checking',1,1,3002239575);
  714. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (238,'Zariyah','17/11/1988','2000-05-26','9446 CASELLI AVE, Campbell River, British Columbia','58zariyah@gmail.com',5141829112,'Banking',5,'password');
  715. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(366,238,'savings',2,1,2070597956);
  716. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(367,238,'investment',3,1,5856377880);
  717. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(368,238,'checking',1,1,3255995073);
  718. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (239,'Allie','23/1/1912','1983-12-26','9548 05TH ST, Campbell River, British Columbia','102allie@gmail.com',5142127954,'Banking',5,'password');
  719. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(369,239,'savings',2,2,2557313897);
  720. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(370,239,'savings',2,2,3120055277);
  721. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(371,239,'savings',2,2,8688830282);
  722. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (240,'Brianna','12/7/1928','1995-07-6','321 CARGO WAY, Campbell River, British Columbia','99brianna@gmail.com',5144129120,'Banking',5,'password');
  723. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (241,'Ruby','11/3/1930','1954-10-12','122 ANGELOS ALY, Campbell River, British Columbia','107ruby@gmail.com',5147463009,'Banking',5,'password');
  724. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(372,241,'investment',3,2,8766938727);
  725. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (242,'Zariah','3/7/1975','2018-08-28','1725 ANZAVISTA AVE, Campbell River, British Columbia','157zariah@gmail.com',5147366112,'Banking',5,'password');
  726. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(373,242,'investment',3,2,3301953354);
  727. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(374,242,'checking',1,2,7741389993);
  728. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (243,'Rylie','22/10/1989','1974-08-4','3629 CARVER ST, Campbell River, British Columbia','114rylie@gmail.com',5147458316,'Banking',5,'password');
  729. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (244,'Maleah','25/3/1917','2004-05-19','6932 BOARDMAN PL, Campbell River, British Columbia','104maleah@gmail.com',5149212316,'Banking',5,'password');
  730. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(375,244,'investment',3,1,76337420);
  731. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (245,'Aisha','11/10/1969','1962-08-18','9228 BRUMISS TER, Campbell River, British Columbia','251aisha@gmail.com',5148291615,'Banking',5,'password');
  732. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(376,245,'checking',1,1,6478905904);
  733. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(377,245,'savings',2,1,3512404819);
  734. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(378,245,'checking',1,1,7473028162);
  735. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (246,'Bailee','22/8/1901','2007-03-20','8824 BELMONT AVE, Campbell River, British Columbia','97bailee@gmail.com',5143388935,'Banking',5,'password');
  736. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(379,246,'savings',2,1,2583359059);
  737. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (247,'Camille','11/5/1910','1970-10-4','9289 BOSWORTH ST, Campbell River, British Columbia','30camille@gmail.com',5145274457,'Banking',5,'password');
  738. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(380,247,'savings',2,2,5848780326);
  739. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(381,247,'checking',1,2,1220696);
  740. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (248,'Olive','6/4/1944','1986-04-1','5919 BURROWS DR, Campbell River, British Columbia','130olive@gmail.com',5146007672,'Banking',5,'password');
  741. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(382,248,'checking',1,2,7174577892);
  742. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(383,248,'investment',3,2,8453829875);
  743. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(384,248,'savings',2,2,2100487495);
  744. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (249,'Mckenna','2/9/1952','1965-11-21','8915 BAY SHORE BLVD ON RAMP, Campbell River, British Columbia','211mckenna@gmail.com',5142192426,'Banking',5,'password');
  745. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(385,249,'checking',1,2,107660294);
  746. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(386,249,'savings',2,2,6766951918);
  747. insert into branch (id, location, phone, fax, openingDate, managerId, serviceId) values (6,'4745 04TH AVE, Campbell River, British Columbia',5141471131,18003345849,'1996-02-28',106,4);
  748. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (106, 'Branch Manager','Isabella','8685 04TH ST, Edmonton, Alberta','2010-6-17',132329,'264isabella@bank.com',5144187659,'Managment',6);
  749. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (107,'Financial Analyst','Nicole','168 ALAMEDA ST, Toronto, Ontario','1969-08-3','86846','123nicole@bank.com',5148199723,'Banking',6);
  750. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (108,'Financial Analyst','Aleah','2211 AMES ST, Toronto, Ontario','2009-02-16','84186','73aleah@bank.com',5140756628,'Banking',6);
  751. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (109,'Financial Analyst','Heaven','8631 BROSNAN ST, Toronto, Ontario','1970-05-22','50041','36heaven@bank.com',5147245431,'Banking',6);
  752. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (110,'Financial Analyst','Kaia','1582 ARELLANO AVE, Toronto, Ontario','1959-04-22','93394','149kaia@bank.com',5144034352,'Banking',6);
  753. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (111,'Financial Analyst','Bailey','9745 CAMPUS WAY, Toronto, Ontario','2014-09-10','49327','183bailey@bank.com',5148723206,'Banking',6);
  754. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (112,'Financial Analyst','Scarlet','702 CERES ST, Toronto, Ontario','2002-05-19','89427','33scarlet@bank.com',5143317953,'Banking',6);
  755. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (113,'Financial Analyst','Lana','9672 31ST ST, Toronto, Ontario','2000-06-4','81293','213lana@bank.com',5146729864,'Banking',6);
  756. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (114,'Financial Analyst','Grace','1863 12TH ST, Toronto, Ontario','1955-01-16','111862','81grace@bank.com',5144106399,'Banking',6);
  757. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (115,'Financial Analyst','Victoria','4189 APTOS AVE, Toronto, Ontario','1988-06-23','100268','143victoria@bank.com',5142378554,'Banking',6);
  758. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (116,'Financial Analyst','Lyric','3206 BAY SHORE BLVD OFF RAMP, Toronto, Ontario','1966-09-9','108878','265lyric@bank.com',5140343255,'Banking',6);
  759. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (117,'Bank Teller','Aleah','3284 BRUSH LN, Toronto, Ontario','1974-07-19','91862','60aleah@bank.com',5145305020,'Banking',6);
  760. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (118,'Bank Teller','Caroline','4519 ALABAMA ST, Toronto, Ontario','2018-11-6','96959','212caroline@bank.com',5149536912,'Banking',6);
  761. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (119,'Bank Teller','Shelby','5749 BISHOP ST, Toronto, Ontario','1987-10-7','94361','197shelby@bank.com',5147758099,'Banking',6);
  762. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (120,'Bank Teller','Sarah','5422 BEAUMONT AVE, Toronto, Ontario','2014-06-4','110069','118sarah@bank.com',5140099585,'Banking',6);
  763. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (121,'Bank Teller','Lily','2102 BONVIEW ST, Toronto, Ontario','1958-01-10','93927','211lily@bank.com',5141043975,'Banking',6);
  764. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (122,'Loan Officer','Layla','8422 CASHMERE ST, Toronto, Ontario','1971-01-24','60736','195layla@bank.com',5142112947,'Banking',6);
  765. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (123,'Loan Officer','Sydney','2868 ALVORD ST, Toronto, Ontario','1982-04-12','75247','224sydney@bank.com',5142020645,'Banking',6);
  766. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (124,'Loan Officer','Maliyah','356 CHAIN OF LAKES DR, Toronto, Ontario','2007-05-6','118816','74maliyah@bank.com',5147927350,'Banking',6);
  767. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (125,'Loan Officer','Cadence','5505 BROADWAY, Toronto, Ontario','1978-04-20','45648','78cadence@bank.com',5140774071,'Banking',6);
  768. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (126,'Loan Officer','Jacqueline','4822 CARL ST, Toronto, Ontario','1987-12-27','63686','65jacqueline@bank.com',5142103642,'Banking',6);
  769. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (250,'Kaylin','27/5/1994','1975-04-24','9685 ANDERSON ST, Toronto, Ontario','86kaylin@gmail.com',5140804808,'Banking',6,'password');
  770. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(387,250,'savings',2,2,2809020956);
  771. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (251,'Heaven','3/10/1972','1959-11-28','1506 ARBALLO DR, Toronto, Ontario','160heaven@gmail.com',5141660774,'Banking',6,'password');
  772. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(388,251,'savings',2,1,3229320198);
  773. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(389,251,'checking',1,1,4858920462);
  774. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (252,'Emory','16/2/1978','2014-05-3','2345 CHANNEL ST, Toronto, Ontario','87emory@gmail.com',5141447376,'Banking',6,'password');
  775. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (253,'Madalynn','25/7/1993','1993-04-11','6228 BELLA VISTA WAY, Toronto, Ontario','54madalynn@gmail.com',5142421191,'Banking',6,'password');
  776. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (254,'Nylah','24/2/1902','1984-01-8','2761 AVILA ST, Toronto, Ontario','193nylah@gmail.com',5144356474,'Banking',6,'password');
  777. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(390,254,'savings',2,2,5733695506);
  778. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(391,254,'savings',2,2,6863021064);
  779. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(392,254,'savings',2,2,6510918671);
  780. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (255,'Wendy','8/5/1980','2008-04-4','2899 19TH ST, Toronto, Ontario','134wendy@gmail.com',5145949302,'Banking',6,'password');
  781. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(393,255,'checking',1,1,596473925);
  782. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(394,255,'savings',2,1,4240274843);
  783. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (256,'Ryan','17/10/1965','1975-06-12','4044 BERTHA LN, Toronto, Ontario','152ryan@gmail.com',5147089170,'Banking',6,'password');
  784. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(395,256,'checking',1,2,1247874341);
  785. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (257,'Winter','14/3/1981','1994-03-8','2590 12TH TI ST, Toronto, Ontario','112winter@gmail.com',5141263973,'Banking',6,'password');
  786. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(396,257,'savings',2,2,2333181559);
  787. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(397,257,'savings',2,2,1120852355);
  788. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(398,257,'checking',1,2,4705951538);
  789. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (258,'Aylin','24/10/1969','1955-11-18','6732 ACME ALY, Toronto, Ontario','83aylin@gmail.com',5141550351,'Banking',6,'password');
  790. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(399,258,'savings',2,1,654053675);
  791. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(400,258,'savings',2,1,6426882080);
  792. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(401,258,'savings',2,1,4443220258);
  793. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (259,'Leyla','15/7/1917','2018-09-28','8362 ALERT ALY, Toronto, Ontario','252leyla@gmail.com',5143300339,'Banking',6,'password');
  794. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(402,259,'checking',1,2,1340742718);
  795. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(403,259,'checking',1,2,9449871880);
  796. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(404,259,'checking',1,2,6545978600);
  797. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (260,'Carlee','24/6/1911','1978-05-22','8195 BRIDGEVIEW WAY, Toronto, Ontario','214carlee@gmail.com',5147889126,'Banking',6,'password');
  798. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (261,'Karla','18/2/1969','1994-02-24','9835 ALMADEN CT, Toronto, Ontario','131karla@gmail.com',5148642837,'Banking',6,'password');
  799. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(405,261,'savings',2,1,2712109971);
  800. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (262,'Nylah','23/5/1922','2013-04-24','575 BONNIE BRAE LN, Toronto, Ontario','242nylah@gmail.com',5149336699,'Banking',6,'password');
  801. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(406,262,'checking',1,2,205488396);
  802. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(407,262,'checking',1,2,2553761438);
  803. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(408,262,'savings',2,2,5431546348);
  804. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (263,'Amiya','17/12/1942','1956-01-17','4544 BRODERICK ST, Toronto, Ontario','172amiya@gmail.com',5144922682,'Banking',6,'password');
  805. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(409,263,'checking',1,1,8172559837);
  806. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(410,263,'checking',1,1,2426531775);
  807. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (264,'Esmeralda','30/7/1966','1977-06-25','4205 31ST AVE, Toronto, Ontario','14esmeralda@gmail.com',5148770702,'Banking',6,'password');
  808. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(411,264,'checking',1,1,9189812048);
  809. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(412,264,'checking',1,1,8297021479);
  810. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(413,264,'checking',1,1,1477592185);
  811. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (265,'Rosa','20/11/1929','1977-08-28','9003 09TH TI ST, Toronto, Ontario','233rosa@gmail.com',5143184950,'Banking',6,'password');
  812. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(414,265,'savings',2,2,6428926236);
  813. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (266,'Alison','2/12/1992','2004-11-27','6290 23RD AVE, Toronto, Ontario','60alison@gmail.com',5140067492,'Banking',6,'password');
  814. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(415,266,'savings',2,2,336917160);
  815. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (267,'Calliope','13/2/1961','1967-07-13','977 CENTRAL MAGAZINE RD, Toronto, Ontario','61calliope@gmail.com',5141317724,'Banking',6,'password');
  816. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(416,267,'checking',1,2,3783070427);
  817. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(417,267,'checking',1,2,8118573490);
  818. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (268,'Cataleya','30/11/1947','2004-04-21','3680 AERIAL WAY, Toronto, Ontario','126cataleya@gmail.com',5143295596,'Banking',6,'password');
  819. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(418,268,'savings',2,1,3898856245);
  820. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (269,'Ryann','14/2/1971','2003-12-9','4926 22ND AVE, Toronto, Ontario','127ryann@gmail.com',5142152718,'Banking',6,'password');
  821. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (270,'Tiffany','24/11/1935','2005-10-7','3878 34TH AVE, Toronto, Ontario','207tiffany@gmail.com',5142191627,'Banking',6,'password');
  822. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(419,270,'savings',2,1,7551046743);
  823. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (271,'Sloan','28/1/1970','1968-10-18','4460 CAPITOL AVE, Toronto, Ontario','36sloan@gmail.com',5142944950,'Banking',6,'password');
  824. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(420,271,'savings',2,1,8216462222);
  825. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(421,271,'savings',2,1,5064287327);
  826. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (272,'Heaven','21/11/1971','1956-10-18','9615 23RD AVE, Toronto, Ontario','111heaven@gmail.com',5142728571,'Banking',6,'password');
  827. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(422,272,'checking',1,2,8956663573);
  828. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(423,272,'checking',1,2,5786275605);
  829. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (273,'Lizbeth','26/8/1964','2018-06-5','1974 ACORN ALY, Toronto, Ontario','222lizbeth@gmail.com',5143025622,'Banking',6,'password');
  830. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(424,273,'checking',1,2,4290231739);
  831. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(425,273,'savings',2,2,6199628563);
  832. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(426,273,'savings',2,2,4567785471);
  833. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (274,'Jimena','30/12/1908','1981-11-2','379 BAKER CT, Toronto, Ontario','246jimena@gmail.com',5145859585,'Banking',6,'password');
  834. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(427,274,'savings',2,2,8808630952);
  835. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (275,'Logan','17/1/1982','1994-06-24','68 ALTA MAR WAY, Toronto, Ontario','4logan@gmail.com',5140968083,'Banking',6,'password');
  836. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(428,275,'savings',2,1,6927063774);
  837. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(429,275,'checking',1,1,5478934895);
  838. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (276,'Mara','28/3/1975','1987-03-3','7083 CASSANDRA CT, Toronto, Ontario','152mara@gmail.com',5148223517,'Banking',6,'password');
  839. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(430,276,'checking',1,1,2580666613);
  840. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (277,'Collins','23/6/1945','2013-10-10','109 07TH AVE, Toronto, Ontario','14collins@gmail.com',5140186615,'Banking',6,'password');
  841. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(431,277,'checking',1,2,82540432);
  842. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(432,277,'checking',1,2,8623106002);
  843. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (278,'Ashley','30/11/1994','1974-07-23','3755 BAKER CT, Toronto, Ontario','177ashley@gmail.com',5143322778,'Banking',6,'password');
  844. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(433,278,'checking',1,2,6808816240);
  845. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(434,278,'savings',2,2,6699763748);
  846. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(435,278,'checking',1,2,3207456215);
  847. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (279,'Autumn','4/4/1946','1969-10-13','4811 22ND AVE, Toronto, Ontario','159autumn@gmail.com',5142034886,'Banking',6,'password');
  848. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(436,279,'savings',2,2,5650779873);
  849. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(437,279,'checking',1,2,8531737661);
  850. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (280,'Brianna','9/11/1917','2000-06-25','8528 BEAVER ST, Toronto, Ontario','211brianna@gmail.com',5141915722,'Banking',6,'password');
  851. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (281,'Zoey','7/1/1990','1979-02-25','1716 ANKENY ST, Toronto, Ontario','258zoey@gmail.com',5141040902,'Banking',6,'password');
  852. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(438,281,'savings',2,1,2334399601);
  853. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(439,281,'savings',2,1,504933509);
  854. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (282,'Caroline','9/2/1903','1982-06-2','2083 CESAR CHAVEZ ON RAMP, Toronto, Ontario','262caroline@gmail.com',5143694204,'Banking',6,'password');
  855. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(440,282,'savings',2,1,6553937510);
  856. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(441,282,'savings',2,1,4117438737);
  857. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (283,'Jazmine','19/10/1952','1999-04-1','4821 ADAIR ST, Toronto, Ontario','43jazmine@gmail.com',5145387201,'Banking',6,'password');
  858. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(442,283,'savings',2,1,9100762478);
  859. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(443,283,'checking',1,1,7427008942);
  860. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (284,'Reign','15/5/1910','1961-03-26','3556 BAYSIDE VILLAGE PL, Toronto, Ontario','31reign@gmail.com',5143976924,'Banking',6,'password');
  861. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (285,'Leah','8/3/1954','1977-01-21','1016 24TH AVE, Toronto, Ontario','210leah@gmail.com',5148560401,'Banking',6,'password');
  862. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(444,285,'savings',2,2,5108196271);
  863. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (286,'Corinne','23/4/1927','1968-07-7','6569 ARAGO ST, Toronto, Ontario','38corinne@gmail.com',5140993173,'Banking',6,'password');
  864. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(445,286,'checking',1,2,3125339645);
  865. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(446,286,'savings',2,2,8588228601);
  866. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (287,'Hana','17/10/1951','1951-11-4','9923 BIRD ST, Toronto, Ontario','135hana@gmail.com',5146159394,'Banking',6,'password');
  867. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(447,287,'checking',1,1,6439159832);
  868. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (288,'Arianna','2/7/1951','1960-03-20','821 BROOKLYN PL, Toronto, Ontario','249arianna@gmail.com',5141665975,'Banking',6,'password');
  869. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(448,288,'savings',2,1,5104197965);
  870. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (289,'Braelynn','16/4/1938','1959-05-12','4021 BELLE AVE, Toronto, Ontario','93braelynn@gmail.com',5144021854,'Banking',6,'password');
  871. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(449,289,'checking',1,2,8987434368);
  872. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(450,289,'checking',1,2,9473655172);
  873. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (290,'Sloane','26/2/1997','1985-11-10','6454 29TH AVE, Toronto, Ontario','234sloane@gmail.com',5140238176,'Banking',6,'password');
  874. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (291,'Finley','3/1/1953','1972-01-26','4117 BANK ST, Toronto, Ontario','13finley@gmail.com',5145609354,'Banking',6,'password');
  875. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(451,291,'checking',1,2,6891948194);
  876. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (292,'Ellianna','13/3/1901','1995-10-11','4557 BLACK PL, Toronto, Ontario','158ellianna@gmail.com',5148219820,'Banking',6,'password');
  877. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(452,292,'checking',1,1,9217839009);
  878. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(453,292,'checking',1,1,6993936747);
  879. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(454,292,'savings',2,1,6241844880);
  880. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (293,'Raelyn','17/8/1970','1962-07-24','1945 ATOLL CIR, Toronto, Ontario','235raelyn@gmail.com',5145450363,'Banking',6,'password');
  881. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(455,293,'savings',2,2,4702890246);
  882. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (294,'Valentina','17/4/1997','1977-05-25','7352 CASITAS AVE, Toronto, Ontario','132valentina@gmail.com',5149715251,'Banking',6,'password');
  883. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(456,294,'savings',2,2,7924195479);
  884. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(457,294,'checking',1,2,4393043819);
  885. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(458,294,'savings',2,2,3323019394);
  886. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (295,'Cali','22/3/1999','1958-09-14','8501 ARMISTEAD RD, Toronto, Ontario','127cali@gmail.com',5149163355,'Banking',6,'password');
  887. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (296,'Breanna','30/3/1911','1950-07-8','6990 CARRIZAL ST, Toronto, Ontario','187breanna@gmail.com',5149481525,'Banking',6,'password');
  888. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(459,296,'savings',2,2,1887281200);
  889. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (297,'Lisa','16/5/1943','1984-03-20','2390 07TH ST, Toronto, Ontario','224lisa@gmail.com',5144517220,'Banking',6,'password');
  890. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(460,297,'savings',2,2,834971533);
  891. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(461,297,'checking',1,2,1022467293);
  892. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(462,297,'checking',1,2,5661420508);
  893. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (298,'Kiana','1/4/1982','1995-07-21','1215 ARLINGTON ST, Toronto, Ontario','36kiana@gmail.com',5144282622,'Banking',6,'password');
  894. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(463,298,'checking',1,1,6093755342);
  895. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (299,'Samantha','27/6/1943','1986-06-22','2905 ALERT ALY, Toronto, Ontario','228samantha@gmail.com',5143080915,'Banking',6,'password');
  896. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(464,299,'savings',2,2,7632792101);
  897. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(465,299,'savings',2,2,1557287287);
  898. insert into branch (id, location, phone, fax, openingDate, managerId, serviceId) values (7,'5755 04TH TI ST, Toronto, Ontario',5142537757,18002905601,'1996-02-28',127,3);
  899. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (127, 'Branch Manager','Mia','1352 05TH AVE, Ottawa–Gatineau, Ontario/Quebec','1978-10-20',179472,'9mia@bank.com',5146083742,'Managment',7);
  900. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (128,'Financial Analyst','Violet','1923 CAPP ST, Montreal, Quebec','2013-06-3','44509','200violet@bank.com',5145251560,'Banking',7);
  901. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (129,'Financial Analyst','Raven','690 BOARDMAN PL, Montreal, Quebec','1961-01-6','78650','39raven@bank.com',5143363160,'Banking',7);
  902. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (130,'Financial Analyst','Carolina','6857 04TH AVE, Montreal, Quebec','2005-09-3','105415','135carolina@bank.com',5142467452,'Banking',7);
  903. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (131,'Financial Analyst','Kaitlyn','93 BROSNAN ST, Montreal, Quebec','1967-11-25','61115','61kaitlyn@bank.com',5149216538,'Banking',7);
  904. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (132,'Financial Analyst','Joy','9004 ALBATROSS CT, Montreal, Quebec','1983-07-23','43462','212joy@bank.com',5145641595,'Banking',7);
  905. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (133,'Financial Analyst','London','6177 BURLWOOD DR, Montreal, Quebec','2012-12-22','51953','92london@bank.com',5144957072,'Banking',7);
  906. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (134,'Financial Analyst','Georgia','9981 BALANCE ST, Montreal, Quebec','1953-06-21','76783','246georgia@bank.com',5149174598,'Banking',7);
  907. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (135,'Financial Analyst','Genevieve','4017 CHARLTON CT, Montreal, Quebec','1963-11-16','61952','169genevieve@bank.com',5145754438,'Banking',7);
  908. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (136,'Financial Analyst','Skyler','5832 BURLWOOD DR, Montreal, Quebec','1971-01-17','113509','37skyler@bank.com',5142103617,'Banking',7);
  909. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (137,'Financial Analyst','Skye','1043 08TH ST, Montreal, Quebec','1959-06-3','82952','118skye@bank.com',5145257460,'Banking',7);
  910. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (138,'Bank Teller','Dakota','5106 07TH ST, Montreal, Quebec','1989-02-11','77741','89dakota@bank.com',5145023506,'Banking',7);
  911. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (139,'Bank Teller','Valeria','2581 BASS CT, Montreal, Quebec','2007-03-1','65199','185valeria@bank.com',5143112123,'Banking',7);
  912. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (140,'Bank Teller','Kathryn','3941 CERRITOS AVE, Montreal, Quebec','1964-03-2','47968','175kathryn@bank.com',5147278750,'Banking',7);
  913. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (141,'Bank Teller','Rylie','5243 BOWLEY CT, Montreal, Quebec','2018-07-11','80453','158rylie@bank.com',5148239905,'Banking',7);
  914. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (142,'Bank Teller','Talia','9214 BRADFORD ST, Montreal, Quebec','1982-03-5','98533','157talia@bank.com',5145246060,'Banking',7);
  915. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (143,'Loan Officer','Catalina','2639 BEATRICE LN, Montreal, Quebec','1969-09-1','98799','77catalina@bank.com',5146735032,'Banking',7);
  916. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (144,'Loan Officer','Makayla','1210 ALDER ST, Montreal, Quebec','1957-06-12','84489','15makayla@bank.com',5141230625,'Banking',7);
  917. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (145,'Loan Officer','Lexi','3022 CARTER ST, Montreal, Quebec','1999-06-4','99607','123lexi@bank.com',5143932647,'Banking',7);
  918. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (146,'Loan Officer','Arielle','9311 BELCHER ST, Montreal, Quebec','1995-09-14','86457','164arielle@bank.com',5149846459,'Banking',7);
  919. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (147,'Loan Officer','Nylah','3019 BRYANT ST, Montreal, Quebec','1962-11-24','82745','191nylah@bank.com',5141373941,'Banking',7);
  920. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (300,'Elena','25/2/1976','1974-02-9','8510 ALMADEN CT, Montreal, Quebec','22elena@gmail.com',5145317695,'Banking',7,'password');
  921. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(466,300,'savings',2,2,7493104165);
  922. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(467,300,'checking',1,2,7181281379);
  923. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(468,300,'savings',2,2,6502348285);
  924. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (301,'Morgan','25/4/1972','1968-06-19','3958 40TH AVE, Montreal, Quebec','258morgan@gmail.com',5146205447,'Banking',7,'password');
  925. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(469,301,'savings',2,1,7175587727);
  926. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(470,301,'checking',1,1,1712404668);
  927. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(471,301,'savings',2,1,1505491640);
  928. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (302,'Valeria','2/3/1929','1985-07-20','5816 AVALON AVE, Montreal, Quebec','62valeria@gmail.com',5144862630,'Banking',7,'password');
  929. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(472,302,'savings',2,1,8122287646);
  930. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (303,'Stevie','1/5/1959','1976-07-10','2690 CCSF PARKING LOT, Montreal, Quebec','175stevie@gmail.com',5144052933,'Banking',7,'password');
  931. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(473,303,'checking',1,1,1802045534);
  932. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(474,303,'savings',2,1,2259665517);
  933. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(475,303,'checking',1,1,215280855);
  934. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (304,'Haley','5/12/1950','1990-07-6','5673 24TH ST, Montreal, Quebec','142haley@gmail.com',5149607730,'Banking',7,'password');
  935. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(476,304,'checking',1,2,521653932);
  936. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (305,'Karla','24/9/1998','1967-09-22','876 BLATCHFORD LN, Montreal, Quebec','198karla@gmail.com',5142709880,'Banking',7,'password');
  937. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(477,305,'savings',2,1,2388599712);
  938. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (306,'Piper','12/3/1914','2016-04-24','8262 CANDLESTICK POINT SRA, Montreal, Quebec','129piper@gmail.com',5148057328,'Banking',7,'password');
  939. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(478,306,'savings',2,2,4572219187);
  940. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(479,306,'savings',2,2,9928211593);
  941. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(480,306,'savings',2,2,6208025832);
  942. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (307,'Ivanna','6/6/1961','1965-06-22','3707 ARROYO WAY, Montreal, Quebec','125ivanna@gmail.com',5149979948,'Banking',7,'password');
  943. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(481,307,'savings',2,1,3194670912);
  944. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(482,307,'checking',1,1,3378438839);
  945. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (308,'Pearl','18/10/1989','1999-05-28','3816 ALMA ST, Montreal, Quebec','114pearl@gmail.com',5147126040,'Banking',7,'password');
  946. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(483,308,'checking',1,2,1620175140);
  947. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (309,'Cadence','9/2/1956','1951-03-21','6179 BOYLSTON ST, Montreal, Quebec','165cadence@gmail.com',5147406766,'Banking',7,'password');
  948. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(484,309,'savings',2,2,40929240);
  949. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (310,'Emmy','22/6/1907','1951-06-26','8838 AMAZON AVE, Montreal, Quebec','192emmy@gmail.com',5144296609,'Banking',7,'password');
  950. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(485,310,'checking',1,1,9644489602);
  951. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(486,310,'checking',1,1,8648898945);
  952. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (311,'Sloan','18/12/1913','1976-10-20','6982 47TH AVE, Montreal, Quebec','246sloan@gmail.com',5140496566,'Banking',7,'password');
  953. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (312,'Harper','1/9/1906','2017-06-21','350 ADDISON ST, Montreal, Quebec','149harper@gmail.com',5143434221,'Banking',7,'password');
  954. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(487,312,'checking',1,1,3529777157);
  955. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (313,'Anabella','4/3/1932','1999-10-16','569 29TH AVE, Montreal, Quebec','153anabella@gmail.com',5141094836,'Banking',7,'password');
  956. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(488,313,'savings',2,2,6087265810);
  957. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(489,313,'savings',2,2,6786539819);
  958. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (314,'Ariah','17/4/1926','2000-06-12','6927 CASTENADA AVE, Montreal, Quebec','111ariah@gmail.com',5147805672,'Banking',7,'password');
  959. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(490,314,'savings',2,2,6543367895);
  960. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(491,314,'checking',1,2,9192705860);
  961. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(492,314,'checking',1,2,5598161175);
  962. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (315,'Christina','1/9/1936','1985-04-18','7339 BATTERY WAGNER RD, Montreal, Quebec','180christina@gmail.com',5148132818,'Banking',7,'password');
  963. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(493,315,'checking',1,1,1092838311);
  964. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (316,'Alyvia','23/4/1985','1969-01-20','5648 AUGUSTA ST, Montreal, Quebec','260alyvia@gmail.com',5143627904,'Banking',7,'password');
  965. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(494,316,'checking',1,2,6973827712);
  966. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(495,316,'checking',1,2,906681552);
  967. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(496,316,'checking',1,2,7412697566);
  968. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (317,'Kyra','10/8/1975','1955-03-27','7003 BANNEKER WAY, Montreal, Quebec','200kyra@gmail.com',5143004798,'Banking',7,'password');
  969. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (318,'Cassandra','13/5/1932','2009-07-27','6813 BALANCE ST, Montreal, Quebec','67cassandra@gmail.com',5146339176,'Banking',7,'password');
  970. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(497,318,'savings',2,2,1963541556);
  971. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(498,318,'checking',1,2,6435767836);
  972. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (319,'Jayleen','30/11/1916','2015-02-13','9512 CHARTER OAK AVE, Montreal, Quebec','9jayleen@gmail.com',5142464421,'Banking',7,'password');
  973. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (320,'Camilla','21/8/1960','2016-05-6','7291 12TH AVE, Montreal, Quebec','67camilla@gmail.com',5144542647,'Banking',7,'password');
  974. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(499,320,'savings',2,2,5244765818);
  975. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (321,'Eve','13/11/1966','1973-03-24','2614 CEDAR ST, Montreal, Quebec','86eve@gmail.com',5144895079,'Banking',7,'password');
  976. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(500,321,'savings',2,2,1203825444);
  977. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(501,321,'checking',1,2,8973057513);
  978. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(502,321,'savings',2,2,4279842323);
  979. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (322,'Baylee','5/8/1957','1977-11-19','767 CAMPUS LN, Montreal, Quebec','81baylee@gmail.com',5140367223,'Banking',7,'password');
  980. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (323,'Kira','28/3/1955','2006-02-5','3810 BRITTON ST, Montreal, Quebec','127kira@gmail.com',5141701454,'Banking',7,'password');
  981. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(503,323,'checking',1,1,7392002691);
  982. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(504,323,'savings',2,1,1706833557);
  983. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(505,323,'checking',1,1,4119920592);
  984. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (324,'Salma','3/5/1959','1980-05-21','9946 A ST, Montreal, Quebec','177salma@gmail.com',5140371170,'Banking',7,'password');
  985. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (325,'Elle','2/12/1933','1984-08-11','2909 BURNS PL, Montreal, Quebec','204elle@gmail.com',5145130473,'Banking',7,'password');
  986. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(506,325,'checking',1,1,5353791098);
  987. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(507,325,'checking',1,1,383956085);
  988. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(508,325,'checking',1,1,8310992704);
  989. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (326,'Sarai','10/8/1904','1970-02-6','3720 12TH AVE, Montreal, Quebec','35sarai@gmail.com',5143088971,'Banking',7,'password');
  990. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(509,326,'checking',1,1,2824889684);
  991. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (327,'Erica','25/3/1922','1963-05-19','4720 CASTENADA AVE, Montreal, Quebec','43erica@gmail.com',5143340059,'Banking',7,'password');
  992. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(510,327,'checking',1,1,5263130899);
  993. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(511,327,'checking',1,1,7437205765);
  994. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (328,'Jaylynn','3/5/1928','1997-06-28','7585 08TH ST, Montreal, Quebec','49jaylynn@gmail.com',5141594985,'Banking',7,'password');
  995. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (329,'Sylvie','10/5/1920','1970-11-5','124 BEHR AVE, Montreal, Quebec','81sylvie@gmail.com',5147302350,'Banking',7,'password');
  996. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(512,329,'checking',1,2,6562777019);
  997. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (330,'Tatiana','29/8/1988','1955-02-20','5114 ACACIA AVE, Montreal, Quebec','114tatiana@gmail.com',5147437750,'Banking',7,'password');
  998. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (331,'Bristol','3/10/1932','1973-04-19','8405 ALLSTON WAY, Montreal, Quebec','200bristol@gmail.com',5146146620,'Banking',7,'password');
  999. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(513,331,'checking',1,2,5796579722);
  1000. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (332,'Zaylee','27/7/1973','1960-02-10','7285 CARSON ST, Montreal, Quebec','46zaylee@gmail.com',5149800464,'Banking',7,'password');
  1001. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(514,332,'savings',2,1,3890732111);
  1002. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(515,332,'checking',1,1,9363789756);
  1003. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (333,'Annabel','1/3/1978','1985-03-13','6840 09TH ST, Montreal, Quebec','240annabel@gmail.com',5148912294,'Banking',7,'password');
  1004. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (334,'Emely','20/3/1920','1958-07-5','1448 AUTO DR, Montreal, Quebec','21emely@gmail.com',5142920406,'Banking',7,'password');
  1005. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (335,'Isabelle','26/11/1976','1951-12-1','850 BERTITA ST, Montreal, Quebec','9isabelle@gmail.com',5149345435,'Banking',7,'password');
  1006. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (336,'Brooke','25/12/1914','1957-05-23','3214 CENTURY PL, Montreal, Quebec','55brooke@gmail.com',5146437851,'Banking',7,'password');
  1007. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (337,'Anna','25/2/1960','1964-07-8','6878 32ND AVE, Montreal, Quebec','269anna@gmail.com',5147479344,'Banking',7,'password');
  1008. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(516,337,'savings',2,1,5469337887);
  1009. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(517,337,'savings',2,1,1920960125);
  1010. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (338,'Jaelyn','11/10/1982','2008-08-1','4246 BROOK ST, Montreal, Quebec','266jaelyn@gmail.com',5143807890,'Banking',7,'password');
  1011. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(518,338,'checking',1,1,5348348472);
  1012. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (339,'Pearl','4/7/1921','1996-01-27','1065 ARBALLO DR, Montreal, Quebec','31pearl@gmail.com',5145672049,'Banking',7,'password');
  1013. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(519,339,'savings',2,2,7335967043);
  1014. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(520,339,'savings',2,2,4894468877);
  1015. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (340,'Christine','4/12/1932','1976-02-19','5653 CEDRO AVE, Montreal, Quebec','240christine@gmail.com',5148025325,'Banking',7,'password');
  1016. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (341,'Aviana','27/5/1932','2004-04-28','1868 AMADOR ST, Montreal, Quebec','222aviana@gmail.com',5149255417,'Banking',7,'password');
  1017. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(521,341,'checking',1,1,815957152);
  1018. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(522,341,'checking',1,1,7288741307);
  1019. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (342,'Galilea','5/11/1984','1957-05-9','9511 ARAGO ST, Montreal, Quebec','113galilea@gmail.com',5149131337,'Banking',7,'password');
  1020. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(523,342,'savings',2,2,860905171);
  1021. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (343,'Katalina','24/5/1944','1962-11-12','5362 12TH TI ST, Montreal, Quebec','78katalina@gmail.com',5146100732,'Banking',7,'password');
  1022. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(524,343,'savings',2,2,5293503115);
  1023. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(525,343,'savings',2,2,6786318661);
  1024. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (344,'Brooke','29/5/1958','2005-11-17','5739 CASTENADA AVE, Montreal, Quebec','255brooke@gmail.com',5145366937,'Banking',7,'password');
  1025. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (345,'Macie','14/6/1930','1969-06-3','7741 ARBOL LN, Montreal, Quebec','202macie@gmail.com',5145428752,'Banking',7,'password');
  1026. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(526,345,'savings',2,2,1419069911);
  1027. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(527,345,'savings',2,2,6084105387);
  1028. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(528,345,'savings',2,2,3099662951);
  1029. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (346,'Laurel','21/7/1967','1980-07-23','7921 BACHE ST, Montreal, Quebec','23laurel@gmail.com',5149537958,'Banking',7,'password');
  1030. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(529,346,'checking',1,1,6459955524);
  1031. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (347,'Collins','16/6/1952','1971-05-15','4688 BUTTE PL, Montreal, Quebec','262collins@gmail.com',5149565851,'Banking',7,'password');
  1032. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(530,347,'checking',1,1,6601096978);
  1033. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(531,347,'savings',2,1,1597657868);
  1034. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(532,347,'checking',1,1,9915822794);
  1035. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (348,'Adelyn','11/2/1972','1997-11-8','9606 BEHR AVE, Montreal, Quebec','242adelyn@gmail.com',5149828083,'Banking',7,'password');
  1036. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(533,348,'savings',2,1,4936983620);
  1037. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (349,'Noor','19/1/1985','1983-01-17','2109 BLAKE ST, Montreal, Quebec','90noor@gmail.com',5143604279,'Banking',7,'password');
  1038. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(534,349,'checking',1,1,8622491078);
  1039. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(535,349,'savings',2,1,6131876643);
  1040. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(536,349,'checking',1,1,7965188947);
  1041. insert into branch (id, location, phone, fax, openingDate, managerId, serviceId) values (8,'5853 05TH ST, Montreal, Quebec',5145540256,18004995147,'1996-02-28',148,1);
  1042. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (148, 'Branch Manager','Charlotte','2461 05TH TI ST, Winnipeg, Manitoba','1994-3-1',121977,'156charlotte@bank.com',5141104459,'Managment',8);
  1043. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (149,'Financial Analyst','Adelaide','5593 BOYNTON CT, Kitchener–Waterloo–Cambridge, Ontario','1985-02-12','106358','179adelaide@bank.com',5144363543,'Banking',8);
  1044. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (150,'Financial Analyst','Mallory','3809 BURNSIDE AVE, Kitchener–Waterloo–Cambridge, Ontario','1950-03-26','57577','67mallory@bank.com',5143119594,'Banking',8);
  1045. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (151,'Financial Analyst','Hailey','1166 ALMA ST, Kitchener–Waterloo–Cambridge, Ontario','1998-08-15','100060','113hailey@bank.com',5146115373,'Banking',8);
  1046. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (152,'Financial Analyst','Jacqueline','631 BOWLEY ST, Kitchener–Waterloo–Cambridge, Ontario','1984-07-3','108829','212jacqueline@bank.com',5141786372,'Banking',8);
  1047. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (153,'Financial Analyst','Scarlet','7272 19TH AVE, Kitchener–Waterloo–Cambridge, Ontario','1990-06-27','116760','240scarlet@bank.com',5147908105,'Banking',8);
  1048. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (154,'Financial Analyst','Emersyn','4742 ALMA ST, Kitchener–Waterloo–Cambridge, Ontario','1975-04-17','56662','70emersyn@bank.com',5145304664,'Banking',8);
  1049. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (155,'Financial Analyst','Delaney','1185 45TH AVE, Kitchener–Waterloo–Cambridge, Ontario','1992-12-22','83100','32delaney@bank.com',5148467724,'Banking',8);
  1050. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (156,'Financial Analyst','Zariah','6918 ANDERSON ST, Kitchener–Waterloo–Cambridge, Ontario','1971-11-15','48032','199zariah@bank.com',5141088014,'Banking',8);
  1051. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (157,'Financial Analyst','Nicole','482 26TH AVE, Kitchener–Waterloo–Cambridge, Ontario','1995-08-27','43457','208nicole@bank.com',5147820566,'Banking',8);
  1052. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (158,'Financial Analyst','Juliette','6387 ARCO WAY, Kitchener–Waterloo–Cambridge, Ontario','1953-09-14','65645','93juliette@bank.com',5147922268,'Banking',8);
  1053. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (159,'Bank Teller','Kyleigh','7982 ANSON PL, Kitchener–Waterloo–Cambridge, Ontario','1979-02-4','102964','94kyleigh@bank.com',5142842632,'Banking',8);
  1054. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (160,'Bank Teller','Jayleen','4378 ANTONIO ST, Kitchener–Waterloo–Cambridge, Ontario','1981-05-17','75169','245jayleen@bank.com',5141901916,'Banking',8);
  1055. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (161,'Bank Teller','Penelope','7192 ANKENY ST, Kitchener–Waterloo–Cambridge, Ontario','1994-04-20','114393','159penelope@bank.com',5146871596,'Banking',8);
  1056. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (162,'Bank Teller','Marlee','7511 BELL CT, Kitchener–Waterloo–Cambridge, Ontario','2006-04-19','89496','183marlee@bank.com',5143841821,'Banking',8);
  1057. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (163,'Bank Teller','Lana','7212 21ST AVE, Kitchener–Waterloo–Cambridge, Ontario','2006-11-13','53853','55lana@bank.com',5143814994,'Banking',8);
  1058. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (164,'Loan Officer','Madison','6827 ALVISO ST, Kitchener–Waterloo–Cambridge, Ontario','2001-10-15','61768','106madison@bank.com',5141125745,'Banking',8);
  1059. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (165,'Loan Officer','Maeve','6825 AMHERST ST, Kitchener–Waterloo–Cambridge, Ontario','2000-05-11','54217','170maeve@bank.com',5148352858,'Banking',8);
  1060. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (166,'Loan Officer','Amara','170 ADDISON ST, Kitchener–Waterloo–Cambridge, Ontario','1966-12-12','67558','263amara@bank.com',5143567102,'Banking',8);
  1061. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (167,'Loan Officer','Kelsey','5675 CARTER ST, Kitchener–Waterloo–Cambridge, Ontario','2005-01-23','89925','30kelsey@bank.com',5146703028,'Banking',8);
  1062. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (168,'Loan Officer','Adeline','1021 ALLISON ST, Kitchener–Waterloo–Cambridge, Ontario','1981-01-22','89986','218adeline@bank.com',5147091280,'Banking',8);
  1063. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (350,'Helen','3/7/1902','1974-05-20','6134 ANZA ST, Kitchener–Waterloo–Cambridge, Ontario','16helen@gmail.com',5147207156,'Banking',8,'password');
  1064. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(537,350,'checking',1,1,7187743334);
  1065. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(538,350,'checking',1,1,1771769803);
  1066. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (351,'Salma','12/5/1907','1957-10-1','4109 CERRITOS AVE, Kitchener–Waterloo–Cambridge, Ontario','41salma@gmail.com',5141403151,'Banking',8,'password');
  1067. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(539,351,'savings',2,1,7650322735);
  1068. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(540,351,'checking',1,1,250062499);
  1069. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (352,'Norah','10/2/1920','1987-04-16','4258 BROMLEY PL, Kitchener–Waterloo–Cambridge, Ontario','57norah@gmail.com',5146831158,'Banking',8,'password');
  1070. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (353,'Jayden','30/10/1913','1988-01-20','6301 CHARLES ST, Kitchener–Waterloo–Cambridge, Ontario','266jayden@gmail.com',5143646093,'Banking',8,'password');
  1071. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(541,353,'savings',2,2,2815691671);
  1072. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(542,353,'savings',2,2,8047358486);
  1073. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(543,353,'checking',1,2,9822171428);
  1074. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (354,'Mia','30/5/1933','1995-08-5','4197 BURGOYNE ST, Kitchener–Waterloo–Cambridge, Ontario','176mia@gmail.com',5146802286,'Banking',8,'password');
  1075. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(544,354,'savings',2,1,7022811107);
  1076. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(545,354,'checking',1,1,7256487228);
  1077. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(546,354,'checking',1,1,3642638855);
  1078. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (355,'Ivory','10/4/1972','1957-03-21','8092 BIRMINGHAM RD, Kitchener–Waterloo–Cambridge, Ontario','191ivory@gmail.com',5145163006,'Banking',8,'password');
  1079. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(547,355,'checking',1,1,841439328);
  1080. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(548,355,'savings',2,1,2963993308);
  1081. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (356,'Melanie','17/11/1908','2005-12-10','9726 BROOKLYN PL, Kitchener–Waterloo–Cambridge, Ontario','100melanie@gmail.com',5141488233,'Banking',8,'password');
  1082. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(549,356,'checking',1,2,7554347778);
  1083. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (357,'Thea','1/12/1932','1963-06-21','1498 CASTENADA AVE, Kitchener–Waterloo–Cambridge, Ontario','110thea@gmail.com',5148669931,'Banking',8,'password');
  1084. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(550,357,'checking',1,2,7546645447);
  1085. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (358,'Liv','27/9/1950','2008-10-1','46 15TH AVE, Kitchener–Waterloo–Cambridge, Ontario','44liv@gmail.com',5147289327,'Banking',8,'password');
  1086. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (359,'Lacey','5/6/1920','1988-01-25','7084 14TH AVE, Kitchener–Waterloo–Cambridge, Ontario','105lacey@gmail.com',5146005726,'Banking',8,'password');
  1087. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(551,359,'checking',1,1,274547478);
  1088. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(552,359,'checking',1,1,3581015036);
  1089. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (360,'Virginia','25/9/1975','1959-11-12','1748 BERTHA LN, Kitchener–Waterloo–Cambridge, Ontario','15virginia@gmail.com',5141905480,'Banking',8,'password');
  1090. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(553,360,'savings',2,1,379701717);
  1091. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(554,360,'savings',2,1,5418290579);
  1092. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (361,'Laila','5/9/1919','1986-02-1','2015 BEVERLY ST, Kitchener–Waterloo–Cambridge, Ontario','65laila@gmail.com',5149809731,'Banking',8,'password');
  1093. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(555,361,'savings',2,1,7947727186);
  1094. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (362,'Eloise','15/4/1927','1959-11-22','544 BUCARELI DR, Kitchener–Waterloo–Cambridge, Ontario','99eloise@gmail.com',5147727527,'Banking',8,'password');
  1095. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(556,362,'savings',2,1,5690802681);
  1096. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (363,'Poppy','1/4/1984','1996-08-13','8955 BOWLEY ST, Kitchener–Waterloo–Cambridge, Ontario','105poppy@gmail.com',5146378132,'Banking',8,'password');
  1097. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(557,363,'savings',2,1,7010459089);
  1098. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(558,363,'checking',1,1,2003782499);
  1099. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(559,363,'checking',1,1,3072427472);
  1100. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (364,'Jaelynn','29/11/1971','2000-12-24','9285 BERRY EXTENSION ST, Kitchener–Waterloo–Cambridge, Ontario','133jaelynn@gmail.com',5140432782,'Banking',8,'password');
  1101. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (365,'Karlie','22/7/1909','1989-12-17','9275 ADOLPH SUTRO CT, Kitchener–Waterloo–Cambridge, Ontario','95karlie@gmail.com',5144485114,'Banking',8,'password');
  1102. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(560,365,'savings',2,2,6969090172);
  1103. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(561,365,'savings',2,2,8987039550);
  1104. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (366,'Rosalie','17/9/1978','1970-10-21','5607 08TH TI ST, Kitchener–Waterloo–Cambridge, Ontario','99rosalie@gmail.com',5144806257,'Banking',8,'password');
  1105. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(562,366,'checking',1,2,8296352307);
  1106. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(563,366,'savings',2,2,3267726192);
  1107. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(564,366,'checking',1,2,1518314657);
  1108. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (367,'Mariam','22/2/1988','2011-07-14','5554 10TH ST, Kitchener–Waterloo–Cambridge, Ontario','112mariam@gmail.com',5142740614,'Banking',8,'password');
  1109. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (368,'Riley','5/11/1962','1959-06-12','2944 30TH AVE, Kitchener–Waterloo–Cambridge, Ontario','221riley@gmail.com',5145734560,'Banking',8,'password');
  1110. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(565,368,'checking',1,2,3816148208);
  1111. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(566,368,'checking',1,2,1167192630);
  1112. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (369,'Imani','8/12/1989','2017-07-27','348 BRIGHT ST, Kitchener–Waterloo–Cambridge, Ontario','239imani@gmail.com',5149459405,'Banking',8,'password');
  1113. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(567,369,'savings',2,1,3209571107);
  1114. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (370,'Ana','27/3/1993','1964-11-13','8959 17TH AVE, Kitchener–Waterloo–Cambridge, Ontario','115ana@gmail.com',5149067870,'Banking',8,'password');
  1115. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(568,370,'savings',2,2,1941542844);
  1116. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (371,'Monroe','12/5/1972','2018-08-23','7771 ALTON AVE, Kitchener–Waterloo–Cambridge, Ontario','251monroe@gmail.com',5148097347,'Banking',8,'password');
  1117. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(569,371,'savings',2,2,5032310177);
  1118. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(570,371,'checking',1,2,8581586634);
  1119. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (372,'Kendall','26/10/1918','1957-07-17','7553 APPLETON AVE, Kitchener–Waterloo–Cambridge, Ontario','149kendall@gmail.com',5149348141,'Banking',8,'password');
  1120. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(571,372,'savings',2,1,569184601);
  1121. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(572,372,'savings',2,1,8170839894);
  1122. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(573,372,'checking',1,1,4252976500);
  1123. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (373,'Emmalyn','27/5/1921','1989-10-17','8723 CATHERINE CT, Kitchener–Waterloo–Cambridge, Ontario','75emmalyn@gmail.com',5148880809,'Banking',8,'password');
  1124. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(574,373,'savings',2,1,5791016257);
  1125. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(575,373,'savings',2,1,5671883704);
  1126. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(576,373,'checking',1,1,577990982);
  1127. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (374,'Adilynn','28/3/1950','1987-02-22','2055 BIGELOW CT, Kitchener–Waterloo–Cambridge, Ontario','77adilynn@gmail.com',5149020277,'Banking',8,'password');
  1128. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(577,374,'checking',1,1,3438904200);
  1129. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(578,374,'checking',1,1,9224428196);
  1130. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(579,374,'checking',1,1,3112328893);
  1131. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (375,'Tiana','15/3/1933','1955-11-11','3186 ARBOR ST, Kitchener–Waterloo–Cambridge, Ontario','245tiana@gmail.com',5149682433,'Banking',8,'password');
  1132. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(580,375,'savings',2,1,2892438032);
  1133. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(581,375,'savings',2,1,5292737588);
  1134. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (376,'Leilani','27/3/1916','1986-02-27','5590 CERRITOS AVE, Kitchener–Waterloo–Cambridge, Ontario','80leilani@gmail.com',5144955791,'Banking',8,'password');
  1135. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(582,376,'savings',2,2,2572606195);
  1136. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(583,376,'savings',2,2,3969462746);
  1137. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (377,'Juniper','13/4/1937','1991-11-10','6280 AMBROSE BIERCE ST, Kitchener–Waterloo–Cambridge, Ontario','198juniper@gmail.com',5147613273,'Banking',8,'password');
  1138. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (378,'Elizabeth','2/11/1962','2007-06-7','5608 ALMA ST, Kitchener–Waterloo–Cambridge, Ontario','104elizabeth@gmail.com',5144968803,'Banking',8,'password');
  1139. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (379,'Kaitlyn','18/8/1933','1987-07-10','5966 BLANCHE ST, Kitchener–Waterloo–Cambridge, Ontario','116kaitlyn@gmail.com',5147548119,'Banking',8,'password');
  1140. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(584,379,'savings',2,2,7278943042);
  1141. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(585,379,'savings',2,2,1238053162);
  1142. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(586,379,'checking',1,2,1144758130);
  1143. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (380,'Miranda','1/3/1979','1989-07-24','8423 ALMADEN CT, Kitchener–Waterloo–Cambridge, Ontario','55miranda@gmail.com',5140532770,'Banking',8,'password');
  1144. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (381,'Aubrey','28/7/1960','1957-06-28','4125 BROMLEY PL, Kitchener–Waterloo–Cambridge, Ontario','144aubrey@gmail.com',5149384415,'Banking',8,'password');
  1145. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (382,'Jordyn','30/11/1945','1962-01-6','9710 BURKE AVE, Kitchener–Waterloo–Cambridge, Ontario','255jordyn@gmail.com',5140175439,'Banking',8,'password');
  1146. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (383,'Salma','13/11/1916','1990-02-26','6196 BIGLER AVE, Kitchener–Waterloo–Cambridge, Ontario','223salma@gmail.com',5143249839,'Banking',8,'password');
  1147. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(587,383,'savings',2,2,9687029072);
  1148. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (384,'Madison','29/11/1997','1981-11-7','6368 CAMEO WAY, Kitchener–Waterloo–Cambridge, Ontario','79madison@gmail.com',5143640937,'Banking',8,'password');
  1149. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(588,384,'checking',1,1,8668894199);
  1150. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (385,'Christine','7/5/1968','1963-09-5','3573 CANYON DR, Kitchener–Waterloo–Cambridge, Ontario','189christine@gmail.com',5146105519,'Banking',8,'password');
  1151. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (386,'Liliana','26/12/1963','2017-01-4','3451 BLANCHE ST, Kitchener–Waterloo–Cambridge, Ontario','182liliana@gmail.com',5146225390,'Banking',8,'password');
  1152. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(589,386,'savings',2,1,3295633314);
  1153. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(590,386,'savings',2,1,6739961078);
  1154. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(591,386,'checking',1,1,3388152535);
  1155. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (387,'Evangeline','12/8/1925','2001-12-17','5594 BALBOA ST, Kitchener–Waterloo–Cambridge, Ontario','204evangeline@gmail.com',5148056346,'Banking',8,'password');
  1156. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(592,387,'savings',2,2,4537235064);
  1157. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(593,387,'savings',2,2,6011001927);
  1158. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (388,'Rosemary','14/12/1958','1958-11-8','499 34TH AVE, Kitchener–Waterloo–Cambridge, Ontario','17rosemary@gmail.com',5143909686,'Banking',8,'password');
  1159. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (389,'Esther','24/12/1941','1958-12-16','2966 BERKELEY WAY, Kitchener–Waterloo–Cambridge, Ontario','101esther@gmail.com',5147220143,'Banking',8,'password');
  1160. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (390,'Maryam','2/9/1929','1985-06-13','9864 ANTONIO ST, Kitchener–Waterloo–Cambridge, Ontario','58maryam@gmail.com',5149828271,'Banking',8,'password');
  1161. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(594,390,'savings',2,1,7221950608);
  1162. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(595,390,'savings',2,1,6445684406);
  1163. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(596,390,'checking',1,1,1123122628);
  1164. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (391,'Hanna','26/1/1949','1999-12-7','1281 ALBION ST, Kitchener–Waterloo–Cambridge, Ontario','67hanna@gmail.com',5143772794,'Banking',8,'password');
  1165. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(597,391,'checking',1,2,6717738524);
  1166. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(598,391,'savings',2,2,1597871692);
  1167. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(599,391,'checking',1,2,8092508790);
  1168. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (392,'Juliana','2/2/1905','2009-10-26','7246 BARTLETT ST, Kitchener–Waterloo–Cambridge, Ontario','246juliana@gmail.com',5142429309,'Banking',8,'password');
  1169. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (393,'Alayah','5/10/1941','1954-07-19','854 ALLISON ST, Kitchener–Waterloo–Cambridge, Ontario','143alayah@gmail.com',5141697566,'Banking',8,'password');
  1170. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(600,393,'savings',2,1,6313564642);
  1171. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (394,'Elisabeth','18/12/1960','1988-08-18','8671 CAMBRIDGE ST, Kitchener–Waterloo–Cambridge, Ontario','93elisabeth@gmail.com',5140955665,'Banking',8,'password');
  1172. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (395,'Christina','5/2/1910','1995-07-14','6316 BOSWORTH ST, Kitchener–Waterloo–Cambridge, Ontario','87christina@gmail.com',5143158702,'Banking',8,'password');
  1173. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (396,'Nevaeh','6/5/1926','1971-03-20','3144 48TH AVE, Kitchener–Waterloo–Cambridge, Ontario','234nevaeh@gmail.com',5148541690,'Banking',8,'password');
  1174. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(601,396,'checking',1,2,6755225393);
  1175. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (397,'Juliana','16/6/1922','1983-12-25','4336 BEACHMONT DR, Kitchener–Waterloo–Cambridge, Ontario','256juliana@gmail.com',5141826981,'Banking',8,'password');
  1176. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(602,397,'savings',2,2,5882164979);
  1177. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (398,'Brielle','29/6/1940','1956-03-10','468 BONVIEW ST, Kitchener–Waterloo–Cambridge, Ontario','138brielle@gmail.com',5144397189,'Banking',8,'password');
  1178. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(603,398,'checking',1,1,809130362);
  1179. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (399,'Mira','25/11/1917','1993-05-26','8326 36TH AVE, Kitchener–Waterloo–Cambridge, Ontario','111mira@gmail.com',5142522302,'Banking',8,'password');
  1180. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(604,399,'checking',1,1,1675598167);
  1181. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(605,399,'checking',1,1,9002485706);
  1182. insert into branch (id, location, phone, fax, openingDate, managerId, serviceId) values (9,'489 06TH AVE, Kitchener–Waterloo–Cambridge, Ontario',5149742072,18000623037,'1996-02-28',169,1);
  1183. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (169, 'Branch Manager','Abigail','5308 06TH ST, Quebec City, Quebec','1967-1-12',129817,'207abigail@bank.com',5146428399,'Managment',9);
  1184. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (170,'Financial Analyst','Juniper','5802 BATTERY WAGNER RD, Calgary, Alberta','1999-11-13','119152','245juniper@bank.com',5147399893,'Banking',9);
  1185. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (171,'Financial Analyst','Macy','6700 CALIFORNIA AVE, Calgary, Alberta','2009-04-28','90664','168macy@bank.com',5141894478,'Banking',9);
  1186. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (172,'Financial Analyst','Madilyn','4958 17TH AVE, Calgary, Alberta','1965-02-4','53046','258madilyn@bank.com',5147829136,'Banking',9);
  1187. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (173,'Financial Analyst','Charleigh','6187 16TH ST, Calgary, Alberta','1992-07-12','66013','105charleigh@bank.com',5146338969,'Banking',9);
  1188. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (174,'Financial Analyst','Felicity','8159 BREWSTER ST, Calgary, Alberta','1984-04-1','100909','199felicity@bank.com',5148480398,'Banking',9);
  1189. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (175,'Financial Analyst','Delilah','8046 ANZA ST, Calgary, Alberta','1980-01-18','87964','103delilah@bank.com',5146478446,'Banking',9);
  1190. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (176,'Financial Analyst','Charlotte','4633 ADA CT, Calgary, Alberta','2000-07-28','50798','56charlotte@bank.com',5142467993,'Banking',9);
  1191. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (177,'Financial Analyst','Carolina','2798 BARCELONA AVE, Calgary, Alberta','1961-11-5','40636','120carolina@bank.com',5141561479,'Banking',9);
  1192. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (178,'Financial Analyst','Autumn','6831 27TH AVE, Calgary, Alberta','1964-01-19','94008','219autumn@bank.com',5149863128,'Banking',9);
  1193. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (179,'Financial Analyst','Lilly','5627 BELLAIR PL, Calgary, Alberta','1996-03-26','99591','136lilly@bank.com',5146589487,'Banking',9);
  1194. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (180,'Bank Teller','Jessica','9751 BLISS RD, Calgary, Alberta','1950-09-9','84302','169jessica@bank.com',5149297830,'Banking',9);
  1195. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (181,'Bank Teller','Madeleine','6278 CATHERINE CT, Calgary, Alberta','1982-06-6','52770','216madeleine@bank.com',5147644609,'Banking',9);
  1196. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (182,'Bank Teller','Aviana','5882 26TH AVE, Calgary, Alberta','1986-11-8','87366','55aviana@bank.com',5148627045,'Banking',9);
  1197. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (183,'Bank Teller','Gabriela','1488 AMBER DR, Calgary, Alberta','2016-07-7','48138','151gabriela@bank.com',5143399102,'Banking',9);
  1198. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (184,'Bank Teller','Jade','8030 BEAVER ST, Calgary, Alberta','1995-11-28','93188','160jade@bank.com',5148238536,'Banking',9);
  1199. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (185,'Loan Officer','Aliyah','3865 40TH AVE, Calgary, Alberta','1972-12-20','106161','139aliyah@bank.com',5149349711,'Banking',9);
  1200. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (186,'Loan Officer','Serenity','3144 29TH ST, Calgary, Alberta','1999-11-8','101205','37serenity@bank.com',5144353366,'Banking',9);
  1201. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (187,'Loan Officer','Kaitlyn','1089 BRENTWOOD AVE, Calgary, Alberta','1975-03-6','76113','75kaitlyn@bank.com',5143400612,'Banking',9);
  1202. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (188,'Loan Officer','Faith','4700 BYXBEE ST, Calgary, Alberta','1966-03-11','96689','84faith@bank.com',5148581658,'Banking',9);
  1203. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (189,'Loan Officer','Freya','86 41ST AVE, Calgary, Alberta','1957-05-24','51059','5freya@bank.com',5142959562,'Banking',9);
  1204. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (400,'Brianna','25/4/1901','2016-01-24','7260 BLAIRWOOD LN, Calgary, Alberta','158brianna@gmail.com',5144771075,'Banking',9,'password');
  1205. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (401,'Jayleen','7/3/1944','1960-09-16','7785 BURLWOOD DR, Calgary, Alberta','210jayleen@gmail.com',5144928916,'Banking',9,'password');
  1206. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(606,401,'savings',2,2,1951419568);
  1207. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(607,401,'savings',2,2,9284149973);
  1208. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(608,401,'savings',2,2,5413476100);
  1209. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (402,'Nathalie','12/2/1900','1983-03-21','4619 AVENUE I, Calgary, Alberta','88nathalie@gmail.com',5144770577,'Banking',9,'password');
  1210. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(609,402,'savings',2,1,7114059987);
  1211. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (403,'Harper','3/11/1979','1960-08-22','6921 AVENUE M, Calgary, Alberta','8harper@gmail.com',5146092071,'Banking',9,'password');
  1212. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(610,403,'checking',1,1,8470591937);
  1213. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (404,'Brooklyn','4/3/1943','1982-06-25','9277 BROMLEY PL, Calgary, Alberta','84brooklyn@gmail.com',5142223702,'Banking',9,'password');
  1214. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (405,'Jayden','28/11/1969','2003-03-10','7928 ANTHONY ST, Calgary, Alberta','159jayden@gmail.com',5140209786,'Banking',9,'password');
  1215. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (406,'Julia','17/1/1977','1950-01-12','1119 APPAREL WAY, Calgary, Alberta','234julia@gmail.com',5148893006,'Banking',9,'password');
  1216. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(611,406,'savings',2,2,1177179227);
  1217. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(612,406,'savings',2,2,1785380501);
  1218. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(613,406,'savings',2,2,2106031291);
  1219. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (407,'Karter','21/6/1927','1967-12-26','7984 CASTENADA AVE, Calgary, Alberta','192karter@gmail.com',5141290645,'Banking',9,'password');
  1220. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (408,'Annabelle','14/7/1993','2011-11-2','2902 BELLA VISTA WAY, Calgary, Alberta','92annabelle@gmail.com',5141927884,'Banking',9,'password');
  1221. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (409,'Thea','19/10/1979','2002-08-20','7674 CASSANDRA CT, Calgary, Alberta','147thea@gmail.com',5149253708,'Banking',9,'password');
  1222. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(614,409,'savings',2,1,921163017);
  1223. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(615,409,'savings',2,1,5943839590);
  1224. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(616,409,'savings',2,1,9810412031);
  1225. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (410,'Ryan','14/1/1918','1999-02-6','5426 AMAZON AVE, Calgary, Alberta','208ryan@gmail.com',5143455927,'Banking',9,'password');
  1226. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(617,410,'checking',1,2,896257678);
  1227. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (411,'Remington','19/4/1958','1959-11-22','7871 27TH AVE, Calgary, Alberta','159remington@gmail.com',5145009853,'Banking',9,'password');
  1228. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (412,'Jasmin','21/7/1962','1954-07-26','8713 ASHTON AVE, Calgary, Alberta','191jasmin@gmail.com',5149991261,'Banking',9,'password');
  1229. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(618,412,'checking',1,2,9871776877);
  1230. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (413,'Johanna','27/1/1938','1974-01-11','5594 BROOKLYN PL, Calgary, Alberta','77johanna@gmail.com',5142561177,'Banking',9,'password');
  1231. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(619,413,'checking',1,1,4988918243);
  1232. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (414,'Madelyn','17/8/1908','1999-08-12','8749 CARL ST, Calgary, Alberta','35madelyn@gmail.com',5148753310,'Banking',9,'password');
  1233. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (415,'Itzel','28/3/1944','1970-06-11','5017 ALABAMA ST, Calgary, Alberta','193itzel@gmail.com',5143060382,'Banking',9,'password');
  1234. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(620,415,'savings',2,2,6774015335);
  1235. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(621,415,'checking',1,2,8728215260);
  1236. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (416,'Madelyn','16/5/1932','1998-06-16','7902 CASE ST, Calgary, Alberta','103madelyn@gmail.com',5145449936,'Banking',9,'password');
  1237. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(622,416,'savings',2,1,5566831438);
  1238. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (417,'Alexandria','15/7/1915','1972-05-5','6480 27TH AVE, Calgary, Alberta','162alexandria@gmail.com',5141852610,'Banking',9,'password');
  1239. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(623,417,'checking',1,1,7945837513);
  1240. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (418,'Madalynn','24/7/1976','1985-04-4','4670 BROOKLYN PL, Calgary, Alberta','21madalynn@gmail.com',5147883470,'Banking',9,'password');
  1241. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (419,'Miah','25/8/1950','1986-02-19','2108 35TH AVE, Calgary, Alberta','12miah@gmail.com',5148012244,'Banking',9,'password');
  1242. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(624,419,'checking',1,1,9408784303);
  1243. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (420,'Ada','5/10/1949','2011-08-8','2826 CABRILLO ST, Calgary, Alberta','55ada@gmail.com',5142687007,'Banking',9,'password');
  1244. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(625,420,'checking',1,1,7065506314);
  1245. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (421,'Lizbeth','16/6/1979','1978-03-9','5585 ADDISON ST, Calgary, Alberta','218lizbeth@gmail.com',5145347695,'Banking',9,'password');
  1246. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (422,'Brittany','3/9/1928','1962-10-6','8999 BAYVIEW PARK RD, Calgary, Alberta','155brittany@gmail.com',5140024955,'Banking',9,'password');
  1247. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(626,422,'checking',1,1,2392183141);
  1248. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(627,422,'checking',1,1,9366878734);
  1249. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (423,'Bianca','16/1/1939','1988-01-15','4641 04TH AVE, Calgary, Alberta','243bianca@gmail.com',5145482155,'Banking',9,'password');
  1250. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (424,'Ivy','15/5/1909','1990-08-5','1057 BEACON ST, Calgary, Alberta','251ivy@gmail.com',5146439785,'Banking',9,'password');
  1251. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(628,424,'savings',2,2,8495219381);
  1252. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (425,'Aubriella','26/8/1998','2008-07-25','5199 CANDLESTICK POINT SRA, Calgary, Alberta','18aubriella@gmail.com',5147426920,'Banking',9,'password');
  1253. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(629,425,'checking',1,2,9028990559);
  1254. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(630,425,'savings',2,2,3946554058);
  1255. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(631,425,'checking',1,2,1691037918);
  1256. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (426,'Nyla','21/9/1943','2015-10-25','5164 ALMA ST, Calgary, Alberta','89nyla@gmail.com',5143934707,'Banking',9,'password');
  1257. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(632,426,'savings',2,2,4249503369);
  1258. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(633,426,'savings',2,2,9375884893);
  1259. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(634,426,'savings',2,2,8428640026);
  1260. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (427,'Athena','29/10/1999','1992-10-21','5809 AMETHYST WAY, Calgary, Alberta','155athena@gmail.com',5149157562,'Banking',9,'password');
  1261. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(635,427,'checking',1,1,2733111017);
  1262. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(636,427,'savings',2,1,4068561585);
  1263. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(637,427,'savings',2,1,7016045031);
  1264. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (428,'Ava','14/8/1917','1954-02-9','2697 AZTEC ST, Calgary, Alberta','237ava@gmail.com',5149089320,'Banking',9,'password');
  1265. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(638,428,'savings',2,1,2698017002);
  1266. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (429,'Adriana','8/8/1981','1989-05-10','380 08TH TI ST, Calgary, Alberta','20adriana@gmail.com',5143750283,'Banking',9,'password');
  1267. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(639,429,'checking',1,2,7332057921);
  1268. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(640,429,'savings',2,2,3155956727);
  1269. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (430,'Madison','30/6/1997','2001-06-7','1760 06TH ST, Calgary, Alberta','16madison@gmail.com',5143599079,'Banking',9,'password');
  1270. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(641,430,'savings',2,1,4632518888);
  1271. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(642,430,'savings',2,1,6423328372);
  1272. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(643,430,'checking',1,1,1401805591);
  1273. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (431,'Willow','10/8/1950','1952-07-12','971 06TH TI ST, Calgary, Alberta','66willow@gmail.com',5144717176,'Banking',9,'password');
  1274. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(644,431,'checking',1,1,3055328432);
  1275. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(645,431,'savings',2,1,2012146070);
  1276. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(646,431,'checking',1,1,2761102995);
  1277. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (432,'Kinsley','19/9/1903','1995-05-22','6913 BALBOA ST, Calgary, Alberta','84kinsley@gmail.com',5143529598,'Banking',9,'password');
  1278. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (433,'Paulina','19/10/1957','2001-08-12','3445 BROADWAY, Calgary, Alberta','130paulina@gmail.com',5143339643,'Banking',9,'password');
  1279. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(647,433,'checking',1,2,3864233399);
  1280. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(648,433,'savings',2,2,4554476922);
  1281. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(649,433,'checking',1,2,9240049644);
  1282. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (434,'Megan','15/10/1974','1976-11-16','7977 ACACIA ST, Calgary, Alberta','64megan@gmail.com',5145552674,'Banking',9,'password');
  1283. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(650,434,'savings',2,1,5824662987);
  1284. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(651,434,'checking',1,1,4682145256);
  1285. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (435,'Bianca','27/7/1902','1964-03-13','3790 BOALT ST, Calgary, Alberta','7bianca@gmail.com',5148393654,'Banking',9,'password');
  1286. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(652,435,'checking',1,2,6487075464);
  1287. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(653,435,'savings',2,2,7097083542);
  1288. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(654,435,'savings',2,2,1161276443);
  1289. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (436,'Izabella','7/10/1958','2012-12-17','2512 18TH ST, Calgary, Alberta','218izabella@gmail.com',5143349896,'Banking',9,'password');
  1290. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (437,'Kali','10/5/1909','1984-02-27','7680 BARCELONA AVE, Calgary, Alberta','246kali@gmail.com',5143195914,'Banking',9,'password');
  1291. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(655,437,'checking',1,1,1902443086);
  1292. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(656,437,'checking',1,1,8300076729);
  1293. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(657,437,'checking',1,1,4792844178);
  1294. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (438,'Clementine','5/4/1988','2004-08-1','9848 BANNOCK ST, Calgary, Alberta','57clementine@gmail.com',5145953294,'Banking',9,'password');
  1295. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(658,438,'savings',2,1,1339944832);
  1296. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(659,438,'savings',2,1,4829828977);
  1297. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(660,438,'savings',2,1,9972352561);
  1298. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (439,'Shiloh','30/3/1962','2008-06-6','2331 AMAZON AVE, Calgary, Alberta','181shiloh@gmail.com',5149745721,'Banking',9,'password');
  1299. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (440,'Kaliyah','27/4/1935','1989-08-3','530 41ST AVE, Calgary, Alberta','104kaliyah@gmail.com',5144003291,'Banking',9,'password');
  1300. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (441,'Alaia','18/1/1939','2018-07-5','5971 BERKSHIRE WAY, Calgary, Alberta','50alaia@gmail.com',5147934563,'Banking',9,'password');
  1301. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(661,441,'savings',2,1,4355762718);
  1302. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (442,'Monica','20/2/1949','2009-04-12','1806 17TH AVE, Calgary, Alberta','117monica@gmail.com',5147041067,'Banking',9,'password');
  1303. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (443,'Jessie','25/9/1964','2000-11-23','3717 APPAREL WAY, Calgary, Alberta','196jessie@gmail.com',5149325234,'Banking',9,'password');
  1304. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(662,443,'savings',2,1,6569229708);
  1305. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(663,443,'checking',1,1,4425164995);
  1306. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (444,'Izabella','21/3/1950','1955-04-13','6491 BITTING AVE, Calgary, Alberta','87izabella@gmail.com',5144391741,'Banking',9,'password');
  1307. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(664,444,'savings',2,1,8664197862);
  1308. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(665,444,'savings',2,1,7474768285);
  1309. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(666,444,'savings',2,1,1525066292);
  1310. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (445,'Zahra','14/4/1909','1956-01-24','3218 AMADOR ST, Calgary, Alberta','12zahra@gmail.com',5147040649,'Banking',9,'password');
  1311. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(667,445,'checking',1,2,1995356153);
  1312. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(668,445,'checking',1,2,1751118784);
  1313. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(669,445,'savings',2,2,5774400618);
  1314. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (446,'Evelyn','8/3/1950','1967-07-17','6355 04TH AVE, Calgary, Alberta','95evelyn@gmail.com',5143047379,'Banking',9,'password');
  1315. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (447,'Ariya','4/10/1998','1958-05-1','7545 BEAUMONT AVE, Calgary, Alberta','84ariya@gmail.com',5141129350,'Banking',9,'password');
  1316. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(670,447,'savings',2,2,3694045503);
  1317. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(671,447,'checking',1,2,8519173955);
  1318. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(672,447,'checking',1,2,1387210514);
  1319. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (448,'Belle','9/6/1949','2018-10-7','9280 BLUXOME ST, Calgary, Alberta','208belle@gmail.com',5145646361,'Banking',9,'password');
  1320. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (449,'Pearl','19/10/1916','1994-08-5','2771 BAYWOOD CT, Calgary, Alberta','94pearl@gmail.com',5142480806,'Banking',9,'password');
  1321. insert into branch (id, location, phone, fax, openingDate, managerId, serviceId) values (10,'9533 06TH HP AVE, Calgary, Alberta',5146767309,18002095765,'1996-02-28',190,3);
  1322. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (190, 'Branch Manager','Emily','1492 06TH TI ST, Hamilton, Ontario','1981-5-22',238429,'131emily@bank.com',5143306437,'Managment',10);
  1323. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (191,'Financial Analyst','Rylie','2521 BRYANT ST, Ottawa–Gatineau, Ontario/Quebec','1956-11-21','55123','7rylie@bank.com',5147232745,'Banking',10);
  1324. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (192,'Financial Analyst','Willow','7651 24TH ST, Ottawa–Gatineau, Ontario/Quebec','1981-11-23','102525','124willow@bank.com',5146983995,'Banking',10);
  1325. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (193,'Financial Analyst','Annabella','4357 BLAKE ST, Ottawa–Gatineau, Ontario/Quebec','1980-03-16','110354','162annabella@bank.com',5140322579,'Banking',10);
  1326. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (194,'Financial Analyst','Emersyn','9227 41ST AVE, Ottawa–Gatineau, Ontario/Quebec','1952-04-26','85247','211emersyn@bank.com',5146961989,'Banking',10);
  1327. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (195,'Financial Analyst','Jocelyn','9412 BRUMISS TER, Ottawa–Gatineau, Ontario/Quebec','1990-01-27','105776','17jocelyn@bank.com',5149983316,'Banking',10);
  1328. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (196,'Financial Analyst','Zara','4317 BUCKINGHAM WAY, Ottawa–Gatineau, Ontario/Quebec','2013-08-17','115354','249zara@bank.com',5142366128,'Banking',10);
  1329. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (197,'Financial Analyst','Joy','9064 AMATURY LOOP, Ottawa–Gatineau, Ontario/Quebec','1994-05-12','54466','211joy@bank.com',5149138113,'Banking',10);
  1330. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (198,'Financial Analyst','Miranda','7341 BORICA ST, Ottawa–Gatineau, Ontario/Quebec','1982-12-12','55292','27miranda@bank.com',5141174228,'Banking',10);
  1331. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (199,'Financial Analyst','Heidi','4767 BEAUMONT AVE, Ottawa–Gatineau, Ontario/Quebec','1999-04-1','84635','92heidi@bank.com',5145144490,'Banking',10);
  1332. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (200,'Financial Analyst','Kate','3798 ARGONAUT AVE, Ottawa–Gatineau, Ontario/Quebec','1981-01-9','106508','199kate@bank.com',5147571011,'Banking',10);
  1333. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (201,'Bank Teller','Jordyn','5747 BATTERY CAULFIELD RD, Ottawa–Gatineau, Ontario/Quebec','1988-09-14','88360','263jordyn@bank.com',5144648670,'Banking',10);
  1334. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (202,'Bank Teller','Raelyn','9652 CHASE CT, Ottawa–Gatineau, Ontario/Quebec','1971-12-14','111897','216raelyn@bank.com',5141163814,'Banking',10);
  1335. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (203,'Bank Teller','Lexi','76 ALANA WAY, Ottawa–Gatineau, Ontario/Quebec','1961-11-12','115316','181lexi@bank.com',5148303706,'Banking',10);
  1336. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (204,'Bank Teller','Tatum','6796 CASTILLO ST, Ottawa–Gatineau, Ontario/Quebec','1955-02-17','94841','146tatum@bank.com',5140918032,'Banking',10);
  1337. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (205,'Bank Teller','Penelope','7085 ACORN ALY, Ottawa–Gatineau, Ontario/Quebec','1994-09-5','82164','266penelope@bank.com',5146332667,'Banking',10);
  1338. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (206,'Loan Officer','Amber','1602 ATALAYA TER, Ottawa–Gatineau, Ontario/Quebec','1959-01-21','94610','44amber@bank.com',5144974280,'Banking',10);
  1339. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (207,'Loan Officer','Ariana','7376 BRIGHT ST, Ottawa–Gatineau, Ontario/Quebec','1984-05-23','74881','41ariana@bank.com',5140114037,'Banking',10);
  1340. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (208,'Loan Officer','Raelynn','9912 ANZA ST, Ottawa–Gatineau, Ontario/Quebec','1996-07-28','62691','155raelynn@bank.com',5148530671,'Banking',10);
  1341. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (209,'Loan Officer','Sarah','882 BERTHA LN, Ottawa–Gatineau, Ontario/Quebec','1967-08-1','64658','198sarah@bank.com',5141855274,'Banking',10);
  1342. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (210,'Loan Officer','Brynn','8313 27TH ST, Ottawa–Gatineau, Ontario/Quebec','1974-04-16','64550','167brynn@bank.com',5146673558,'Banking',10);
  1343. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (450,'Cataleya','10/3/1902','1993-03-4','5416 BRADY ST, Ottawa–Gatineau, Ontario/Quebec','114cataleya@gmail.com',5142733076,'Banking',10,'password');
  1344. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(673,450,'checking',1,2,4795240457);
  1345. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (451,'Lilah','30/4/1919','2011-09-21','5074 ALTA ST, Ottawa–Gatineau, Ontario/Quebec','116lilah@gmail.com',5146074193,'Banking',10,'password');
  1346. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(674,451,'savings',2,1,3193342211);
  1347. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(675,451,'checking',1,1,800863988);
  1348. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(676,451,'checking',1,1,1040757640);
  1349. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (452,'Lucia','8/6/1971','1994-08-13','980 CALGARY ST, Ottawa–Gatineau, Ontario/Quebec','133lucia@gmail.com',5145281925,'Banking',10,'password');
  1350. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(677,452,'checking',1,1,7512578748);
  1351. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (453,'Danna','23/2/1967','1958-03-1','2422 AVERY ST, Ottawa–Gatineau, Ontario/Quebec','193danna@gmail.com',5149281554,'Banking',10,'password');
  1352. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(678,453,'savings',2,1,1572301410);
  1353. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(679,453,'checking',1,1,273610062);
  1354. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (454,'Harleigh','11/12/1996','1993-03-21','7142 ANSON PL, Ottawa–Gatineau, Ontario/Quebec','136harleigh@gmail.com',5146356925,'Banking',10,'password');
  1355. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(680,454,'checking',1,1,6869758054);
  1356. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (455,'Dakota','5/3/1939','1950-10-27','9362 BELLES ST, Ottawa–Gatineau, Ontario/Quebec','164dakota@gmail.com',5140602468,'Banking',10,'password');
  1357. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (456,'Lana','22/1/1928','1959-07-26','7871 BRET HARTE TER, Ottawa–Gatineau, Ontario/Quebec','156lana@gmail.com',5145321012,'Banking',10,'password');
  1358. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(681,456,'checking',1,1,200722452);
  1359. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(682,456,'checking',1,1,958165487);
  1360. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (457,'Laney','28/5/1992','1961-02-4','2649 ARMORY DR, Ottawa–Gatineau, Ontario/Quebec','101laney@gmail.com',5140277538,'Banking',10,'password');
  1361. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(683,457,'checking',1,1,2363873491);
  1362. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(684,457,'checking',1,1,8174368284);
  1363. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (458,'Deborah','13/12/1901','1986-12-1','9644 01ST ST, Ottawa–Gatineau, Ontario/Quebec','36deborah@gmail.com',5147151835,'Banking',10,'password');
  1364. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(685,458,'savings',2,2,1882509830);
  1365. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(686,458,'checking',1,2,8406223269);
  1366. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (459,'Zendaya','24/7/1928','1954-08-16','5129 CALEDONIA ST, Ottawa–Gatineau, Ontario/Quebec','203zendaya@gmail.com',5144554150,'Banking',10,'password');
  1367. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(687,459,'checking',1,2,2188350465);
  1368. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (460,'Aliyah','24/6/1967','2001-03-26','771 BALANCE ST, Ottawa–Gatineau, Ontario/Quebec','42aliyah@gmail.com',5142773537,'Banking',10,'password');
  1369. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(688,460,'checking',1,2,75358779);
  1370. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (461,'Rosemary','30/2/1911','1991-12-28','3186 BERRY ST, Ottawa–Gatineau, Ontario/Quebec','49rosemary@gmail.com',5140081358,'Banking',10,'password');
  1371. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (462,'Ivy','30/3/1906','2014-02-8','5489 ATTRIDGE ALY, Ottawa–Gatineau, Ontario/Quebec','42ivy@gmail.com',5142722824,'Banking',10,'password');
  1372. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (463,'Naya','2/4/1947','1982-07-22','3406 ASHBURY ST, Ottawa–Gatineau, Ontario/Quebec','162naya@gmail.com',5140426352,'Banking',10,'password');
  1373. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(689,463,'savings',2,2,3699629910);
  1374. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (464,'Wren','24/6/1948','2004-10-24','4065 32ND AVE, Ottawa–Gatineau, Ontario/Quebec','154wren@gmail.com',5144645002,'Banking',10,'password');
  1375. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(690,464,'checking',1,1,4775225412);
  1376. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (465,'Cameron','2/2/1937','1957-04-4','7737 ALERT ALY, Ottawa–Gatineau, Ontario/Quebec','250cameron@gmail.com',5147576172,'Banking',10,'password');
  1377. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(691,465,'savings',2,2,2656376978);
  1378. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(692,465,'checking',1,2,2846247914);
  1379. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(693,465,'checking',1,2,2626858461);
  1380. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (466,'Johanna','4/4/1920','2015-05-8','8378 C ST, Ottawa–Gatineau, Ontario/Quebec','177johanna@gmail.com',5141091952,'Banking',10,'password');
  1381. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(694,466,'savings',2,1,9858318170);
  1382. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(695,466,'checking',1,1,6468301927);
  1383. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(696,466,'savings',2,1,2649859022);
  1384. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (467,'Addisyn','19/2/1911','1990-11-22','7060 30TH ST, Ottawa–Gatineau, Ontario/Quebec','198addisyn@gmail.com',5142085830,'Banking',10,'password');
  1385. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(697,467,'checking',1,1,1442781539);
  1386. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(698,467,'checking',1,1,4215214924);
  1387. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(699,467,'checking',1,1,9973603907);
  1388. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (468,'Juniper','29/12/1924','1974-11-2','9834 AMBER DR, Ottawa–Gatineau, Ontario/Quebec','242juniper@gmail.com',5143876891,'Banking',10,'password');
  1389. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (469,'Nayeli','6/4/1984','2009-03-4','3146 21ST ST, Ottawa–Gatineau, Ontario/Quebec','103nayeli@gmail.com',5147263571,'Banking',10,'password');
  1390. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (470,'Carla','9/9/1990','1992-12-13','2406 CENTURY PL, Ottawa–Gatineau, Ontario/Quebec','251carla@gmail.com',5148214344,'Banking',10,'password');
  1391. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(700,470,'checking',1,1,4463669051);
  1392. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (471,'Lizbeth','1/9/1916','1969-04-5','3461 BEDFORD PL, Ottawa–Gatineau, Ontario/Quebec','153lizbeth@gmail.com',5149381029,'Banking',10,'password');
  1393. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(701,471,'checking',1,1,9734673043);
  1394. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(702,471,'checking',1,1,978428581);
  1395. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (472,'Livia','13/12/1944','1965-07-3','7966 ANDREW ST, Ottawa–Gatineau, Ontario/Quebec','67livia@gmail.com',5140327341,'Banking',10,'password');
  1396. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(703,472,'checking',1,2,1028908425);
  1397. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(704,472,'savings',2,2,1685171749);
  1398. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (473,'Ashley','7/5/1978','2011-07-13','4123 AERIAL WAY, Ottawa–Gatineau, Ontario/Quebec','160ashley@gmail.com',5147733411,'Banking',10,'password');
  1399. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(705,473,'savings',2,2,4597525398);
  1400. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(706,473,'savings',2,2,5342537828);
  1401. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(707,473,'savings',2,2,2516163653);
  1402. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (474,'Lucille','25/3/1901','1957-06-27','4851 ALBION ST, Ottawa–Gatineau, Ontario/Quebec','126lucille@gmail.com',5147215801,'Banking',10,'password');
  1403. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(708,474,'checking',1,1,2161456005);
  1404. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (475,'Danielle','5/5/1979','2008-08-5','7433 BROTHERHOOD WAY, Ottawa–Gatineau, Ontario/Quebec','57danielle@gmail.com',5145070259,'Banking',10,'password');
  1405. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (476,'Kadence','13/7/1971','1983-06-28','1378 BACON ST, Ottawa–Gatineau, Ontario/Quebec','18kadence@gmail.com',5144449350,'Banking',10,'password');
  1406. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(709,476,'savings',2,1,2261396287);
  1407. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(710,476,'checking',1,1,760673779);
  1408. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (477,'Anne','8/9/1904','1958-12-20','318 21ST ST, Ottawa–Gatineau, Ontario/Quebec','201anne@gmail.com',5144823607,'Banking',10,'password');
  1409. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (478,'Maliyah','2/11/1960','2010-03-13','6825 13TH TI ST, Ottawa–Gatineau, Ontario/Quebec','37maliyah@gmail.com',5142264808,'Banking',10,'password');
  1410. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(711,478,'savings',2,1,1070315316);
  1411. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(712,478,'savings',2,1,5496306567);
  1412. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(713,478,'checking',1,1,8736153639);
  1413. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (479,'Brianna','1/6/1964','2016-01-18','916 BIRCHWOOD CT, Ottawa–Gatineau, Ontario/Quebec','266brianna@gmail.com',5148734962,'Banking',10,'password');
  1414. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(714,479,'savings',2,2,8297106038);
  1415. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (480,'Addilynn','22/5/1999','1953-11-20','7662 13TH TI ST, Ottawa–Gatineau, Ontario/Quebec','73addilynn@gmail.com',5149585368,'Banking',10,'password');
  1416. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (481,'Rachel','19/11/1955','2001-05-23','9380 ARMISTEAD RD, Ottawa–Gatineau, Ontario/Quebec','131rachel@gmail.com',5140137262,'Banking',10,'password');
  1417. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (482,'Landry','23/9/1908','1989-04-22','2036 BREEN PL, Ottawa–Gatineau, Ontario/Quebec','140landry@gmail.com',5147298957,'Banking',10,'password');
  1418. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(715,482,'checking',1,1,1458100335);
  1419. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (483,'Allyson','9/9/1910','1957-06-18','8948 BEDFORD PL, Ottawa–Gatineau, Ontario/Quebec','164allyson@gmail.com',5141352887,'Banking',10,'password');
  1420. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (484,'Isla','5/11/1936','1996-04-15','9022 BANNAN PL, Ottawa–Gatineau, Ontario/Quebec','194isla@gmail.com',5144964471,'Banking',10,'password');
  1421. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(716,484,'savings',2,2,3507360267);
  1422. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(717,484,'savings',2,2,1910203500);
  1423. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(718,484,'savings',2,2,510346365);
  1424. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (485,'Dorothy','20/8/1966','2003-08-5','9231 CASTRO ST, Ottawa–Gatineau, Ontario/Quebec','161dorothy@gmail.com',5147211486,'Banking',10,'password');
  1425. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (486,'Wren','8/1/1955','1997-09-11','2207 BLAIR TER, Ottawa–Gatineau, Ontario/Quebec','237wren@gmail.com',5148669185,'Banking',10,'password');
  1426. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(719,486,'savings',2,2,5192746106);
  1427. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(720,486,'checking',1,2,7882208122);
  1428. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (487,'Anniston','24/10/1942','1952-03-18','810 BIGLER AVE, Ottawa–Gatineau, Ontario/Quebec','176anniston@gmail.com',5146308898,'Banking',10,'password');
  1429. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (488,'Charleigh','17/9/1975','2005-12-17','4648 02ND AVE, Ottawa–Gatineau, Ontario/Quebec','246charleigh@gmail.com',5144982176,'Banking',10,'password');
  1430. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(721,488,'savings',2,1,3185707241);
  1431. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (489,'Presley','28/1/1925','1957-02-5','6064 09TH TI ST, Ottawa–Gatineau, Ontario/Quebec','138presley@gmail.com',5144507478,'Banking',10,'password');
  1432. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(722,489,'checking',1,1,4140390656);
  1433. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (490,'Myra','17/4/1970','1952-12-24','3050 BELMONT AVE, Ottawa–Gatineau, Ontario/Quebec','149myra@gmail.com',5143941335,'Banking',10,'password');
  1434. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (491,'Maria','15/6/1936','1975-10-24','4864 10TH TI ST, Ottawa–Gatineau, Ontario/Quebec','162maria@gmail.com',5140558644,'Banking',10,'password');
  1435. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(723,491,'checking',1,2,3544791546);
  1436. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(724,491,'checking',1,2,3273288298);
  1437. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(725,491,'savings',2,2,3470093756);
  1438. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (492,'Shiloh','3/7/1925','1990-01-10','6771 BASS CT, Ottawa–Gatineau, Ontario/Quebec','11shiloh@gmail.com',5146473059,'Banking',10,'password');
  1439. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (493,'Heather','28/8/1999','2008-05-26','3800 CASA WAY, Ottawa–Gatineau, Ontario/Quebec','122heather@gmail.com',5146724628,'Banking',10,'password');
  1440. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(726,493,'savings',2,1,1870964808);
  1441. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(727,493,'checking',1,1,2889152978);
  1442. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(728,493,'checking',1,1,2433859306);
  1443. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (494,'Royal','8/10/1907','1969-03-4','4914 ALBATROSS CT, Ottawa–Gatineau, Ontario/Quebec','76royal@gmail.com',5145507584,'Banking',10,'password');
  1444. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(729,494,'checking',1,1,3311267546);
  1445. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(730,494,'savings',2,1,3854003140);
  1446. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(731,494,'savings',2,1,735856678);
  1447. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (495,'Elaine','27/1/1989','1986-06-15','4430 BLACK PL, Ottawa–Gatineau, Ontario/Quebec','89elaine@gmail.com',5147450243,'Banking',10,'password');
  1448. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (496,'Melina','26/6/1977','1961-03-15','4667 BEALE ST, Ottawa–Gatineau, Ontario/Quebec','40melina@gmail.com',5147682809,'Banking',10,'password');
  1449. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(732,496,'checking',1,1,8844105040);
  1450. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(733,496,'checking',1,1,943551452);
  1451. insert into account (accountNum, clientId, type, interestRateId, chargePlanId, balance) values(734,496,'savings',2,1,2533118562);
  1452. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (497,'Leilani','4/4/1962','1961-05-19','8864 BANNOCK ST, Ottawa–Gatineau, Ontario/Quebec','124leilani@gmail.com',5141890257,'Banking',10,'password');
  1453. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (498,'Jane','18/11/1963','1957-10-12','8428 02ND AVE, Ottawa–Gatineau, Ontario/Quebec','175jane@gmail.com',5140819051,'Banking',10,'password');
  1454. insert into client (id, name, dOB, joiningDate, address, email, phone, category, branchId, password) values (499,'Mckinley','12/5/1921','1971-08-22','7778 06TH HP AVE, Ottawa–Gatineau, Ontario/Quebec','47mckinley@gmail.com',5146790816,'Banking',10,'password');
  1455. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (211, 'President','Johnny','12800 rue sherbrooke, Montreal, Qc','1974-9-15',1,'president@bank.com',5140000000,'managment',1);
  1456. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (212, 'GM of Banking','Ben','18030 rue sherbrooke, Montreal, Qc','1974-9-15',1,'gmb@bank.com',5140000000,'managment',1);
  1457. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (213, 'GM of Investment','Linda','18003 rue sherbrooke, Montreal, Qc','1974-9-15',1,'gminv@bank.com',5140000000,'managment',1);
  1458. insert into employee (id, title, name, address, startDate, salary, email, phone, category, branchID) values (214, 'GM of Insurance','Charlotte','18010 rue sherbrooke, Montreal, Qc','1974-9-15',1,'gmins@bank.com',5140000000,'managment',1);
  1459. insert into bank (bankName, presidentId, bankingGMId, investmentGMId, insuranceGMId) values ('BKCAJ Bank',211, 212, 213, 214);
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!