API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jan 21st, 2018
92
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 220.17 KB | None | 0 0
raw download clone embed print report
  1. -- This file contains the questions and queries for the assignment of Database 1718.
  2.  
  3. /*
  4. Course: INFANL02-2 , Introduction to Database , 1718
  5. Assignment 2
  6. Student1: Tim, Lampers ; 0939714 , Class INF1B
  7. Student2: N/A
  8. */
  9. -- SQL commands to create tables
  10. -- write the commands here
  11.  
  12. CREATE TABLE teacher(bsn char(15) primary key, name varchar(20), surname varchar(20), salary real);
  13. CREATE TABLE course(course_code varchar(15) primary key, course_name varchar(20), study_points integer);
  14. CREATE TABLE student(student_id char(15) primary key, bsn char(11), name varchar(20), surname varchar(20), enrollment_year integer);
  15. CREATE TABLE study_program(course_program varchar(15) primary key, level varchar(20), duration integer);
  16. CREATE TABLE assignment(a_code varchar(15), grade bool,published_year integer, published_week integer, course_id varchar(10) references course(course_code) on delete cascade, primary key(a_code, course_id));
  17. CREATE TABLE design(bsn char(15) references teacher(bsn), course_code varchar(10) references course(course_code), primary key(bsn, course_code));
  18. CREATE TABLE review(bsn char(15) references teacher(bsn), course_code varchar(10) references course(course_code), primary key(bsn, course_code));
  19. CREATE TABLE teach(bsn char(15) references teacher(bsn), course_code varchar(10) references course(course_code), student_id char(11) references student(student_id), primary key(bsn, course_code, student_id));
  20. CREATE TABLE completed(student_id char(15) primary key references student(student_id), course_program varchar(10) references study_program(course_program));
  21. CREATE TABLE are_given(bsn char(15), a_code varchar(10), course_code varchar(10), primary key(bsn, a_code, course_code), foreign key(bsn)references student, foreign key(a_code, course_code) references assignment);
  22. CREATE TABLE work_on(bsn char(15), a_code varchar(10), course_code varchar(10), primary key(bsn, a_code, course_code), foreign key(bsn) references teacher, foreign key(a_code, course_code) references assignment);
  23. CREATE TABLE requirement(required_a_code varchar(10), is_required_a_code varchar(10), required_course_code varchar(10), is_required_course_code varchar(10),
  24. primary key(required_a_code, is_required_a_code, required_course_code, is_required_course_code),
  25. foreign key(required_a_code, required_course_code) references assignment(a_code, course_id),
  26. foreign key(is_required_a_code, is_required_course_code) references assignment(a_code, course_id));
  27.  
  28.  
  29. alter table teacher add column scale integer;
  30. ALTER TABLE teacher ADD constraint checkScale check (scale >= 5 and scale <= 13);
  31. ALTER TABLE teacher ADD constraint checkSalary check (salary >= (10 * scale) AND salary <= (35 * scale));
  32.  
  33. -- SQL commands to insert values
  34. -- write the commands here
  35.  
  36. --Teacher. BSN, fistname, lastname, salary, scale.
  37.  
  38. INSERT INTO teacher VALUES('12345678922', 'Flor', 'Farrell', '300', '10');
  39. INSERT INTO teacher VALUES('12345678923', 'Colleen', 'Causby', '350', '12');
  40. INSERT INTO teacher VALUES('12345678924', 'Leigha', 'Loredo', '300', '11');
  41. INSERT INTO teacher VALUES('12345678925', 'Tyrone', 'Thistle', '350', '10');
  42. INSERT INTO teacher VALUES('12345678926', 'Bea', 'Brabham', '250', '10');
  43. INSERT INTO teacher VALUES('12345678927', 'Shalanda', 'Sisto', '200', '10');
  44. INSERT INTO teacher VALUES('12345678928', 'Wynell', 'Wetherington', '300', '11');
  45. INSERT INTO teacher VALUES('12345678929', 'Phyllis', 'Plante', '300', '10');
  46. INSERT INTO teacher VALUES('12345678930', 'Donella', 'Divers', '230', '10');
  47. INSERT INTO teacher VALUES('12345678931', 'Rubin', 'Royston', '130', '9');
  48. INSERT INTO teacher VALUES('12345678932', 'Frederik', 'Fred', '130', '9');
  49.  
  50. --Student. ID, BSN, firstname, lastname, enrollment year.
  51.  
  52. INSERT INTO student VALUES('98765432199', '98345678923', 'Becky', 'Bidwell', '2014');
  53. INSERT INTO student VALUES('98765432198', '98345678924', 'Shenna', 'Sindelar', '2014');
  54. INSERT INTO student VALUES('98765432197', '98345678925', 'Sherell', 'Slusher', '2016');
  55. INSERT INTO student VALUES('98765432196', '98345678926', 'Kandice', 'Kamm', '2015');
  56. INSERT INTO student VALUES('98765432195', '98345678927', 'Kary', 'Kirby', '2014');
  57. INSERT INTO student VALUES('98765432194', '98345678928', 'Lacresha', 'Leisure', '2015');
  58. INSERT INTO student VALUES('98765432193', '98345678929', 'Roseann', 'Rapier', '2015');
  59. INSERT INTO student VALUES('98765432192', '98345678930', 'Cecila', 'Cottle', '2015');
  60. INSERT INTO student VALUES('98765432191', '98345678931', 'Jettie', 'Juneau', '2014');
  61. INSERT INTO student VALUES('98765432190', '98345678932', 'Eden', 'Eden', '2014');
  62. INSERT INTO student VALUES('98765432189', '98345678933', 'Hannelore', 'Hinrichs', '2016');
  63. INSERT INTO student VALUES('98765432188', '98345678934', 'Levi', 'Laguna', '2016');
  64. INSERT INTO student VALUES('98765432187', '98345678935', 'Eugenie', 'Endsley', '2016');
  65. INSERT INTO student VALUES('98765432186', '98345678936', 'Raisa', 'Revelle', '2015');
  66. INSERT INTO student VALUES('98765432185', '98345678937', 'Nathaniel', 'Nick', '2016');
  67. INSERT INTO student VALUES('98765432184', '98345678938', 'Lakenya', 'Levine', '2015');
  68. INSERT INTO student VALUES('98765432183', '98345678939', 'Malinda', 'Mccutcheon', '2014');
  69. INSERT INTO student VALUES('98765432182', '98345678940', 'Cinderella', 'Caplan', '2015');
  70. INSERT INTO student VALUES('98765432181', '98345678941', 'Larae', 'Losee', '2016');
  71. INSERT INTO student VALUES('98765432180', '98345678942', 'Margrett', 'Marler', '2014');
  72. INSERT INTO student VALUES('98765432179', '98345678943', 'Chaya', 'Caddell', '2016');
  73. INSERT INTO student VALUES('98765432178', '98345678944', 'Felecia', 'Farrington', '2016');
  74. INSERT INTO student VALUES('98765432177', '98345678945', 'Angelique', 'Ahern', '2015');
  75. INSERT INTO student VALUES('98765432176', '98345678946', 'Delena', 'Dapolito', '2015');
  76. INSERT INTO student VALUES('98765432175', '98345678947', 'Glenna', 'Gobel', '2014');
  77. INSERT INTO student VALUES('98765432174', '98345678948', 'Corine', 'Capetillo', '2015');
  78. INSERT INTO student VALUES('98765432173', '98345678949', 'Dorris', 'Dengler', '2014');
  79. INSERT INTO student VALUES('98765432172', '98345678950', 'Sergio', 'Steinhauser', '2015');
  80. INSERT INTO student VALUES('98765432171', '98345678951', 'Leia', 'Lobato', '2016');
  81. INSERT INTO student VALUES('98765432170', '98345678952', 'Deadra', 'Dansie', '2014');
  82. INSERT INTO student VALUES('98765432169', '98345678953', 'Peggy', 'Prouty', '2014');
  83. INSERT INTO student VALUES('98765432168', '98345678954', 'Cyril', 'Cueto', '2015');
  84. INSERT INTO student VALUES('98765432167', '98345678955', 'Edyth', 'Ehlert', '2014');
  85. INSERT INTO student VALUES('98765432166', '98345678956', 'Ronna', 'Roses', '2014');
  86. INSERT INTO student VALUES('98765432165', '98345678957', 'Ramon', 'Rish', '2016');
  87. INSERT INTO student VALUES('98765432164', '98345678958', 'Eli', 'Epperly', '2015');
  88. INSERT INTO student VALUES('98765432163', '98345678959', 'Noelle', 'Noles', '2015');
  89. INSERT INTO student VALUES('98765432162', '98345678960', 'Ken', 'Kuether', '2014');
  90. INSERT INTO student VALUES('98765432161', '98345678961', 'Felisa', 'Fenstermaker', '2016');
  91. INSERT INTO student VALUES('98765432160', '98345678962', 'Toby', 'Testani', '2014');
  92. INSERT INTO student VALUES('98765432159', '98345678963', 'Maile', 'Manzi', '2015');
  93. INSERT INTO student VALUES('98765432158', '98345678964', 'Raymonde', 'Romanowski', '2016');
  94. INSERT INTO student VALUES('98765432157', '98345678965', 'Scot', 'Sisneros', '2015');
  95. INSERT INTO student VALUES('98765432156', '98345678966', 'Edmond', 'Elsey', '2015');
  96. INSERT INTO student VALUES('98765432155', '98345678967', 'Ressie', 'Rosenberry', '2014');
  97. INSERT INTO student VALUES('98765432154', '98345678968', 'Miles', 'Merkel', '2014');
  98. INSERT INTO student VALUES('98765432153', '98345678969', 'Regan', 'Renfro', '2015');
  99. INSERT INTO student VALUES('98765432152', '98345678970', 'Edgar', 'Eddington', '2015');
  100. INSERT INTO student VALUES('98765432151', '98345678971', 'Sherrell', 'Stanwood', '2016');
  101. INSERT INTO student VALUES('98765432150', '98345678972', 'Bridget', 'Bellantoni', '2015');
  102. INSERT INTO student VALUES('98765432149', '98345678973', 'Steve', 'Shin', '2014');
  103. INSERT INTO student VALUES('98765432148', '98345678974', 'Xiao', 'Xu', '2016');
  104. INSERT INTO student VALUES('98765432147', '98345678975', 'Grover', 'Gordillo', '2014');
  105. INSERT INTO student VALUES('98765432146', '98345678976', 'Anastacia', 'Abasta', '2014');
  106. INSERT INTO student VALUES('98765432145', '98345678977', 'Cristal', 'Chicoine', '2014');
  107. INSERT INTO student VALUES('98765432144', '98345678978', 'Vashti', 'Voelker', '2015');
  108. INSERT INTO student VALUES('98765432143', '98345678979', 'Karine', 'Kruchten', '2015');
  109. INSERT INTO student VALUES('98765432142', '98345678980', 'Chantell', 'Comfort', '2015');
  110. INSERT INTO student VALUES('98765432141', '98345678981', 'Hiram', 'Heuser', '2016');
  111. INSERT INTO student VALUES('98765432140', '98345678982', 'Armandina', 'Asencio', '2014');
  112. INSERT INTO student VALUES('98765432139', '98345678983', 'Sal', 'Sherron', '2016');
  113. INSERT INTO student VALUES('98765432138', '98345678984', 'Chandra', 'Canon', '2014');
  114. INSERT INTO student VALUES('98765432137', '98345678985', 'Alexia', 'Ahlquist', '2015');
  115. INSERT INTO student VALUES('98765432136', '98345678986', 'Elmira', 'Eugene', '2014');
  116. INSERT INTO student VALUES('98765432135', '98345678987', 'Monte', 'Marie', '2014');
  117. INSERT INTO student VALUES('98765432134', '98345678988', 'Grisel', 'Gisi', '2016');
  118. INSERT INTO student VALUES('98765432133', '98345678989', 'Rebecka', 'Randall', '2014');
  119. INSERT INTO student VALUES('98765432132', '98345678990', 'Marquis', 'Mcconnaughey', '2015');
  120. INSERT INTO student VALUES('98765432131', '98345678991', 'Livia', 'Levay', '2016');
  121. INSERT INTO student VALUES('98765432130', '98345678992', 'Ariel', 'Ames', '2014');
  122. INSERT INTO student VALUES('98765432129', '98345678993', 'Sonny', 'Say', '2015');
  123. INSERT INTO student VALUES('98765432128', '98345678994', 'Rosalina', 'Ripley', '2014');
  124. INSERT INTO student VALUES('98765432127', '98345678995', 'Gillian', 'Grow', '2015');
  125. INSERT INTO student VALUES('98765432126', '98345678996', 'Lawanda', 'Lyman', '2014');
  126. INSERT INTO student VALUES('98765432125', '98345678997', 'Leanne', 'Layfield', '2014');
  127. INSERT INTO student VALUES('98765432124', '98345678998', 'Madeleine', 'Marconi', '2014');
  128. INSERT INTO student VALUES('98765432123', '98345678999', 'Kasi', 'Kohr', '2014');
  129. INSERT INTO student VALUES('98765432122', '98345679000', 'Misti', 'Markwell', '2015');
  130. INSERT INTO student VALUES('98765432121', '98345679001', 'Lue', 'Lino', '2015');
  131. INSERT INTO student VALUES('98765432120', '98345679002', 'Elenore', 'Elwell', '2015');
  132. INSERT INTO student VALUES('98765432119', '98345679003', 'Ian', 'Iglesias', '2016');
  133. INSERT INTO student VALUES('98765432118', '98345679004', 'Catina', 'Currence', '2016');
  134. INSERT INTO student VALUES('98765432117', '98345679005', 'Isabella', 'Isenberg', '2014');
  135. INSERT INTO student VALUES('98765432116', '98345679006', 'Fredrick', 'Fillion', '2016');
  136. INSERT INTO student VALUES('98765432115', '98345679007', 'Eduardo', 'Ellender', '2015');
  137. INSERT INTO student VALUES('98765432114', '98345679008', 'Eda', 'Ernst', '2016');
  138. INSERT INTO student VALUES('98765432113', '98345679009', 'Ezra', 'Evers', '2014');
  139. INSERT INTO student VALUES('98765432112', '98345679010', 'Lesha', 'Lasker', '2016');
  140. INSERT INTO student VALUES('98765432111', '98345679011', 'Shan', 'Sobieski', '2015');
  141. INSERT INTO student VALUES('98765432110', '98345679012', 'Laurene', 'Lau', '2016');
  142. INSERT INTO student VALUES('98765432109', '98345679013', 'Brad', 'Boomer', '2015');
  143. INSERT INTO student VALUES('98765432108', '98345679014', 'Evangeline', 'Eckart', '2014');
  144. INSERT INTO student VALUES('98765432107', '98345679015', 'Susana', 'Simental', '2016');
  145. INSERT INTO student VALUES('98765432106', '98345679016', 'Aiko', 'Albertson', '2016');
  146. INSERT INTO student VALUES('98765432105', '98345679017', 'Evonne', 'Eiler', '2016');
  147. INSERT INTO student VALUES('98765432104', '98345679018', 'Devona', 'Dearborn', '2016');
  148. INSERT INTO student VALUES('98765432103', '98345679019', 'Christina', 'Crowson', '2015');
  149. INSERT INTO student VALUES('98765432102', '98345679020', 'Elvira', 'Ellers', '2016');
  150. INSERT INTO student VALUES('98765432101', '98345679021', 'Su', 'Skipworth', '2015');
  151. INSERT INTO student VALUES('98765432100', '98345679022', 'Hal', 'Hose', '2014');
  152. INSERT INTO student VALUES('98765432099', '98345679023', 'Sherill', 'Schneiderman', '2015');
  153. INSERT INTO student VALUES('98765432098', '98345679024', 'Hayley', 'Hinman', '2015');
  154. INSERT INTO student VALUES('98765432097', '98345679025', 'Nenita', 'Naff', '2014');
  155. INSERT INTO student VALUES('98765432096', '98345679026', 'Oren', 'Osteen', '2015');
  156. INSERT INTO student VALUES('98765432095', '98345679027', 'Zoe', 'Zamarripa', '2015');
  157. INSERT INTO student VALUES('98765432094', '98345679028', 'Ronna', 'Roder', '2016');
  158. INSERT INTO student VALUES('98765432093', '98345679029', 'Tierra', 'Tibbals', '2014');
  159. INSERT INTO student VALUES('98765432092', '98345679030', 'Earlene', 'Eslinger', '2015');
  160. INSERT INTO student VALUES('98765432091', '98345679031', 'Shantelle', 'Shaeffer', '2015');
  161. INSERT INTO student VALUES('98765432090', '98345679032', 'Arlie', 'Arjona', '2015');
  162. INSERT INTO student VALUES('98765432089', '98345679033', 'Marna', 'Mclead', '2016');
  163. INSERT INTO student VALUES('98765432088', '98345679034', 'Fredda', 'Farnum', '2015');
  164. INSERT INTO student VALUES('98765432087', '98345679035', 'Kris', 'Keown', '2014');
  165. INSERT INTO student VALUES('98765432086', '98345679036', 'Malinda', 'Maris', '2015');
  166. INSERT INTO student VALUES('98765432085', '98345679037', 'Joanie', 'Jacobi', '2015');
  167. INSERT INTO student VALUES('98765432084', '98345679038', 'Tamiko', 'Thode', '2015');
  168. INSERT INTO student VALUES('98765432083', '98345679039', 'Reginia', 'Rettig', '2014');
  169. INSERT INTO student VALUES('98765432082', '98345679040', 'Marty', 'Mahle', '2016');
  170. INSERT INTO student VALUES('98765432081', '98345679041', 'Georgette', 'Greene', '2015');
  171. INSERT INTO student VALUES('98765432080', '98345679042', 'Corrin', 'Castruita', '2015');
  172. INSERT INTO student VALUES('98765432079', '98345679043', 'Mignon', 'Maclaren', '2015');
  173. INSERT INTO student VALUES('98765432078', '98345679044', 'Minnie', 'Molton', '2015');
  174. INSERT INTO student VALUES('98765432077', '98345679045', 'Stepanie', 'Steffensmeier', '2015');
  175. INSERT INTO student VALUES('98765432076', '98345679046', 'Thelma', 'Tope', '2014');
  176. INSERT INTO student VALUES('98765432075', '98345679047', 'Tory', 'Troia', '2015');
  177. INSERT INTO student VALUES('98765432074', '98345679048', 'Olene', 'Overton', '2015');
  178. INSERT INTO student VALUES('98765432073', '98345679049', 'Jean', 'Jared', '2016');
  179. INSERT INTO student VALUES('98765432072', '98345679050', 'Scottie', 'Soules', '2014');
  180. INSERT INTO student VALUES('98765432071', '98345679051', 'Maddie', 'Mcmeans', '2015');
  181. INSERT INTO student VALUES('98765432070', '98345679052', 'Jenell', 'Jahns', '2014');
  182. INSERT INTO student VALUES('98765432069', '98345679053', 'Corliss', 'Carillo', '2016');
  183. INSERT INTO student VALUES('98765432068', '98345679054', 'Amy', 'Atkison', '2014');
  184. INSERT INTO student VALUES('98765432067', '98345679055', 'Jake', 'Judon', '2014');
  185. INSERT INTO student VALUES('98765432066', '98345679056', 'Marlin', 'Marsh', '2015');
  186. INSERT INTO student VALUES('98765432065', '98345679057', 'Yoshie', 'Youngren', '2014');
  187. INSERT INTO student VALUES('98765432064', '98345679058', 'Katherin', 'Kolar', '2016');
  188. INSERT INTO student VALUES('98765432063', '98345679059', 'Jettie', 'Jaycox', '2016');
  189. INSERT INTO student VALUES('98765432062', '98345679060', 'Yee', 'Younts', '2015');
  190. INSERT INTO student VALUES('98765432061', '98345679061', 'Trinity', 'Tetzlaff', '2015');
  191. INSERT INTO student VALUES('98765432060', '98345679062', 'Jolanda', 'Jaimes', '2015');
  192. INSERT INTO student VALUES('98765432059', '98345679063', 'Rima', 'Rossbach', '2015');
  193. INSERT INTO student VALUES('98765432058', '98345679064', 'Dion', 'Dudas', '2016');
  194. INSERT INTO student VALUES('98765432057', '98345679065', 'Erick', 'Ellison', '2016');
  195. INSERT INTO student VALUES('98765432056', '98345679066', 'Collette', 'Chand', '2015');
  196. INSERT INTO student VALUES('98765432055', '98345679067', 'Edelmira', 'Eddington', '2014');
  197. INSERT INTO student VALUES('98765432054', '98345679068', 'Oliver', 'Outen', '2016');
  198. INSERT INTO student VALUES('98765432053', '98345679069', 'Lan', 'Lippman', '2014');
  199. INSERT INTO student VALUES('98765432052', '98345679070', 'Karie', 'Kindle', '2014');
  200. INSERT INTO student VALUES('98765432051', '98345679071', 'Armand', 'Angus', '2014');
  201. INSERT INTO student VALUES('98765432050', '98345679072', 'Val', 'Vanderbilt', '2016');
  202.  
  203. --Course. Coursecode, coursename, studypoints
  204. INSERT INTO course VALUES('a_01', 'dev_01', '4');
  205. INSERT INTO course VALUES('a_02', 'dev_02', '4');
  206. INSERT INTO course VALUES('a_03', 'dev_03', '4');
  207. INSERT INTO course VALUES('a_04', 'dev_04', '4');
  208. INSERT INTO course VALUES('b_01', 'ana_01', '4');
  209. INSERT INTO course VALUES('b_02', 'ana_02', '4');
  210. INSERT INTO course VALUES('b_03', 'ana_03', '4');
  211. INSERT INTO course VALUES('b_04', 'ana_04', '4');
  212. INSERT INTO course VALUES('c_01', 'skl_01', '4');
  213. INSERT INTO course VALUES('c_02', 'skl_02', '4');
  214. INSERT INTO course VALUES('c_03', 'skl_03', '4');
  215. INSERT INTO course VALUES('c_04', 'skl_04', '4');
  216. INSERT INTO course VALUES('d_01', 'slc_01', '1');
  217. INSERT INTO course VALUES('d_02', 'slc_02', '1');
  218. INSERT INTO course VALUES('d_03', 'slc_03', '1');
  219. INSERT INTO course VALUES('d_04', 'slc_04', '1');
  220.  
  221. --Study program. Couurseprogram, level, duration.
  222.  
  223. INSERT INTO study_program VALUES('Inf', 'Batchelor', '4');
  224. INSERT INTO study_program VALUES('TI', 'Master', '4');
  225. INSERT INTO study_program VALUES('M&D', 'Master', '10');
  226.  
  227. --Review. RELATIONSHIP. Teacher:BSN and Course:Coursecode.
  228.  
  229. INSERT INTO review VALUES('12345678923', 'a_04');
  230. INSERT INTO review VALUES('12345678925', 'a_03');
  231. INSERT INTO review VALUES('12345678924', 'a_02');
  232. INSERT INTO review VALUES('12345678923', 'a_02');
  233. INSERT INTO review VALUES('12345678922', 'a_01');
  234. INSERT INTO review VALUES('12345678922', 'b_03');
  235. INSERT INTO review VALUES('12345678930', 'b_01');
  236. INSERT INTO review VALUES('12345678928', 'b_02');
  237. INSERT INTO review VALUES('12345678931', 'b_03');
  238. INSERT INTO review VALUES('12345678922', 'b_04');
  239. INSERT INTO review VALUES('12345678922', 'c_02');
  240. INSERT INTO review VALUES('12345678926', 'c_01');
  241. INSERT INTO review VALUES('12345678925', 'c_04');
  242. INSERT INTO review VALUES('12345678923', 'c_04');
  243. INSERT INTO review VALUES('12345678923', 'c_03');
  244. INSERT INTO review VALUES('12345678923', 'd_04');
  245. INSERT INTO review VALUES('12345678927', 'd_04');
  246. INSERT INTO review VALUES('12345678924', 'd_01');
  247. INSERT INTO review VALUES('12345678930', 'd_03');
  248. INSERT INTO review VALUES('12345678925', 'd_02');
  249.  
  250. --Design. RELATIONSHIP. Teacher:BSN and course:Coursecode.
  251.  
  252. INSERT INTO design VALUES('12345678922', 'a_01');
  253. INSERT INTO design VALUES('12345678929', 'a_01');
  254. INSERT INTO design VALUES('12345678923', 'a_02');
  255. INSERT INTO design VALUES('12345678924', 'a_03');
  256. INSERT INTO design VALUES('12345678924', 'a_04');
  257. INSERT INTO design VALUES('12345678923', 'b_03');
  258. INSERT INTO design VALUES('12345678924', 'b_04');
  259. INSERT INTO design VALUES('12345678927', 'b_01');
  260. INSERT INTO design VALUES('12345678923', 'b_02');
  261. INSERT INTO design VALUES('12345678924', 'b_01');
  262. INSERT INTO design VALUES('12345678923', 'c_03');
  263. INSERT INTO design VALUES('12345678926', 'c_04');
  264. INSERT INTO design VALUES('12345678928', 'c_01');
  265. INSERT INTO design VALUES('12345678929', 'c_02');
  266. INSERT INTO design VALUES('12345678925', 'c_01');
  267. INSERT INTO design VALUES('12345678929', 'c_01');
  268. INSERT INTO design VALUES('12345678929', 'd_02');
  269. INSERT INTO design VALUES('12345678930', 'd_04');
  270. INSERT INTO design VALUES('12345678923', 'd_01');
  271. INSERT INTO design VALUES('12345678924', 'd_03');
  272. INSERT INTO design VALUES('12345678927', 'd_04');
  273. INSERT INTO design VALUES('12345678927', 'd_02');
  274.  
  275. --Teach. RELATIONSHIP. Teacher:BSN, Course:Coursecode and Student:ID.
  276. INSERT INTO teach VALUES('12345678928', 'a_03', '98765432198');
  277. INSERT INTO teach VALUES('12345678930', 'a_04', '98765432197');
  278. INSERT INTO teach VALUES('12345678925', 'a_04', '98765432196');
  279. INSERT INTO teach VALUES('12345678925', 'a_01', '98765432195');
  280. INSERT INTO teach VALUES('12345678926', 'a_03', '98765432194');
  281. INSERT INTO teach VALUES('12345678931', 'a_01', '98765432193');
  282. INSERT INTO teach VALUES('12345678927', 'a_01', '98765432192');
  283. INSERT INTO teach VALUES('12345678929', 'a_04', '98765432191');
  284. INSERT INTO teach VALUES('12345678923', 'a_03', '98765432190');
  285. INSERT INTO teach VALUES('12345678924', 'a_01', '98765432189');
  286. INSERT INTO teach VALUES('12345678929', 'a_03', '98765432188');
  287. INSERT INTO teach VALUES('12345678928', 'a_03', '98765432187');
  288. INSERT INTO teach VALUES('12345678925', 'a_02', '98765432186');
  289. INSERT INTO teach VALUES('12345678930', 'a_03', '98765432185');
  290. INSERT INTO teach VALUES('12345678928', 'a_04', '98765432184');
  291. INSERT INTO teach VALUES('12345678929', 'a_03', '98765432183');
  292. INSERT INTO teach VALUES('12345678924', 'a_03', '98765432182');
  293. INSERT INTO teach VALUES('12345678927', 'a_02', '98765432181');
  294. INSERT INTO teach VALUES('12345678930', 'a_04', '98765432180');
  295. INSERT INTO teach VALUES('12345678923', 'a_02', '98765432179');
  296. INSERT INTO teach VALUES('12345678927', 'a_04', '98765432178');
  297. INSERT INTO teach VALUES('12345678930', 'a_04', '98765432177');
  298. INSERT INTO teach VALUES('12345678930', 'a_01', '98765432176');
  299. INSERT INTO teach VALUES('12345678926', 'a_03', '98765432175');
  300. INSERT INTO teach VALUES('12345678928', 'a_03', '98765432174');
  301. INSERT INTO teach VALUES('12345678929', 'a_02', '98765432173');
  302. INSERT INTO teach VALUES('12345678932', 'a_04', '98765432172');
  303. INSERT INTO teach VALUES('12345678923', 'a_02', '98765432171');
  304. INSERT INTO teach VALUES('12345678927', 'a_04', '98765432170');
  305. INSERT INTO teach VALUES('12345678929', 'a_03', '98765432169');
  306. INSERT INTO teach VALUES('12345678930', 'a_01', '98765432168');
  307. INSERT INTO teach VALUES('12345678926', 'a_01', '98765432167');
  308. INSERT INTO teach VALUES('12345678928', 'a_03', '98765432166');
  309. INSERT INTO teach VALUES('12345678928', 'a_01', '98765432165');
  310. INSERT INTO teach VALUES('12345678923', 'a_03', '98765432164');
  311. INSERT INTO teach VALUES('12345678928', 'a_03', '98765432163');
  312. INSERT INTO teach VALUES('12345678924', 'a_01', '98765432162');
  313. INSERT INTO teach VALUES('12345678924', 'a_04', '98765432161');
  314. INSERT INTO teach VALUES('12345678932', 'a_01', '98765432160');
  315. INSERT INTO teach VALUES('12345678929', 'a_01', '98765432159');
  316. INSERT INTO teach VALUES('12345678931', 'a_02', '98765432158');
  317. INSERT INTO teach VALUES('12345678927', 'a_02', '98765432157');
  318. INSERT INTO teach VALUES('12345678925', 'a_04', '98765432156');
  319. INSERT INTO teach VALUES('12345678926', 'a_02', '98765432155');
  320. INSERT INTO teach VALUES('12345678926', 'a_03', '98765432154');
  321. INSERT INTO teach VALUES('12345678926', 'a_02', '98765432153');
  322. INSERT INTO teach VALUES('12345678925', 'a_01', '98765432152');
  323. INSERT INTO teach VALUES('12345678923', 'a_01', '98765432151');
  324. INSERT INTO teach VALUES('12345678926', 'a_03', '98765432150');
  325. INSERT INTO teach VALUES('12345678929', 'a_02', '98765432149');
  326. INSERT INTO teach VALUES('12345678923', 'a_03', '98765432148');
  327. INSERT INTO teach VALUES('12345678925', 'a_02', '98765432147');
  328. INSERT INTO teach VALUES('12345678929', 'a_04', '98765432146');
  329. INSERT INTO teach VALUES('12345678927', 'a_01', '98765432145');
  330. INSERT INTO teach VALUES('12345678929', 'a_02', '98765432144');
  331. INSERT INTO teach VALUES('12345678924', 'a_04', '98765432143');
  332. INSERT INTO teach VALUES('12345678928', 'a_04', '98765432142');
  333. INSERT INTO teach VALUES('12345678927', 'a_02', '98765432141');
  334. INSERT INTO teach VALUES('12345678925', 'a_02', '98765432140');
  335. INSERT INTO teach VALUES('12345678932', 'a_04', '98765432139');
  336. INSERT INTO teach VALUES('12345678926', 'a_04', '98765432138');
  337. INSERT INTO teach VALUES('12345678932', 'a_01', '98765432137');
  338. INSERT INTO teach VALUES('12345678924', 'a_02', '98765432136');
  339. INSERT INTO teach VALUES('12345678928', 'a_02', '98765432135');
  340. INSERT INTO teach VALUES('12345678923', 'a_01', '98765432134');
  341. INSERT INTO teach VALUES('12345678925', 'a_04', '98765432133');
  342. INSERT INTO teach VALUES('12345678930', 'a_02', '98765432132');
  343. INSERT INTO teach VALUES('12345678932', 'a_03', '98765432131');
  344. INSERT INTO teach VALUES('12345678924', 'a_03', '98765432130');
  345. INSERT INTO teach VALUES('12345678930', 'a_01', '98765432129');
  346. INSERT INTO teach VALUES('12345678930', 'a_04', '98765432128');
  347. INSERT INTO teach VALUES('12345678926', 'a_02', '98765432127');
  348. INSERT INTO teach VALUES('12345678924', 'a_03', '98765432126');
  349. INSERT INTO teach VALUES('12345678931', 'a_04', '98765432125');
  350. INSERT INTO teach VALUES('12345678929', 'a_03', '98765432124');
  351. INSERT INTO teach VALUES('12345678926', 'a_03', '98765432123');
  352. INSERT INTO teach VALUES('12345678929', 'a_01', '98765432122');
  353. INSERT INTO teach VALUES('12345678927', 'a_03', '98765432121');
  354. INSERT INTO teach VALUES('12345678926', 'a_01', '98765432120');
  355. INSERT INTO teach VALUES('12345678927', 'a_03', '98765432119');
  356. INSERT INTO teach VALUES('12345678925', 'a_03', '98765432118');
  357. INSERT INTO teach VALUES('12345678931', 'a_01', '98765432117');
  358. INSERT INTO teach VALUES('12345678931', 'a_01', '98765432116');
  359. INSERT INTO teach VALUES('12345678923', 'a_03', '98765432115');
  360. INSERT INTO teach VALUES('12345678925', 'a_01', '98765432114');
  361. INSERT INTO teach VALUES('12345678923', 'a_02', '98765432113');
  362. INSERT INTO teach VALUES('12345678923', 'a_01', '98765432112');
  363. INSERT INTO teach VALUES('12345678924', 'a_04', '98765432111');
  364. INSERT INTO teach VALUES('12345678925', 'a_03', '98765432110');
  365. INSERT INTO teach VALUES('12345678929', 'a_01', '98765432109');
  366. INSERT INTO teach VALUES('12345678932', 'a_01', '98765432108');
  367. INSERT INTO teach VALUES('12345678924', 'a_03', '98765432107');
  368. INSERT INTO teach VALUES('12345678925', 'a_04', '98765432106');
  369. INSERT INTO teach VALUES('12345678927', 'a_04', '98765432105');
  370. INSERT INTO teach VALUES('12345678926', 'a_01', '98765432104');
  371. INSERT INTO teach VALUES('12345678932', 'a_04', '98765432103');
  372. INSERT INTO teach VALUES('12345678926', 'a_01', '98765432102');
  373. INSERT INTO teach VALUES('12345678926', 'a_01', '98765432101');
  374. INSERT INTO teach VALUES('12345678925', 'a_01', '98765432100');
  375. INSERT INTO teach VALUES('12345678925', 'a_03', '98765432099');
  376. INSERT INTO teach VALUES('12345678932', 'a_04', '98765432098');
  377. INSERT INTO teach VALUES('12345678928', 'a_02', '98765432097');
  378. INSERT INTO teach VALUES('12345678923', 'a_01', '98765432096');
  379. INSERT INTO teach VALUES('12345678930', 'a_02', '98765432095');
  380. INSERT INTO teach VALUES('12345678927', 'a_04', '98765432094');
  381. INSERT INTO teach VALUES('12345678926', 'a_04', '98765432093');
  382. INSERT INTO teach VALUES('12345678930', 'a_01', '98765432092');
  383. INSERT INTO teach VALUES('12345678923', 'a_03', '98765432091');
  384. INSERT INTO teach VALUES('12345678923', 'a_04', '98765432090');
  385. INSERT INTO teach VALUES('12345678925', 'a_02', '98765432089');
  386. INSERT INTO teach VALUES('12345678930', 'a_02', '98765432088');
  387. INSERT INTO teach VALUES('12345678931', 'a_02', '98765432087');
  388. INSERT INTO teach VALUES('12345678930', 'a_04', '98765432086');
  389. INSERT INTO teach VALUES('12345678926', 'a_03', '98765432085');
  390. INSERT INTO teach VALUES('12345678925', 'a_02', '98765432084');
  391. INSERT INTO teach VALUES('12345678928', 'a_02', '98765432083');
  392. INSERT INTO teach VALUES('12345678926', 'a_01', '98765432082');
  393. INSERT INTO teach VALUES('12345678932', 'a_04', '98765432081');
  394. INSERT INTO teach VALUES('12345678925', 'a_01', '98765432080');
  395. INSERT INTO teach VALUES('12345678925', 'a_02', '98765432079');
  396. INSERT INTO teach VALUES('12345678931', 'a_01', '98765432078');
  397. INSERT INTO teach VALUES('12345678924', 'a_04', '98765432077');
  398. INSERT INTO teach VALUES('12345678932', 'a_04', '98765432076');
  399. INSERT INTO teach VALUES('12345678924', 'a_01', '98765432075');
  400. INSERT INTO teach VALUES('12345678930', 'a_03', '98765432074');
  401. INSERT INTO teach VALUES('12345678924', 'a_02', '98765432073');
  402. INSERT INTO teach VALUES('12345678925', 'a_02', '98765432072');
  403. INSERT INTO teach VALUES('12345678926', 'a_01', '98765432071');
  404. INSERT INTO teach VALUES('12345678924', 'a_02', '98765432070');
  405. INSERT INTO teach VALUES('12345678925', 'a_04', '98765432069');
  406. INSERT INTO teach VALUES('12345678930', 'a_01', '98765432068');
  407. INSERT INTO teach VALUES('12345678926', 'a_01', '98765432067');
  408. INSERT INTO teach VALUES('12345678925', 'a_01', '98765432066');
  409. INSERT INTO teach VALUES('12345678931', 'a_04', '98765432065');
  410. INSERT INTO teach VALUES('12345678929', 'a_02', '98765432064');
  411. INSERT INTO teach VALUES('12345678928', 'a_03', '98765432063');
  412. INSERT INTO teach VALUES('12345678925', 'a_04', '98765432062');
  413. INSERT INTO teach VALUES('12345678931', 'a_03', '98765432061');
  414. INSERT INTO teach VALUES('12345678931', 'a_03', '98765432060');
  415. INSERT INTO teach VALUES('12345678927', 'a_03', '98765432059');
  416. INSERT INTO teach VALUES('12345678930', 'a_02', '98765432058');
  417. INSERT INTO teach VALUES('12345678931', 'a_04', '98765432057');
  418. INSERT INTO teach VALUES('12345678928', 'a_01', '98765432056');
  419. INSERT INTO teach VALUES('12345678927', 'a_01', '98765432055');
  420. INSERT INTO teach VALUES('12345678924', 'a_01', '98765432054');
  421. INSERT INTO teach VALUES('12345678927', 'a_04', '98765432053');
  422. INSERT INTO teach VALUES('12345678926', 'a_03', '98765432052');
  423. INSERT INTO teach VALUES('12345678923', 'a_03', '98765432051');
  424. INSERT INTO teach VALUES('12345678930', 'a_02', '98765432050');
  425. INSERT INTO teach VALUES('12345678929', 'b_04', '98765432198');
  426. INSERT INTO teach VALUES('12345678926', 'b_02', '98765432197');
  427. INSERT INTO teach VALUES('12345678928', 'b_02', '98765432196');
  428. INSERT INTO teach VALUES('12345678928', 'b_03', '98765432195');
  429. INSERT INTO teach VALUES('12345678924', 'b_01', '98765432194');
  430. INSERT INTO teach VALUES('12345678923', 'b_03', '98765432193');
  431. INSERT INTO teach VALUES('12345678931', 'b_04', '98765432192');
  432. INSERT INTO teach VALUES('12345678924', 'b_01', '98765432191');
  433. INSERT INTO teach VALUES('12345678925', 'b_01', '98765432190');
  434. INSERT INTO teach VALUES('12345678930', 'b_01', '98765432189');
  435. INSERT INTO teach VALUES('12345678924', 'b_01', '98765432188');
  436. INSERT INTO teach VALUES('12345678926', 'b_01', '98765432187');
  437. INSERT INTO teach VALUES('12345678923', 'b_01', '98765432186');
  438. INSERT INTO teach VALUES('12345678932', 'b_01', '98765432185');
  439. INSERT INTO teach VALUES('12345678925', 'b_02', '98765432184');
  440. INSERT INTO teach VALUES('12345678923', 'b_02', '98765432183');
  441. INSERT INTO teach VALUES('12345678926', 'b_02', '98765432182');
  442. INSERT INTO teach VALUES('12345678931', 'b_01', '98765432181');
  443. INSERT INTO teach VALUES('12345678926', 'b_03', '98765432180');
  444. INSERT INTO teach VALUES('12345678931', 'b_01', '98765432179');
  445. INSERT INTO teach VALUES('12345678925', 'b_03', '98765432178');
  446. INSERT INTO teach VALUES('12345678930', 'b_04', '98765432177');
  447. INSERT INTO teach VALUES('12345678925', 'b_03', '98765432176');
  448. INSERT INTO teach VALUES('12345678925', 'b_04', '98765432175');
  449. INSERT INTO teach VALUES('12345678926', 'b_03', '98765432174');
  450. INSERT INTO teach VALUES('12345678925', 'b_03', '98765432173');
  451. INSERT INTO teach VALUES('12345678924', 'b_01', '98765432172');
  452. INSERT INTO teach VALUES('12345678926', 'b_04', '98765432171');
  453. INSERT INTO teach VALUES('12345678930', 'b_02', '98765432170');
  454. INSERT INTO teach VALUES('12345678931', 'b_04', '98765432169');
  455. INSERT INTO teach VALUES('12345678923', 'b_01', '98765432168');
  456. INSERT INTO teach VALUES('12345678926', 'b_01', '98765432167');
  457. INSERT INTO teach VALUES('12345678929', 'b_02', '98765432166');
  458. INSERT INTO teach VALUES('12345678926', 'b_04', '98765432165');
  459. INSERT INTO teach VALUES('12345678931', 'b_04', '98765432164');
  460. INSERT INTO teach VALUES('12345678929', 'b_01', '98765432163');
  461. INSERT INTO teach VALUES('12345678930', 'b_01', '98765432162');
  462. INSERT INTO teach VALUES('12345678925', 'b_01', '98765432161');
  463. INSERT INTO teach VALUES('12345678930', 'b_04', '98765432160');
  464. INSERT INTO teach VALUES('12345678923', 'b_03', '98765432159');
  465. INSERT INTO teach VALUES('12345678928', 'b_03', '98765432158');
  466. INSERT INTO teach VALUES('12345678930', 'b_02', '98765432157');
  467. INSERT INTO teach VALUES('12345678931', 'b_03', '98765432156');
  468. INSERT INTO teach VALUES('12345678930', 'b_01', '98765432155');
  469. INSERT INTO teach VALUES('12345678929', 'b_02', '98765432154');
  470. INSERT INTO teach VALUES('12345678924', 'b_02', '98765432153');
  471. INSERT INTO teach VALUES('12345678929', 'b_01', '98765432152');
  472. INSERT INTO teach VALUES('12345678927', 'b_04', '98765432151');
  473. INSERT INTO teach VALUES('12345678930', 'b_03', '98765432150');
  474. INSERT INTO teach VALUES('12345678929', 'b_02', '98765432149');
  475. INSERT INTO teach VALUES('12345678923', 'b_01', '98765432148');
  476. INSERT INTO teach VALUES('12345678924', 'b_04', '98765432147');
  477. INSERT INTO teach VALUES('12345678924', 'b_01', '98765432146');
  478. INSERT INTO teach VALUES('12345678932', 'b_01', '98765432145');
  479. INSERT INTO teach VALUES('12345678924', 'b_04', '98765432144');
  480. INSERT INTO teach VALUES('12345678926', 'b_02', '98765432143');
  481. INSERT INTO teach VALUES('12345678925', 'b_03', '98765432142');
  482. INSERT INTO teach VALUES('12345678931', 'b_01', '98765432141');
  483. INSERT INTO teach VALUES('12345678932', 'b_04', '98765432140');
  484. INSERT INTO teach VALUES('12345678927', 'b_03', '98765432139');
  485. INSERT INTO teach VALUES('12345678929', 'b_03', '98765432138');
  486. INSERT INTO teach VALUES('12345678924', 'b_03', '98765432137');
  487. INSERT INTO teach VALUES('12345678929', 'b_02', '98765432136');
  488. INSERT INTO teach VALUES('12345678923', 'b_01', '98765432135');
  489. INSERT INTO teach VALUES('12345678926', 'b_04', '98765432134');
  490. INSERT INTO teach VALUES('12345678928', 'b_01', '98765432133');
  491. INSERT INTO teach VALUES('12345678927', 'b_04', '98765432132');
  492. INSERT INTO teach VALUES('12345678932', 'b_03', '98765432131');
  493. INSERT INTO teach VALUES('12345678931', 'b_01', '98765432130');
  494. INSERT INTO teach VALUES('12345678928', 'b_01', '98765432129');
  495. INSERT INTO teach VALUES('12345678931', 'b_03', '98765432128');
  496. INSERT INTO teach VALUES('12345678923', 'b_02', '98765432127');
  497. INSERT INTO teach VALUES('12345678932', 'b_01', '98765432126');
  498. INSERT INTO teach VALUES('12345678929', 'b_03', '98765432125');
  499. INSERT INTO teach VALUES('12345678925', 'b_02', '98765432124');
  500. INSERT INTO teach VALUES('12345678927', 'b_04', '98765432123');
  501. INSERT INTO teach VALUES('12345678927', 'b_04', '98765432122');
  502. INSERT INTO teach VALUES('12345678925', 'b_01', '98765432121');
  503. INSERT INTO teach VALUES('12345678925', 'b_04', '98765432120');
  504. INSERT INTO teach VALUES('12345678932', 'b_03', '98765432119');
  505. INSERT INTO teach VALUES('12345678924', 'b_01', '98765432118');
  506. INSERT INTO teach VALUES('12345678930', 'b_01', '98765432117');
  507. INSERT INTO teach VALUES('12345678928', 'b_02', '98765432116');
  508. INSERT INTO teach VALUES('12345678925', 'b_04', '98765432115');
  509. INSERT INTO teach VALUES('12345678929', 'b_04', '98765432114');
  510. INSERT INTO teach VALUES('12345678930', 'b_04', '98765432113');
  511. INSERT INTO teach VALUES('12345678932', 'b_02', '98765432112');
  512. INSERT INTO teach VALUES('12345678924', 'b_04', '98765432111');
  513. INSERT INTO teach VALUES('12345678928', 'b_01', '98765432110');
  514. INSERT INTO teach VALUES('12345678927', 'b_03', '98765432109');
  515. INSERT INTO teach VALUES('12345678932', 'b_04', '98765432108');
  516. INSERT INTO teach VALUES('12345678929', 'b_02', '98765432107');
  517. INSERT INTO teach VALUES('12345678923', 'b_03', '98765432106');
  518. INSERT INTO teach VALUES('12345678924', 'b_02', '98765432105');
  519. INSERT INTO teach VALUES('12345678926', 'b_04', '98765432104');
  520. INSERT INTO teach VALUES('12345678925', 'b_04', '98765432103');
  521. INSERT INTO teach VALUES('12345678924', 'b_03', '98765432102');
  522. INSERT INTO teach VALUES('12345678929', 'b_01', '98765432101');
  523. INSERT INTO teach VALUES('12345678924', 'b_01', '98765432100');
  524. INSERT INTO teach VALUES('12345678925', 'b_02', '98765432099');
  525. INSERT INTO teach VALUES('12345678923', 'b_01', '98765432098');
  526. INSERT INTO teach VALUES('12345678929', 'b_02', '98765432097');
  527. INSERT INTO teach VALUES('12345678929', 'b_03', '98765432096');
  528. INSERT INTO teach VALUES('12345678924', 'b_03', '98765432095');
  529. INSERT INTO teach VALUES('12345678930', 'b_04', '98765432094');
  530. INSERT INTO teach VALUES('12345678930', 'b_04', '98765432093');
  531. INSERT INTO teach VALUES('12345678930', 'b_04', '98765432092');
  532. INSERT INTO teach VALUES('12345678927', 'b_02', '98765432091');
  533. INSERT INTO teach VALUES('12345678927', 'b_04', '98765432090');
  534. INSERT INTO teach VALUES('12345678932', 'b_01', '98765432089');
  535. INSERT INTO teach VALUES('12345678925', 'b_01', '98765432088');
  536. INSERT INTO teach VALUES('12345678924', 'b_03', '98765432087');
  537. INSERT INTO teach VALUES('12345678924', 'b_02', '98765432086');
  538. INSERT INTO teach VALUES('12345678925', 'b_03', '98765432085');
  539. INSERT INTO teach VALUES('12345678925', 'b_02', '98765432084');
  540. INSERT INTO teach VALUES('12345678927', 'b_04', '98765432083');
  541. INSERT INTO teach VALUES('12345678932', 'b_04', '98765432082');
  542. INSERT INTO teach VALUES('12345678931', 'b_04', '98765432081');
  543. INSERT INTO teach VALUES('12345678925', 'b_03', '98765432080');
  544. INSERT INTO teach VALUES('12345678929', 'b_01', '98765432079');
  545. INSERT INTO teach VALUES('12345678926', 'b_02', '98765432078');
  546. INSERT INTO teach VALUES('12345678931', 'b_02', '98765432077');
  547. INSERT INTO teach VALUES('12345678924', 'b_02', '98765432076');
  548. INSERT INTO teach VALUES('12345678923', 'b_04', '98765432075');
  549. INSERT INTO teach VALUES('12345678925', 'b_01', '98765432074');
  550. INSERT INTO teach VALUES('12345678924', 'b_01', '98765432073');
  551. INSERT INTO teach VALUES('12345678930', 'b_02', '98765432072');
  552. INSERT INTO teach VALUES('12345678930', 'b_01', '98765432071');
  553. INSERT INTO teach VALUES('12345678925', 'b_01', '98765432070');
  554. INSERT INTO teach VALUES('12345678923', 'b_04', '98765432069');
  555. INSERT INTO teach VALUES('12345678928', 'b_02', '98765432068');
  556. INSERT INTO teach VALUES('12345678929', 'b_02', '98765432067');
  557. INSERT INTO teach VALUES('12345678925', 'b_02', '98765432066');
  558. INSERT INTO teach VALUES('12345678925', 'b_02', '98765432065');
  559. INSERT INTO teach VALUES('12345678932', 'b_03', '98765432064');
  560. INSERT INTO teach VALUES('12345678929', 'b_03', '98765432063');
  561. INSERT INTO teach VALUES('12345678924', 'b_01', '98765432062');
  562. INSERT INTO teach VALUES('12345678927', 'b_04', '98765432061');
  563. INSERT INTO teach VALUES('12345678931', 'b_01', '98765432060');
  564. INSERT INTO teach VALUES('12345678923', 'b_01', '98765432059');
  565. INSERT INTO teach VALUES('12345678925', 'b_01', '98765432058');
  566. INSERT INTO teach VALUES('12345678931', 'b_01', '98765432057');
  567. INSERT INTO teach VALUES('12345678925', 'b_01', '98765432056');
  568. INSERT INTO teach VALUES('12345678927', 'b_04', '98765432055');
  569. INSERT INTO teach VALUES('12345678932', 'b_04', '98765432054');
  570. INSERT INTO teach VALUES('12345678923', 'b_04', '98765432053');
  571. INSERT INTO teach VALUES('12345678926', 'b_02', '98765432052');
  572. INSERT INTO teach VALUES('12345678930', 'b_02', '98765432051');
  573. INSERT INTO teach VALUES('12345678930', 'b_03', '98765432050');
  574. INSERT INTO teach VALUES('12345678930', 'c_01', '98765432198');
  575. INSERT INTO teach VALUES('12345678925', 'c_02', '98765432197');
  576. INSERT INTO teach VALUES('12345678923', 'c_04', '98765432196');
  577. INSERT INTO teach VALUES('12345678926', 'c_01', '98765432195');
  578. INSERT INTO teach VALUES('12345678931', 'c_04', '98765432194');
  579. INSERT INTO teach VALUES('12345678928', 'c_03', '98765432193');
  580. INSERT INTO teach VALUES('12345678924', 'c_04', '98765432192');
  581. INSERT INTO teach VALUES('12345678923', 'c_02', '98765432191');
  582. INSERT INTO teach VALUES('12345678932', 'c_02', '98765432190');
  583. INSERT INTO teach VALUES('12345678929', 'c_02', '98765432189');
  584. INSERT INTO teach VALUES('12345678924', 'c_03', '98765432188');
  585. INSERT INTO teach VALUES('12345678930', 'c_01', '98765432187');
  586. INSERT INTO teach VALUES('12345678930', 'c_01', '98765432186');
  587. INSERT INTO teach VALUES('12345678930', 'c_04', '98765432185');
  588. INSERT INTO teach VALUES('12345678926', 'c_02', '98765432184');
  589. INSERT INTO teach VALUES('12345678923', 'c_01', '98765432183');
  590. INSERT INTO teach VALUES('12345678932', 'c_04', '98765432182');
  591. INSERT INTO teach VALUES('12345678932', 'c_04', '98765432181');
  592. INSERT INTO teach VALUES('12345678923', 'c_02', '98765432180');
  593. INSERT INTO teach VALUES('12345678926', 'c_03', '98765432179');
  594. INSERT INTO teach VALUES('12345678924', 'c_01', '98765432178');
  595. INSERT INTO teach VALUES('12345678923', 'c_02', '98765432177');
  596. INSERT INTO teach VALUES('12345678923', 'c_02', '98765432176');
  597. INSERT INTO teach VALUES('12345678924', 'c_02', '98765432175');
  598. INSERT INTO teach VALUES('12345678926', 'c_03', '98765432174');
  599. INSERT INTO teach VALUES('12345678927', 'c_02', '98765432173');
  600. INSERT INTO teach VALUES('12345678930', 'c_02', '98765432172');
  601. INSERT INTO teach VALUES('12345678930', 'c_04', '98765432171');
  602. INSERT INTO teach VALUES('12345678925', 'c_04', '98765432170');
  603. INSERT INTO teach VALUES('12345678926', 'c_02', '98765432169');
  604. INSERT INTO teach VALUES('12345678932', 'c_02', '98765432168');
  605. INSERT INTO teach VALUES('12345678927', 'c_01', '98765432167');
  606. INSERT INTO teach VALUES('12345678926', 'c_03', '98765432166');
  607. INSERT INTO teach VALUES('12345678928', 'c_02', '98765432165');
  608. INSERT INTO teach VALUES('12345678930', 'c_02', '98765432164');
  609. INSERT INTO teach VALUES('12345678926', 'c_03', '98765432163');
  610. INSERT INTO teach VALUES('12345678932', 'c_03', '98765432162');
  611. INSERT INTO teach VALUES('12345678932', 'c_03', '98765432161');
  612. INSERT INTO teach VALUES('12345678930', 'c_01', '98765432160');
  613. INSERT INTO teach VALUES('12345678930', 'c_02', '98765432159');
  614. INSERT INTO teach VALUES('12345678926', 'c_03', '98765432158');
  615. INSERT INTO teach VALUES('12345678925', 'c_03', '98765432157');
  616. INSERT INTO teach VALUES('12345678926', 'c_04', '98765432156');
  617. INSERT INTO teach VALUES('12345678931', 'c_04', '98765432155');
  618. INSERT INTO teach VALUES('12345678929', 'c_04', '98765432154');
  619. INSERT INTO teach VALUES('12345678931', 'c_02', '98765432153');
  620. INSERT INTO teach VALUES('12345678930', 'c_02', '98765432152');
  621. INSERT INTO teach VALUES('12345678925', 'c_02', '98765432151');
  622. INSERT INTO teach VALUES('12345678926', 'c_01', '98765432150');
  623. INSERT INTO teach VALUES('12345678926', 'c_02', '98765432149');
  624. INSERT INTO teach VALUES('12345678928', 'c_03', '98765432148');
  625. INSERT INTO teach VALUES('12345678928', 'c_02', '98765432147');
  626. INSERT INTO teach VALUES('12345678923', 'c_01', '98765432146');
  627. INSERT INTO teach VALUES('12345678923', 'c_04', '98765432145');
  628. INSERT INTO teach VALUES('12345678928', 'c_01', '98765432144');
  629. INSERT INTO teach VALUES('12345678924', 'c_02', '98765432143');
  630. INSERT INTO teach VALUES('12345678931', 'c_04', '98765432142');
  631. INSERT INTO teach VALUES('12345678925', 'c_02', '98765432141');
  632. INSERT INTO teach VALUES('12345678926', 'c_01', '98765432140');
  633. INSERT INTO teach VALUES('12345678924', 'c_04', '98765432139');
  634. INSERT INTO teach VALUES('12345678926', 'c_03', '98765432138');
  635. INSERT INTO teach VALUES('12345678925', 'c_03', '98765432137');
  636. INSERT INTO teach VALUES('12345678924', 'c_03', '98765432136');
  637. INSERT INTO teach VALUES('12345678932', 'c_04', '98765432135');
  638. INSERT INTO teach VALUES('12345678925', 'c_03', '98765432134');
  639. INSERT INTO teach VALUES('12345678931', 'c_03', '98765432133');
  640. INSERT INTO teach VALUES('12345678928', 'c_01', '98765432132');
  641. INSERT INTO teach VALUES('12345678931', 'c_03', '98765432131');
  642. INSERT INTO teach VALUES('12345678927', 'c_03', '98765432130');
  643. INSERT INTO teach VALUES('12345678929', 'c_03', '98765432129');
  644. INSERT INTO teach VALUES('12345678926', 'c_01', '98765432128');
  645. INSERT INTO teach VALUES('12345678925', 'c_03', '98765432127');
  646. INSERT INTO teach VALUES('12345678927', 'c_04', '98765432126');
  647. INSERT INTO teach VALUES('12345678927', 'c_01', '98765432125');
  648. INSERT INTO teach VALUES('12345678928', 'c_04', '98765432124');
  649. INSERT INTO teach VALUES('12345678924', 'c_04', '98765432123');
  650. INSERT INTO teach VALUES('12345678926', 'c_04', '98765432122');
  651. INSERT INTO teach VALUES('12345678931', 'c_03', '98765432121');
  652. INSERT INTO teach VALUES('12345678928', 'c_04', '98765432120');
  653. INSERT INTO teach VALUES('12345678926', 'c_03', '98765432119');
  654. INSERT INTO teach VALUES('12345678926', 'c_04', '98765432118');
  655. INSERT INTO teach VALUES('12345678925', 'c_04', '98765432117');
  656. INSERT INTO teach VALUES('12345678927', 'c_01', '98765432116');
  657. INSERT INTO teach VALUES('12345678926', 'c_03', '98765432115');
  658. INSERT INTO teach VALUES('12345678930', 'c_02', '98765432114');
  659. INSERT INTO teach VALUES('12345678930', 'c_03', '98765432113');
  660. INSERT INTO teach VALUES('12345678926', 'c_03', '98765432112');
  661. INSERT INTO teach VALUES('12345678928', 'c_04', '98765432111');
  662. INSERT INTO teach VALUES('12345678926', 'c_01', '98765432110');
  663. INSERT INTO teach VALUES('12345678929', 'c_01', '98765432109');
  664. INSERT INTO teach VALUES('12345678925', 'c_03', '98765432108');
  665. INSERT INTO teach VALUES('12345678928', 'c_04', '98765432107');
  666. INSERT INTO teach VALUES('12345678923', 'c_02', '98765432106');
  667. INSERT INTO teach VALUES('12345678923', 'c_04', '98765432105');
  668. INSERT INTO teach VALUES('12345678927', 'c_03', '98765432104');
  669. INSERT INTO teach VALUES('12345678930', 'c_01', '98765432103');
  670. INSERT INTO teach VALUES('12345678928', 'c_02', '98765432102');
  671. INSERT INTO teach VALUES('12345678931', 'c_02', '98765432101');
  672. INSERT INTO teach VALUES('12345678924', 'c_03', '98765432100');
  673. INSERT INTO teach VALUES('12345678930', 'c_02', '98765432099');
  674. INSERT INTO teach VALUES('12345678926', 'c_03', '98765432098');
  675. INSERT INTO teach VALUES('12345678924', 'c_03', '98765432097');
  676. INSERT INTO teach VALUES('12345678924', 'c_02', '98765432096');
  677. INSERT INTO teach VALUES('12345678928', 'c_04', '98765432095');
  678. INSERT INTO teach VALUES('12345678925', 'c_02', '98765432094');
  679. INSERT INTO teach VALUES('12345678932', 'c_04', '98765432093');
  680. INSERT INTO teach VALUES('12345678932', 'c_02', '98765432092');
  681. INSERT INTO teach VALUES('12345678927', 'c_02', '98765432091');
  682. INSERT INTO teach VALUES('12345678925', 'c_02', '98765432090');
  683. INSERT INTO teach VALUES('12345678932', 'c_04', '98765432089');
  684. INSERT INTO teach VALUES('12345678928', 'c_03', '98765432088');
  685. INSERT INTO teach VALUES('12345678926', 'c_04', '98765432087');
  686. INSERT INTO teach VALUES('12345678928', 'c_01', '98765432086');
  687. INSERT INTO teach VALUES('12345678929', 'c_03', '98765432085');
  688. INSERT INTO teach VALUES('12345678931', 'c_04', '98765432084');
  689. INSERT INTO teach VALUES('12345678923', 'c_02', '98765432083');
  690. INSERT INTO teach VALUES('12345678930', 'c_03', '98765432082');
  691. INSERT INTO teach VALUES('12345678925', 'c_01', '98765432081');
  692. INSERT INTO teach VALUES('12345678929', 'c_03', '98765432080');
  693. INSERT INTO teach VALUES('12345678928', 'c_02', '98765432079');
  694. INSERT INTO teach VALUES('12345678929', 'c_04', '98765432078');
  695. INSERT INTO teach VALUES('12345678924', 'c_01', '98765432077');
  696. INSERT INTO teach VALUES('12345678932', 'c_02', '98765432076');
  697. INSERT INTO teach VALUES('12345678928', 'c_04', '98765432075');
  698. INSERT INTO teach VALUES('12345678924', 'c_01', '98765432074');
  699. INSERT INTO teach VALUES('12345678928', 'c_01', '98765432073');
  700. INSERT INTO teach VALUES('12345678929', 'c_03', '98765432072');
  701. INSERT INTO teach VALUES('12345678925', 'c_03', '98765432071');
  702. INSERT INTO teach VALUES('12345678925', 'c_04', '98765432070');
  703. INSERT INTO teach VALUES('12345678930', 'c_01', '98765432069');
  704. INSERT INTO teach VALUES('12345678928', 'c_03', '98765432068');
  705. INSERT INTO teach VALUES('12345678932', 'c_01', '98765432067');
  706. INSERT INTO teach VALUES('12345678928', 'c_01', '98765432066');
  707. INSERT INTO teach VALUES('12345678931', 'c_03', '98765432065');
  708. INSERT INTO teach VALUES('12345678923', 'c_03', '98765432064');
  709. INSERT INTO teach VALUES('12345678923', 'c_02', '98765432063');
  710. INSERT INTO teach VALUES('12345678932', 'c_02', '98765432062');
  711. INSERT INTO teach VALUES('12345678930', 'c_03', '98765432061');
  712. INSERT INTO teach VALUES('12345678925', 'c_02', '98765432060');
  713. INSERT INTO teach VALUES('12345678932', 'c_03', '98765432059');
  714. INSERT INTO teach VALUES('12345678924', 'c_01', '98765432058');
  715. INSERT INTO teach VALUES('12345678931', 'c_03', '98765432057');
  716. INSERT INTO teach VALUES('12345678923', 'c_01', '98765432056');
  717. INSERT INTO teach VALUES('12345678923', 'c_02', '98765432055');
  718. INSERT INTO teach VALUES('12345678931', 'c_01', '98765432054');
  719. INSERT INTO teach VALUES('12345678928', 'c_01', '98765432053');
  720. INSERT INTO teach VALUES('12345678932', 'c_02', '98765432052');
  721. INSERT INTO teach VALUES('12345678932', 'c_04', '98765432051');
  722. INSERT INTO teach VALUES('12345678930', 'c_04', '98765432050');
  723. INSERT INTO teach VALUES('12345678932', 'd_02', '98765432198');
  724. INSERT INTO teach VALUES('12345678932', 'd_03', '98765432197');
  725. INSERT INTO teach VALUES('12345678930', 'd_04', '98765432196');
  726. INSERT INTO teach VALUES('12345678925', 'd_01', '98765432195');
  727. INSERT INTO teach VALUES('12345678924', 'd_03', '98765432194');
  728. INSERT INTO teach VALUES('12345678931', 'd_02', '98765432193');
  729. INSERT INTO teach VALUES('12345678927', 'd_03', '98765432192');
  730. INSERT INTO teach VALUES('12345678928', 'd_03', '98765432191');
  731. INSERT INTO teach VALUES('12345678925', 'd_02', '98765432190');
  732. INSERT INTO teach VALUES('12345678924', 'd_01', '98765432189');
  733. INSERT INTO teach VALUES('12345678930', 'd_03', '98765432188');
  734. INSERT INTO teach VALUES('12345678929', 'd_02', '98765432187');
  735. INSERT INTO teach VALUES('12345678930', 'd_04', '98765432186');
  736. INSERT INTO teach VALUES('12345678926', 'd_01', '98765432185');
  737. INSERT INTO teach VALUES('12345678932', 'd_01', '98765432184');
  738. INSERT INTO teach VALUES('12345678924', 'd_01', '98765432183');
  739. INSERT INTO teach VALUES('12345678930', 'd_04', '98765432182');
  740. INSERT INTO teach VALUES('12345678929', 'd_02', '98765432181');
  741. INSERT INTO teach VALUES('12345678932', 'd_04', '98765432180');
  742. INSERT INTO teach VALUES('12345678931', 'd_01', '98765432179');
  743. INSERT INTO teach VALUES('12345678930', 'd_03', '98765432178');
  744. INSERT INTO teach VALUES('12345678927', 'd_02', '98765432177');
  745. INSERT INTO teach VALUES('12345678924', 'd_02', '98765432176');
  746. INSERT INTO teach VALUES('12345678928', 'd_01', '98765432175');
  747. INSERT INTO teach VALUES('12345678928', 'd_03', '98765432174');
  748. INSERT INTO teach VALUES('12345678924', 'd_01', '98765432173');
  749. INSERT INTO teach VALUES('12345678923', 'd_04', '98765432172');
  750. INSERT INTO teach VALUES('12345678925', 'd_01', '98765432171');
  751. INSERT INTO teach VALUES('12345678925', 'd_04', '98765432170');
  752. INSERT INTO teach VALUES('12345678932', 'd_02', '98765432169');
  753. INSERT INTO teach VALUES('12345678928', 'd_04', '98765432168');
  754. INSERT INTO teach VALUES('12345678931', 'd_03', '98765432167');
  755. INSERT INTO teach VALUES('12345678931', 'd_02', '98765432166');
  756. INSERT INTO teach VALUES('12345678928', 'd_01', '98765432165');
  757. INSERT INTO teach VALUES('12345678923', 'd_03', '98765432164');
  758. INSERT INTO teach VALUES('12345678928', 'd_03', '98765432163');
  759. INSERT INTO teach VALUES('12345678931', 'd_01', '98765432162');
  760. INSERT INTO teach VALUES('12345678931', 'd_03', '98765432161');
  761. INSERT INTO teach VALUES('12345678932', 'd_01', '98765432160');
  762. INSERT INTO teach VALUES('12345678923', 'd_01', '98765432159');
  763. INSERT INTO teach VALUES('12345678927', 'd_01', '98765432158');
  764. INSERT INTO teach VALUES('12345678926', 'd_04', '98765432157');
  765. INSERT INTO teach VALUES('12345678929', 'd_01', '98765432156');
  766. INSERT INTO teach VALUES('12345678923', 'd_03', '98765432155');
  767. INSERT INTO teach VALUES('12345678932', 'd_04', '98765432154');
  768. INSERT INTO teach VALUES('12345678924', 'd_01', '98765432153');
  769. INSERT INTO teach VALUES('12345678929', 'd_03', '98765432152');
  770. INSERT INTO teach VALUES('12345678931', 'd_02', '98765432151');
  771. INSERT INTO teach VALUES('12345678924', 'd_03', '98765432150');
  772. INSERT INTO teach VALUES('12345678932', 'd_03', '98765432149');
  773. INSERT INTO teach VALUES('12345678927', 'd_02', '98765432148');
  774. INSERT INTO teach VALUES('12345678924', 'd_01', '98765432147');
  775. INSERT INTO teach VALUES('12345678925', 'd_03', '98765432146');
  776. INSERT INTO teach VALUES('12345678931', 'd_02', '98765432145');
  777. INSERT INTO teach VALUES('12345678924', 'd_03', '98765432144');
  778. INSERT INTO teach VALUES('12345678931', 'd_03', '98765432143');
  779. INSERT INTO teach VALUES('12345678930', 'd_02', '98765432142');
  780. INSERT INTO teach VALUES('12345678931', 'd_03', '98765432141');
  781. INSERT INTO teach VALUES('12345678930', 'd_01', '98765432140');
  782. INSERT INTO teach VALUES('12345678925', 'd_02', '98765432139');
  783. INSERT INTO teach VALUES('12345678928', 'd_04', '98765432138');
  784. INSERT INTO teach VALUES('12345678931', 'd_03', '98765432137');
  785. INSERT INTO teach VALUES('12345678926', 'd_02', '98765432136');
  786. INSERT INTO teach VALUES('12345678926', 'd_02', '98765432135');
  787. INSERT INTO teach VALUES('12345678931', 'd_01', '98765432134');
  788. INSERT INTO teach VALUES('12345678926', 'd_02', '98765432133');
  789. INSERT INTO teach VALUES('12345678932', 'd_04', '98765432132');
  790. INSERT INTO teach VALUES('12345678923', 'd_04', '98765432131');
  791. INSERT INTO teach VALUES('12345678923', 'd_04', '98765432130');
  792. INSERT INTO teach VALUES('12345678928', 'd_04', '98765432129');
  793. INSERT INTO teach VALUES('12345678927', 'd_01', '98765432128');
  794. INSERT INTO teach VALUES('12345678932', 'd_01', '98765432127');
  795. INSERT INTO teach VALUES('12345678930', 'd_02', '98765432126');
  796. INSERT INTO teach VALUES('12345678928', 'd_01', '98765432125');
  797. INSERT INTO teach VALUES('12345678927', 'd_04', '98765432124');
  798. INSERT INTO teach VALUES('12345678931', 'd_03', '98765432123');
  799. INSERT INTO teach VALUES('12345678931', 'd_02', '98765432122');
  800. INSERT INTO teach VALUES('12345678932', 'd_04', '98765432121');
  801. INSERT INTO teach VALUES('12345678932', 'd_04', '98765432120');
  802. INSERT INTO teach VALUES('12345678928', 'd_04', '98765432119');
  803. INSERT INTO teach VALUES('12345678926', 'd_03', '98765432118');
  804. INSERT INTO teach VALUES('12345678927', 'd_02', '98765432117');
  805. INSERT INTO teach VALUES('12345678929', 'd_04', '98765432116');
  806. INSERT INTO teach VALUES('12345678928', 'd_03', '98765432115');
  807. INSERT INTO teach VALUES('12345678931', 'd_03', '98765432114');
  808. INSERT INTO teach VALUES('12345678926', 'd_02', '98765432113');
  809. INSERT INTO teach VALUES('12345678931', 'd_02', '98765432112');
  810. INSERT INTO teach VALUES('12345678924', 'd_03', '98765432111');
  811. INSERT INTO teach VALUES('12345678930', 'd_04', '98765432110');
  812. INSERT INTO teach VALUES('12345678926', 'd_04', '98765432109');
  813. INSERT INTO teach VALUES('12345678931', 'd_03', '98765432108');
  814. INSERT INTO teach VALUES('12345678930', 'd_01', '98765432107');
  815. INSERT INTO teach VALUES('12345678923', 'd_04', '98765432106');
  816. INSERT INTO teach VALUES('12345678932', 'd_04', '98765432105');
  817. INSERT INTO teach VALUES('12345678927', 'd_04', '98765432104');
  818. INSERT INTO teach VALUES('12345678927', 'd_01', '98765432103');
  819. INSERT INTO teach VALUES('12345678931', 'd_02', '98765432102');
  820. INSERT INTO teach VALUES('12345678927', 'd_03', '98765432101');
  821. INSERT INTO teach VALUES('12345678928', 'd_03', '98765432100');
  822. INSERT INTO teach VALUES('12345678929', 'd_03', '98765432099');
  823. INSERT INTO teach VALUES('12345678929', 'd_04', '98765432098');
  824. INSERT INTO teach VALUES('12345678930', 'd_01', '98765432097');
  825. INSERT INTO teach VALUES('12345678923', 'd_03', '98765432096');
  826. INSERT INTO teach VALUES('12345678929', 'd_04', '98765432095');
  827. INSERT INTO teach VALUES('12345678926', 'd_02', '98765432094');
  828. INSERT INTO teach VALUES('12345678926', 'd_04', '98765432093');
  829. INSERT INTO teach VALUES('12345678930', 'd_01', '98765432092');
  830. INSERT INTO teach VALUES('12345678932', 'd_02', '98765432091');
  831. INSERT INTO teach VALUES('12345678927', 'd_02', '98765432090');
  832. INSERT INTO teach VALUES('12345678928', 'd_02', '98765432089');
  833. INSERT INTO teach VALUES('12345678932', 'd_02', '98765432088');
  834. INSERT INTO teach VALUES('12345678923', 'd_02', '98765432087');
  835. INSERT INTO teach VALUES('12345678925', 'd_01', '98765432086');
  836. INSERT INTO teach VALUES('12345678931', 'd_03', '98765432085');
  837. INSERT INTO teach VALUES('12345678923', 'd_01', '98765432084');
  838. INSERT INTO teach VALUES('12345678930', 'd_04', '98765432083');
  839. INSERT INTO teach VALUES('12345678930', 'd_04', '98765432082');
  840. INSERT INTO teach VALUES('12345678927', 'd_03', '98765432081');
  841. INSERT INTO teach VALUES('12345678926', 'd_03', '98765432080');
  842. INSERT INTO teach VALUES('12345678932', 'd_03', '98765432079');
  843. INSERT INTO teach VALUES('12345678930', 'd_03', '98765432078');
  844. INSERT INTO teach VALUES('12345678931', 'd_02', '98765432077');
  845. INSERT INTO teach VALUES('12345678931', 'd_02', '98765432076');
  846. INSERT INTO teach VALUES('12345678925', 'd_04', '98765432075');
  847. INSERT INTO teach VALUES('12345678923', 'd_03', '98765432074');
  848. INSERT INTO teach VALUES('12345678932', 'd_03', '98765432073');
  849. INSERT INTO teach VALUES('12345678930', 'd_03', '98765432072');
  850. INSERT INTO teach VALUES('12345678925', 'd_03', '98765432071');
  851. INSERT INTO teach VALUES('12345678931', 'd_02', '98765432070');
  852. INSERT INTO teach VALUES('12345678930', 'd_02', '98765432069');
  853. INSERT INTO teach VALUES('12345678931', 'd_02', '98765432068');
  854. INSERT INTO teach VALUES('12345678923', 'd_02', '98765432067');
  855. INSERT INTO teach VALUES('12345678926', 'd_02', '98765432066');
  856. INSERT INTO teach VALUES('12345678926', 'd_03', '98765432065');
  857. INSERT INTO teach VALUES('12345678932', 'd_04', '98765432064');
  858. INSERT INTO teach VALUES('12345678923', 'd_01', '98765432063');
  859. INSERT INTO teach VALUES('12345678932', 'd_01', '98765432062');
  860. INSERT INTO teach VALUES('12345678929', 'd_04', '98765432061');
  861. INSERT INTO teach VALUES('12345678928', 'd_03', '98765432060');
  862. INSERT INTO teach VALUES('12345678931', 'd_01', '98765432059');
  863. INSERT INTO teach VALUES('12345678929', 'd_01', '98765432058');
  864. INSERT INTO teach VALUES('12345678931', 'd_01', '98765432057');
  865. INSERT INTO teach VALUES('12345678926', 'd_02', '98765432056');
  866. INSERT INTO teach VALUES('12345678929', 'd_01', '98765432055');
  867. INSERT INTO teach VALUES('12345678928', 'd_01', '98765432054');
  868. INSERT INTO teach VALUES('12345678930', 'd_01', '98765432053');
  869. INSERT INTO teach VALUES('12345678929', 'd_04', '98765432052');
  870. INSERT INTO teach VALUES('12345678930', 'd_02', '98765432051');
  871. INSERT INTO teach VALUES('12345678923', 'd_04', '98765432050');
  872.  
  873. --Completed. RELATIONSHIP. Student:ID and Studyprogram:Courseprogram.
  874. INSERT INTO completed VALUES('98765432199', 'Inf');
  875. INSERT INTO completed VALUES('98765432198', 'Inf');
  876. INSERT INTO completed VALUES('98765432197', 'M&D');
  877. INSERT INTO completed VALUES('98765432196', 'Inf');
  878. INSERT INTO completed VALUES('98765432195', 'M&D');
  879. INSERT INTO completed VALUES('98765432194', 'Inf');
  880. INSERT INTO completed VALUES('98765432193', 'M&D');
  881. INSERT INTO completed VALUES('98765432192', 'TI');
  882. INSERT INTO completed VALUES('98765432191', 'TI');
  883. INSERT INTO completed VALUES('98765432190', 'Inf');
  884. INSERT INTO completed VALUES('98765432189', 'TI');
  885. INSERT INTO completed VALUES('98765432188', 'M&D');
  886. INSERT INTO completed VALUES('98765432187', 'TI');
  887. INSERT INTO completed VALUES('98765432186', 'TI');
  888. INSERT INTO completed VALUES('98765432185', 'M&D');
  889. INSERT INTO completed VALUES('98765432184', 'M&D');
  890. INSERT INTO completed VALUES('98765432183', 'TI');
  891. INSERT INTO completed VALUES('98765432182', 'TI');
  892. INSERT INTO completed VALUES('98765432181', 'TI');
  893. INSERT INTO completed VALUES('98765432180', 'Inf');
  894. INSERT INTO completed VALUES('98765432179', 'M&D');
  895. INSERT INTO completed VALUES('98765432178', 'M&D');
  896. INSERT INTO completed VALUES('98765432177', 'Inf');
  897. INSERT INTO completed VALUES('98765432176', 'TI');
  898. INSERT INTO completed VALUES('98765432175', 'Inf');
  899. INSERT INTO completed VALUES('98765432174', 'TI');
  900. INSERT INTO completed VALUES('98765432173', 'Inf');
  901. INSERT INTO completed VALUES('98765432172', 'M&D');
  902. INSERT INTO completed VALUES('98765432171', 'TI');
  903. INSERT INTO completed VALUES('98765432170', 'M&D');
  904. INSERT INTO completed VALUES('98765432169', 'Inf');
  905. INSERT INTO completed VALUES('98765432168', 'Inf');
  906. INSERT INTO completed VALUES('98765432167', 'TI');
  907. INSERT INTO completed VALUES('98765432166', 'M&D');
  908. INSERT INTO completed VALUES('98765432165', 'TI');
  909. INSERT INTO completed VALUES('98765432164', 'M&D');
  910. INSERT INTO completed VALUES('98765432163', 'M&D');
  911. INSERT INTO completed VALUES('98765432162', 'TI');
  912. INSERT INTO completed VALUES('98765432161', 'M&D');
  913. INSERT INTO completed VALUES('98765432160', 'M&D');
  914. INSERT INTO completed VALUES('98765432159', 'M&D');
  915. INSERT INTO completed VALUES('98765432158', 'Inf');
  916. INSERT INTO completed VALUES('98765432157', 'M&D');
  917. INSERT INTO completed VALUES('98765432156', 'Inf');
  918. INSERT INTO completed VALUES('98765432155', 'TI');
  919. INSERT INTO completed VALUES('98765432154', 'TI');
  920. INSERT INTO completed VALUES('98765432153', 'M&D');
  921. INSERT INTO completed VALUES('98765432152', 'TI');
  922. INSERT INTO completed VALUES('98765432151', 'Inf');
  923. INSERT INTO completed VALUES('98765432150', 'TI');
  924. INSERT INTO completed VALUES('98765432149', 'TI');
  925. INSERT INTO completed VALUES('98765432148', 'M&D');
  926. INSERT INTO completed VALUES('98765432147', 'M&D');
  927. INSERT INTO completed VALUES('98765432146', 'M&D');
  928. INSERT INTO completed VALUES('98765432145', 'M&D');
  929. INSERT INTO completed VALUES('98765432144', 'TI');
  930. INSERT INTO completed VALUES('98765432143', 'M&D');
  931. INSERT INTO completed VALUES('98765432142', 'M&D');
  932. INSERT INTO completed VALUES('98765432141', 'Inf');
  933. INSERT INTO completed VALUES('98765432140', 'Inf');
  934. INSERT INTO completed VALUES('98765432139', 'M&D');
  935. INSERT INTO completed VALUES('98765432138', 'M&D');
  936. INSERT INTO completed VALUES('98765432137', 'M&D');
  937. INSERT INTO completed VALUES('98765432136', 'TI');
  938. INSERT INTO completed VALUES('98765432135', 'M&D');
  939. INSERT INTO completed VALUES('98765432134', 'TI');
  940. INSERT INTO completed VALUES('98765432133', 'TI');
  941. INSERT INTO completed VALUES('98765432132', 'Inf');
  942. INSERT INTO completed VALUES('98765432131', 'Inf');
  943. INSERT INTO completed VALUES('98765432130', 'TI');
  944. INSERT INTO completed VALUES('98765432129', 'M&D');
  945. INSERT INTO completed VALUES('98765432128', 'Inf');
  946. INSERT INTO completed VALUES('98765432127', 'Inf');
  947. INSERT INTO completed VALUES('98765432126', 'TI');
  948. INSERT INTO completed VALUES('98765432125', 'TI');
  949. INSERT INTO completed VALUES('98765432124', 'Inf');
  950. INSERT INTO completed VALUES('98765432123', 'TI');
  951. INSERT INTO completed VALUES('98765432122', 'Inf');
  952. INSERT INTO completed VALUES('98765432121', 'Inf');
  953. INSERT INTO completed VALUES('98765432120', 'TI');
  954. INSERT INTO completed VALUES('98765432119', 'M&D');
  955. INSERT INTO completed VALUES('98765432118', 'TI');
  956. INSERT INTO completed VALUES('98765432117', 'M&D');
  957. INSERT INTO completed VALUES('98765432116', 'TI');
  958. INSERT INTO completed VALUES('98765432115', 'M&D');
  959. INSERT INTO completed VALUES('98765432114', 'Inf');
  960. INSERT INTO completed VALUES('98765432113', 'TI');
  961. INSERT INTO completed VALUES('98765432112', 'M&D');
  962. INSERT INTO completed VALUES('98765432111', 'Inf');
  963. INSERT INTO completed VALUES('98765432110', 'M&D');
  964. INSERT INTO completed VALUES('98765432109', 'M&D');
  965. INSERT INTO completed VALUES('98765432108', 'Inf');
  966. INSERT INTO completed VALUES('98765432107', 'Inf');
  967. INSERT INTO completed VALUES('98765432106', 'M&D');
  968. INSERT INTO completed VALUES('98765432105', 'TI');
  969. INSERT INTO completed VALUES('98765432104', 'Inf');
  970. INSERT INTO completed VALUES('98765432103', 'TI');
  971. INSERT INTO completed VALUES('98765432102', 'TI');
  972. INSERT INTO completed VALUES('98765432101', 'TI');
  973. INSERT INTO completed VALUES('98765432100', 'Inf');
  974. INSERT INTO completed VALUES('98765432099', 'TI');
  975. INSERT INTO completed VALUES('98765432098', 'Inf');
  976. INSERT INTO completed VALUES('98765432097', 'TI');
  977. INSERT INTO completed VALUES('98765432096', 'Inf');
  978. INSERT INTO completed VALUES('98765432095', 'M&D');
  979. INSERT INTO completed VALUES('98765432094', 'M&D');
  980. INSERT INTO completed VALUES('98765432093', 'Inf');
  981. INSERT INTO completed VALUES('98765432092', 'M&D');
  982. INSERT INTO completed VALUES('98765432091', 'TI');
  983. INSERT INTO completed VALUES('98765432090', 'M&D');
  984. INSERT INTO completed VALUES('98765432089', 'Inf');
  985. INSERT INTO completed VALUES('98765432088', 'TI');
  986. INSERT INTO completed VALUES('98765432087', 'TI');
  987. INSERT INTO completed VALUES('98765432086', 'Inf');
  988. INSERT INTO completed VALUES('98765432085', 'M&D');
  989. INSERT INTO completed VALUES('98765432084', 'TI');
  990. INSERT INTO completed VALUES('98765432083', 'M&D');
  991. INSERT INTO completed VALUES('98765432082', 'M&D');
  992. INSERT INTO completed VALUES('98765432081', 'TI');
  993. INSERT INTO completed VALUES('98765432080', 'M&D');
  994. INSERT INTO completed VALUES('98765432079', 'Inf');
  995. INSERT INTO completed VALUES('98765432078', 'TI');
  996. INSERT INTO completed VALUES('98765432077', 'M&D');
  997. INSERT INTO completed VALUES('98765432076', 'Inf');
  998. INSERT INTO completed VALUES('98765432075', 'Inf');
  999. INSERT INTO completed VALUES('98765432074', 'M&D');
  1000. INSERT INTO completed VALUES('98765432073', 'TI');
  1001. INSERT INTO completed VALUES('98765432072', 'TI');
  1002. INSERT INTO completed VALUES('98765432071', 'Inf');
  1003. INSERT INTO completed VALUES('98765432070', 'Inf');
  1004. INSERT INTO completed VALUES('98765432069', 'TI');
  1005. INSERT INTO completed VALUES('98765432068', 'TI');
  1006. INSERT INTO completed VALUES('98765432067', 'Inf');
  1007. INSERT INTO completed VALUES('98765432066', 'TI');
  1008. INSERT INTO completed VALUES('98765432065', 'TI');
  1009. INSERT INTO completed VALUES('98765432064', 'TI');
  1010. INSERT INTO completed VALUES('98765432063', 'TI');
  1011. INSERT INTO completed VALUES('98765432062', 'M&D');
  1012. INSERT INTO completed VALUES('98765432061', 'Inf');
  1013. INSERT INTO completed VALUES('98765432060', 'Inf');
  1014. INSERT INTO completed VALUES('98765432059', 'Inf');
  1015. INSERT INTO completed VALUES('98765432058', 'M&D');
  1016. INSERT INTO completed VALUES('98765432057', 'Inf');
  1017. INSERT INTO completed VALUES('98765432056', 'M&D');
  1018. INSERT INTO completed VALUES('98765432055', 'TI');
  1019. INSERT INTO completed VALUES('98765432054', 'TI');
  1020. INSERT INTO completed VALUES('98765432053', 'Inf');
  1021. INSERT INTO completed VALUES('98765432052', 'M&D');
  1022. INSERT INTO completed VALUES('98765432051', 'M&D');
  1023. INSERT INTO completed VALUES('98765432050', 'M&D');
  1024.  
  1025. --Assingment. Assingmentcode, isGraded, published year, published week, Course:Coursecode
  1026.  
  1027. INSERT INTO assignment VALUES('ass_01', True, '2010', '12', 'a_01');
  1028. INSERT INTO assignment VALUES('ass_02', True, '2010', '25', 'a_02');
  1029. INSERT INTO assignment VALUES('ass_03', True, '2010', '41', 'a_03');
  1030. INSERT INTO assignment VALUES('ass_04', True, '2011', '4', 'a_04');
  1031. INSERT INTO assignment VALUES('ass_11', True, '2009', '15', 'b_01');
  1032. INSERT INTO assignment VALUES('ass_12', True, '2009', '28', 'b_02');
  1033. INSERT INTO assignment VALUES('ass_13', True, '2009', '41', 'b_03');
  1034. INSERT INTO assignment VALUES('ass_14', True, '2010', '7', 'b_04');
  1035. INSERT INTO assignment VALUES('ass_21', True, '2007', '40', 'c_01');
  1036. INSERT INTO assignment VALUES('ass_22', True, '2007', '51', 'c_02');
  1037. INSERT INTO assignment VALUES('ass_23', True, '2008', '7', 'c_03');
  1038. INSERT INTO assignment VALUES('ass_24', True, '2008', '17', 'c_04');
  1039. INSERT INTO assignment VALUES('ass_31', False, '2009', '15', 'd_01');
  1040. INSERT INTO assignment VALUES('ass_32', False, '2009', '28', 'd_02');
  1041. INSERT INTO assignment VALUES('ass_33', False, '2009', '41', 'd_03');
  1042. INSERT INTO assignment VALUES('ass_34', True, '2010', '7', 'd_04');
  1043.  
  1044. --Work on. RELATIONSHIP. Student:ID, Assingment:Assignmentcode, Course:CourseCode
  1045.  
  1046. INSERT INTO work_on VALUES('12345678932', 'ass_01', 'a_01');
  1047. INSERT INTO work_on VALUES('12345678929', 'ass_02', 'a_02');
  1048. INSERT INTO work_on VALUES('12345678926', 'ass_03', 'a_03');
  1049. INSERT INTO work_on VALUES('12345678931', 'ass_04', 'a_04');
  1050. INSERT INTO work_on VALUES('12345678928', 'ass_11', 'b_01');
  1051. INSERT INTO work_on VALUES('12345678929', 'ass_12', 'b_02');
  1052. INSERT INTO work_on VALUES('12345678930', 'ass_13', 'b_03');
  1053. INSERT INTO work_on VALUES('12345678924', 'ass_14', 'b_04');
  1054. INSERT INTO work_on VALUES('12345678928', 'ass_21', 'c_01');
  1055. INSERT INTO work_on VALUES('12345678926', 'ass_22', 'c_02');
  1056. INSERT INTO work_on VALUES('12345678929', 'ass_23', 'c_03');
  1057. INSERT INTO work_on VALUES('12345678930', 'ass_24', 'c_04');
  1058. INSERT INTO work_on VALUES('12345678932', 'ass_31', 'd_01');
  1059. INSERT INTO work_on VALUES('12345678926', 'ass_32', 'd_02');
  1060. INSERT INTO work_on VALUES('12345678925', 'ass_33', 'd_03');
  1061. INSERT INTO work_on VALUES('12345678924', 'ass_34', 'd_04');
  1062.  
  1063. --Requirement. RELATIONSHIP.
  1064.  
  1065. INSERT INTO requirement VALUES('ass_02', 'ass_01', 'a_02', 'a_01');
  1066. INSERT INTO requirement VALUES('ass_03', 'ass_02', 'a_03', 'a_02');
  1067. INSERT INTO requirement VALUES('ass_04', 'ass_03', 'a_04', 'a_03');
  1068. INSERT INTO requirement VALUES('ass_12', 'ass_11', 'b_02', 'b_01');
  1069. INSERT INTO requirement VALUES('ass_13', 'ass_12', 'b_03', 'b_02');
  1070. INSERT INTO requirement VALUES('ass_14', 'ass_13', 'b_04', 'b_03');
  1071. INSERT INTO requirement VALUES('ass_22', 'ass_21', 'c_02', 'c_01');
  1072. INSERT INTO requirement VALUES('ass_23', 'ass_22', 'c_03', 'c_02');
  1073. INSERT INTO requirement VALUES('ass_24', 'ass_23', 'c_04', 'c_03');
  1074. INSERT INTO requirement VALUES('ass_32', 'ass_31', 'd_02', 'd_01');
  1075. INSERT INTO requirement VALUES('ass_33', 'ass_32', 'd_03', 'd_02');
  1076. INSERT INTO requirement VALUES('ass_34', 'ass_33', 'd_04', 'd_03');
  1077.  
  1078. --Are given. RELATIONSHIP.
  1079.  
  1080. INSERT INTO are_given VALUES('98765432198', 'ass_01', 'a_01');
  1081. INSERT INTO are_given VALUES('98765432198', 'ass_02', 'a_02');
  1082. INSERT INTO are_given VALUES('98765432198', 'ass_03', 'a_03');
  1083. INSERT INTO are_given VALUES('98765432198', 'ass_04', 'a_04');
  1084. INSERT INTO are_given VALUES('98765432198', 'ass_11', 'b_01');
  1085. INSERT INTO are_given VALUES('98765432198', 'ass_12', 'b_02');
  1086. INSERT INTO are_given VALUES('98765432198', 'ass_13', 'b_03');
  1087. INSERT INTO are_given VALUES('98765432198', 'ass_14', 'b_04');
  1088. INSERT INTO are_given VALUES('98765432198', 'ass_21', 'c_01');
  1089. INSERT INTO are_given VALUES('98765432198', 'ass_22', 'c_02');
  1090. INSERT INTO are_given VALUES('98765432198', 'ass_23', 'c_03');
  1091. INSERT INTO are_given VALUES('98765432198', 'ass_24', 'c_04');
  1092. INSERT INTO are_given VALUES('98765432198', 'ass_31', 'd_01');
  1093. INSERT INTO are_given VALUES('98765432198', 'ass_32', 'd_02');
  1094. INSERT INTO are_given VALUES('98765432198', 'ass_33', 'd_03');
  1095. INSERT INTO are_given VALUES('98765432198', 'ass_34', 'd_04');
  1096. INSERT INTO are_given VALUES('98765432197', 'ass_01', 'a_01');
  1097. INSERT INTO are_given VALUES('98765432197', 'ass_02', 'a_02');
  1098. INSERT INTO are_given VALUES('98765432197', 'ass_03', 'a_03');
  1099. INSERT INTO are_given VALUES('98765432197', 'ass_04', 'a_04');
  1100. INSERT INTO are_given VALUES('98765432197', 'ass_11', 'b_01');
  1101. INSERT INTO are_given VALUES('98765432197', 'ass_12', 'b_02');
  1102. INSERT INTO are_given VALUES('98765432197', 'ass_13', 'b_03');
  1103. INSERT INTO are_given VALUES('98765432197', 'ass_14', 'b_04');
  1104. INSERT INTO are_given VALUES('98765432197', 'ass_21', 'c_01');
  1105. INSERT INTO are_given VALUES('98765432197', 'ass_22', 'c_02');
  1106. INSERT INTO are_given VALUES('98765432197', 'ass_23', 'c_03');
  1107. INSERT INTO are_given VALUES('98765432197', 'ass_24', 'c_04');
  1108. INSERT INTO are_given VALUES('98765432197', 'ass_31', 'd_01');
  1109. INSERT INTO are_given VALUES('98765432197', 'ass_32', 'd_02');
  1110. INSERT INTO are_given VALUES('98765432197', 'ass_33', 'd_03');
  1111. INSERT INTO are_given VALUES('98765432197', 'ass_34', 'd_04');
  1112. INSERT INTO are_given VALUES('98765432196', 'ass_01', 'a_01');
  1113. INSERT INTO are_given VALUES('98765432196', 'ass_02', 'a_02');
  1114. INSERT INTO are_given VALUES('98765432196', 'ass_03', 'a_03');
  1115. INSERT INTO are_given VALUES('98765432196', 'ass_04', 'a_04');
  1116. INSERT INTO are_given VALUES('98765432196', 'ass_11', 'b_01');
  1117. INSERT INTO are_given VALUES('98765432196', 'ass_12', 'b_02');
  1118. INSERT INTO are_given VALUES('98765432196', 'ass_13', 'b_03');
  1119. INSERT INTO are_given VALUES('98765432196', 'ass_14', 'b_04');
  1120. INSERT INTO are_given VALUES('98765432196', 'ass_21', 'c_01');
  1121. INSERT INTO are_given VALUES('98765432196', 'ass_22', 'c_02');
  1122. INSERT INTO are_given VALUES('98765432196', 'ass_23', 'c_03');
  1123. INSERT INTO are_given VALUES('98765432196', 'ass_24', 'c_04');
  1124. INSERT INTO are_given VALUES('98765432196', 'ass_31', 'd_01');
  1125. INSERT INTO are_given VALUES('98765432196', 'ass_32', 'd_02');
  1126. INSERT INTO are_given VALUES('98765432196', 'ass_33', 'd_03');
  1127. INSERT INTO are_given VALUES('98765432196', 'ass_34', 'd_04');
  1128. INSERT INTO are_given VALUES('98765432195', 'ass_01', 'a_01');
  1129. INSERT INTO are_given VALUES('98765432195', 'ass_02', 'a_02');
  1130. INSERT INTO are_given VALUES('98765432195', 'ass_03', 'a_03');
  1131. INSERT INTO are_given VALUES('98765432195', 'ass_04', 'a_04');
  1132. INSERT INTO are_given VALUES('98765432195', 'ass_11', 'b_01');
  1133. INSERT INTO are_given VALUES('98765432195', 'ass_12', 'b_02');
  1134. INSERT INTO are_given VALUES('98765432195', 'ass_13', 'b_03');
  1135. INSERT INTO are_given VALUES('98765432195', 'ass_14', 'b_04');
  1136. INSERT INTO are_given VALUES('98765432195', 'ass_21', 'c_01');
  1137. INSERT INTO are_given VALUES('98765432195', 'ass_22', 'c_02');
  1138. INSERT INTO are_given VALUES('98765432195', 'ass_23', 'c_03');
  1139. INSERT INTO are_given VALUES('98765432195', 'ass_24', 'c_04');
  1140. INSERT INTO are_given VALUES('98765432195', 'ass_31', 'd_01');
  1141. INSERT INTO are_given VALUES('98765432195', 'ass_32', 'd_02');
  1142. INSERT INTO are_given VALUES('98765432195', 'ass_33', 'd_03');
  1143. INSERT INTO are_given VALUES('98765432195', 'ass_34', 'd_04');
  1144. INSERT INTO are_given VALUES('98765432194', 'ass_01', 'a_01');
  1145. INSERT INTO are_given VALUES('98765432194', 'ass_02', 'a_02');
  1146. INSERT INTO are_given VALUES('98765432194', 'ass_03', 'a_03');
  1147. INSERT INTO are_given VALUES('98765432194', 'ass_04', 'a_04');
  1148. INSERT INTO are_given VALUES('98765432194', 'ass_11', 'b_01');
  1149. INSERT INTO are_given VALUES('98765432194', 'ass_12', 'b_02');
  1150. INSERT INTO are_given VALUES('98765432194', 'ass_13', 'b_03');
  1151. INSERT INTO are_given VALUES('98765432194', 'ass_14', 'b_04');
  1152. INSERT INTO are_given VALUES('98765432194', 'ass_21', 'c_01');
  1153. INSERT INTO are_given VALUES('98765432194', 'ass_22', 'c_02');
  1154. INSERT INTO are_given VALUES('98765432194', 'ass_23', 'c_03');
  1155. INSERT INTO are_given VALUES('98765432194', 'ass_24', 'c_04');
  1156. INSERT INTO are_given VALUES('98765432194', 'ass_31', 'd_01');
  1157. INSERT INTO are_given VALUES('98765432194', 'ass_32', 'd_02');
  1158. INSERT INTO are_given VALUES('98765432194', 'ass_33', 'd_03');
  1159. INSERT INTO are_given VALUES('98765432194', 'ass_34', 'd_04');
  1160. INSERT INTO are_given VALUES('98765432193', 'ass_01', 'a_01');
  1161. INSERT INTO are_given VALUES('98765432193', 'ass_02', 'a_02');
  1162. INSERT INTO are_given VALUES('98765432193', 'ass_03', 'a_03');
  1163. INSERT INTO are_given VALUES('98765432193', 'ass_04', 'a_04');
  1164. INSERT INTO are_given VALUES('98765432193', 'ass_11', 'b_01');
  1165. INSERT INTO are_given VALUES('98765432193', 'ass_12', 'b_02');
  1166. INSERT INTO are_given VALUES('98765432193', 'ass_13', 'b_03');
  1167. INSERT INTO are_given VALUES('98765432193', 'ass_14', 'b_04');
  1168. INSERT INTO are_given VALUES('98765432193', 'ass_21', 'c_01');
  1169. INSERT INTO are_given VALUES('98765432193', 'ass_22', 'c_02');
  1170. INSERT INTO are_given VALUES('98765432193', 'ass_23', 'c_03');
  1171. INSERT INTO are_given VALUES('98765432193', 'ass_24', 'c_04');
  1172. INSERT INTO are_given VALUES('98765432193', 'ass_31', 'd_01');
  1173. INSERT INTO are_given VALUES('98765432193', 'ass_32', 'd_02');
  1174. INSERT INTO are_given VALUES('98765432193', 'ass_33', 'd_03');
  1175. INSERT INTO are_given VALUES('98765432193', 'ass_34', 'd_04');
  1176. INSERT INTO are_given VALUES('98765432192', 'ass_01', 'a_01');
  1177. INSERT INTO are_given VALUES('98765432192', 'ass_02', 'a_02');
  1178. INSERT INTO are_given VALUES('98765432192', 'ass_03', 'a_03');
  1179. INSERT INTO are_given VALUES('98765432192', 'ass_04', 'a_04');
  1180. INSERT INTO are_given VALUES('98765432192', 'ass_11', 'b_01');
  1181. INSERT INTO are_given VALUES('98765432192', 'ass_12', 'b_02');
  1182. INSERT INTO are_given VALUES('98765432192', 'ass_13', 'b_03');
  1183. INSERT INTO are_given VALUES('98765432192', 'ass_14', 'b_04');
  1184. INSERT INTO are_given VALUES('98765432192', 'ass_21', 'c_01');
  1185. INSERT INTO are_given VALUES('98765432192', 'ass_22', 'c_02');
  1186. INSERT INTO are_given VALUES('98765432192', 'ass_23', 'c_03');
  1187. INSERT INTO are_given VALUES('98765432192', 'ass_24', 'c_04');
  1188. INSERT INTO are_given VALUES('98765432192', 'ass_31', 'd_01');
  1189. INSERT INTO are_given VALUES('98765432192', 'ass_32', 'd_02');
  1190. INSERT INTO are_given VALUES('98765432192', 'ass_33', 'd_03');
  1191. INSERT INTO are_given VALUES('98765432192', 'ass_34', 'd_04');
  1192. INSERT INTO are_given VALUES('98765432191', 'ass_01', 'a_01');
  1193. INSERT INTO are_given VALUES('98765432191', 'ass_02', 'a_02');
  1194. INSERT INTO are_given VALUES('98765432191', 'ass_03', 'a_03');
  1195. INSERT INTO are_given VALUES('98765432191', 'ass_04', 'a_04');
  1196. INSERT INTO are_given VALUES('98765432191', 'ass_11', 'b_01');
  1197. INSERT INTO are_given VALUES('98765432191', 'ass_12', 'b_02');
  1198. INSERT INTO are_given VALUES('98765432191', 'ass_13', 'b_03');
  1199. INSERT INTO are_given VALUES('98765432191', 'ass_14', 'b_04');
  1200. INSERT INTO are_given VALUES('98765432191', 'ass_21', 'c_01');
  1201. INSERT INTO are_given VALUES('98765432191', 'ass_22', 'c_02');
  1202. INSERT INTO are_given VALUES('98765432191', 'ass_23', 'c_03');
  1203. INSERT INTO are_given VALUES('98765432191', 'ass_24', 'c_04');
  1204. INSERT INTO are_given VALUES('98765432191', 'ass_31', 'd_01');
  1205. INSERT INTO are_given VALUES('98765432191', 'ass_32', 'd_02');
  1206. INSERT INTO are_given VALUES('98765432191', 'ass_33', 'd_03');
  1207. INSERT INTO are_given VALUES('98765432191', 'ass_34', 'd_04');
  1208. INSERT INTO are_given VALUES('98765432190', 'ass_01', 'a_01');
  1209. INSERT INTO are_given VALUES('98765432190', 'ass_02', 'a_02');
  1210. INSERT INTO are_given VALUES('98765432190', 'ass_03', 'a_03');
  1211. INSERT INTO are_given VALUES('98765432190', 'ass_04', 'a_04');
  1212. INSERT INTO are_given VALUES('98765432190', 'ass_11', 'b_01');
  1213. INSERT INTO are_given VALUES('98765432190', 'ass_12', 'b_02');
  1214. INSERT INTO are_given VALUES('98765432190', 'ass_13', 'b_03');
  1215. INSERT INTO are_given VALUES('98765432190', 'ass_14', 'b_04');
  1216. INSERT INTO are_given VALUES('98765432190', 'ass_21', 'c_01');
  1217. INSERT INTO are_given VALUES('98765432190', 'ass_22', 'c_02');
  1218. INSERT INTO are_given VALUES('98765432190', 'ass_23', 'c_03');
  1219. INSERT INTO are_given VALUES('98765432190', 'ass_24', 'c_04');
  1220. INSERT INTO are_given VALUES('98765432190', 'ass_31', 'd_01');
  1221. INSERT INTO are_given VALUES('98765432190', 'ass_32', 'd_02');
  1222. INSERT INTO are_given VALUES('98765432190', 'ass_33', 'd_03');
  1223. INSERT INTO are_given VALUES('98765432190', 'ass_34', 'd_04');
  1224. INSERT INTO are_given VALUES('98765432189', 'ass_01', 'a_01');
  1225. INSERT INTO are_given VALUES('98765432189', 'ass_02', 'a_02');
  1226. INSERT INTO are_given VALUES('98765432189', 'ass_03', 'a_03');
  1227. INSERT INTO are_given VALUES('98765432189', 'ass_04', 'a_04');
  1228. INSERT INTO are_given VALUES('98765432189', 'ass_11', 'b_01');
  1229. INSERT INTO are_given VALUES('98765432189', 'ass_12', 'b_02');
  1230. INSERT INTO are_given VALUES('98765432189', 'ass_13', 'b_03');
  1231. INSERT INTO are_given VALUES('98765432189', 'ass_14', 'b_04');
  1232. INSERT INTO are_given VALUES('98765432189', 'ass_21', 'c_01');
  1233. INSERT INTO are_given VALUES('98765432189', 'ass_22', 'c_02');
  1234. INSERT INTO are_given VALUES('98765432189', 'ass_23', 'c_03');
  1235. INSERT INTO are_given VALUES('98765432189', 'ass_24', 'c_04');
  1236. INSERT INTO are_given VALUES('98765432189', 'ass_31', 'd_01');
  1237. INSERT INTO are_given VALUES('98765432189', 'ass_32', 'd_02');
  1238. INSERT INTO are_given VALUES('98765432189', 'ass_33', 'd_03');
  1239. INSERT INTO are_given VALUES('98765432189', 'ass_34', 'd_04');
  1240. INSERT INTO are_given VALUES('98765432188', 'ass_01', 'a_01');
  1241. INSERT INTO are_given VALUES('98765432188', 'ass_02', 'a_02');
  1242. INSERT INTO are_given VALUES('98765432188', 'ass_03', 'a_03');
  1243. INSERT INTO are_given VALUES('98765432188', 'ass_04', 'a_04');
  1244. INSERT INTO are_given VALUES('98765432188', 'ass_11', 'b_01');
  1245. INSERT INTO are_given VALUES('98765432188', 'ass_12', 'b_02');
  1246. INSERT INTO are_given VALUES('98765432188', 'ass_13', 'b_03');
  1247. INSERT INTO are_given VALUES('98765432188', 'ass_14', 'b_04');
  1248. INSERT INTO are_given VALUES('98765432188', 'ass_21', 'c_01');
  1249. INSERT INTO are_given VALUES('98765432188', 'ass_22', 'c_02');
  1250. INSERT INTO are_given VALUES('98765432188', 'ass_23', 'c_03');
  1251. INSERT INTO are_given VALUES('98765432188', 'ass_24', 'c_04');
  1252. INSERT INTO are_given VALUES('98765432188', 'ass_31', 'd_01');
  1253. INSERT INTO are_given VALUES('98765432188', 'ass_32', 'd_02');
  1254. INSERT INTO are_given VALUES('98765432188', 'ass_33', 'd_03');
  1255. INSERT INTO are_given VALUES('98765432188', 'ass_34', 'd_04');
  1256. INSERT INTO are_given VALUES('98765432187', 'ass_01', 'a_01');
  1257. INSERT INTO are_given VALUES('98765432187', 'ass_02', 'a_02');
  1258. INSERT INTO are_given VALUES('98765432187', 'ass_03', 'a_03');
  1259. INSERT INTO are_given VALUES('98765432187', 'ass_04', 'a_04');
  1260. INSERT INTO are_given VALUES('98765432187', 'ass_11', 'b_01');
  1261. INSERT INTO are_given VALUES('98765432187', 'ass_12', 'b_02');
  1262. INSERT INTO are_given VALUES('98765432187', 'ass_13', 'b_03');
  1263. INSERT INTO are_given VALUES('98765432187', 'ass_14', 'b_04');
  1264. INSERT INTO are_given VALUES('98765432187', 'ass_21', 'c_01');
  1265. INSERT INTO are_given VALUES('98765432187', 'ass_22', 'c_02');
  1266. INSERT INTO are_given VALUES('98765432187', 'ass_23', 'c_03');
  1267. INSERT INTO are_given VALUES('98765432187', 'ass_24', 'c_04');
  1268. INSERT INTO are_given VALUES('98765432187', 'ass_31', 'd_01');
  1269. INSERT INTO are_given VALUES('98765432187', 'ass_32', 'd_02');
  1270. INSERT INTO are_given VALUES('98765432187', 'ass_33', 'd_03');
  1271. INSERT INTO are_given VALUES('98765432187', 'ass_34', 'd_04');
  1272. INSERT INTO are_given VALUES('98765432186', 'ass_01', 'a_01');
  1273. INSERT INTO are_given VALUES('98765432186', 'ass_02', 'a_02');
  1274. INSERT INTO are_given VALUES('98765432186', 'ass_03', 'a_03');
  1275. INSERT INTO are_given VALUES('98765432186', 'ass_04', 'a_04');
  1276. INSERT INTO are_given VALUES('98765432186', 'ass_11', 'b_01');
  1277. INSERT INTO are_given VALUES('98765432186', 'ass_12', 'b_02');
  1278. INSERT INTO are_given VALUES('98765432186', 'ass_13', 'b_03');
  1279. INSERT INTO are_given VALUES('98765432186', 'ass_14', 'b_04');
  1280. INSERT INTO are_given VALUES('98765432186', 'ass_21', 'c_01');
  1281. INSERT INTO are_given VALUES('98765432186', 'ass_22', 'c_02');
  1282. INSERT INTO are_given VALUES('98765432186', 'ass_23', 'c_03');
  1283. INSERT INTO are_given VALUES('98765432186', 'ass_24', 'c_04');
  1284. INSERT INTO are_given VALUES('98765432186', 'ass_31', 'd_01');
  1285. INSERT INTO are_given VALUES('98765432186', 'ass_32', 'd_02');
  1286. INSERT INTO are_given VALUES('98765432186', 'ass_33', 'd_03');
  1287. INSERT INTO are_given VALUES('98765432186', 'ass_34', 'd_04');
  1288. INSERT INTO are_given VALUES('98765432185', 'ass_01', 'a_01');
  1289. INSERT INTO are_given VALUES('98765432185', 'ass_02', 'a_02');
  1290. INSERT INTO are_given VALUES('98765432185', 'ass_03', 'a_03');
  1291. INSERT INTO are_given VALUES('98765432185', 'ass_04', 'a_04');
  1292. INSERT INTO are_given VALUES('98765432185', 'ass_11', 'b_01');
  1293. INSERT INTO are_given VALUES('98765432185', 'ass_12', 'b_02');
  1294. INSERT INTO are_given VALUES('98765432185', 'ass_13', 'b_03');
  1295. INSERT INTO are_given VALUES('98765432185', 'ass_14', 'b_04');
  1296. INSERT INTO are_given VALUES('98765432185', 'ass_21', 'c_01');
  1297. INSERT INTO are_given VALUES('98765432185', 'ass_22', 'c_02');
  1298. INSERT INTO are_given VALUES('98765432185', 'ass_23', 'c_03');
  1299. INSERT INTO are_given VALUES('98765432185', 'ass_24', 'c_04');
  1300. INSERT INTO are_given VALUES('98765432185', 'ass_31', 'd_01');
  1301. INSERT INTO are_given VALUES('98765432185', 'ass_32', 'd_02');
  1302. INSERT INTO are_given VALUES('98765432185', 'ass_33', 'd_03');
  1303. INSERT INTO are_given VALUES('98765432185', 'ass_34', 'd_04');
  1304. INSERT INTO are_given VALUES('98765432184', 'ass_01', 'a_01');
  1305. INSERT INTO are_given VALUES('98765432184', 'ass_02', 'a_02');
  1306. INSERT INTO are_given VALUES('98765432184', 'ass_03', 'a_03');
  1307. INSERT INTO are_given VALUES('98765432184', 'ass_04', 'a_04');
  1308. INSERT INTO are_given VALUES('98765432184', 'ass_11', 'b_01');
  1309. INSERT INTO are_given VALUES('98765432184', 'ass_12', 'b_02');
  1310. INSERT INTO are_given VALUES('98765432184', 'ass_13', 'b_03');
  1311. INSERT INTO are_given VALUES('98765432184', 'ass_14', 'b_04');
  1312. INSERT INTO are_given VALUES('98765432184', 'ass_21', 'c_01');
  1313. INSERT INTO are_given VALUES('98765432184', 'ass_22', 'c_02');
  1314. INSERT INTO are_given VALUES('98765432184', 'ass_23', 'c_03');
  1315. INSERT INTO are_given VALUES('98765432184', 'ass_24', 'c_04');
  1316. INSERT INTO are_given VALUES('98765432184', 'ass_31', 'd_01');
  1317. INSERT INTO are_given VALUES('98765432184', 'ass_32', 'd_02');
  1318. INSERT INTO are_given VALUES('98765432184', 'ass_33', 'd_03');
  1319. INSERT INTO are_given VALUES('98765432184', 'ass_34', 'd_04');
  1320. INSERT INTO are_given VALUES('98765432183', 'ass_01', 'a_01');
  1321. INSERT INTO are_given VALUES('98765432183', 'ass_02', 'a_02');
  1322. INSERT INTO are_given VALUES('98765432183', 'ass_03', 'a_03');
  1323. INSERT INTO are_given VALUES('98765432183', 'ass_04', 'a_04');
  1324. INSERT INTO are_given VALUES('98765432183', 'ass_11', 'b_01');
  1325. INSERT INTO are_given VALUES('98765432183', 'ass_12', 'b_02');
  1326. INSERT INTO are_given VALUES('98765432183', 'ass_13', 'b_03');
  1327. INSERT INTO are_given VALUES('98765432183', 'ass_14', 'b_04');
  1328. INSERT INTO are_given VALUES('98765432183', 'ass_21', 'c_01');
  1329. INSERT INTO are_given VALUES('98765432183', 'ass_22', 'c_02');
  1330. INSERT INTO are_given VALUES('98765432183', 'ass_23', 'c_03');
  1331. INSERT INTO are_given VALUES('98765432183', 'ass_24', 'c_04');
  1332. INSERT INTO are_given VALUES('98765432183', 'ass_31', 'd_01');
  1333. INSERT INTO are_given VALUES('98765432183', 'ass_32', 'd_02');
  1334. INSERT INTO are_given VALUES('98765432183', 'ass_33', 'd_03');
  1335. INSERT INTO are_given VALUES('98765432183', 'ass_34', 'd_04');
  1336. INSERT INTO are_given VALUES('98765432182', 'ass_01', 'a_01');
  1337. INSERT INTO are_given VALUES('98765432182', 'ass_02', 'a_02');
  1338. INSERT INTO are_given VALUES('98765432182', 'ass_03', 'a_03');
  1339. INSERT INTO are_given VALUES('98765432182', 'ass_04', 'a_04');
  1340. INSERT INTO are_given VALUES('98765432182', 'ass_11', 'b_01');
  1341. INSERT INTO are_given VALUES('98765432182', 'ass_12', 'b_02');
  1342. INSERT INTO are_given VALUES('98765432182', 'ass_13', 'b_03');
  1343. INSERT INTO are_given VALUES('98765432182', 'ass_14', 'b_04');
  1344. INSERT INTO are_given VALUES('98765432182', 'ass_21', 'c_01');
  1345. INSERT INTO are_given VALUES('98765432182', 'ass_22', 'c_02');
  1346. INSERT INTO are_given VALUES('98765432182', 'ass_23', 'c_03');
  1347. INSERT INTO are_given VALUES('98765432182', 'ass_24', 'c_04');
  1348. INSERT INTO are_given VALUES('98765432182', 'ass_31', 'd_01');
  1349. INSERT INTO are_given VALUES('98765432182', 'ass_32', 'd_02');
  1350. INSERT INTO are_given VALUES('98765432182', 'ass_33', 'd_03');
  1351. INSERT INTO are_given VALUES('98765432182', 'ass_34', 'd_04');
  1352. INSERT INTO are_given VALUES('98765432181', 'ass_01', 'a_01');
  1353. INSERT INTO are_given VALUES('98765432181', 'ass_02', 'a_02');
  1354. INSERT INTO are_given VALUES('98765432181', 'ass_03', 'a_03');
  1355. INSERT INTO are_given VALUES('98765432181', 'ass_04', 'a_04');
  1356. INSERT INTO are_given VALUES('98765432181', 'ass_11', 'b_01');
  1357. INSERT INTO are_given VALUES('98765432181', 'ass_12', 'b_02');
  1358. INSERT INTO are_given VALUES('98765432181', 'ass_13', 'b_03');
  1359. INSERT INTO are_given VALUES('98765432181', 'ass_14', 'b_04');
  1360. INSERT INTO are_given VALUES('98765432181', 'ass_21', 'c_01');
  1361. INSERT INTO are_given VALUES('98765432181', 'ass_22', 'c_02');
  1362. INSERT INTO are_given VALUES('98765432181', 'ass_23', 'c_03');
  1363. INSERT INTO are_given VALUES('98765432181', 'ass_24', 'c_04');
  1364. INSERT INTO are_given VALUES('98765432181', 'ass_31', 'd_01');
  1365. INSERT INTO are_given VALUES('98765432181', 'ass_32', 'd_02');
  1366. INSERT INTO are_given VALUES('98765432181', 'ass_33', 'd_03');
  1367. INSERT INTO are_given VALUES('98765432181', 'ass_34', 'd_04');
  1368. INSERT INTO are_given VALUES('98765432180', 'ass_01', 'a_01');
  1369. INSERT INTO are_given VALUES('98765432180', 'ass_02', 'a_02');
  1370. INSERT INTO are_given VALUES('98765432180', 'ass_03', 'a_03');
  1371. INSERT INTO are_given VALUES('98765432180', 'ass_04', 'a_04');
  1372. INSERT INTO are_given VALUES('98765432180', 'ass_11', 'b_01');
  1373. INSERT INTO are_given VALUES('98765432180', 'ass_12', 'b_02');
  1374. INSERT INTO are_given VALUES('98765432180', 'ass_13', 'b_03');
  1375. INSERT INTO are_given VALUES('98765432180', 'ass_14', 'b_04');
  1376. INSERT INTO are_given VALUES('98765432180', 'ass_21', 'c_01');
  1377. INSERT INTO are_given VALUES('98765432180', 'ass_22', 'c_02');
  1378. INSERT INTO are_given VALUES('98765432180', 'ass_23', 'c_03');
  1379. INSERT INTO are_given VALUES('98765432180', 'ass_24', 'c_04');
  1380. INSERT INTO are_given VALUES('98765432180', 'ass_31', 'd_01');
  1381. INSERT INTO are_given VALUES('98765432180', 'ass_32', 'd_02');
  1382. INSERT INTO are_given VALUES('98765432180', 'ass_33', 'd_03');
  1383. INSERT INTO are_given VALUES('98765432180', 'ass_34', 'd_04');
  1384. INSERT INTO are_given VALUES('98765432179', 'ass_01', 'a_01');
  1385. INSERT INTO are_given VALUES('98765432179', 'ass_02', 'a_02');
  1386. INSERT INTO are_given VALUES('98765432179', 'ass_03', 'a_03');
  1387. INSERT INTO are_given VALUES('98765432179', 'ass_04', 'a_04');
  1388. INSERT INTO are_given VALUES('98765432179', 'ass_11', 'b_01');
  1389. INSERT INTO are_given VALUES('98765432179', 'ass_12', 'b_02');
  1390. INSERT INTO are_given VALUES('98765432179', 'ass_13', 'b_03');
  1391. INSERT INTO are_given VALUES('98765432179', 'ass_14', 'b_04');
  1392. INSERT INTO are_given VALUES('98765432179', 'ass_21', 'c_01');
  1393. INSERT INTO are_given VALUES('98765432179', 'ass_22', 'c_02');
  1394. INSERT INTO are_given VALUES('98765432179', 'ass_23', 'c_03');
  1395. INSERT INTO are_given VALUES('98765432179', 'ass_24', 'c_04');
  1396. INSERT INTO are_given VALUES('98765432179', 'ass_31', 'd_01');
  1397. INSERT INTO are_given VALUES('98765432179', 'ass_32', 'd_02');
  1398. INSERT INTO are_given VALUES('98765432179', 'ass_33', 'd_03');
  1399. INSERT INTO are_given VALUES('98765432179', 'ass_34', 'd_04');
  1400. INSERT INTO are_given VALUES('98765432178', 'ass_01', 'a_01');
  1401. INSERT INTO are_given VALUES('98765432178', 'ass_02', 'a_02');
  1402. INSERT INTO are_given VALUES('98765432178', 'ass_03', 'a_03');
  1403. INSERT INTO are_given VALUES('98765432178', 'ass_04', 'a_04');
  1404. INSERT INTO are_given VALUES('98765432178', 'ass_11', 'b_01');
  1405. INSERT INTO are_given VALUES('98765432178', 'ass_12', 'b_02');
  1406. INSERT INTO are_given VALUES('98765432178', 'ass_13', 'b_03');
  1407. INSERT INTO are_given VALUES('98765432178', 'ass_14', 'b_04');
  1408. INSERT INTO are_given VALUES('98765432178', 'ass_21', 'c_01');
  1409. INSERT INTO are_given VALUES('98765432178', 'ass_22', 'c_02');
  1410. INSERT INTO are_given VALUES('98765432178', 'ass_23', 'c_03');
  1411. INSERT INTO are_given VALUES('98765432178', 'ass_24', 'c_04');
  1412. INSERT INTO are_given VALUES('98765432178', 'ass_31', 'd_01');
  1413. INSERT INTO are_given VALUES('98765432178', 'ass_32', 'd_02');
  1414. INSERT INTO are_given VALUES('98765432178', 'ass_33', 'd_03');
  1415. INSERT INTO are_given VALUES('98765432178', 'ass_34', 'd_04');
  1416. INSERT INTO are_given VALUES('98765432177', 'ass_01', 'a_01');
  1417. INSERT INTO are_given VALUES('98765432177', 'ass_02', 'a_02');
  1418. INSERT INTO are_given VALUES('98765432177', 'ass_03', 'a_03');
  1419. INSERT INTO are_given VALUES('98765432177', 'ass_04', 'a_04');
  1420. INSERT INTO are_given VALUES('98765432177', 'ass_11', 'b_01');
  1421. INSERT INTO are_given VALUES('98765432177', 'ass_12', 'b_02');
  1422. INSERT INTO are_given VALUES('98765432177', 'ass_13', 'b_03');
  1423. INSERT INTO are_given VALUES('98765432177', 'ass_14', 'b_04');
  1424. INSERT INTO are_given VALUES('98765432177', 'ass_21', 'c_01');
  1425. INSERT INTO are_given VALUES('98765432177', 'ass_22', 'c_02');
  1426. INSERT INTO are_given VALUES('98765432177', 'ass_23', 'c_03');
  1427. INSERT INTO are_given VALUES('98765432177', 'ass_24', 'c_04');
  1428. INSERT INTO are_given VALUES('98765432177', 'ass_31', 'd_01');
  1429. INSERT INTO are_given VALUES('98765432177', 'ass_32', 'd_02');
  1430. INSERT INTO are_given VALUES('98765432177', 'ass_33', 'd_03');
  1431. INSERT INTO are_given VALUES('98765432177', 'ass_34', 'd_04');
  1432. INSERT INTO are_given VALUES('98765432176', 'ass_01', 'a_01');
  1433. INSERT INTO are_given VALUES('98765432176', 'ass_02', 'a_02');
  1434. INSERT INTO are_given VALUES('98765432176', 'ass_03', 'a_03');
  1435. INSERT INTO are_given VALUES('98765432176', 'ass_04', 'a_04');
  1436. INSERT INTO are_given VALUES('98765432176', 'ass_11', 'b_01');
  1437. INSERT INTO are_given VALUES('98765432176', 'ass_12', 'b_02');
  1438. INSERT INTO are_given VALUES('98765432176', 'ass_13', 'b_03');
  1439. INSERT INTO are_given VALUES('98765432176', 'ass_14', 'b_04');
  1440. INSERT INTO are_given VALUES('98765432176', 'ass_21', 'c_01');
  1441. INSERT INTO are_given VALUES('98765432176', 'ass_22', 'c_02');
  1442. INSERT INTO are_given VALUES('98765432176', 'ass_23', 'c_03');
  1443. INSERT INTO are_given VALUES('98765432176', 'ass_24', 'c_04');
  1444. INSERT INTO are_given VALUES('98765432176', 'ass_31', 'd_01');
  1445. INSERT INTO are_given VALUES('98765432176', 'ass_32', 'd_02');
  1446. INSERT INTO are_given VALUES('98765432176', 'ass_33', 'd_03');
  1447. INSERT INTO are_given VALUES('98765432176', 'ass_34', 'd_04');
  1448. INSERT INTO are_given VALUES('98765432175', 'ass_01', 'a_01');
  1449. INSERT INTO are_given VALUES('98765432175', 'ass_02', 'a_02');
  1450. INSERT INTO are_given VALUES('98765432175', 'ass_03', 'a_03');
  1451. INSERT INTO are_given VALUES('98765432175', 'ass_04', 'a_04');
  1452. INSERT INTO are_given VALUES('98765432175', 'ass_11', 'b_01');
  1453. INSERT INTO are_given VALUES('98765432175', 'ass_12', 'b_02');
  1454. INSERT INTO are_given VALUES('98765432175', 'ass_13', 'b_03');
  1455. INSERT INTO are_given VALUES('98765432175', 'ass_14', 'b_04');
  1456. INSERT INTO are_given VALUES('98765432175', 'ass_21', 'c_01');
  1457. INSERT INTO are_given VALUES('98765432175', 'ass_22', 'c_02');
  1458. INSERT INTO are_given VALUES('98765432175', 'ass_23', 'c_03');
  1459. INSERT INTO are_given VALUES('98765432175', 'ass_24', 'c_04');
  1460. INSERT INTO are_given VALUES('98765432175', 'ass_31', 'd_01');
  1461. INSERT INTO are_given VALUES('98765432175', 'ass_32', 'd_02');
  1462. INSERT INTO are_given VALUES('98765432175', 'ass_33', 'd_03');
  1463. INSERT INTO are_given VALUES('98765432175', 'ass_34', 'd_04');
  1464. INSERT INTO are_given VALUES('98765432174', 'ass_01', 'a_01');
  1465. INSERT INTO are_given VALUES('98765432174', 'ass_02', 'a_02');
  1466. INSERT INTO are_given VALUES('98765432174', 'ass_03', 'a_03');
  1467. INSERT INTO are_given VALUES('98765432174', 'ass_04', 'a_04');
  1468. INSERT INTO are_given VALUES('98765432174', 'ass_11', 'b_01');
  1469. INSERT INTO are_given VALUES('98765432174', 'ass_12', 'b_02');
  1470. INSERT INTO are_given VALUES('98765432174', 'ass_13', 'b_03');
  1471. INSERT INTO are_given VALUES('98765432174', 'ass_14', 'b_04');
  1472. INSERT INTO are_given VALUES('98765432174', 'ass_21', 'c_01');
  1473. INSERT INTO are_given VALUES('98765432174', 'ass_22', 'c_02');
  1474. INSERT INTO are_given VALUES('98765432174', 'ass_23', 'c_03');
  1475. INSERT INTO are_given VALUES('98765432174', 'ass_24', 'c_04');
  1476. INSERT INTO are_given VALUES('98765432174', 'ass_31', 'd_01');
  1477. INSERT INTO are_given VALUES('98765432174', 'ass_32', 'd_02');
  1478. INSERT INTO are_given VALUES('98765432174', 'ass_33', 'd_03');
  1479. INSERT INTO are_given VALUES('98765432174', 'ass_34', 'd_04');
  1480. INSERT INTO are_given VALUES('98765432173', 'ass_01', 'a_01');
  1481. INSERT INTO are_given VALUES('98765432173', 'ass_02', 'a_02');
  1482. INSERT INTO are_given VALUES('98765432173', 'ass_03', 'a_03');
  1483. INSERT INTO are_given VALUES('98765432173', 'ass_04', 'a_04');
  1484. INSERT INTO are_given VALUES('98765432173', 'ass_11', 'b_01');
  1485. INSERT INTO are_given VALUES('98765432173', 'ass_12', 'b_02');
  1486. INSERT INTO are_given VALUES('98765432173', 'ass_13', 'b_03');
  1487. INSERT INTO are_given VALUES('98765432173', 'ass_14', 'b_04');
  1488. INSERT INTO are_given VALUES('98765432173', 'ass_21', 'c_01');
  1489. INSERT INTO are_given VALUES('98765432173', 'ass_22', 'c_02');
  1490. INSERT INTO are_given VALUES('98765432173', 'ass_23', 'c_03');
  1491. INSERT INTO are_given VALUES('98765432173', 'ass_24', 'c_04');
  1492. INSERT INTO are_given VALUES('98765432173', 'ass_31', 'd_01');
  1493. INSERT INTO are_given VALUES('98765432173', 'ass_32', 'd_02');
  1494. INSERT INTO are_given VALUES('98765432173', 'ass_33', 'd_03');
  1495. INSERT INTO are_given VALUES('98765432173', 'ass_34', 'd_04');
  1496. INSERT INTO are_given VALUES('98765432172', 'ass_01', 'a_01');
  1497. INSERT INTO are_given VALUES('98765432172', 'ass_02', 'a_02');
  1498. INSERT INTO are_given VALUES('98765432172', 'ass_03', 'a_03');
  1499. INSERT INTO are_given VALUES('98765432172', 'ass_04', 'a_04');
  1500. INSERT INTO are_given VALUES('98765432172', 'ass_11', 'b_01');
  1501. INSERT INTO are_given VALUES('98765432172', 'ass_12', 'b_02');
  1502. INSERT INTO are_given VALUES('98765432172', 'ass_13', 'b_03');
  1503. INSERT INTO are_given VALUES('98765432172', 'ass_14', 'b_04');
  1504. INSERT INTO are_given VALUES('98765432172', 'ass_21', 'c_01');
  1505. INSERT INTO are_given VALUES('98765432172', 'ass_22', 'c_02');
  1506. INSERT INTO are_given VALUES('98765432172', 'ass_23', 'c_03');
  1507. INSERT INTO are_given VALUES('98765432172', 'ass_24', 'c_04');
  1508. INSERT INTO are_given VALUES('98765432172', 'ass_31', 'd_01');
  1509. INSERT INTO are_given VALUES('98765432172', 'ass_32', 'd_02');
  1510. INSERT INTO are_given VALUES('98765432172', 'ass_33', 'd_03');
  1511. INSERT INTO are_given VALUES('98765432172', 'ass_34', 'd_04');
  1512. INSERT INTO are_given VALUES('98765432171', 'ass_01', 'a_01');
  1513. INSERT INTO are_given VALUES('98765432171', 'ass_02', 'a_02');
  1514. INSERT INTO are_given VALUES('98765432171', 'ass_03', 'a_03');
  1515. INSERT INTO are_given VALUES('98765432171', 'ass_04', 'a_04');
  1516. INSERT INTO are_given VALUES('98765432171', 'ass_11', 'b_01');
  1517. INSERT INTO are_given VALUES('98765432171', 'ass_12', 'b_02');
  1518. INSERT INTO are_given VALUES('98765432171', 'ass_13', 'b_03');
  1519. INSERT INTO are_given VALUES('98765432171', 'ass_14', 'b_04');
  1520. INSERT INTO are_given VALUES('98765432171', 'ass_21', 'c_01');
  1521. INSERT INTO are_given VALUES('98765432171', 'ass_22', 'c_02');
  1522. INSERT INTO are_given VALUES('98765432171', 'ass_23', 'c_03');
  1523. INSERT INTO are_given VALUES('98765432171', 'ass_24', 'c_04');
  1524. INSERT INTO are_given VALUES('98765432171', 'ass_31', 'd_01');
  1525. INSERT INTO are_given VALUES('98765432171', 'ass_32', 'd_02');
  1526. INSERT INTO are_given VALUES('98765432171', 'ass_33', 'd_03');
  1527. INSERT INTO are_given VALUES('98765432171', 'ass_34', 'd_04');
  1528. INSERT INTO are_given VALUES('98765432170', 'ass_01', 'a_01');
  1529. INSERT INTO are_given VALUES('98765432170', 'ass_02', 'a_02');
  1530. INSERT INTO are_given VALUES('98765432170', 'ass_03', 'a_03');
  1531. INSERT INTO are_given VALUES('98765432170', 'ass_04', 'a_04');
  1532. INSERT INTO are_given VALUES('98765432170', 'ass_11', 'b_01');
  1533. INSERT INTO are_given VALUES('98765432170', 'ass_12', 'b_02');
  1534. INSERT INTO are_given VALUES('98765432170', 'ass_13', 'b_03');
  1535. INSERT INTO are_given VALUES('98765432170', 'ass_14', 'b_04');
  1536. INSERT INTO are_given VALUES('98765432170', 'ass_21', 'c_01');
  1537. INSERT INTO are_given VALUES('98765432170', 'ass_22', 'c_02');
  1538. INSERT INTO are_given VALUES('98765432170', 'ass_23', 'c_03');
  1539. INSERT INTO are_given VALUES('98765432170', 'ass_24', 'c_04');
  1540. INSERT INTO are_given VALUES('98765432170', 'ass_31', 'd_01');
  1541. INSERT INTO are_given VALUES('98765432170', 'ass_32', 'd_02');
  1542. INSERT INTO are_given VALUES('98765432170', 'ass_33', 'd_03');
  1543. INSERT INTO are_given VALUES('98765432170', 'ass_34', 'd_04');
  1544. INSERT INTO are_given VALUES('98765432169', 'ass_01', 'a_01');
  1545. INSERT INTO are_given VALUES('98765432169', 'ass_02', 'a_02');
  1546. INSERT INTO are_given VALUES('98765432169', 'ass_03', 'a_03');
  1547. INSERT INTO are_given VALUES('98765432169', 'ass_04', 'a_04');
  1548. INSERT INTO are_given VALUES('98765432169', 'ass_11', 'b_01');
  1549. INSERT INTO are_given VALUES('98765432169', 'ass_12', 'b_02');
  1550. INSERT INTO are_given VALUES('98765432169', 'ass_13', 'b_03');
  1551. INSERT INTO are_given VALUES('98765432169', 'ass_14', 'b_04');
  1552. INSERT INTO are_given VALUES('98765432169', 'ass_21', 'c_01');
  1553. INSERT INTO are_given VALUES('98765432169', 'ass_22', 'c_02');
  1554. INSERT INTO are_given VALUES('98765432169', 'ass_23', 'c_03');
  1555. INSERT INTO are_given VALUES('98765432169', 'ass_24', 'c_04');
  1556. INSERT INTO are_given VALUES('98765432169', 'ass_31', 'd_01');
  1557. INSERT INTO are_given VALUES('98765432169', 'ass_32', 'd_02');
  1558. INSERT INTO are_given VALUES('98765432169', 'ass_33', 'd_03');
  1559. INSERT INTO are_given VALUES('98765432169', 'ass_34', 'd_04');
  1560. INSERT INTO are_given VALUES('98765432168', 'ass_01', 'a_01');
  1561. INSERT INTO are_given VALUES('98765432168', 'ass_02', 'a_02');
  1562. INSERT INTO are_given VALUES('98765432168', 'ass_03', 'a_03');
  1563. INSERT INTO are_given VALUES('98765432168', 'ass_04', 'a_04');
  1564. INSERT INTO are_given VALUES('98765432168', 'ass_11', 'b_01');
  1565. INSERT INTO are_given VALUES('98765432168', 'ass_12', 'b_02');
  1566. INSERT INTO are_given VALUES('98765432168', 'ass_13', 'b_03');
  1567. INSERT INTO are_given VALUES('98765432168', 'ass_14', 'b_04');
  1568. INSERT INTO are_given VALUES('98765432168', 'ass_21', 'c_01');
  1569. INSERT INTO are_given VALUES('98765432168', 'ass_22', 'c_02');
  1570. INSERT INTO are_given VALUES('98765432168', 'ass_23', 'c_03');
  1571. INSERT INTO are_given VALUES('98765432168', 'ass_24', 'c_04');
  1572. INSERT INTO are_given VALUES('98765432168', 'ass_31', 'd_01');
  1573. INSERT INTO are_given VALUES('98765432168', 'ass_32', 'd_02');
  1574. INSERT INTO are_given VALUES('98765432168', 'ass_33', 'd_03');
  1575. INSERT INTO are_given VALUES('98765432168', 'ass_34', 'd_04');
  1576. INSERT INTO are_given VALUES('98765432167', 'ass_01', 'a_01');
  1577. INSERT INTO are_given VALUES('98765432167', 'ass_02', 'a_02');
  1578. INSERT INTO are_given VALUES('98765432167', 'ass_03', 'a_03');
  1579. INSERT INTO are_given VALUES('98765432167', 'ass_04', 'a_04');
  1580. INSERT INTO are_given VALUES('98765432167', 'ass_11', 'b_01');
  1581. INSERT INTO are_given VALUES('98765432167', 'ass_12', 'b_02');
  1582. INSERT INTO are_given VALUES('98765432167', 'ass_13', 'b_03');
  1583. INSERT INTO are_given VALUES('98765432167', 'ass_14', 'b_04');
  1584. INSERT INTO are_given VALUES('98765432167', 'ass_21', 'c_01');
  1585. INSERT INTO are_given VALUES('98765432167', 'ass_22', 'c_02');
  1586. INSERT INTO are_given VALUES('98765432167', 'ass_23', 'c_03');
  1587. INSERT INTO are_given VALUES('98765432167', 'ass_24', 'c_04');
  1588. INSERT INTO are_given VALUES('98765432167', 'ass_31', 'd_01');
  1589. INSERT INTO are_given VALUES('98765432167', 'ass_32', 'd_02');
  1590. INSERT INTO are_given VALUES('98765432167', 'ass_33', 'd_03');
  1591. INSERT INTO are_given VALUES('98765432167', 'ass_34', 'd_04');
  1592. INSERT INTO are_given VALUES('98765432166', 'ass_01', 'a_01');
  1593. INSERT INTO are_given VALUES('98765432166', 'ass_02', 'a_02');
  1594. INSERT INTO are_given VALUES('98765432166', 'ass_03', 'a_03');
  1595. INSERT INTO are_given VALUES('98765432166', 'ass_04', 'a_04');
  1596. INSERT INTO are_given VALUES('98765432166', 'ass_11', 'b_01');
  1597. INSERT INTO are_given VALUES('98765432166', 'ass_12', 'b_02');
  1598. INSERT INTO are_given VALUES('98765432166', 'ass_13', 'b_03');
  1599. INSERT INTO are_given VALUES('98765432166', 'ass_14', 'b_04');
  1600. INSERT INTO are_given VALUES('98765432166', 'ass_21', 'c_01');
  1601. INSERT INTO are_given VALUES('98765432166', 'ass_22', 'c_02');
  1602. INSERT INTO are_given VALUES('98765432166', 'ass_23', 'c_03');
  1603. INSERT INTO are_given VALUES('98765432166', 'ass_24', 'c_04');
  1604. INSERT INTO are_given VALUES('98765432166', 'ass_31', 'd_01');
  1605. INSERT INTO are_given VALUES('98765432166', 'ass_32', 'd_02');
  1606. INSERT INTO are_given VALUES('98765432166', 'ass_33', 'd_03');
  1607. INSERT INTO are_given VALUES('98765432166', 'ass_34', 'd_04');
  1608. INSERT INTO are_given VALUES('98765432165', 'ass_01', 'a_01');
  1609. INSERT INTO are_given VALUES('98765432165', 'ass_02', 'a_02');
  1610. INSERT INTO are_given VALUES('98765432165', 'ass_03', 'a_03');
  1611. INSERT INTO are_given VALUES('98765432165', 'ass_04', 'a_04');
  1612. INSERT INTO are_given VALUES('98765432165', 'ass_11', 'b_01');
  1613. INSERT INTO are_given VALUES('98765432165', 'ass_12', 'b_02');
  1614. INSERT INTO are_given VALUES('98765432165', 'ass_13', 'b_03');
  1615. INSERT INTO are_given VALUES('98765432165', 'ass_14', 'b_04');
  1616. INSERT INTO are_given VALUES('98765432165', 'ass_21', 'c_01');
  1617. INSERT INTO are_given VALUES('98765432165', 'ass_22', 'c_02');
  1618. INSERT INTO are_given VALUES('98765432165', 'ass_23', 'c_03');
  1619. INSERT INTO are_given VALUES('98765432165', 'ass_24', 'c_04');
  1620. INSERT INTO are_given VALUES('98765432165', 'ass_31', 'd_01');
  1621. INSERT INTO are_given VALUES('98765432165', 'ass_32', 'd_02');
  1622. INSERT INTO are_given VALUES('98765432165', 'ass_33', 'd_03');
  1623. INSERT INTO are_given VALUES('98765432165', 'ass_34', 'd_04');
  1624. INSERT INTO are_given VALUES('98765432164', 'ass_01', 'a_01');
  1625. INSERT INTO are_given VALUES('98765432164', 'ass_02', 'a_02');
  1626. INSERT INTO are_given VALUES('98765432164', 'ass_03', 'a_03');
  1627. INSERT INTO are_given VALUES('98765432164', 'ass_04', 'a_04');
  1628. INSERT INTO are_given VALUES('98765432164', 'ass_11', 'b_01');
  1629. INSERT INTO are_given VALUES('98765432164', 'ass_12', 'b_02');
  1630. INSERT INTO are_given VALUES('98765432164', 'ass_13', 'b_03');
  1631. INSERT INTO are_given VALUES('98765432164', 'ass_14', 'b_04');
  1632. INSERT INTO are_given VALUES('98765432164', 'ass_21', 'c_01');
  1633. INSERT INTO are_given VALUES('98765432164', 'ass_22', 'c_02');
  1634. INSERT INTO are_given VALUES('98765432164', 'ass_23', 'c_03');
  1635. INSERT INTO are_given VALUES('98765432164', 'ass_24', 'c_04');
  1636. INSERT INTO are_given VALUES('98765432164', 'ass_31', 'd_01');
  1637. INSERT INTO are_given VALUES('98765432164', 'ass_32', 'd_02');
  1638. INSERT INTO are_given VALUES('98765432164', 'ass_33', 'd_03');
  1639. INSERT INTO are_given VALUES('98765432164', 'ass_34', 'd_04');
  1640. INSERT INTO are_given VALUES('98765432163', 'ass_01', 'a_01');
  1641. INSERT INTO are_given VALUES('98765432163', 'ass_02', 'a_02');
  1642. INSERT INTO are_given VALUES('98765432163', 'ass_03', 'a_03');
  1643. INSERT INTO are_given VALUES('98765432163', 'ass_04', 'a_04');
  1644. INSERT INTO are_given VALUES('98765432163', 'ass_11', 'b_01');
  1645. INSERT INTO are_given VALUES('98765432163', 'ass_12', 'b_02');
  1646. INSERT INTO are_given VALUES('98765432163', 'ass_13', 'b_03');
  1647. INSERT INTO are_given VALUES('98765432163', 'ass_14', 'b_04');
  1648. INSERT INTO are_given VALUES('98765432163', 'ass_21', 'c_01');
  1649. INSERT INTO are_given VALUES('98765432163', 'ass_22', 'c_02');
  1650. INSERT INTO are_given VALUES('98765432163', 'ass_23', 'c_03');
  1651. INSERT INTO are_given VALUES('98765432163', 'ass_24', 'c_04');
  1652. INSERT INTO are_given VALUES('98765432163', 'ass_31', 'd_01');
  1653. INSERT INTO are_given VALUES('98765432163', 'ass_32', 'd_02');
  1654. INSERT INTO are_given VALUES('98765432163', 'ass_33', 'd_03');
  1655. INSERT INTO are_given VALUES('98765432163', 'ass_34', 'd_04');
  1656. INSERT INTO are_given VALUES('98765432162', 'ass_01', 'a_01');
  1657. INSERT INTO are_given VALUES('98765432162', 'ass_02', 'a_02');
  1658. INSERT INTO are_given VALUES('98765432162', 'ass_03', 'a_03');
  1659. INSERT INTO are_given VALUES('98765432162', 'ass_04', 'a_04');
  1660. INSERT INTO are_given VALUES('98765432162', 'ass_11', 'b_01');
  1661. INSERT INTO are_given VALUES('98765432162', 'ass_12', 'b_02');
  1662. INSERT INTO are_given VALUES('98765432162', 'ass_13', 'b_03');
  1663. INSERT INTO are_given VALUES('98765432162', 'ass_14', 'b_04');
  1664. INSERT INTO are_given VALUES('98765432162', 'ass_21', 'c_01');
  1665. INSERT INTO are_given VALUES('98765432162', 'ass_22', 'c_02');
  1666. INSERT INTO are_given VALUES('98765432162', 'ass_23', 'c_03');
  1667. INSERT INTO are_given VALUES('98765432162', 'ass_24', 'c_04');
  1668. INSERT INTO are_given VALUES('98765432162', 'ass_31', 'd_01');
  1669. INSERT INTO are_given VALUES('98765432162', 'ass_32', 'd_02');
  1670. INSERT INTO are_given VALUES('98765432162', 'ass_33', 'd_03');
  1671. INSERT INTO are_given VALUES('98765432162', 'ass_34', 'd_04');
  1672. INSERT INTO are_given VALUES('98765432161', 'ass_01', 'a_01');
  1673. INSERT INTO are_given VALUES('98765432161', 'ass_02', 'a_02');
  1674. INSERT INTO are_given VALUES('98765432161', 'ass_03', 'a_03');
  1675. INSERT INTO are_given VALUES('98765432161', 'ass_04', 'a_04');
  1676. INSERT INTO are_given VALUES('98765432161', 'ass_11', 'b_01');
  1677. INSERT INTO are_given VALUES('98765432161', 'ass_12', 'b_02');
  1678. INSERT INTO are_given VALUES('98765432161', 'ass_13', 'b_03');
  1679. INSERT INTO are_given VALUES('98765432161', 'ass_14', 'b_04');
  1680. INSERT INTO are_given VALUES('98765432161', 'ass_21', 'c_01');
  1681. INSERT INTO are_given VALUES('98765432161', 'ass_22', 'c_02');
  1682. INSERT INTO are_given VALUES('98765432161', 'ass_23', 'c_03');
  1683. INSERT INTO are_given VALUES('98765432161', 'ass_24', 'c_04');
  1684. INSERT INTO are_given VALUES('98765432161', 'ass_31', 'd_01');
  1685. INSERT INTO are_given VALUES('98765432161', 'ass_32', 'd_02');
  1686. INSERT INTO are_given VALUES('98765432161', 'ass_33', 'd_03');
  1687. INSERT INTO are_given VALUES('98765432161', 'ass_34', 'd_04');
  1688. INSERT INTO are_given VALUES('98765432160', 'ass_01', 'a_01');
  1689. INSERT INTO are_given VALUES('98765432160', 'ass_02', 'a_02');
  1690. INSERT INTO are_given VALUES('98765432160', 'ass_03', 'a_03');
  1691. INSERT INTO are_given VALUES('98765432160', 'ass_04', 'a_04');
  1692. INSERT INTO are_given VALUES('98765432160', 'ass_11', 'b_01');
  1693. INSERT INTO are_given VALUES('98765432160', 'ass_12', 'b_02');
  1694. INSERT INTO are_given VALUES('98765432160', 'ass_13', 'b_03');
  1695. INSERT INTO are_given VALUES('98765432160', 'ass_14', 'b_04');
  1696. INSERT INTO are_given VALUES('98765432160', 'ass_21', 'c_01');
  1697. INSERT INTO are_given VALUES('98765432160', 'ass_22', 'c_02');
  1698. INSERT INTO are_given VALUES('98765432160', 'ass_23', 'c_03');
  1699. INSERT INTO are_given VALUES('98765432160', 'ass_24', 'c_04');
  1700. INSERT INTO are_given VALUES('98765432160', 'ass_31', 'd_01');
  1701. INSERT INTO are_given VALUES('98765432160', 'ass_32', 'd_02');
  1702. INSERT INTO are_given VALUES('98765432160', 'ass_33', 'd_03');
  1703. INSERT INTO are_given VALUES('98765432160', 'ass_34', 'd_04');
  1704. INSERT INTO are_given VALUES('98765432159', 'ass_01', 'a_01');
  1705. INSERT INTO are_given VALUES('98765432159', 'ass_02', 'a_02');
  1706. INSERT INTO are_given VALUES('98765432159', 'ass_03', 'a_03');
  1707. INSERT INTO are_given VALUES('98765432159', 'ass_04', 'a_04');
  1708. INSERT INTO are_given VALUES('98765432159', 'ass_11', 'b_01');
  1709. INSERT INTO are_given VALUES('98765432159', 'ass_12', 'b_02');
  1710. INSERT INTO are_given VALUES('98765432159', 'ass_13', 'b_03');
  1711. INSERT INTO are_given VALUES('98765432159', 'ass_14', 'b_04');
  1712. INSERT INTO are_given VALUES('98765432159', 'ass_21', 'c_01');
  1713. INSERT INTO are_given VALUES('98765432159', 'ass_22', 'c_02');
  1714. INSERT INTO are_given VALUES('98765432159', 'ass_23', 'c_03');
  1715. INSERT INTO are_given VALUES('98765432159', 'ass_24', 'c_04');
  1716. INSERT INTO are_given VALUES('98765432159', 'ass_31', 'd_01');
  1717. INSERT INTO are_given VALUES('98765432159', 'ass_32', 'd_02');
  1718. INSERT INTO are_given VALUES('98765432159', 'ass_33', 'd_03');
  1719. INSERT INTO are_given VALUES('98765432159', 'ass_34', 'd_04');
  1720. INSERT INTO are_given VALUES('98765432158', 'ass_01', 'a_01');
  1721. INSERT INTO are_given VALUES('98765432158', 'ass_02', 'a_02');
  1722. INSERT INTO are_given VALUES('98765432158', 'ass_03', 'a_03');
  1723. INSERT INTO are_given VALUES('98765432158', 'ass_04', 'a_04');
  1724. INSERT INTO are_given VALUES('98765432158', 'ass_11', 'b_01');
  1725. INSERT INTO are_given VALUES('98765432158', 'ass_12', 'b_02');
  1726. INSERT INTO are_given VALUES('98765432158', 'ass_13', 'b_03');
  1727. INSERT INTO are_given VALUES('98765432158', 'ass_14', 'b_04');
  1728. INSERT INTO are_given VALUES('98765432158', 'ass_21', 'c_01');
  1729. INSERT INTO are_given VALUES('98765432158', 'ass_22', 'c_02');
  1730. INSERT INTO are_given VALUES('98765432158', 'ass_23', 'c_03');
  1731. INSERT INTO are_given VALUES('98765432158', 'ass_24', 'c_04');
  1732. INSERT INTO are_given VALUES('98765432158', 'ass_31', 'd_01');
  1733. INSERT INTO are_given VALUES('98765432158', 'ass_32', 'd_02');
  1734. INSERT INTO are_given VALUES('98765432158', 'ass_33', 'd_03');
  1735. INSERT INTO are_given VALUES('98765432158', 'ass_34', 'd_04');
  1736. INSERT INTO are_given VALUES('98765432157', 'ass_01', 'a_01');
  1737. INSERT INTO are_given VALUES('98765432157', 'ass_02', 'a_02');
  1738. INSERT INTO are_given VALUES('98765432157', 'ass_03', 'a_03');
  1739. INSERT INTO are_given VALUES('98765432157', 'ass_04', 'a_04');
  1740. INSERT INTO are_given VALUES('98765432157', 'ass_11', 'b_01');
  1741. INSERT INTO are_given VALUES('98765432157', 'ass_12', 'b_02');
  1742. INSERT INTO are_given VALUES('98765432157', 'ass_13', 'b_03');
  1743. INSERT INTO are_given VALUES('98765432157', 'ass_14', 'b_04');
  1744. INSERT INTO are_given VALUES('98765432157', 'ass_21', 'c_01');
  1745. INSERT INTO are_given VALUES('98765432157', 'ass_22', 'c_02');
  1746. INSERT INTO are_given VALUES('98765432157', 'ass_23', 'c_03');
  1747. INSERT INTO are_given VALUES('98765432157', 'ass_24', 'c_04');
  1748. INSERT INTO are_given VALUES('98765432157', 'ass_31', 'd_01');
  1749. INSERT INTO are_given VALUES('98765432157', 'ass_32', 'd_02');
  1750. INSERT INTO are_given VALUES('98765432157', 'ass_33', 'd_03');
  1751. INSERT INTO are_given VALUES('98765432157', 'ass_34', 'd_04');
  1752. INSERT INTO are_given VALUES('98765432156', 'ass_01', 'a_01');
  1753. INSERT INTO are_given VALUES('98765432156', 'ass_02', 'a_02');
  1754. INSERT INTO are_given VALUES('98765432156', 'ass_03', 'a_03');
  1755. INSERT INTO are_given VALUES('98765432156', 'ass_04', 'a_04');
  1756. INSERT INTO are_given VALUES('98765432156', 'ass_11', 'b_01');
  1757. INSERT INTO are_given VALUES('98765432156', 'ass_12', 'b_02');
  1758. INSERT INTO are_given VALUES('98765432156', 'ass_13', 'b_03');
  1759. INSERT INTO are_given VALUES('98765432156', 'ass_14', 'b_04');
  1760. INSERT INTO are_given VALUES('98765432156', 'ass_21', 'c_01');
  1761. INSERT INTO are_given VALUES('98765432156', 'ass_22', 'c_02');
  1762. INSERT INTO are_given VALUES('98765432156', 'ass_23', 'c_03');
  1763. INSERT INTO are_given VALUES('98765432156', 'ass_24', 'c_04');
  1764. INSERT INTO are_given VALUES('98765432156', 'ass_31', 'd_01');
  1765. INSERT INTO are_given VALUES('98765432156', 'ass_32', 'd_02');
  1766. INSERT INTO are_given VALUES('98765432156', 'ass_33', 'd_03');
  1767. INSERT INTO are_given VALUES('98765432156', 'ass_34', 'd_04');
  1768. INSERT INTO are_given VALUES('98765432155', 'ass_01', 'a_01');
  1769. INSERT INTO are_given VALUES('98765432155', 'ass_02', 'a_02');
  1770. INSERT INTO are_given VALUES('98765432155', 'ass_03', 'a_03');
  1771. INSERT INTO are_given VALUES('98765432155', 'ass_04', 'a_04');
  1772. INSERT INTO are_given VALUES('98765432155', 'ass_11', 'b_01');
  1773. INSERT INTO are_given VALUES('98765432155', 'ass_12', 'b_02');
  1774. INSERT INTO are_given VALUES('98765432155', 'ass_13', 'b_03');
  1775. INSERT INTO are_given VALUES('98765432155', 'ass_14', 'b_04');
  1776. INSERT INTO are_given VALUES('98765432155', 'ass_21', 'c_01');
  1777. INSERT INTO are_given VALUES('98765432155', 'ass_22', 'c_02');
  1778. INSERT INTO are_given VALUES('98765432155', 'ass_23', 'c_03');
  1779. INSERT INTO are_given VALUES('98765432155', 'ass_24', 'c_04');
  1780. INSERT INTO are_given VALUES('98765432155', 'ass_31', 'd_01');
  1781. INSERT INTO are_given VALUES('98765432155', 'ass_32', 'd_02');
  1782. INSERT INTO are_given VALUES('98765432155', 'ass_33', 'd_03');
  1783. INSERT INTO are_given VALUES('98765432155', 'ass_34', 'd_04');
  1784. INSERT INTO are_given VALUES('98765432154', 'ass_01', 'a_01');
  1785. INSERT INTO are_given VALUES('98765432154', 'ass_02', 'a_02');
  1786. INSERT INTO are_given VALUES('98765432154', 'ass_03', 'a_03');
  1787. INSERT INTO are_given VALUES('98765432154', 'ass_04', 'a_04');
  1788. INSERT INTO are_given VALUES('98765432154', 'ass_11', 'b_01');
  1789. INSERT INTO are_given VALUES('98765432154', 'ass_12', 'b_02');
  1790. INSERT INTO are_given VALUES('98765432154', 'ass_13', 'b_03');
  1791. INSERT INTO are_given VALUES('98765432154', 'ass_14', 'b_04');
  1792. INSERT INTO are_given VALUES('98765432154', 'ass_21', 'c_01');
  1793. INSERT INTO are_given VALUES('98765432154', 'ass_22', 'c_02');
  1794. INSERT INTO are_given VALUES('98765432154', 'ass_23', 'c_03');
  1795. INSERT INTO are_given VALUES('98765432154', 'ass_24', 'c_04');
  1796. INSERT INTO are_given VALUES('98765432154', 'ass_31', 'd_01');
  1797. INSERT INTO are_given VALUES('98765432154', 'ass_32', 'd_02');
  1798. INSERT INTO are_given VALUES('98765432154', 'ass_33', 'd_03');
  1799. INSERT INTO are_given VALUES('98765432154', 'ass_34', 'd_04');
  1800. INSERT INTO are_given VALUES('98765432153', 'ass_01', 'a_01');
  1801. INSERT INTO are_given VALUES('98765432153', 'ass_02', 'a_02');
  1802. INSERT INTO are_given VALUES('98765432153', 'ass_03', 'a_03');
  1803. INSERT INTO are_given VALUES('98765432153', 'ass_04', 'a_04');
  1804. INSERT INTO are_given VALUES('98765432153', 'ass_11', 'b_01');
  1805. INSERT INTO are_given VALUES('98765432153', 'ass_12', 'b_02');
  1806. INSERT INTO are_given VALUES('98765432153', 'ass_13', 'b_03');
  1807. INSERT INTO are_given VALUES('98765432153', 'ass_14', 'b_04');
  1808. INSERT INTO are_given VALUES('98765432153', 'ass_21', 'c_01');
  1809. INSERT INTO are_given VALUES('98765432153', 'ass_22', 'c_02');
  1810. INSERT INTO are_given VALUES('98765432153', 'ass_23', 'c_03');
  1811. INSERT INTO are_given VALUES('98765432153', 'ass_24', 'c_04');
  1812. INSERT INTO are_given VALUES('98765432153', 'ass_31', 'd_01');
  1813. INSERT INTO are_given VALUES('98765432153', 'ass_32', 'd_02');
  1814. INSERT INTO are_given VALUES('98765432153', 'ass_33', 'd_03');
  1815. INSERT INTO are_given VALUES('98765432153', 'ass_34', 'd_04');
  1816. INSERT INTO are_given VALUES('98765432152', 'ass_01', 'a_01');
  1817. INSERT INTO are_given VALUES('98765432152', 'ass_02', 'a_02');
  1818. INSERT INTO are_given VALUES('98765432152', 'ass_03', 'a_03');
  1819. INSERT INTO are_given VALUES('98765432152', 'ass_04', 'a_04');
  1820. INSERT INTO are_given VALUES('98765432152', 'ass_11', 'b_01');
  1821. INSERT INTO are_given VALUES('98765432152', 'ass_12', 'b_02');
  1822. INSERT INTO are_given VALUES('98765432152', 'ass_13', 'b_03');
  1823. INSERT INTO are_given VALUES('98765432152', 'ass_14', 'b_04');
  1824. INSERT INTO are_given VALUES('98765432152', 'ass_21', 'c_01');
  1825. INSERT INTO are_given VALUES('98765432152', 'ass_22', 'c_02');
  1826. INSERT INTO are_given VALUES('98765432152', 'ass_23', 'c_03');
  1827. INSERT INTO are_given VALUES('98765432152', 'ass_24', 'c_04');
  1828. INSERT INTO are_given VALUES('98765432152', 'ass_31', 'd_01');
  1829. INSERT INTO are_given VALUES('98765432152', 'ass_32', 'd_02');
  1830. INSERT INTO are_given VALUES('98765432152', 'ass_33', 'd_03');
  1831. INSERT INTO are_given VALUES('98765432152', 'ass_34', 'd_04');
  1832. INSERT INTO are_given VALUES('98765432151', 'ass_01', 'a_01');
  1833. INSERT INTO are_given VALUES('98765432151', 'ass_02', 'a_02');
  1834. INSERT INTO are_given VALUES('98765432151', 'ass_03', 'a_03');
  1835. INSERT INTO are_given VALUES('98765432151', 'ass_04', 'a_04');
  1836. INSERT INTO are_given VALUES('98765432151', 'ass_11', 'b_01');
  1837. INSERT INTO are_given VALUES('98765432151', 'ass_12', 'b_02');
  1838. INSERT INTO are_given VALUES('98765432151', 'ass_13', 'b_03');
  1839. INSERT INTO are_given VALUES('98765432151', 'ass_14', 'b_04');
  1840. INSERT INTO are_given VALUES('98765432151', 'ass_21', 'c_01');
  1841. INSERT INTO are_given VALUES('98765432151', 'ass_22', 'c_02');
  1842. INSERT INTO are_given VALUES('98765432151', 'ass_23', 'c_03');
  1843. INSERT INTO are_given VALUES('98765432151', 'ass_24', 'c_04');
  1844. INSERT INTO are_given VALUES('98765432151', 'ass_31', 'd_01');
  1845. INSERT INTO are_given VALUES('98765432151', 'ass_32', 'd_02');
  1846. INSERT INTO are_given VALUES('98765432151', 'ass_33', 'd_03');
  1847. INSERT INTO are_given VALUES('98765432151', 'ass_34', 'd_04');
  1848. INSERT INTO are_given VALUES('98765432150', 'ass_01', 'a_01');
  1849. INSERT INTO are_given VALUES('98765432150', 'ass_02', 'a_02');
  1850. INSERT INTO are_given VALUES('98765432150', 'ass_03', 'a_03');
  1851. INSERT INTO are_given VALUES('98765432150', 'ass_04', 'a_04');
  1852. INSERT INTO are_given VALUES('98765432150', 'ass_11', 'b_01');
  1853. INSERT INTO are_given VALUES('98765432150', 'ass_12', 'b_02');
  1854. INSERT INTO are_given VALUES('98765432150', 'ass_13', 'b_03');
  1855. INSERT INTO are_given VALUES('98765432150', 'ass_14', 'b_04');
  1856. INSERT INTO are_given VALUES('98765432150', 'ass_21', 'c_01');
  1857. INSERT INTO are_given VALUES('98765432150', 'ass_22', 'c_02');
  1858. INSERT INTO are_given VALUES('98765432150', 'ass_23', 'c_03');
  1859. INSERT INTO are_given VALUES('98765432150', 'ass_24', 'c_04');
  1860. INSERT INTO are_given VALUES('98765432150', 'ass_31', 'd_01');
  1861. INSERT INTO are_given VALUES('98765432150', 'ass_32', 'd_02');
  1862. INSERT INTO are_given VALUES('98765432150', 'ass_33', 'd_03');
  1863. INSERT INTO are_given VALUES('98765432150', 'ass_34', 'd_04');
  1864. INSERT INTO are_given VALUES('98765432149', 'ass_01', 'a_01');
  1865. INSERT INTO are_given VALUES('98765432149', 'ass_02', 'a_02');
  1866. INSERT INTO are_given VALUES('98765432149', 'ass_03', 'a_03');
  1867. INSERT INTO are_given VALUES('98765432149', 'ass_04', 'a_04');
  1868. INSERT INTO are_given VALUES('98765432149', 'ass_11', 'b_01');
  1869. INSERT INTO are_given VALUES('98765432149', 'ass_12', 'b_02');
  1870. INSERT INTO are_given VALUES('98765432149', 'ass_13', 'b_03');
  1871. INSERT INTO are_given VALUES('98765432149', 'ass_14', 'b_04');
  1872. INSERT INTO are_given VALUES('98765432149', 'ass_21', 'c_01');
  1873. INSERT INTO are_given VALUES('98765432149', 'ass_22', 'c_02');
  1874. INSERT INTO are_given VALUES('98765432149', 'ass_23', 'c_03');
  1875. INSERT INTO are_given VALUES('98765432149', 'ass_24', 'c_04');
  1876. INSERT INTO are_given VALUES('98765432149', 'ass_31', 'd_01');
  1877. INSERT INTO are_given VALUES('98765432149', 'ass_32', 'd_02');
  1878. INSERT INTO are_given VALUES('98765432149', 'ass_33', 'd_03');
  1879. INSERT INTO are_given VALUES('98765432149', 'ass_34', 'd_04');
  1880. INSERT INTO are_given VALUES('98765432148', 'ass_01', 'a_01');
  1881. INSERT INTO are_given VALUES('98765432148', 'ass_02', 'a_02');
  1882. INSERT INTO are_given VALUES('98765432148', 'ass_03', 'a_03');
  1883. INSERT INTO are_given VALUES('98765432148', 'ass_04', 'a_04');
  1884. INSERT INTO are_given VALUES('98765432148', 'ass_11', 'b_01');
  1885. INSERT INTO are_given VALUES('98765432148', 'ass_12', 'b_02');
  1886. INSERT INTO are_given VALUES('98765432148', 'ass_13', 'b_03');
  1887. INSERT INTO are_given VALUES('98765432148', 'ass_14', 'b_04');
  1888. INSERT INTO are_given VALUES('98765432148', 'ass_21', 'c_01');
  1889. INSERT INTO are_given VALUES('98765432148', 'ass_22', 'c_02');
  1890. INSERT INTO are_given VALUES('98765432148', 'ass_23', 'c_03');
  1891. INSERT INTO are_given VALUES('98765432148', 'ass_24', 'c_04');
  1892. INSERT INTO are_given VALUES('98765432148', 'ass_31', 'd_01');
  1893. INSERT INTO are_given VALUES('98765432148', 'ass_32', 'd_02');
  1894. INSERT INTO are_given VALUES('98765432148', 'ass_33', 'd_03');
  1895. INSERT INTO are_given VALUES('98765432148', 'ass_34', 'd_04');
  1896. INSERT INTO are_given VALUES('98765432147', 'ass_01', 'a_01');
  1897. INSERT INTO are_given VALUES('98765432147', 'ass_02', 'a_02');
  1898. INSERT INTO are_given VALUES('98765432147', 'ass_03', 'a_03');
  1899. INSERT INTO are_given VALUES('98765432147', 'ass_04', 'a_04');
  1900. INSERT INTO are_given VALUES('98765432147', 'ass_11', 'b_01');
  1901. INSERT INTO are_given VALUES('98765432147', 'ass_12', 'b_02');
  1902. INSERT INTO are_given VALUES('98765432147', 'ass_13', 'b_03');
  1903. INSERT INTO are_given VALUES('98765432147', 'ass_14', 'b_04');
  1904. INSERT INTO are_given VALUES('98765432147', 'ass_21', 'c_01');
  1905. INSERT INTO are_given VALUES('98765432147', 'ass_22', 'c_02');
  1906. INSERT INTO are_given VALUES('98765432147', 'ass_23', 'c_03');
  1907. INSERT INTO are_given VALUES('98765432147', 'ass_24', 'c_04');
  1908. INSERT INTO are_given VALUES('98765432147', 'ass_31', 'd_01');
  1909. INSERT INTO are_given VALUES('98765432147', 'ass_32', 'd_02');
  1910. INSERT INTO are_given VALUES('98765432147', 'ass_33', 'd_03');
  1911. INSERT INTO are_given VALUES('98765432147', 'ass_34', 'd_04');
  1912. INSERT INTO are_given VALUES('98765432146', 'ass_01', 'a_01');
  1913. INSERT INTO are_given VALUES('98765432146', 'ass_02', 'a_02');
  1914. INSERT INTO are_given VALUES('98765432146', 'ass_03', 'a_03');
  1915. INSERT INTO are_given VALUES('98765432146', 'ass_04', 'a_04');
  1916. INSERT INTO are_given VALUES('98765432146', 'ass_11', 'b_01');
  1917. INSERT INTO are_given VALUES('98765432146', 'ass_12', 'b_02');
  1918. INSERT INTO are_given VALUES('98765432146', 'ass_13', 'b_03');
  1919. INSERT INTO are_given VALUES('98765432146', 'ass_14', 'b_04');
  1920. INSERT INTO are_given VALUES('98765432146', 'ass_21', 'c_01');
  1921. INSERT INTO are_given VALUES('98765432146', 'ass_22', 'c_02');
  1922. INSERT INTO are_given VALUES('98765432146', 'ass_23', 'c_03');
  1923. INSERT INTO are_given VALUES('98765432146', 'ass_24', 'c_04');
  1924. INSERT INTO are_given VALUES('98765432146', 'ass_31', 'd_01');
  1925. INSERT INTO are_given VALUES('98765432146', 'ass_32', 'd_02');
  1926. INSERT INTO are_given VALUES('98765432146', 'ass_33', 'd_03');
  1927. INSERT INTO are_given VALUES('98765432146', 'ass_34', 'd_04');
  1928. INSERT INTO are_given VALUES('98765432145', 'ass_01', 'a_01');
  1929. INSERT INTO are_given VALUES('98765432145', 'ass_02', 'a_02');
  1930. INSERT INTO are_given VALUES('98765432145', 'ass_03', 'a_03');
  1931. INSERT INTO are_given VALUES('98765432145', 'ass_04', 'a_04');
  1932. INSERT INTO are_given VALUES('98765432145', 'ass_11', 'b_01');
  1933. INSERT INTO are_given VALUES('98765432145', 'ass_12', 'b_02');
  1934. INSERT INTO are_given VALUES('98765432145', 'ass_13', 'b_03');
  1935. INSERT INTO are_given VALUES('98765432145', 'ass_14', 'b_04');
  1936. INSERT INTO are_given VALUES('98765432145', 'ass_21', 'c_01');
  1937. INSERT INTO are_given VALUES('98765432145', 'ass_22', 'c_02');
  1938. INSERT INTO are_given VALUES('98765432145', 'ass_23', 'c_03');
  1939. INSERT INTO are_given VALUES('98765432145', 'ass_24', 'c_04');
  1940. INSERT INTO are_given VALUES('98765432145', 'ass_31', 'd_01');
  1941. INSERT INTO are_given VALUES('98765432145', 'ass_32', 'd_02');
  1942. INSERT INTO are_given VALUES('98765432145', 'ass_33', 'd_03');
  1943. INSERT INTO are_given VALUES('98765432145', 'ass_34', 'd_04');
  1944. INSERT INTO are_given VALUES('98765432144', 'ass_01', 'a_01');
  1945. INSERT INTO are_given VALUES('98765432144', 'ass_02', 'a_02');
  1946. INSERT INTO are_given VALUES('98765432144', 'ass_03', 'a_03');
  1947. INSERT INTO are_given VALUES('98765432144', 'ass_04', 'a_04');
  1948. INSERT INTO are_given VALUES('98765432144', 'ass_11', 'b_01');
  1949. INSERT INTO are_given VALUES('98765432144', 'ass_12', 'b_02');
  1950. INSERT INTO are_given VALUES('98765432144', 'ass_13', 'b_03');
  1951. INSERT INTO are_given VALUES('98765432144', 'ass_14', 'b_04');
  1952. INSERT INTO are_given VALUES('98765432144', 'ass_21', 'c_01');
  1953. INSERT INTO are_given VALUES('98765432144', 'ass_22', 'c_02');
  1954. INSERT INTO are_given VALUES('98765432144', 'ass_23', 'c_03');
  1955. INSERT INTO are_given VALUES('98765432144', 'ass_24', 'c_04');
  1956. INSERT INTO are_given VALUES('98765432144', 'ass_31', 'd_01');
  1957. INSERT INTO are_given VALUES('98765432144', 'ass_32', 'd_02');
  1958. INSERT INTO are_given VALUES('98765432144', 'ass_33', 'd_03');
  1959. INSERT INTO are_given VALUES('98765432144', 'ass_34', 'd_04');
  1960. INSERT INTO are_given VALUES('98765432143', 'ass_01', 'a_01');
  1961. INSERT INTO are_given VALUES('98765432143', 'ass_02', 'a_02');
  1962. INSERT INTO are_given VALUES('98765432143', 'ass_03', 'a_03');
  1963. INSERT INTO are_given VALUES('98765432143', 'ass_04', 'a_04');
  1964. INSERT INTO are_given VALUES('98765432143', 'ass_11', 'b_01');
  1965. INSERT INTO are_given VALUES('98765432143', 'ass_12', 'b_02');
  1966. INSERT INTO are_given VALUES('98765432143', 'ass_13', 'b_03');
  1967. INSERT INTO are_given VALUES('98765432143', 'ass_14', 'b_04');
  1968. INSERT INTO are_given VALUES('98765432143', 'ass_21', 'c_01');
  1969. INSERT INTO are_given VALUES('98765432143', 'ass_22', 'c_02');
  1970. INSERT INTO are_given VALUES('98765432143', 'ass_23', 'c_03');
  1971. INSERT INTO are_given VALUES('98765432143', 'ass_24', 'c_04');
  1972. INSERT INTO are_given VALUES('98765432143', 'ass_31', 'd_01');
  1973. INSERT INTO are_given VALUES('98765432143', 'ass_32', 'd_02');
  1974. INSERT INTO are_given VALUES('98765432143', 'ass_33', 'd_03');
  1975. INSERT INTO are_given VALUES('98765432143', 'ass_34', 'd_04');
  1976. INSERT INTO are_given VALUES('98765432142', 'ass_01', 'a_01');
  1977. INSERT INTO are_given VALUES('98765432142', 'ass_02', 'a_02');
  1978. INSERT INTO are_given VALUES('98765432142', 'ass_03', 'a_03');
  1979. INSERT INTO are_given VALUES('98765432142', 'ass_04', 'a_04');
  1980. INSERT INTO are_given VALUES('98765432142', 'ass_11', 'b_01');
  1981. INSERT INTO are_given VALUES('98765432142', 'ass_12', 'b_02');
  1982. INSERT INTO are_given VALUES('98765432142', 'ass_13', 'b_03');
  1983. INSERT INTO are_given VALUES('98765432142', 'ass_14', 'b_04');
  1984. INSERT INTO are_given VALUES('98765432142', 'ass_21', 'c_01');
  1985. INSERT INTO are_given VALUES('98765432142', 'ass_22', 'c_02');
  1986. INSERT INTO are_given VALUES('98765432142', 'ass_23', 'c_03');
  1987. INSERT INTO are_given VALUES('98765432142', 'ass_24', 'c_04');
  1988. INSERT INTO are_given VALUES('98765432142', 'ass_31', 'd_01');
  1989. INSERT INTO are_given VALUES('98765432142', 'ass_32', 'd_02');
  1990. INSERT INTO are_given VALUES('98765432142', 'ass_33', 'd_03');
  1991. INSERT INTO are_given VALUES('98765432142', 'ass_34', 'd_04');
  1992. INSERT INTO are_given VALUES('98765432141', 'ass_01', 'a_01');
  1993. INSERT INTO are_given VALUES('98765432141', 'ass_02', 'a_02');
  1994. INSERT INTO are_given VALUES('98765432141', 'ass_03', 'a_03');
  1995. INSERT INTO are_given VALUES('98765432141', 'ass_04', 'a_04');
  1996. INSERT INTO are_given VALUES('98765432141', 'ass_11', 'b_01');
  1997. INSERT INTO are_given VALUES('98765432141', 'ass_12', 'b_02');
  1998. INSERT INTO are_given VALUES('98765432141', 'ass_13', 'b_03');
  1999. INSERT INTO are_given VALUES('98765432141', 'ass_14', 'b_04');
  2000. INSERT INTO are_given VALUES('98765432141', 'ass_21', 'c_01');
  2001. INSERT INTO are_given VALUES('98765432141', 'ass_22', 'c_02');
  2002. INSERT INTO are_given VALUES('98765432141', 'ass_23', 'c_03');
  2003. INSERT INTO are_given VALUES('98765432141', 'ass_24', 'c_04');
  2004. INSERT INTO are_given VALUES('98765432141', 'ass_31', 'd_01');
  2005. INSERT INTO are_given VALUES('98765432141', 'ass_32', 'd_02');
  2006. INSERT INTO are_given VALUES('98765432141', 'ass_33', 'd_03');
  2007. INSERT INTO are_given VALUES('98765432141', 'ass_34', 'd_04');
  2008. INSERT INTO are_given VALUES('98765432140', 'ass_01', 'a_01');
  2009. INSERT INTO are_given VALUES('98765432140', 'ass_02', 'a_02');
  2010. INSERT INTO are_given VALUES('98765432140', 'ass_03', 'a_03');
  2011. INSERT INTO are_given VALUES('98765432140', 'ass_04', 'a_04');
  2012. INSERT INTO are_given VALUES('98765432140', 'ass_11', 'b_01');
  2013. INSERT INTO are_given VALUES('98765432140', 'ass_12', 'b_02');
  2014. INSERT INTO are_given VALUES('98765432140', 'ass_13', 'b_03');
  2015. INSERT INTO are_given VALUES('98765432140', 'ass_14', 'b_04');
  2016. INSERT INTO are_given VALUES('98765432140', 'ass_21', 'c_01');
  2017. INSERT INTO are_given VALUES('98765432140', 'ass_22', 'c_02');
  2018. INSERT INTO are_given VALUES('98765432140', 'ass_23', 'c_03');
  2019. INSERT INTO are_given VALUES('98765432140', 'ass_24', 'c_04');
  2020. INSERT INTO are_given VALUES('98765432140', 'ass_31', 'd_01');
  2021. INSERT INTO are_given VALUES('98765432140', 'ass_32', 'd_02');
  2022. INSERT INTO are_given VALUES('98765432140', 'ass_33', 'd_03');
  2023. INSERT INTO are_given VALUES('98765432140', 'ass_34', 'd_04');
  2024. INSERT INTO are_given VALUES('98765432139', 'ass_01', 'a_01');
  2025. INSERT INTO are_given VALUES('98765432139', 'ass_02', 'a_02');
  2026. INSERT INTO are_given VALUES('98765432139', 'ass_03', 'a_03');
  2027. INSERT INTO are_given VALUES('98765432139', 'ass_04', 'a_04');
  2028. INSERT INTO are_given VALUES('98765432139', 'ass_11', 'b_01');
  2029. INSERT INTO are_given VALUES('98765432139', 'ass_12', 'b_02');
  2030. INSERT INTO are_given VALUES('98765432139', 'ass_13', 'b_03');
  2031. INSERT INTO are_given VALUES('98765432139', 'ass_14', 'b_04');
  2032. INSERT INTO are_given VALUES('98765432139', 'ass_21', 'c_01');
  2033. INSERT INTO are_given VALUES('98765432139', 'ass_22', 'c_02');
  2034. INSERT INTO are_given VALUES('98765432139', 'ass_23', 'c_03');
  2035. INSERT INTO are_given VALUES('98765432139', 'ass_24', 'c_04');
  2036. INSERT INTO are_given VALUES('98765432139', 'ass_31', 'd_01');
  2037. INSERT INTO are_given VALUES('98765432139', 'ass_32', 'd_02');
  2038. INSERT INTO are_given VALUES('98765432139', 'ass_33', 'd_03');
  2039. INSERT INTO are_given VALUES('98765432139', 'ass_34', 'd_04');
  2040. INSERT INTO are_given VALUES('98765432138', 'ass_01', 'a_01');
  2041. INSERT INTO are_given VALUES('98765432138', 'ass_02', 'a_02');
  2042. INSERT INTO are_given VALUES('98765432138', 'ass_03', 'a_03');
  2043. INSERT INTO are_given VALUES('98765432138', 'ass_04', 'a_04');
  2044. INSERT INTO are_given VALUES('98765432138', 'ass_11', 'b_01');
  2045. INSERT INTO are_given VALUES('98765432138', 'ass_12', 'b_02');
  2046. INSERT INTO are_given VALUES('98765432138', 'ass_13', 'b_03');
  2047. INSERT INTO are_given VALUES('98765432138', 'ass_14', 'b_04');
  2048. INSERT INTO are_given VALUES('98765432138', 'ass_21', 'c_01');
  2049. INSERT INTO are_given VALUES('98765432138', 'ass_22', 'c_02');
  2050. INSERT INTO are_given VALUES('98765432138', 'ass_23', 'c_03');
  2051. INSERT INTO are_given VALUES('98765432138', 'ass_24', 'c_04');
  2052. INSERT INTO are_given VALUES('98765432138', 'ass_31', 'd_01');
  2053. INSERT INTO are_given VALUES('98765432138', 'ass_32', 'd_02');
  2054. INSERT INTO are_given VALUES('98765432138', 'ass_33', 'd_03');
  2055. INSERT INTO are_given VALUES('98765432138', 'ass_34', 'd_04');
  2056. INSERT INTO are_given VALUES('98765432137', 'ass_01', 'a_01');
  2057. INSERT INTO are_given VALUES('98765432137', 'ass_02', 'a_02');
  2058. INSERT INTO are_given VALUES('98765432137', 'ass_03', 'a_03');
  2059. INSERT INTO are_given VALUES('98765432137', 'ass_04', 'a_04');
  2060. INSERT INTO are_given VALUES('98765432137', 'ass_11', 'b_01');
  2061. INSERT INTO are_given VALUES('98765432137', 'ass_12', 'b_02');
  2062. INSERT INTO are_given VALUES('98765432137', 'ass_13', 'b_03');
  2063. INSERT INTO are_given VALUES('98765432137', 'ass_14', 'b_04');
  2064. INSERT INTO are_given VALUES('98765432137', 'ass_21', 'c_01');
  2065. INSERT INTO are_given VALUES('98765432137', 'ass_22', 'c_02');
  2066. INSERT INTO are_given VALUES('98765432137', 'ass_23', 'c_03');
  2067. INSERT INTO are_given VALUES('98765432137', 'ass_24', 'c_04');
  2068. INSERT INTO are_given VALUES('98765432137', 'ass_31', 'd_01');
  2069. INSERT INTO are_given VALUES('98765432137', 'ass_32', 'd_02');
  2070. INSERT INTO are_given VALUES('98765432137', 'ass_33', 'd_03');
  2071. INSERT INTO are_given VALUES('98765432137', 'ass_34', 'd_04');
  2072. INSERT INTO are_given VALUES('98765432136', 'ass_01', 'a_01');
  2073. INSERT INTO are_given VALUES('98765432136', 'ass_02', 'a_02');
  2074. INSERT INTO are_given VALUES('98765432136', 'ass_03', 'a_03');
  2075. INSERT INTO are_given VALUES('98765432136', 'ass_04', 'a_04');
  2076. INSERT INTO are_given VALUES('98765432136', 'ass_11', 'b_01');
  2077. INSERT INTO are_given VALUES('98765432136', 'ass_12', 'b_02');
  2078. INSERT INTO are_given VALUES('98765432136', 'ass_13', 'b_03');
  2079. INSERT INTO are_given VALUES('98765432136', 'ass_14', 'b_04');
  2080. INSERT INTO are_given VALUES('98765432136', 'ass_21', 'c_01');
  2081. INSERT INTO are_given VALUES('98765432136', 'ass_22', 'c_02');
  2082. INSERT INTO are_given VALUES('98765432136', 'ass_23', 'c_03');
  2083. INSERT INTO are_given VALUES('98765432136', 'ass_24', 'c_04');
  2084. INSERT INTO are_given VALUES('98765432136', 'ass_31', 'd_01');
  2085. INSERT INTO are_given VALUES('98765432136', 'ass_32', 'd_02');
  2086. INSERT INTO are_given VALUES('98765432136', 'ass_33', 'd_03');
  2087. INSERT INTO are_given VALUES('98765432136', 'ass_34', 'd_04');
  2088. INSERT INTO are_given VALUES('98765432135', 'ass_01', 'a_01');
  2089. INSERT INTO are_given VALUES('98765432135', 'ass_02', 'a_02');
  2090. INSERT INTO are_given VALUES('98765432135', 'ass_03', 'a_03');
  2091. INSERT INTO are_given VALUES('98765432135', 'ass_04', 'a_04');
  2092. INSERT INTO are_given VALUES('98765432135', 'ass_11', 'b_01');
  2093. INSERT INTO are_given VALUES('98765432135', 'ass_12', 'b_02');
  2094. INSERT INTO are_given VALUES('98765432135', 'ass_13', 'b_03');
  2095. INSERT INTO are_given VALUES('98765432135', 'ass_14', 'b_04');
  2096. INSERT INTO are_given VALUES('98765432135', 'ass_21', 'c_01');
  2097. INSERT INTO are_given VALUES('98765432135', 'ass_22', 'c_02');
  2098. INSERT INTO are_given VALUES('98765432135', 'ass_23', 'c_03');
  2099. INSERT INTO are_given VALUES('98765432135', 'ass_24', 'c_04');
  2100. INSERT INTO are_given VALUES('98765432135', 'ass_31', 'd_01');
  2101. INSERT INTO are_given VALUES('98765432135', 'ass_32', 'd_02');
  2102. INSERT INTO are_given VALUES('98765432135', 'ass_33', 'd_03');
  2103. INSERT INTO are_given VALUES('98765432135', 'ass_34', 'd_04');
  2104. INSERT INTO are_given VALUES('98765432134', 'ass_01', 'a_01');
  2105. INSERT INTO are_given VALUES('98765432134', 'ass_02', 'a_02');
  2106. INSERT INTO are_given VALUES('98765432134', 'ass_03', 'a_03');
  2107. INSERT INTO are_given VALUES('98765432134', 'ass_04', 'a_04');
  2108. INSERT INTO are_given VALUES('98765432134', 'ass_11', 'b_01');
  2109. INSERT INTO are_given VALUES('98765432134', 'ass_12', 'b_02');
  2110. INSERT INTO are_given VALUES('98765432134', 'ass_13', 'b_03');
  2111. INSERT INTO are_given VALUES('98765432134', 'ass_14', 'b_04');
  2112. INSERT INTO are_given VALUES('98765432134', 'ass_21', 'c_01');
  2113. INSERT INTO are_given VALUES('98765432134', 'ass_22', 'c_02');
  2114. INSERT INTO are_given VALUES('98765432134', 'ass_23', 'c_03');
  2115. INSERT INTO are_given VALUES('98765432134', 'ass_24', 'c_04');
  2116. INSERT INTO are_given VALUES('98765432134', 'ass_31', 'd_01');
  2117. INSERT INTO are_given VALUES('98765432134', 'ass_32', 'd_02');
  2118. INSERT INTO are_given VALUES('98765432134', 'ass_33', 'd_03');
  2119. INSERT INTO are_given VALUES('98765432134', 'ass_34', 'd_04');
  2120. INSERT INTO are_given VALUES('98765432133', 'ass_01', 'a_01');
  2121. INSERT INTO are_given VALUES('98765432133', 'ass_02', 'a_02');
  2122. INSERT INTO are_given VALUES('98765432133', 'ass_03', 'a_03');
  2123. INSERT INTO are_given VALUES('98765432133', 'ass_04', 'a_04');
  2124. INSERT INTO are_given VALUES('98765432133', 'ass_11', 'b_01');
  2125. INSERT INTO are_given VALUES('98765432133', 'ass_12', 'b_02');
  2126. INSERT INTO are_given VALUES('98765432133', 'ass_13', 'b_03');
  2127. INSERT INTO are_given VALUES('98765432133', 'ass_14', 'b_04');
  2128. INSERT INTO are_given VALUES('98765432133', 'ass_21', 'c_01');
  2129. INSERT INTO are_given VALUES('98765432133', 'ass_22', 'c_02');
  2130. INSERT INTO are_given VALUES('98765432133', 'ass_23', 'c_03');
  2131. INSERT INTO are_given VALUES('98765432133', 'ass_24', 'c_04');
  2132. INSERT INTO are_given VALUES('98765432133', 'ass_31', 'd_01');
  2133. INSERT INTO are_given VALUES('98765432133', 'ass_32', 'd_02');
  2134. INSERT INTO are_given VALUES('98765432133', 'ass_33', 'd_03');
  2135. INSERT INTO are_given VALUES('98765432133', 'ass_34', 'd_04');
  2136. INSERT INTO are_given VALUES('98765432132', 'ass_01', 'a_01');
  2137. INSERT INTO are_given VALUES('98765432132', 'ass_02', 'a_02');
  2138. INSERT INTO are_given VALUES('98765432132', 'ass_03', 'a_03');
  2139. INSERT INTO are_given VALUES('98765432132', 'ass_04', 'a_04');
  2140. INSERT INTO are_given VALUES('98765432132', 'ass_11', 'b_01');
  2141. INSERT INTO are_given VALUES('98765432132', 'ass_12', 'b_02');
  2142. INSERT INTO are_given VALUES('98765432132', 'ass_13', 'b_03');
  2143. INSERT INTO are_given VALUES('98765432132', 'ass_14', 'b_04');
  2144. INSERT INTO are_given VALUES('98765432132', 'ass_21', 'c_01');
  2145. INSERT INTO are_given VALUES('98765432132', 'ass_22', 'c_02');
  2146. INSERT INTO are_given VALUES('98765432132', 'ass_23', 'c_03');
  2147. INSERT INTO are_given VALUES('98765432132', 'ass_24', 'c_04');
  2148. INSERT INTO are_given VALUES('98765432132', 'ass_31', 'd_01');
  2149. INSERT INTO are_given VALUES('98765432132', 'ass_32', 'd_02');
  2150. INSERT INTO are_given VALUES('98765432132', 'ass_33', 'd_03');
  2151. INSERT INTO are_given VALUES('98765432132', 'ass_34', 'd_04');
  2152. INSERT INTO are_given VALUES('98765432131', 'ass_01', 'a_01');
  2153. INSERT INTO are_given VALUES('98765432131', 'ass_02', 'a_02');
  2154. INSERT INTO are_given VALUES('98765432131', 'ass_03', 'a_03');
  2155. INSERT INTO are_given VALUES('98765432131', 'ass_04', 'a_04');
  2156. INSERT INTO are_given VALUES('98765432131', 'ass_11', 'b_01');
  2157. INSERT INTO are_given VALUES('98765432131', 'ass_12', 'b_02');
  2158. INSERT INTO are_given VALUES('98765432131', 'ass_13', 'b_03');
  2159. INSERT INTO are_given VALUES('98765432131', 'ass_14', 'b_04');
  2160. INSERT INTO are_given VALUES('98765432131', 'ass_21', 'c_01');
  2161. INSERT INTO are_given VALUES('98765432131', 'ass_22', 'c_02');
  2162. INSERT INTO are_given VALUES('98765432131', 'ass_23', 'c_03');
  2163. INSERT INTO are_given VALUES('98765432131', 'ass_24', 'c_04');
  2164. INSERT INTO are_given VALUES('98765432131', 'ass_31', 'd_01');
  2165. INSERT INTO are_given VALUES('98765432131', 'ass_32', 'd_02');
  2166. INSERT INTO are_given VALUES('98765432131', 'ass_33', 'd_03');
  2167. INSERT INTO are_given VALUES('98765432131', 'ass_34', 'd_04');
  2168. INSERT INTO are_given VALUES('98765432130', 'ass_01', 'a_01');
  2169. INSERT INTO are_given VALUES('98765432130', 'ass_02', 'a_02');
  2170. INSERT INTO are_given VALUES('98765432130', 'ass_03', 'a_03');
  2171. INSERT INTO are_given VALUES('98765432130', 'ass_04', 'a_04');
  2172. INSERT INTO are_given VALUES('98765432130', 'ass_11', 'b_01');
  2173. INSERT INTO are_given VALUES('98765432130', 'ass_12', 'b_02');
  2174. INSERT INTO are_given VALUES('98765432130', 'ass_13', 'b_03');
  2175. INSERT INTO are_given VALUES('98765432130', 'ass_14', 'b_04');
  2176. INSERT INTO are_given VALUES('98765432130', 'ass_21', 'c_01');
  2177. INSERT INTO are_given VALUES('98765432130', 'ass_22', 'c_02');
  2178. INSERT INTO are_given VALUES('98765432130', 'ass_23', 'c_03');
  2179. INSERT INTO are_given VALUES('98765432130', 'ass_24', 'c_04');
  2180. INSERT INTO are_given VALUES('98765432130', 'ass_31', 'd_01');
  2181. INSERT INTO are_given VALUES('98765432130', 'ass_32', 'd_02');
  2182. INSERT INTO are_given VALUES('98765432130', 'ass_33', 'd_03');
  2183. INSERT INTO are_given VALUES('98765432130', 'ass_34', 'd_04');
  2184. INSERT INTO are_given VALUES('98765432129', 'ass_01', 'a_01');
  2185. INSERT INTO are_given VALUES('98765432129', 'ass_02', 'a_02');
  2186. INSERT INTO are_given VALUES('98765432129', 'ass_03', 'a_03');
  2187. INSERT INTO are_given VALUES('98765432129', 'ass_04', 'a_04');
  2188. INSERT INTO are_given VALUES('98765432129', 'ass_11', 'b_01');
  2189. INSERT INTO are_given VALUES('98765432129', 'ass_12', 'b_02');
  2190. INSERT INTO are_given VALUES('98765432129', 'ass_13', 'b_03');
  2191. INSERT INTO are_given VALUES('98765432129', 'ass_14', 'b_04');
  2192. INSERT INTO are_given VALUES('98765432129', 'ass_21', 'c_01');
  2193. INSERT INTO are_given VALUES('98765432129', 'ass_22', 'c_02');
  2194. INSERT INTO are_given VALUES('98765432129', 'ass_23', 'c_03');
  2195. INSERT INTO are_given VALUES('98765432129', 'ass_24', 'c_04');
  2196. INSERT INTO are_given VALUES('98765432129', 'ass_31', 'd_01');
  2197. INSERT INTO are_given VALUES('98765432129', 'ass_32', 'd_02');
  2198. INSERT INTO are_given VALUES('98765432129', 'ass_33', 'd_03');
  2199. INSERT INTO are_given VALUES('98765432129', 'ass_34', 'd_04');
  2200. INSERT INTO are_given VALUES('98765432128', 'ass_01', 'a_01');
  2201. INSERT INTO are_given VALUES('98765432128', 'ass_02', 'a_02');
  2202. INSERT INTO are_given VALUES('98765432128', 'ass_03', 'a_03');
  2203. INSERT INTO are_given VALUES('98765432128', 'ass_04', 'a_04');
  2204. INSERT INTO are_given VALUES('98765432128', 'ass_11', 'b_01');
  2205. INSERT INTO are_given VALUES('98765432128', 'ass_12', 'b_02');
  2206. INSERT INTO are_given VALUES('98765432128', 'ass_13', 'b_03');
  2207. INSERT INTO are_given VALUES('98765432128', 'ass_14', 'b_04');
  2208. INSERT INTO are_given VALUES('98765432128', 'ass_21', 'c_01');
  2209. INSERT INTO are_given VALUES('98765432128', 'ass_22', 'c_02');
  2210. INSERT INTO are_given VALUES('98765432128', 'ass_23', 'c_03');
  2211. INSERT INTO are_given VALUES('98765432128', 'ass_24', 'c_04');
  2212. INSERT INTO are_given VALUES('98765432128', 'ass_31', 'd_01');
  2213. INSERT INTO are_given VALUES('98765432128', 'ass_32', 'd_02');
  2214. INSERT INTO are_given VALUES('98765432128', 'ass_33', 'd_03');
  2215. INSERT INTO are_given VALUES('98765432128', 'ass_34', 'd_04');
  2216. INSERT INTO are_given VALUES('98765432127', 'ass_01', 'a_01');
  2217. INSERT INTO are_given VALUES('98765432127', 'ass_02', 'a_02');
  2218. INSERT INTO are_given VALUES('98765432127', 'ass_03', 'a_03');
  2219. INSERT INTO are_given VALUES('98765432127', 'ass_04', 'a_04');
  2220. INSERT INTO are_given VALUES('98765432127', 'ass_11', 'b_01');
  2221. INSERT INTO are_given VALUES('98765432127', 'ass_12', 'b_02');
  2222. INSERT INTO are_given VALUES('98765432127', 'ass_13', 'b_03');
  2223. INSERT INTO are_given VALUES('98765432127', 'ass_14', 'b_04');
  2224. INSERT INTO are_given VALUES('98765432127', 'ass_21', 'c_01');
  2225. INSERT INTO are_given VALUES('98765432127', 'ass_22', 'c_02');
  2226. INSERT INTO are_given VALUES('98765432127', 'ass_23', 'c_03');
  2227. INSERT INTO are_given VALUES('98765432127', 'ass_24', 'c_04');
  2228. INSERT INTO are_given VALUES('98765432127', 'ass_31', 'd_01');
  2229. INSERT INTO are_given VALUES('98765432127', 'ass_32', 'd_02');
  2230. INSERT INTO are_given VALUES('98765432127', 'ass_33', 'd_03');
  2231. INSERT INTO are_given VALUES('98765432127', 'ass_34', 'd_04');
  2232. INSERT INTO are_given VALUES('98765432126', 'ass_01', 'a_01');
  2233. INSERT INTO are_given VALUES('98765432126', 'ass_02', 'a_02');
  2234. INSERT INTO are_given VALUES('98765432126', 'ass_03', 'a_03');
  2235. INSERT INTO are_given VALUES('98765432126', 'ass_04', 'a_04');
  2236. INSERT INTO are_given VALUES('98765432126', 'ass_11', 'b_01');
  2237. INSERT INTO are_given VALUES('98765432126', 'ass_12', 'b_02');
  2238. INSERT INTO are_given VALUES('98765432126', 'ass_13', 'b_03');
  2239. INSERT INTO are_given VALUES('98765432126', 'ass_14', 'b_04');
  2240. INSERT INTO are_given VALUES('98765432126', 'ass_21', 'c_01');
  2241. INSERT INTO are_given VALUES('98765432126', 'ass_22', 'c_02');
  2242. INSERT INTO are_given VALUES('98765432126', 'ass_23', 'c_03');
  2243. INSERT INTO are_given VALUES('98765432126', 'ass_24', 'c_04');
  2244. INSERT INTO are_given VALUES('98765432126', 'ass_31', 'd_01');
  2245. INSERT INTO are_given VALUES('98765432126', 'ass_32', 'd_02');
  2246. INSERT INTO are_given VALUES('98765432126', 'ass_33', 'd_03');
  2247. INSERT INTO are_given VALUES('98765432126', 'ass_34', 'd_04');
  2248. INSERT INTO are_given VALUES('98765432125', 'ass_01', 'a_01');
  2249. INSERT INTO are_given VALUES('98765432125', 'ass_02', 'a_02');
  2250. INSERT INTO are_given VALUES('98765432125', 'ass_03', 'a_03');
  2251. INSERT INTO are_given VALUES('98765432125', 'ass_04', 'a_04');
  2252. INSERT INTO are_given VALUES('98765432125', 'ass_11', 'b_01');
  2253. INSERT INTO are_given VALUES('98765432125', 'ass_12', 'b_02');
  2254. INSERT INTO are_given VALUES('98765432125', 'ass_13', 'b_03');
  2255. INSERT INTO are_given VALUES('98765432125', 'ass_14', 'b_04');
  2256. INSERT INTO are_given VALUES('98765432125', 'ass_21', 'c_01');
  2257. INSERT INTO are_given VALUES('98765432125', 'ass_22', 'c_02');
  2258. INSERT INTO are_given VALUES('98765432125', 'ass_23', 'c_03');
  2259. INSERT INTO are_given VALUES('98765432125', 'ass_24', 'c_04');
  2260. INSERT INTO are_given VALUES('98765432125', 'ass_31', 'd_01');
  2261. INSERT INTO are_given VALUES('98765432125', 'ass_32', 'd_02');
  2262. INSERT INTO are_given VALUES('98765432125', 'ass_33', 'd_03');
  2263. INSERT INTO are_given VALUES('98765432125', 'ass_34', 'd_04');
  2264. INSERT INTO are_given VALUES('98765432124', 'ass_01', 'a_01');
  2265. INSERT INTO are_given VALUES('98765432124', 'ass_02', 'a_02');
  2266. INSERT INTO are_given VALUES('98765432124', 'ass_03', 'a_03');
  2267. INSERT INTO are_given VALUES('98765432124', 'ass_04', 'a_04');
  2268. INSERT INTO are_given VALUES('98765432124', 'ass_11', 'b_01');
  2269. INSERT INTO are_given VALUES('98765432124', 'ass_12', 'b_02');
  2270. INSERT INTO are_given VALUES('98765432124', 'ass_13', 'b_03');
  2271. INSERT INTO are_given VALUES('98765432124', 'ass_14', 'b_04');
  2272. INSERT INTO are_given VALUES('98765432124', 'ass_21', 'c_01');
  2273. INSERT INTO are_given VALUES('98765432124', 'ass_22', 'c_02');
  2274. INSERT INTO are_given VALUES('98765432124', 'ass_23', 'c_03');
  2275. INSERT INTO are_given VALUES('98765432124', 'ass_24', 'c_04');
  2276. INSERT INTO are_given VALUES('98765432124', 'ass_31', 'd_01');
  2277. INSERT INTO are_given VALUES('98765432124', 'ass_32', 'd_02');
  2278. INSERT INTO are_given VALUES('98765432124', 'ass_33', 'd_03');
  2279. INSERT INTO are_given VALUES('98765432124', 'ass_34', 'd_04');
  2280. INSERT INTO are_given VALUES('98765432123', 'ass_01', 'a_01');
  2281. INSERT INTO are_given VALUES('98765432123', 'ass_02', 'a_02');
  2282. INSERT INTO are_given VALUES('98765432123', 'ass_03', 'a_03');
  2283. INSERT INTO are_given VALUES('98765432123', 'ass_04', 'a_04');
  2284. INSERT INTO are_given VALUES('98765432123', 'ass_11', 'b_01');
  2285. INSERT INTO are_given VALUES('98765432123', 'ass_12', 'b_02');
  2286. INSERT INTO are_given VALUES('98765432123', 'ass_13', 'b_03');
  2287. INSERT INTO are_given VALUES('98765432123', 'ass_14', 'b_04');
  2288. INSERT INTO are_given VALUES('98765432123', 'ass_21', 'c_01');
  2289. INSERT INTO are_given VALUES('98765432123', 'ass_22', 'c_02');
  2290. INSERT INTO are_given VALUES('98765432123', 'ass_23', 'c_03');
  2291. INSERT INTO are_given VALUES('98765432123', 'ass_24', 'c_04');
  2292. INSERT INTO are_given VALUES('98765432123', 'ass_31', 'd_01');
  2293. INSERT INTO are_given VALUES('98765432123', 'ass_32', 'd_02');
  2294. INSERT INTO are_given VALUES('98765432123', 'ass_33', 'd_03');
  2295. INSERT INTO are_given VALUES('98765432123', 'ass_34', 'd_04');
  2296. INSERT INTO are_given VALUES('98765432122', 'ass_01', 'a_01');
  2297. INSERT INTO are_given VALUES('98765432122', 'ass_02', 'a_02');
  2298. INSERT INTO are_given VALUES('98765432122', 'ass_03', 'a_03');
  2299. INSERT INTO are_given VALUES('98765432122', 'ass_04', 'a_04');
  2300. INSERT INTO are_given VALUES('98765432122', 'ass_11', 'b_01');
  2301. INSERT INTO are_given VALUES('98765432122', 'ass_12', 'b_02');
  2302. INSERT INTO are_given VALUES('98765432122', 'ass_13', 'b_03');
  2303. INSERT INTO are_given VALUES('98765432122', 'ass_14', 'b_04');
  2304. INSERT INTO are_given VALUES('98765432122', 'ass_21', 'c_01');
  2305. INSERT INTO are_given VALUES('98765432122', 'ass_22', 'c_02');
  2306. INSERT INTO are_given VALUES('98765432122', 'ass_23', 'c_03');
  2307. INSERT INTO are_given VALUES('98765432122', 'ass_24', 'c_04');
  2308. INSERT INTO are_given VALUES('98765432122', 'ass_31', 'd_01');
  2309. INSERT INTO are_given VALUES('98765432122', 'ass_32', 'd_02');
  2310. INSERT INTO are_given VALUES('98765432122', 'ass_33', 'd_03');
  2311. INSERT INTO are_given VALUES('98765432122', 'ass_34', 'd_04');
  2312. INSERT INTO are_given VALUES('98765432121', 'ass_01', 'a_01');
  2313. INSERT INTO are_given VALUES('98765432121', 'ass_02', 'a_02');
  2314. INSERT INTO are_given VALUES('98765432121', 'ass_03', 'a_03');
  2315. INSERT INTO are_given VALUES('98765432121', 'ass_04', 'a_04');
  2316. INSERT INTO are_given VALUES('98765432121', 'ass_11', 'b_01');
  2317. INSERT INTO are_given VALUES('98765432121', 'ass_12', 'b_02');
  2318. INSERT INTO are_given VALUES('98765432121', 'ass_13', 'b_03');
  2319. INSERT INTO are_given VALUES('98765432121', 'ass_14', 'b_04');
  2320. INSERT INTO are_given VALUES('98765432121', 'ass_21', 'c_01');
  2321. INSERT INTO are_given VALUES('98765432121', 'ass_22', 'c_02');
  2322. INSERT INTO are_given VALUES('98765432121', 'ass_23', 'c_03');
  2323. INSERT INTO are_given VALUES('98765432121', 'ass_24', 'c_04');
  2324. INSERT INTO are_given VALUES('98765432121', 'ass_31', 'd_01');
  2325. INSERT INTO are_given VALUES('98765432121', 'ass_32', 'd_02');
  2326. INSERT INTO are_given VALUES('98765432121', 'ass_33', 'd_03');
  2327. INSERT INTO are_given VALUES('98765432121', 'ass_34', 'd_04');
  2328. INSERT INTO are_given VALUES('98765432120', 'ass_01', 'a_01');
  2329. INSERT INTO are_given VALUES('98765432120', 'ass_02', 'a_02');
  2330. INSERT INTO are_given VALUES('98765432120', 'ass_03', 'a_03');
  2331. INSERT INTO are_given VALUES('98765432120', 'ass_04', 'a_04');
  2332. INSERT INTO are_given VALUES('98765432120', 'ass_11', 'b_01');
  2333. INSERT INTO are_given VALUES('98765432120', 'ass_12', 'b_02');
  2334. INSERT INTO are_given VALUES('98765432120', 'ass_13', 'b_03');
  2335. INSERT INTO are_given VALUES('98765432120', 'ass_14', 'b_04');
  2336. INSERT INTO are_given VALUES('98765432120', 'ass_21', 'c_01');
  2337. INSERT INTO are_given VALUES('98765432120', 'ass_22', 'c_02');
  2338. INSERT INTO are_given VALUES('98765432120', 'ass_23', 'c_03');
  2339. INSERT INTO are_given VALUES('98765432120', 'ass_24', 'c_04');
  2340. INSERT INTO are_given VALUES('98765432120', 'ass_31', 'd_01');
  2341. INSERT INTO are_given VALUES('98765432120', 'ass_32', 'd_02');
  2342. INSERT INTO are_given VALUES('98765432120', 'ass_33', 'd_03');
  2343. INSERT INTO are_given VALUES('98765432120', 'ass_34', 'd_04');
  2344. INSERT INTO are_given VALUES('98765432119', 'ass_01', 'a_01');
  2345. INSERT INTO are_given VALUES('98765432119', 'ass_02', 'a_02');
  2346. INSERT INTO are_given VALUES('98765432119', 'ass_03', 'a_03');
  2347. INSERT INTO are_given VALUES('98765432119', 'ass_04', 'a_04');
  2348. INSERT INTO are_given VALUES('98765432119', 'ass_11', 'b_01');
  2349. INSERT INTO are_given VALUES('98765432119', 'ass_12', 'b_02');
  2350. INSERT INTO are_given VALUES('98765432119', 'ass_13', 'b_03');
  2351. INSERT INTO are_given VALUES('98765432119', 'ass_14', 'b_04');
  2352. INSERT INTO are_given VALUES('98765432119', 'ass_21', 'c_01');
  2353. INSERT INTO are_given VALUES('98765432119', 'ass_22', 'c_02');
  2354. INSERT INTO are_given VALUES('98765432119', 'ass_23', 'c_03');
  2355. INSERT INTO are_given VALUES('98765432119', 'ass_24', 'c_04');
  2356. INSERT INTO are_given VALUES('98765432119', 'ass_31', 'd_01');
  2357. INSERT INTO are_given VALUES('98765432119', 'ass_32', 'd_02');
  2358. INSERT INTO are_given VALUES('98765432119', 'ass_33', 'd_03');
  2359. INSERT INTO are_given VALUES('98765432119', 'ass_34', 'd_04');
  2360. INSERT INTO are_given VALUES('98765432118', 'ass_01', 'a_01');
  2361. INSERT INTO are_given VALUES('98765432118', 'ass_02', 'a_02');
  2362. INSERT INTO are_given VALUES('98765432118', 'ass_03', 'a_03');
  2363. INSERT INTO are_given VALUES('98765432118', 'ass_04', 'a_04');
  2364. INSERT INTO are_given VALUES('98765432118', 'ass_11', 'b_01');
  2365. INSERT INTO are_given VALUES('98765432118', 'ass_12', 'b_02');
  2366. INSERT INTO are_given VALUES('98765432118', 'ass_13', 'b_03');
  2367. INSERT INTO are_given VALUES('98765432118', 'ass_14', 'b_04');
  2368. INSERT INTO are_given VALUES('98765432118', 'ass_21', 'c_01');
  2369. INSERT INTO are_given VALUES('98765432118', 'ass_22', 'c_02');
  2370. INSERT INTO are_given VALUES('98765432118', 'ass_23', 'c_03');
  2371. INSERT INTO are_given VALUES('98765432118', 'ass_24', 'c_04');
  2372. INSERT INTO are_given VALUES('98765432118', 'ass_31', 'd_01');
  2373. INSERT INTO are_given VALUES('98765432118', 'ass_32', 'd_02');
  2374. INSERT INTO are_given VALUES('98765432118', 'ass_33', 'd_03');
  2375. INSERT INTO are_given VALUES('98765432118', 'ass_34', 'd_04');
  2376. INSERT INTO are_given VALUES('98765432117', 'ass_01', 'a_01');
  2377. INSERT INTO are_given VALUES('98765432117', 'ass_02', 'a_02');
  2378. INSERT INTO are_given VALUES('98765432117', 'ass_03', 'a_03');
  2379. INSERT INTO are_given VALUES('98765432117', 'ass_04', 'a_04');
  2380. INSERT INTO are_given VALUES('98765432117', 'ass_11', 'b_01');
  2381. INSERT INTO are_given VALUES('98765432117', 'ass_12', 'b_02');
  2382. INSERT INTO are_given VALUES('98765432117', 'ass_13', 'b_03');
  2383. INSERT INTO are_given VALUES('98765432117', 'ass_14', 'b_04');
  2384. INSERT INTO are_given VALUES('98765432117', 'ass_21', 'c_01');
  2385. INSERT INTO are_given VALUES('98765432117', 'ass_22', 'c_02');
  2386. INSERT INTO are_given VALUES('98765432117', 'ass_23', 'c_03');
  2387. INSERT INTO are_given VALUES('98765432117', 'ass_24', 'c_04');
  2388. INSERT INTO are_given VALUES('98765432117', 'ass_31', 'd_01');
  2389. INSERT INTO are_given VALUES('98765432117', 'ass_32', 'd_02');
  2390. INSERT INTO are_given VALUES('98765432117', 'ass_33', 'd_03');
  2391. INSERT INTO are_given VALUES('98765432117', 'ass_34', 'd_04');
  2392. INSERT INTO are_given VALUES('98765432116', 'ass_01', 'a_01');
  2393. INSERT INTO are_given VALUES('98765432116', 'ass_02', 'a_02');
  2394. INSERT INTO are_given VALUES('98765432116', 'ass_03', 'a_03');
  2395. INSERT INTO are_given VALUES('98765432116', 'ass_04', 'a_04');
  2396. INSERT INTO are_given VALUES('98765432116', 'ass_11', 'b_01');
  2397. INSERT INTO are_given VALUES('98765432116', 'ass_12', 'b_02');
  2398. INSERT INTO are_given VALUES('98765432116', 'ass_13', 'b_03');
  2399. INSERT INTO are_given VALUES('98765432116', 'ass_14', 'b_04');
  2400. INSERT INTO are_given VALUES('98765432116', 'ass_21', 'c_01');
  2401. INSERT INTO are_given VALUES('98765432116', 'ass_22', 'c_02');
  2402. INSERT INTO are_given VALUES('98765432116', 'ass_23', 'c_03');
  2403. INSERT INTO are_given VALUES('98765432116', 'ass_24', 'c_04');
  2404. INSERT INTO are_given VALUES('98765432116', 'ass_31', 'd_01');
  2405. INSERT INTO are_given VALUES('98765432116', 'ass_32', 'd_02');
  2406. INSERT INTO are_given VALUES('98765432116', 'ass_33', 'd_03');
  2407. INSERT INTO are_given VALUES('98765432116', 'ass_34', 'd_04');
  2408. INSERT INTO are_given VALUES('98765432115', 'ass_01', 'a_01');
  2409. INSERT INTO are_given VALUES('98765432115', 'ass_02', 'a_02');
  2410. INSERT INTO are_given VALUES('98765432115', 'ass_03', 'a_03');
  2411. INSERT INTO are_given VALUES('98765432115', 'ass_04', 'a_04');
  2412. INSERT INTO are_given VALUES('98765432115', 'ass_11', 'b_01');
  2413. INSERT INTO are_given VALUES('98765432115', 'ass_12', 'b_02');
  2414. INSERT INTO are_given VALUES('98765432115', 'ass_13', 'b_03');
  2415. INSERT INTO are_given VALUES('98765432115', 'ass_14', 'b_04');
  2416. INSERT INTO are_given VALUES('98765432115', 'ass_21', 'c_01');
  2417. INSERT INTO are_given VALUES('98765432115', 'ass_22', 'c_02');
  2418. INSERT INTO are_given VALUES('98765432115', 'ass_23', 'c_03');
  2419. INSERT INTO are_given VALUES('98765432115', 'ass_24', 'c_04');
  2420. INSERT INTO are_given VALUES('98765432115', 'ass_31', 'd_01');
  2421. INSERT INTO are_given VALUES('98765432115', 'ass_32', 'd_02');
  2422. INSERT INTO are_given VALUES('98765432115', 'ass_33', 'd_03');
  2423. INSERT INTO are_given VALUES('98765432115', 'ass_34', 'd_04');
  2424. INSERT INTO are_given VALUES('98765432114', 'ass_01', 'a_01');
  2425. INSERT INTO are_given VALUES('98765432114', 'ass_02', 'a_02');
  2426. INSERT INTO are_given VALUES('98765432114', 'ass_03', 'a_03');
  2427. INSERT INTO are_given VALUES('98765432114', 'ass_04', 'a_04');
  2428. INSERT INTO are_given VALUES('98765432114', 'ass_11', 'b_01');
  2429. INSERT INTO are_given VALUES('98765432114', 'ass_12', 'b_02');
  2430. INSERT INTO are_given VALUES('98765432114', 'ass_13', 'b_03');
  2431. INSERT INTO are_given VALUES('98765432114', 'ass_14', 'b_04');
  2432. INSERT INTO are_given VALUES('98765432114', 'ass_21', 'c_01');
  2433. INSERT INTO are_given VALUES('98765432114', 'ass_22', 'c_02');
  2434. INSERT INTO are_given VALUES('98765432114', 'ass_23', 'c_03');
  2435. INSERT INTO are_given VALUES('98765432114', 'ass_24', 'c_04');
  2436. INSERT INTO are_given VALUES('98765432114', 'ass_31', 'd_01');
  2437. INSERT INTO are_given VALUES('98765432114', 'ass_32', 'd_02');
  2438. INSERT INTO are_given VALUES('98765432114', 'ass_33', 'd_03');
  2439. INSERT INTO are_given VALUES('98765432114', 'ass_34', 'd_04');
  2440. INSERT INTO are_given VALUES('98765432113', 'ass_01', 'a_01');
  2441. INSERT INTO are_given VALUES('98765432113', 'ass_02', 'a_02');
  2442. INSERT INTO are_given VALUES('98765432113', 'ass_03', 'a_03');
  2443. INSERT INTO are_given VALUES('98765432113', 'ass_04', 'a_04');
  2444. INSERT INTO are_given VALUES('98765432113', 'ass_11', 'b_01');
  2445. INSERT INTO are_given VALUES('98765432113', 'ass_12', 'b_02');
  2446. INSERT INTO are_given VALUES('98765432113', 'ass_13', 'b_03');
  2447. INSERT INTO are_given VALUES('98765432113', 'ass_14', 'b_04');
  2448. INSERT INTO are_given VALUES('98765432113', 'ass_21', 'c_01');
  2449. INSERT INTO are_given VALUES('98765432113', 'ass_22', 'c_02');
  2450. INSERT INTO are_given VALUES('98765432113', 'ass_23', 'c_03');
  2451. INSERT INTO are_given VALUES('98765432113', 'ass_24', 'c_04');
  2452. INSERT INTO are_given VALUES('98765432113', 'ass_31', 'd_01');
  2453. INSERT INTO are_given VALUES('98765432113', 'ass_32', 'd_02');
  2454. INSERT INTO are_given VALUES('98765432113', 'ass_33', 'd_03');
  2455. INSERT INTO are_given VALUES('98765432113', 'ass_34', 'd_04');
  2456. INSERT INTO are_given VALUES('98765432112', 'ass_01', 'a_01');
  2457. INSERT INTO are_given VALUES('98765432112', 'ass_02', 'a_02');
  2458. INSERT INTO are_given VALUES('98765432112', 'ass_03', 'a_03');
  2459. INSERT INTO are_given VALUES('98765432112', 'ass_04', 'a_04');
  2460. INSERT INTO are_given VALUES('98765432112', 'ass_11', 'b_01');
  2461. INSERT INTO are_given VALUES('98765432112', 'ass_12', 'b_02');
  2462. INSERT INTO are_given VALUES('98765432112', 'ass_13', 'b_03');
  2463. INSERT INTO are_given VALUES('98765432112', 'ass_14', 'b_04');
  2464. INSERT INTO are_given VALUES('98765432112', 'ass_21', 'c_01');
  2465. INSERT INTO are_given VALUES('98765432112', 'ass_22', 'c_02');
  2466. INSERT INTO are_given VALUES('98765432112', 'ass_23', 'c_03');
  2467. INSERT INTO are_given VALUES('98765432112', 'ass_24', 'c_04');
  2468. INSERT INTO are_given VALUES('98765432112', 'ass_31', 'd_01');
  2469. INSERT INTO are_given VALUES('98765432112', 'ass_32', 'd_02');
  2470. INSERT INTO are_given VALUES('98765432112', 'ass_33', 'd_03');
  2471. INSERT INTO are_given VALUES('98765432112', 'ass_34', 'd_04');
  2472. INSERT INTO are_given VALUES('98765432111', 'ass_01', 'a_01');
  2473. INSERT INTO are_given VALUES('98765432111', 'ass_02', 'a_02');
  2474. INSERT INTO are_given VALUES('98765432111', 'ass_03', 'a_03');
  2475. INSERT INTO are_given VALUES('98765432111', 'ass_04', 'a_04');
  2476. INSERT INTO are_given VALUES('98765432111', 'ass_11', 'b_01');
  2477. INSERT INTO are_given VALUES('98765432111', 'ass_12', 'b_02');
  2478. INSERT INTO are_given VALUES('98765432111', 'ass_13', 'b_03');
  2479. INSERT INTO are_given VALUES('98765432111', 'ass_14', 'b_04');
  2480. INSERT INTO are_given VALUES('98765432111', 'ass_21', 'c_01');
  2481. INSERT INTO are_given VALUES('98765432111', 'ass_22', 'c_02');
  2482. INSERT INTO are_given VALUES('98765432111', 'ass_23', 'c_03');
  2483. INSERT INTO are_given VALUES('98765432111', 'ass_24', 'c_04');
  2484. INSERT INTO are_given VALUES('98765432111', 'ass_31', 'd_01');
  2485. INSERT INTO are_given VALUES('98765432111', 'ass_32', 'd_02');
  2486. INSERT INTO are_given VALUES('98765432111', 'ass_33', 'd_03');
  2487. INSERT INTO are_given VALUES('98765432111', 'ass_34', 'd_04');
  2488. INSERT INTO are_given VALUES('98765432110', 'ass_01', 'a_01');
  2489. INSERT INTO are_given VALUES('98765432110', 'ass_02', 'a_02');
  2490. INSERT INTO are_given VALUES('98765432110', 'ass_03', 'a_03');
  2491. INSERT INTO are_given VALUES('98765432110', 'ass_04', 'a_04');
  2492. INSERT INTO are_given VALUES('98765432110', 'ass_11', 'b_01');
  2493. INSERT INTO are_given VALUES('98765432110', 'ass_12', 'b_02');
  2494. INSERT INTO are_given VALUES('98765432110', 'ass_13', 'b_03');
  2495. INSERT INTO are_given VALUES('98765432110', 'ass_14', 'b_04');
  2496. INSERT INTO are_given VALUES('98765432110', 'ass_21', 'c_01');
  2497. INSERT INTO are_given VALUES('98765432110', 'ass_22', 'c_02');
  2498. INSERT INTO are_given VALUES('98765432110', 'ass_23', 'c_03');
  2499. INSERT INTO are_given VALUES('98765432110', 'ass_24', 'c_04');
  2500. INSERT INTO are_given VALUES('98765432110', 'ass_31', 'd_01');
  2501. INSERT INTO are_given VALUES('98765432110', 'ass_32', 'd_02');
  2502. INSERT INTO are_given VALUES('98765432110', 'ass_33', 'd_03');
  2503. INSERT INTO are_given VALUES('98765432110', 'ass_34', 'd_04');
  2504. INSERT INTO are_given VALUES('98765432109', 'ass_01', 'a_01');
  2505. INSERT INTO are_given VALUES('98765432109', 'ass_02', 'a_02');
  2506. INSERT INTO are_given VALUES('98765432109', 'ass_03', 'a_03');
  2507. INSERT INTO are_given VALUES('98765432109', 'ass_04', 'a_04');
  2508. INSERT INTO are_given VALUES('98765432109', 'ass_11', 'b_01');
  2509. INSERT INTO are_given VALUES('98765432109', 'ass_12', 'b_02');
  2510. INSERT INTO are_given VALUES('98765432109', 'ass_13', 'b_03');
  2511. INSERT INTO are_given VALUES('98765432109', 'ass_14', 'b_04');
  2512. INSERT INTO are_given VALUES('98765432109', 'ass_21', 'c_01');
  2513. INSERT INTO are_given VALUES('98765432109', 'ass_22', 'c_02');
  2514. INSERT INTO are_given VALUES('98765432109', 'ass_23', 'c_03');
  2515. INSERT INTO are_given VALUES('98765432109', 'ass_24', 'c_04');
  2516. INSERT INTO are_given VALUES('98765432109', 'ass_31', 'd_01');
  2517. INSERT INTO are_given VALUES('98765432109', 'ass_32', 'd_02');
  2518. INSERT INTO are_given VALUES('98765432109', 'ass_33', 'd_03');
  2519. INSERT INTO are_given VALUES('98765432109', 'ass_34', 'd_04');
  2520. INSERT INTO are_given VALUES('98765432108', 'ass_01', 'a_01');
  2521. INSERT INTO are_given VALUES('98765432108', 'ass_02', 'a_02');
  2522. INSERT INTO are_given VALUES('98765432108', 'ass_03', 'a_03');
  2523. INSERT INTO are_given VALUES('98765432108', 'ass_04', 'a_04');
  2524. INSERT INTO are_given VALUES('98765432108', 'ass_11', 'b_01');
  2525. INSERT INTO are_given VALUES('98765432108', 'ass_12', 'b_02');
  2526. INSERT INTO are_given VALUES('98765432108', 'ass_13', 'b_03');
  2527. INSERT INTO are_given VALUES('98765432108', 'ass_14', 'b_04');
  2528. INSERT INTO are_given VALUES('98765432108', 'ass_21', 'c_01');
  2529. INSERT INTO are_given VALUES('98765432108', 'ass_22', 'c_02');
  2530. INSERT INTO are_given VALUES('98765432108', 'ass_23', 'c_03');
  2531. INSERT INTO are_given VALUES('98765432108', 'ass_24', 'c_04');
  2532. INSERT INTO are_given VALUES('98765432108', 'ass_31', 'd_01');
  2533. INSERT INTO are_given VALUES('98765432108', 'ass_32', 'd_02');
  2534. INSERT INTO are_given VALUES('98765432108', 'ass_33', 'd_03');
  2535. INSERT INTO are_given VALUES('98765432108', 'ass_34', 'd_04');
  2536. INSERT INTO are_given VALUES('98765432107', 'ass_01', 'a_01');
  2537. INSERT INTO are_given VALUES('98765432107', 'ass_02', 'a_02');
  2538. INSERT INTO are_given VALUES('98765432107', 'ass_03', 'a_03');
  2539. INSERT INTO are_given VALUES('98765432107', 'ass_04', 'a_04');
  2540. INSERT INTO are_given VALUES('98765432107', 'ass_11', 'b_01');
  2541. INSERT INTO are_given VALUES('98765432107', 'ass_12', 'b_02');
  2542. INSERT INTO are_given VALUES('98765432107', 'ass_13', 'b_03');
  2543. INSERT INTO are_given VALUES('98765432107', 'ass_14', 'b_04');
  2544. INSERT INTO are_given VALUES('98765432107', 'ass_21', 'c_01');
  2545. INSERT INTO are_given VALUES('98765432107', 'ass_22', 'c_02');
  2546. INSERT INTO are_given VALUES('98765432107', 'ass_23', 'c_03');
  2547. INSERT INTO are_given VALUES('98765432107', 'ass_24', 'c_04');
  2548. INSERT INTO are_given VALUES('98765432107', 'ass_31', 'd_01');
  2549. INSERT INTO are_given VALUES('98765432107', 'ass_32', 'd_02');
  2550. INSERT INTO are_given VALUES('98765432107', 'ass_33', 'd_03');
  2551. INSERT INTO are_given VALUES('98765432107', 'ass_34', 'd_04');
  2552. INSERT INTO are_given VALUES('98765432106', 'ass_01', 'a_01');
  2553. INSERT INTO are_given VALUES('98765432106', 'ass_02', 'a_02');
  2554. INSERT INTO are_given VALUES('98765432106', 'ass_03', 'a_03');
  2555. INSERT INTO are_given VALUES('98765432106', 'ass_04', 'a_04');
  2556. INSERT INTO are_given VALUES('98765432106', 'ass_11', 'b_01');
  2557. INSERT INTO are_given VALUES('98765432106', 'ass_12', 'b_02');
  2558. INSERT INTO are_given VALUES('98765432106', 'ass_13', 'b_03');
  2559. INSERT INTO are_given VALUES('98765432106', 'ass_14', 'b_04');
  2560. INSERT INTO are_given VALUES('98765432106', 'ass_21', 'c_01');
  2561. INSERT INTO are_given VALUES('98765432106', 'ass_22', 'c_02');
  2562. INSERT INTO are_given VALUES('98765432106', 'ass_23', 'c_03');
  2563. INSERT INTO are_given VALUES('98765432106', 'ass_24', 'c_04');
  2564. INSERT INTO are_given VALUES('98765432106', 'ass_31', 'd_01');
  2565. INSERT INTO are_given VALUES('98765432106', 'ass_32', 'd_02');
  2566. INSERT INTO are_given VALUES('98765432106', 'ass_33', 'd_03');
  2567. INSERT INTO are_given VALUES('98765432106', 'ass_34', 'd_04');
  2568. INSERT INTO are_given VALUES('98765432105', 'ass_01', 'a_01');
  2569. INSERT INTO are_given VALUES('98765432105', 'ass_02', 'a_02');
  2570. INSERT INTO are_given VALUES('98765432105', 'ass_03', 'a_03');
  2571. INSERT INTO are_given VALUES('98765432105', 'ass_04', 'a_04');
  2572. INSERT INTO are_given VALUES('98765432105', 'ass_11', 'b_01');
  2573. INSERT INTO are_given VALUES('98765432105', 'ass_12', 'b_02');
  2574. INSERT INTO are_given VALUES('98765432105', 'ass_13', 'b_03');
  2575. INSERT INTO are_given VALUES('98765432105', 'ass_14', 'b_04');
  2576. INSERT INTO are_given VALUES('98765432105', 'ass_21', 'c_01');
  2577. INSERT INTO are_given VALUES('98765432105', 'ass_22', 'c_02');
  2578. INSERT INTO are_given VALUES('98765432105', 'ass_23', 'c_03');
  2579. INSERT INTO are_given VALUES('98765432105', 'ass_24', 'c_04');
  2580. INSERT INTO are_given VALUES('98765432105', 'ass_31', 'd_01');
  2581. INSERT INTO are_given VALUES('98765432105', 'ass_32', 'd_02');
  2582. INSERT INTO are_given VALUES('98765432105', 'ass_33', 'd_03');
  2583. INSERT INTO are_given VALUES('98765432105', 'ass_34', 'd_04');
  2584. INSERT INTO are_given VALUES('98765432104', 'ass_01', 'a_01');
  2585. INSERT INTO are_given VALUES('98765432104', 'ass_02', 'a_02');
  2586. INSERT INTO are_given VALUES('98765432104', 'ass_03', 'a_03');
  2587. INSERT INTO are_given VALUES('98765432104', 'ass_04', 'a_04');
  2588. INSERT INTO are_given VALUES('98765432104', 'ass_11', 'b_01');
  2589. INSERT INTO are_given VALUES('98765432104', 'ass_12', 'b_02');
  2590. INSERT INTO are_given VALUES('98765432104', 'ass_13', 'b_03');
  2591. INSERT INTO are_given VALUES('98765432104', 'ass_14', 'b_04');
  2592. INSERT INTO are_given VALUES('98765432104', 'ass_21', 'c_01');
  2593. INSERT INTO are_given VALUES('98765432104', 'ass_22', 'c_02');
  2594. INSERT INTO are_given VALUES('98765432104', 'ass_23', 'c_03');
  2595. INSERT INTO are_given VALUES('98765432104', 'ass_24', 'c_04');
  2596. INSERT INTO are_given VALUES('98765432104', 'ass_31', 'd_01');
  2597. INSERT INTO are_given VALUES('98765432104', 'ass_32', 'd_02');
  2598. INSERT INTO are_given VALUES('98765432104', 'ass_33', 'd_03');
  2599. INSERT INTO are_given VALUES('98765432104', 'ass_34', 'd_04');
  2600. INSERT INTO are_given VALUES('98765432103', 'ass_01', 'a_01');
  2601. INSERT INTO are_given VALUES('98765432103', 'ass_02', 'a_02');
  2602. INSERT INTO are_given VALUES('98765432103', 'ass_03', 'a_03');
  2603. INSERT INTO are_given VALUES('98765432103', 'ass_04', 'a_04');
  2604. INSERT INTO are_given VALUES('98765432103', 'ass_11', 'b_01');
  2605. INSERT INTO are_given VALUES('98765432103', 'ass_12', 'b_02');
  2606. INSERT INTO are_given VALUES('98765432103', 'ass_13', 'b_03');
  2607. INSERT INTO are_given VALUES('98765432103', 'ass_14', 'b_04');
  2608. INSERT INTO are_given VALUES('98765432103', 'ass_21', 'c_01');
  2609. INSERT INTO are_given VALUES('98765432103', 'ass_22', 'c_02');
  2610. INSERT INTO are_given VALUES('98765432103', 'ass_23', 'c_03');
  2611. INSERT INTO are_given VALUES('98765432103', 'ass_24', 'c_04');
  2612. INSERT INTO are_given VALUES('98765432103', 'ass_31', 'd_01');
  2613. INSERT INTO are_given VALUES('98765432103', 'ass_32', 'd_02');
  2614. INSERT INTO are_given VALUES('98765432103', 'ass_33', 'd_03');
  2615. INSERT INTO are_given VALUES('98765432103', 'ass_34', 'd_04');
  2616. INSERT INTO are_given VALUES('98765432102', 'ass_01', 'a_01');
  2617. INSERT INTO are_given VALUES('98765432102', 'ass_02', 'a_02');
  2618. INSERT INTO are_given VALUES('98765432102', 'ass_03', 'a_03');
  2619. INSERT INTO are_given VALUES('98765432102', 'ass_04', 'a_04');
  2620. INSERT INTO are_given VALUES('98765432102', 'ass_11', 'b_01');
  2621. INSERT INTO are_given VALUES('98765432102', 'ass_12', 'b_02');
  2622. INSERT INTO are_given VALUES('98765432102', 'ass_13', 'b_03');
  2623. INSERT INTO are_given VALUES('98765432102', 'ass_14', 'b_04');
  2624. INSERT INTO are_given VALUES('98765432102', 'ass_21', 'c_01');
  2625. INSERT INTO are_given VALUES('98765432102', 'ass_22', 'c_02');
  2626. INSERT INTO are_given VALUES('98765432102', 'ass_23', 'c_03');
  2627. INSERT INTO are_given VALUES('98765432102', 'ass_24', 'c_04');
  2628. INSERT INTO are_given VALUES('98765432102', 'ass_31', 'd_01');
  2629. INSERT INTO are_given VALUES('98765432102', 'ass_32', 'd_02');
  2630. INSERT INTO are_given VALUES('98765432102', 'ass_33', 'd_03');
  2631. INSERT INTO are_given VALUES('98765432102', 'ass_34', 'd_04');
  2632. INSERT INTO are_given VALUES('98765432101', 'ass_01', 'a_01');
  2633. INSERT INTO are_given VALUES('98765432101', 'ass_02', 'a_02');
  2634. INSERT INTO are_given VALUES('98765432101', 'ass_03', 'a_03');
  2635. INSERT INTO are_given VALUES('98765432101', 'ass_04', 'a_04');
  2636. INSERT INTO are_given VALUES('98765432101', 'ass_11', 'b_01');
  2637. INSERT INTO are_given VALUES('98765432101', 'ass_12', 'b_02');
  2638. INSERT INTO are_given VALUES('98765432101', 'ass_13', 'b_03');
  2639. INSERT INTO are_given VALUES('98765432101', 'ass_14', 'b_04');
  2640. INSERT INTO are_given VALUES('98765432101', 'ass_21', 'c_01');
  2641. INSERT INTO are_given VALUES('98765432101', 'ass_22', 'c_02');
  2642. INSERT INTO are_given VALUES('98765432101', 'ass_23', 'c_03');
  2643. INSERT INTO are_given VALUES('98765432101', 'ass_24', 'c_04');
  2644. INSERT INTO are_given VALUES('98765432101', 'ass_31', 'd_01');
  2645. INSERT INTO are_given VALUES('98765432101', 'ass_32', 'd_02');
  2646. INSERT INTO are_given VALUES('98765432101', 'ass_33', 'd_03');
  2647. INSERT INTO are_given VALUES('98765432101', 'ass_34', 'd_04');
  2648. INSERT INTO are_given VALUES('98765432100', 'ass_01', 'a_01');
  2649. INSERT INTO are_given VALUES('98765432100', 'ass_02', 'a_02');
  2650. INSERT INTO are_given VALUES('98765432100', 'ass_03', 'a_03');
  2651. INSERT INTO are_given VALUES('98765432100', 'ass_04', 'a_04');
  2652. INSERT INTO are_given VALUES('98765432100', 'ass_11', 'b_01');
  2653. INSERT INTO are_given VALUES('98765432100', 'ass_12', 'b_02');
  2654. INSERT INTO are_given VALUES('98765432100', 'ass_13', 'b_03');
  2655. INSERT INTO are_given VALUES('98765432100', 'ass_14', 'b_04');
  2656. INSERT INTO are_given VALUES('98765432100', 'ass_21', 'c_01');
  2657. INSERT INTO are_given VALUES('98765432100', 'ass_22', 'c_02');
  2658. INSERT INTO are_given VALUES('98765432100', 'ass_23', 'c_03');
  2659. INSERT INTO are_given VALUES('98765432100', 'ass_24', 'c_04');
  2660. INSERT INTO are_given VALUES('98765432100', 'ass_31', 'd_01');
  2661. INSERT INTO are_given VALUES('98765432100', 'ass_32', 'd_02');
  2662. INSERT INTO are_given VALUES('98765432100', 'ass_33', 'd_03');
  2663. INSERT INTO are_given VALUES('98765432100', 'ass_34', 'd_04');
  2664. INSERT INTO are_given VALUES('98765432099', 'ass_01', 'a_01');
  2665. INSERT INTO are_given VALUES('98765432099', 'ass_02', 'a_02');
  2666. INSERT INTO are_given VALUES('98765432099', 'ass_03', 'a_03');
  2667. INSERT INTO are_given VALUES('98765432099', 'ass_04', 'a_04');
  2668. INSERT INTO are_given VALUES('98765432099', 'ass_11', 'b_01');
  2669. INSERT INTO are_given VALUES('98765432099', 'ass_12', 'b_02');
  2670. INSERT INTO are_given VALUES('98765432099', 'ass_13', 'b_03');
  2671. INSERT INTO are_given VALUES('98765432099', 'ass_14', 'b_04');
  2672. INSERT INTO are_given VALUES('98765432099', 'ass_21', 'c_01');
  2673. INSERT INTO are_given VALUES('98765432099', 'ass_22', 'c_02');
  2674. INSERT INTO are_given VALUES('98765432099', 'ass_23', 'c_03');
  2675. INSERT INTO are_given VALUES('98765432099', 'ass_24', 'c_04');
  2676. INSERT INTO are_given VALUES('98765432099', 'ass_31', 'd_01');
  2677. INSERT INTO are_given VALUES('98765432099', 'ass_32', 'd_02');
  2678. INSERT INTO are_given VALUES('98765432099', 'ass_33', 'd_03');
  2679. INSERT INTO are_given VALUES('98765432099', 'ass_34', 'd_04');
  2680. INSERT INTO are_given VALUES('98765432098', 'ass_01', 'a_01');
  2681. INSERT INTO are_given VALUES('98765432098', 'ass_02', 'a_02');
  2682. INSERT INTO are_given VALUES('98765432098', 'ass_03', 'a_03');
  2683. INSERT INTO are_given VALUES('98765432098', 'ass_04', 'a_04');
  2684. INSERT INTO are_given VALUES('98765432098', 'ass_11', 'b_01');
  2685. INSERT INTO are_given VALUES('98765432098', 'ass_12', 'b_02');
  2686. INSERT INTO are_given VALUES('98765432098', 'ass_13', 'b_03');
  2687. INSERT INTO are_given VALUES('98765432098', 'ass_14', 'b_04');
  2688. INSERT INTO are_given VALUES('98765432098', 'ass_21', 'c_01');
  2689. INSERT INTO are_given VALUES('98765432098', 'ass_22', 'c_02');
  2690. INSERT INTO are_given VALUES('98765432098', 'ass_23', 'c_03');
  2691. INSERT INTO are_given VALUES('98765432098', 'ass_24', 'c_04');
  2692. INSERT INTO are_given VALUES('98765432098', 'ass_31', 'd_01');
  2693. INSERT INTO are_given VALUES('98765432098', 'ass_32', 'd_02');
  2694. INSERT INTO are_given VALUES('98765432098', 'ass_33', 'd_03');
  2695. INSERT INTO are_given VALUES('98765432098', 'ass_34', 'd_04');
  2696. INSERT INTO are_given VALUES('98765432097', 'ass_01', 'a_01');
  2697. INSERT INTO are_given VALUES('98765432097', 'ass_02', 'a_02');
  2698. INSERT INTO are_given VALUES('98765432097', 'ass_03', 'a_03');
  2699. INSERT INTO are_given VALUES('98765432097', 'ass_04', 'a_04');
  2700. INSERT INTO are_given VALUES('98765432097', 'ass_11', 'b_01');
  2701. INSERT INTO are_given VALUES('98765432097', 'ass_12', 'b_02');
  2702. INSERT INTO are_given VALUES('98765432097', 'ass_13', 'b_03');
  2703. INSERT INTO are_given VALUES('98765432097', 'ass_14', 'b_04');
  2704. INSERT INTO are_given VALUES('98765432097', 'ass_21', 'c_01');
  2705. INSERT INTO are_given VALUES('98765432097', 'ass_22', 'c_02');
  2706. INSERT INTO are_given VALUES('98765432097', 'ass_23', 'c_03');
  2707. INSERT INTO are_given VALUES('98765432097', 'ass_24', 'c_04');
  2708. INSERT INTO are_given VALUES('98765432097', 'ass_31', 'd_01');
  2709. INSERT INTO are_given VALUES('98765432097', 'ass_32', 'd_02');
  2710. INSERT INTO are_given VALUES('98765432097', 'ass_33', 'd_03');
  2711. INSERT INTO are_given VALUES('98765432097', 'ass_34', 'd_04');
  2712. INSERT INTO are_given VALUES('98765432096', 'ass_01', 'a_01');
  2713. INSERT INTO are_given VALUES('98765432096', 'ass_02', 'a_02');
  2714. INSERT INTO are_given VALUES('98765432096', 'ass_03', 'a_03');
  2715. INSERT INTO are_given VALUES('98765432096', 'ass_04', 'a_04');
  2716. INSERT INTO are_given VALUES('98765432096', 'ass_11', 'b_01');
  2717. INSERT INTO are_given VALUES('98765432096', 'ass_12', 'b_02');
  2718. INSERT INTO are_given VALUES('98765432096', 'ass_13', 'b_03');
  2719. INSERT INTO are_given VALUES('98765432096', 'ass_14', 'b_04');
  2720. INSERT INTO are_given VALUES('98765432096', 'ass_21', 'c_01');
  2721. INSERT INTO are_given VALUES('98765432096', 'ass_22', 'c_02');
  2722. INSERT INTO are_given VALUES('98765432096', 'ass_23', 'c_03');
  2723. INSERT INTO are_given VALUES('98765432096', 'ass_24', 'c_04');
  2724. INSERT INTO are_given VALUES('98765432096', 'ass_31', 'd_01');
  2725. INSERT INTO are_given VALUES('98765432096', 'ass_32', 'd_02');
  2726. INSERT INTO are_given VALUES('98765432096', 'ass_33', 'd_03');
  2727. INSERT INTO are_given VALUES('98765432096', 'ass_34', 'd_04');
  2728. INSERT INTO are_given VALUES('98765432095', 'ass_01', 'a_01');
  2729. INSERT INTO are_given VALUES('98765432095', 'ass_02', 'a_02');
  2730. INSERT INTO are_given VALUES('98765432095', 'ass_03', 'a_03');
  2731. INSERT INTO are_given VALUES('98765432095', 'ass_04', 'a_04');
  2732. INSERT INTO are_given VALUES('98765432095', 'ass_11', 'b_01');
  2733. INSERT INTO are_given VALUES('98765432095', 'ass_12', 'b_02');
  2734. INSERT INTO are_given VALUES('98765432095', 'ass_13', 'b_03');
  2735. INSERT INTO are_given VALUES('98765432095', 'ass_14', 'b_04');
  2736. INSERT INTO are_given VALUES('98765432095', 'ass_21', 'c_01');
  2737. INSERT INTO are_given VALUES('98765432095', 'ass_22', 'c_02');
  2738. INSERT INTO are_given VALUES('98765432095', 'ass_23', 'c_03');
  2739. INSERT INTO are_given VALUES('98765432095', 'ass_24', 'c_04');
  2740. INSERT INTO are_given VALUES('98765432095', 'ass_31', 'd_01');
  2741. INSERT INTO are_given VALUES('98765432095', 'ass_32', 'd_02');
  2742. INSERT INTO are_given VALUES('98765432095', 'ass_33', 'd_03');
  2743. INSERT INTO are_given VALUES('98765432095', 'ass_34', 'd_04');
  2744. INSERT INTO are_given VALUES('98765432094', 'ass_01', 'a_01');
  2745. INSERT INTO are_given VALUES('98765432094', 'ass_02', 'a_02');
  2746. INSERT INTO are_given VALUES('98765432094', 'ass_03', 'a_03');
  2747. INSERT INTO are_given VALUES('98765432094', 'ass_04', 'a_04');
  2748. INSERT INTO are_given VALUES('98765432094', 'ass_11', 'b_01');
  2749. INSERT INTO are_given VALUES('98765432094', 'ass_12', 'b_02');
  2750. INSERT INTO are_given VALUES('98765432094', 'ass_13', 'b_03');
  2751. INSERT INTO are_given VALUES('98765432094', 'ass_14', 'b_04');
  2752. INSERT INTO are_given VALUES('98765432094', 'ass_21', 'c_01');
  2753. INSERT INTO are_given VALUES('98765432094', 'ass_22', 'c_02');
  2754. INSERT INTO are_given VALUES('98765432094', 'ass_23', 'c_03');
  2755. INSERT INTO are_given VALUES('98765432094', 'ass_24', 'c_04');
  2756. INSERT INTO are_given VALUES('98765432094', 'ass_31', 'd_01');
  2757. INSERT INTO are_given VALUES('98765432094', 'ass_32', 'd_02');
  2758. INSERT INTO are_given VALUES('98765432094', 'ass_33', 'd_03');
  2759. INSERT INTO are_given VALUES('98765432094', 'ass_34', 'd_04');
  2760. INSERT INTO are_given VALUES('98765432093', 'ass_01', 'a_01');
  2761. INSERT INTO are_given VALUES('98765432093', 'ass_02', 'a_02');
  2762. INSERT INTO are_given VALUES('98765432093', 'ass_03', 'a_03');
  2763. INSERT INTO are_given VALUES('98765432093', 'ass_04', 'a_04');
  2764. INSERT INTO are_given VALUES('98765432093', 'ass_11', 'b_01');
  2765. INSERT INTO are_given VALUES('98765432093', 'ass_12', 'b_02');
  2766. INSERT INTO are_given VALUES('98765432093', 'ass_13', 'b_03');
  2767. INSERT INTO are_given VALUES('98765432093', 'ass_14', 'b_04');
  2768. INSERT INTO are_given VALUES('98765432093', 'ass_21', 'c_01');
  2769. INSERT INTO are_given VALUES('98765432093', 'ass_22', 'c_02');
  2770. INSERT INTO are_given VALUES('98765432093', 'ass_23', 'c_03');
  2771. INSERT INTO are_given VALUES('98765432093', 'ass_24', 'c_04');
  2772. INSERT INTO are_given VALUES('98765432093', 'ass_31', 'd_01');
  2773. INSERT INTO are_given VALUES('98765432093', 'ass_32', 'd_02');
  2774. INSERT INTO are_given VALUES('98765432093', 'ass_33', 'd_03');
  2775. INSERT INTO are_given VALUES('98765432093', 'ass_34', 'd_04');
  2776. INSERT INTO are_given VALUES('98765432092', 'ass_01', 'a_01');
  2777. INSERT INTO are_given VALUES('98765432092', 'ass_02', 'a_02');
  2778. INSERT INTO are_given VALUES('98765432092', 'ass_03', 'a_03');
  2779. INSERT INTO are_given VALUES('98765432092', 'ass_04', 'a_04');
  2780. INSERT INTO are_given VALUES('98765432092', 'ass_11', 'b_01');
  2781. INSERT INTO are_given VALUES('98765432092', 'ass_12', 'b_02');
  2782. INSERT INTO are_given VALUES('98765432092', 'ass_13', 'b_03');
  2783. INSERT INTO are_given VALUES('98765432092', 'ass_14', 'b_04');
  2784. INSERT INTO are_given VALUES('98765432092', 'ass_21', 'c_01');
  2785. INSERT INTO are_given VALUES('98765432092', 'ass_22', 'c_02');
  2786. INSERT INTO are_given VALUES('98765432092', 'ass_23', 'c_03');
  2787. INSERT INTO are_given VALUES('98765432092', 'ass_24', 'c_04');
  2788. INSERT INTO are_given VALUES('98765432092', 'ass_31', 'd_01');
  2789. INSERT INTO are_given VALUES('98765432092', 'ass_32', 'd_02');
  2790. INSERT INTO are_given VALUES('98765432092', 'ass_33', 'd_03');
  2791. INSERT INTO are_given VALUES('98765432092', 'ass_34', 'd_04');
  2792. INSERT INTO are_given VALUES('98765432091', 'ass_01', 'a_01');
  2793. INSERT INTO are_given VALUES('98765432091', 'ass_02', 'a_02');
  2794. INSERT INTO are_given VALUES('98765432091', 'ass_03', 'a_03');
  2795. INSERT INTO are_given VALUES('98765432091', 'ass_04', 'a_04');
  2796. INSERT INTO are_given VALUES('98765432091', 'ass_11', 'b_01');
  2797. INSERT INTO are_given VALUES('98765432091', 'ass_12', 'b_02');
  2798. INSERT INTO are_given VALUES('98765432091', 'ass_13', 'b_03');
  2799. INSERT INTO are_given VALUES('98765432091', 'ass_14', 'b_04');
  2800. INSERT INTO are_given VALUES('98765432091', 'ass_21', 'c_01');
  2801. INSERT INTO are_given VALUES('98765432091', 'ass_22', 'c_02');
  2802. INSERT INTO are_given VALUES('98765432091', 'ass_23', 'c_03');
  2803. INSERT INTO are_given VALUES('98765432091', 'ass_24', 'c_04');
  2804. INSERT INTO are_given VALUES('98765432091', 'ass_31', 'd_01');
  2805. INSERT INTO are_given VALUES('98765432091', 'ass_32', 'd_02');
  2806. INSERT INTO are_given VALUES('98765432091', 'ass_33', 'd_03');
  2807. INSERT INTO are_given VALUES('98765432091', 'ass_34', 'd_04');
  2808. INSERT INTO are_given VALUES('98765432090', 'ass_01', 'a_01');
  2809. INSERT INTO are_given VALUES('98765432090', 'ass_02', 'a_02');
  2810. INSERT INTO are_given VALUES('98765432090', 'ass_03', 'a_03');
  2811. INSERT INTO are_given VALUES('98765432090', 'ass_04', 'a_04');
  2812. INSERT INTO are_given VALUES('98765432090', 'ass_11', 'b_01');
  2813. INSERT INTO are_given VALUES('98765432090', 'ass_12', 'b_02');
  2814. INSERT INTO are_given VALUES('98765432090', 'ass_13', 'b_03');
  2815. INSERT INTO are_given VALUES('98765432090', 'ass_14', 'b_04');
  2816. INSERT INTO are_given VALUES('98765432090', 'ass_21', 'c_01');
  2817. INSERT INTO are_given VALUES('98765432090', 'ass_22', 'c_02');
  2818. INSERT INTO are_given VALUES('98765432090', 'ass_23', 'c_03');
  2819. INSERT INTO are_given VALUES('98765432090', 'ass_24', 'c_04');
  2820. INSERT INTO are_given VALUES('98765432090', 'ass_31', 'd_01');
  2821. INSERT INTO are_given VALUES('98765432090', 'ass_32', 'd_02');
  2822. INSERT INTO are_given VALUES('98765432090', 'ass_33', 'd_03');
  2823. INSERT INTO are_given VALUES('98765432090', 'ass_34', 'd_04');
  2824. INSERT INTO are_given VALUES('98765432089', 'ass_01', 'a_01');
  2825. INSERT INTO are_given VALUES('98765432089', 'ass_02', 'a_02');
  2826. INSERT INTO are_given VALUES('98765432089', 'ass_03', 'a_03');
  2827. INSERT INTO are_given VALUES('98765432089', 'ass_04', 'a_04');
  2828. INSERT INTO are_given VALUES('98765432089', 'ass_11', 'b_01');
  2829. INSERT INTO are_given VALUES('98765432089', 'ass_12', 'b_02');
  2830. INSERT INTO are_given VALUES('98765432089', 'ass_13', 'b_03');
  2831. INSERT INTO are_given VALUES('98765432089', 'ass_14', 'b_04');
  2832. INSERT INTO are_given VALUES('98765432089', 'ass_21', 'c_01');
  2833. INSERT INTO are_given VALUES('98765432089', 'ass_22', 'c_02');
  2834. INSERT INTO are_given VALUES('98765432089', 'ass_23', 'c_03');
  2835. INSERT INTO are_given VALUES('98765432089', 'ass_24', 'c_04');
  2836. INSERT INTO are_given VALUES('98765432089', 'ass_31', 'd_01');
  2837. INSERT INTO are_given VALUES('98765432089', 'ass_32', 'd_02');
  2838. INSERT INTO are_given VALUES('98765432089', 'ass_33', 'd_03');
  2839. INSERT INTO are_given VALUES('98765432089', 'ass_34', 'd_04');
  2840. INSERT INTO are_given VALUES('98765432088', 'ass_01', 'a_01');
  2841. INSERT INTO are_given VALUES('98765432088', 'ass_02', 'a_02');
  2842. INSERT INTO are_given VALUES('98765432088', 'ass_03', 'a_03');
  2843. INSERT INTO are_given VALUES('98765432088', 'ass_04', 'a_04');
  2844. INSERT INTO are_given VALUES('98765432088', 'ass_11', 'b_01');
  2845. INSERT INTO are_given VALUES('98765432088', 'ass_12', 'b_02');
  2846. INSERT INTO are_given VALUES('98765432088', 'ass_13', 'b_03');
  2847. INSERT INTO are_given VALUES('98765432088', 'ass_14', 'b_04');
  2848. INSERT INTO are_given VALUES('98765432088', 'ass_21', 'c_01');
  2849. INSERT INTO are_given VALUES('98765432088', 'ass_22', 'c_02');
  2850. INSERT INTO are_given VALUES('98765432088', 'ass_23', 'c_03');
  2851. INSERT INTO are_given VALUES('98765432088', 'ass_24', 'c_04');
  2852. INSERT INTO are_given VALUES('98765432088', 'ass_31', 'd_01');
  2853. INSERT INTO are_given VALUES('98765432088', 'ass_32', 'd_02');
  2854. INSERT INTO are_given VALUES('98765432088', 'ass_33', 'd_03');
  2855. INSERT INTO are_given VALUES('98765432088', 'ass_34', 'd_04');
  2856. INSERT INTO are_given VALUES('98765432087', 'ass_01', 'a_01');
  2857. INSERT INTO are_given VALUES('98765432087', 'ass_02', 'a_02');
  2858. INSERT INTO are_given VALUES('98765432087', 'ass_03', 'a_03');
  2859. INSERT INTO are_given VALUES('98765432087', 'ass_04', 'a_04');
  2860. INSERT INTO are_given VALUES('98765432087', 'ass_11', 'b_01');
  2861. INSERT INTO are_given VALUES('98765432087', 'ass_12', 'b_02');
  2862. INSERT INTO are_given VALUES('98765432087', 'ass_13', 'b_03');
  2863. INSERT INTO are_given VALUES('98765432087', 'ass_14', 'b_04');
  2864. INSERT INTO are_given VALUES('98765432087', 'ass_21', 'c_01');
  2865. INSERT INTO are_given VALUES('98765432087', 'ass_22', 'c_02');
  2866. INSERT INTO are_given VALUES('98765432087', 'ass_23', 'c_03');
  2867. INSERT INTO are_given VALUES('98765432087', 'ass_24', 'c_04');
  2868. INSERT INTO are_given VALUES('98765432087', 'ass_31', 'd_01');
  2869. INSERT INTO are_given VALUES('98765432087', 'ass_32', 'd_02');
  2870. INSERT INTO are_given VALUES('98765432087', 'ass_33', 'd_03');
  2871. INSERT INTO are_given VALUES('98765432087', 'ass_34', 'd_04');
  2872. INSERT INTO are_given VALUES('98765432086', 'ass_01', 'a_01');
  2873. INSERT INTO are_given VALUES('98765432086', 'ass_02', 'a_02');
  2874. INSERT INTO are_given VALUES('98765432086', 'ass_03', 'a_03');
  2875. INSERT INTO are_given VALUES('98765432086', 'ass_04', 'a_04');
  2876. INSERT INTO are_given VALUES('98765432086', 'ass_11', 'b_01');
  2877. INSERT INTO are_given VALUES('98765432086', 'ass_12', 'b_02');
  2878. INSERT INTO are_given VALUES('98765432086', 'ass_13', 'b_03');
  2879. INSERT INTO are_given VALUES('98765432086', 'ass_14', 'b_04');
  2880. INSERT INTO are_given VALUES('98765432086', 'ass_21', 'c_01');
  2881. INSERT INTO are_given VALUES('98765432086', 'ass_22', 'c_02');
  2882. INSERT INTO are_given VALUES('98765432086', 'ass_23', 'c_03');
  2883. INSERT INTO are_given VALUES('98765432086', 'ass_24', 'c_04');
  2884. INSERT INTO are_given VALUES('98765432086', 'ass_31', 'd_01');
  2885. INSERT INTO are_given VALUES('98765432086', 'ass_32', 'd_02');
  2886. INSERT INTO are_given VALUES('98765432086', 'ass_33', 'd_03');
  2887. INSERT INTO are_given VALUES('98765432086', 'ass_34', 'd_04');
  2888. INSERT INTO are_given VALUES('98765432085', 'ass_01', 'a_01');
  2889. INSERT INTO are_given VALUES('98765432085', 'ass_02', 'a_02');
  2890. INSERT INTO are_given VALUES('98765432085', 'ass_03', 'a_03');
  2891. INSERT INTO are_given VALUES('98765432085', 'ass_04', 'a_04');
  2892. INSERT INTO are_given VALUES('98765432085', 'ass_11', 'b_01');
  2893. INSERT INTO are_given VALUES('98765432085', 'ass_12', 'b_02');
  2894. INSERT INTO are_given VALUES('98765432085', 'ass_13', 'b_03');
  2895. INSERT INTO are_given VALUES('98765432085', 'ass_14', 'b_04');
  2896. INSERT INTO are_given VALUES('98765432085', 'ass_21', 'c_01');
  2897. INSERT INTO are_given VALUES('98765432085', 'ass_22', 'c_02');
  2898. INSERT INTO are_given VALUES('98765432085', 'ass_23', 'c_03');
  2899. INSERT INTO are_given VALUES('98765432085', 'ass_24', 'c_04');
  2900. INSERT INTO are_given VALUES('98765432085', 'ass_31', 'd_01');
  2901. INSERT INTO are_given VALUES('98765432085', 'ass_32', 'd_02');
  2902. INSERT INTO are_given VALUES('98765432085', 'ass_33', 'd_03');
  2903. INSERT INTO are_given VALUES('98765432085', 'ass_34', 'd_04');
  2904. INSERT INTO are_given VALUES('98765432084', 'ass_01', 'a_01');
  2905. INSERT INTO are_given VALUES('98765432084', 'ass_02', 'a_02');
  2906. INSERT INTO are_given VALUES('98765432084', 'ass_03', 'a_03');
  2907. INSERT INTO are_given VALUES('98765432084', 'ass_04', 'a_04');
  2908. INSERT INTO are_given VALUES('98765432084', 'ass_11', 'b_01');
  2909. INSERT INTO are_given VALUES('98765432084', 'ass_12', 'b_02');
  2910. INSERT INTO are_given VALUES('98765432084', 'ass_13', 'b_03');
  2911. INSERT INTO are_given VALUES('98765432084', 'ass_14', 'b_04');
  2912. INSERT INTO are_given VALUES('98765432084', 'ass_21', 'c_01');
  2913. INSERT INTO are_given VALUES('98765432084', 'ass_22', 'c_02');
  2914. INSERT INTO are_given VALUES('98765432084', 'ass_23', 'c_03');
  2915. INSERT INTO are_given VALUES('98765432084', 'ass_24', 'c_04');
  2916. INSERT INTO are_given VALUES('98765432084', 'ass_31', 'd_01');
  2917. INSERT INTO are_given VALUES('98765432084', 'ass_32', 'd_02');
  2918. INSERT INTO are_given VALUES('98765432084', 'ass_33', 'd_03');
  2919. INSERT INTO are_given VALUES('98765432084', 'ass_34', 'd_04');
  2920. INSERT INTO are_given VALUES('98765432083', 'ass_01', 'a_01');
  2921. INSERT INTO are_given VALUES('98765432083', 'ass_02', 'a_02');
  2922. INSERT INTO are_given VALUES('98765432083', 'ass_03', 'a_03');
  2923. INSERT INTO are_given VALUES('98765432083', 'ass_04', 'a_04');
  2924. INSERT INTO are_given VALUES('98765432083', 'ass_11', 'b_01');
  2925. INSERT INTO are_given VALUES('98765432083', 'ass_12', 'b_02');
  2926. INSERT INTO are_given VALUES('98765432083', 'ass_13', 'b_03');
  2927. INSERT INTO are_given VALUES('98765432083', 'ass_14', 'b_04');
  2928. INSERT INTO are_given VALUES('98765432083', 'ass_21', 'c_01');
  2929. INSERT INTO are_given VALUES('98765432083', 'ass_22', 'c_02');
  2930. INSERT INTO are_given VALUES('98765432083', 'ass_23', 'c_03');
  2931. INSERT INTO are_given VALUES('98765432083', 'ass_24', 'c_04');
  2932. INSERT INTO are_given VALUES('98765432083', 'ass_31', 'd_01');
  2933. INSERT INTO are_given VALUES('98765432083', 'ass_32', 'd_02');
  2934. INSERT INTO are_given VALUES('98765432083', 'ass_33', 'd_03');
  2935. INSERT INTO are_given VALUES('98765432083', 'ass_34', 'd_04');
  2936. INSERT INTO are_given VALUES('98765432082', 'ass_01', 'a_01');
  2937. INSERT INTO are_given VALUES('98765432082', 'ass_02', 'a_02');
  2938. INSERT INTO are_given VALUES('98765432082', 'ass_03', 'a_03');
  2939. INSERT INTO are_given VALUES('98765432082', 'ass_04', 'a_04');
  2940. INSERT INTO are_given VALUES('98765432082', 'ass_11', 'b_01');
  2941. INSERT INTO are_given VALUES('98765432082', 'ass_12', 'b_02');
  2942. INSERT INTO are_given VALUES('98765432082', 'ass_13', 'b_03');
  2943. INSERT INTO are_given VALUES('98765432082', 'ass_14', 'b_04');
  2944. INSERT INTO are_given VALUES('98765432082', 'ass_21', 'c_01');
  2945. INSERT INTO are_given VALUES('98765432082', 'ass_22', 'c_02');
  2946. INSERT INTO are_given VALUES('98765432082', 'ass_23', 'c_03');
  2947. INSERT INTO are_given VALUES('98765432082', 'ass_24', 'c_04');
  2948. INSERT INTO are_given VALUES('98765432082', 'ass_31', 'd_01');
  2949. INSERT INTO are_given VALUES('98765432082', 'ass_32', 'd_02');
  2950. INSERT INTO are_given VALUES('98765432082', 'ass_33', 'd_03');
  2951. INSERT INTO are_given VALUES('98765432082', 'ass_34', 'd_04');
  2952. INSERT INTO are_given VALUES('98765432081', 'ass_01', 'a_01');
  2953. INSERT INTO are_given VALUES('98765432081', 'ass_02', 'a_02');
  2954. INSERT INTO are_given VALUES('98765432081', 'ass_03', 'a_03');
  2955. INSERT INTO are_given VALUES('98765432081', 'ass_04', 'a_04');
  2956. INSERT INTO are_given VALUES('98765432081', 'ass_11', 'b_01');
  2957. INSERT INTO are_given VALUES('98765432081', 'ass_12', 'b_02');
  2958. INSERT INTO are_given VALUES('98765432081', 'ass_13', 'b_03');
  2959. INSERT INTO are_given VALUES('98765432081', 'ass_14', 'b_04');
  2960. INSERT INTO are_given VALUES('98765432081', 'ass_21', 'c_01');
  2961. INSERT INTO are_given VALUES('98765432081', 'ass_22', 'c_02');
  2962. INSERT INTO are_given VALUES('98765432081', 'ass_23', 'c_03');
  2963. INSERT INTO are_given VALUES('98765432081', 'ass_24', 'c_04');
  2964. INSERT INTO are_given VALUES('98765432081', 'ass_31', 'd_01');
  2965. INSERT INTO are_given VALUES('98765432081', 'ass_32', 'd_02');
  2966. INSERT INTO are_given VALUES('98765432081', 'ass_33', 'd_03');
  2967. INSERT INTO are_given VALUES('98765432081', 'ass_34', 'd_04');
  2968. INSERT INTO are_given VALUES('98765432080', 'ass_01', 'a_01');
  2969. INSERT INTO are_given VALUES('98765432080', 'ass_02', 'a_02');
  2970. INSERT INTO are_given VALUES('98765432080', 'ass_03', 'a_03');
  2971. INSERT INTO are_given VALUES('98765432080', 'ass_04', 'a_04');
  2972. INSERT INTO are_given VALUES('98765432080', 'ass_11', 'b_01');
  2973. INSERT INTO are_given VALUES('98765432080', 'ass_12', 'b_02');
  2974. INSERT INTO are_given VALUES('98765432080', 'ass_13', 'b_03');
  2975. INSERT INTO are_given VALUES('98765432080', 'ass_14', 'b_04');
  2976. INSERT INTO are_given VALUES('98765432080', 'ass_21', 'c_01');
  2977. INSERT INTO are_given VALUES('98765432080', 'ass_22', 'c_02');
  2978. INSERT INTO are_given VALUES('98765432080', 'ass_23', 'c_03');
  2979. INSERT INTO are_given VALUES('98765432080', 'ass_24', 'c_04');
  2980. INSERT INTO are_given VALUES('98765432080', 'ass_31', 'd_01');
  2981. INSERT INTO are_given VALUES('98765432080', 'ass_32', 'd_02');
  2982. INSERT INTO are_given VALUES('98765432080', 'ass_33', 'd_03');
  2983. INSERT INTO are_given VALUES('98765432080', 'ass_34', 'd_04');
  2984. INSERT INTO are_given VALUES('98765432079', 'ass_01', 'a_01');
  2985. INSERT INTO are_given VALUES('98765432079', 'ass_02', 'a_02');
  2986. INSERT INTO are_given VALUES('98765432079', 'ass_03', 'a_03');
  2987. INSERT INTO are_given VALUES('98765432079', 'ass_04', 'a_04');
  2988. INSERT INTO are_given VALUES('98765432079', 'ass_11', 'b_01');
  2989. INSERT INTO are_given VALUES('98765432079', 'ass_12', 'b_02');
  2990. INSERT INTO are_given VALUES('98765432079', 'ass_13', 'b_03');
  2991. INSERT INTO are_given VALUES('98765432079', 'ass_14', 'b_04');
  2992. INSERT INTO are_given VALUES('98765432079', 'ass_21', 'c_01');
  2993. INSERT INTO are_given VALUES('98765432079', 'ass_22', 'c_02');
  2994. INSERT INTO are_given VALUES('98765432079', 'ass_23', 'c_03');
  2995. INSERT INTO are_given VALUES('98765432079', 'ass_24', 'c_04');
  2996. INSERT INTO are_given VALUES('98765432079', 'ass_31', 'd_01');
  2997. INSERT INTO are_given VALUES('98765432079', 'ass_32', 'd_02');
  2998. INSERT INTO are_given VALUES('98765432079', 'ass_33', 'd_03');
  2999. INSERT INTO are_given VALUES('98765432079', 'ass_34', 'd_04');
  3000. INSERT INTO are_given VALUES('98765432078', 'ass_01', 'a_01');
  3001. INSERT INTO are_given VALUES('98765432078', 'ass_02', 'a_02');
  3002. INSERT INTO are_given VALUES('98765432078', 'ass_03', 'a_03');
  3003. INSERT INTO are_given VALUES('98765432078', 'ass_04', 'a_04');
  3004. INSERT INTO are_given VALUES('98765432078', 'ass_11', 'b_01');
  3005. INSERT INTO are_given VALUES('98765432078', 'ass_12', 'b_02');
  3006. INSERT INTO are_given VALUES('98765432078', 'ass_13', 'b_03');
  3007. INSERT INTO are_given VALUES('98765432078', 'ass_14', 'b_04');
  3008. INSERT INTO are_given VALUES('98765432078', 'ass_21', 'c_01');
  3009. INSERT INTO are_given VALUES('98765432078', 'ass_22', 'c_02');
  3010. INSERT INTO are_given VALUES('98765432078', 'ass_23', 'c_03');
  3011. INSERT INTO are_given VALUES('98765432078', 'ass_24', 'c_04');
  3012. INSERT INTO are_given VALUES('98765432078', 'ass_31', 'd_01');
  3013. INSERT INTO are_given VALUES('98765432078', 'ass_32', 'd_02');
  3014. INSERT INTO are_given VALUES('98765432078', 'ass_33', 'd_03');
  3015. INSERT INTO are_given VALUES('98765432078', 'ass_34', 'd_04');
  3016. INSERT INTO are_given VALUES('98765432077', 'ass_01', 'a_01');
  3017. INSERT INTO are_given VALUES('98765432077', 'ass_02', 'a_02');
  3018. INSERT INTO are_given VALUES('98765432077', 'ass_03', 'a_03');
  3019. INSERT INTO are_given VALUES('98765432077', 'ass_04', 'a_04');
  3020. INSERT INTO are_given VALUES('98765432077', 'ass_11', 'b_01');
  3021. INSERT INTO are_given VALUES('98765432077', 'ass_12', 'b_02');
  3022. INSERT INTO are_given VALUES('98765432077', 'ass_13', 'b_03');
  3023. INSERT INTO are_given VALUES('98765432077', 'ass_14', 'b_04');
  3024. INSERT INTO are_given VALUES('98765432077', 'ass_21', 'c_01');
  3025. INSERT INTO are_given VALUES('98765432077', 'ass_22', 'c_02');
  3026. INSERT INTO are_given VALUES('98765432077', 'ass_23', 'c_03');
  3027. INSERT INTO are_given VALUES('98765432077', 'ass_24', 'c_04');
  3028. INSERT INTO are_given VALUES('98765432077', 'ass_31', 'd_01');
  3029. INSERT INTO are_given VALUES('98765432077', 'ass_32', 'd_02');
  3030. INSERT INTO are_given VALUES('98765432077', 'ass_33', 'd_03');
  3031. INSERT INTO are_given VALUES('98765432077', 'ass_34', 'd_04');
  3032. INSERT INTO are_given VALUES('98765432076', 'ass_01', 'a_01');
  3033. INSERT INTO are_given VALUES('98765432076', 'ass_02', 'a_02');
  3034. INSERT INTO are_given VALUES('98765432076', 'ass_03', 'a_03');
  3035. INSERT INTO are_given VALUES('98765432076', 'ass_04', 'a_04');
  3036. INSERT INTO are_given VALUES('98765432076', 'ass_11', 'b_01');
  3037. INSERT INTO are_given VALUES('98765432076', 'ass_12', 'b_02');
  3038. INSERT INTO are_given VALUES('98765432076', 'ass_13', 'b_03');
  3039. INSERT INTO are_given VALUES('98765432076', 'ass_14', 'b_04');
  3040. INSERT INTO are_given VALUES('98765432076', 'ass_21', 'c_01');
  3041. INSERT INTO are_given VALUES('98765432076', 'ass_22', 'c_02');
  3042. INSERT INTO are_given VALUES('98765432076', 'ass_23', 'c_03');
  3043. INSERT INTO are_given VALUES('98765432076', 'ass_24', 'c_04');
  3044. INSERT INTO are_given VALUES('98765432076', 'ass_31', 'd_01');
  3045. INSERT INTO are_given VALUES('98765432076', 'ass_32', 'd_02');
  3046. INSERT INTO are_given VALUES('98765432076', 'ass_33', 'd_03');
  3047. INSERT INTO are_given VALUES('98765432076', 'ass_34', 'd_04');
  3048. INSERT INTO are_given VALUES('98765432075', 'ass_01', 'a_01');
  3049. INSERT INTO are_given VALUES('98765432075', 'ass_02', 'a_02');
  3050. INSERT INTO are_given VALUES('98765432075', 'ass_03', 'a_03');
  3051. INSERT INTO are_given VALUES('98765432075', 'ass_04', 'a_04');
  3052. INSERT INTO are_given VALUES('98765432075', 'ass_11', 'b_01');
  3053. INSERT INTO are_given VALUES('98765432075', 'ass_12', 'b_02');
  3054. INSERT INTO are_given VALUES('98765432075', 'ass_13', 'b_03');
  3055. INSERT INTO are_given VALUES('98765432075', 'ass_14', 'b_04');
  3056. INSERT INTO are_given VALUES('98765432075', 'ass_21', 'c_01');
  3057. INSERT INTO are_given VALUES('98765432075', 'ass_22', 'c_02');
  3058. INSERT INTO are_given VALUES('98765432075', 'ass_23', 'c_03');
  3059. INSERT INTO are_given VALUES('98765432075', 'ass_24', 'c_04');
  3060. INSERT INTO are_given VALUES('98765432075', 'ass_31', 'd_01');
  3061. INSERT INTO are_given VALUES('98765432075', 'ass_32', 'd_02');
  3062. INSERT INTO are_given VALUES('98765432075', 'ass_33', 'd_03');
  3063. INSERT INTO are_given VALUES('98765432075', 'ass_34', 'd_04');
  3064. INSERT INTO are_given VALUES('98765432074', 'ass_01', 'a_01');
  3065. INSERT INTO are_given VALUES('98765432074', 'ass_02', 'a_02');
  3066. INSERT INTO are_given VALUES('98765432074', 'ass_03', 'a_03');
  3067. INSERT INTO are_given VALUES('98765432074', 'ass_04', 'a_04');
  3068. INSERT INTO are_given VALUES('98765432074', 'ass_11', 'b_01');
  3069. INSERT INTO are_given VALUES('98765432074', 'ass_12', 'b_02');
  3070. INSERT INTO are_given VALUES('98765432074', 'ass_13', 'b_03');
  3071. INSERT INTO are_given VALUES('98765432074', 'ass_14', 'b_04');
  3072. INSERT INTO are_given VALUES('98765432074', 'ass_21', 'c_01');
  3073. INSERT INTO are_given VALUES('98765432074', 'ass_22', 'c_02');
  3074. INSERT INTO are_given VALUES('98765432074', 'ass_23', 'c_03');
  3075. INSERT INTO are_given VALUES('98765432074', 'ass_24', 'c_04');
  3076. INSERT INTO are_given VALUES('98765432074', 'ass_31', 'd_01');
  3077. INSERT INTO are_given VALUES('98765432074', 'ass_32', 'd_02');
  3078. INSERT INTO are_given VALUES('98765432074', 'ass_33', 'd_03');
  3079. INSERT INTO are_given VALUES('98765432074', 'ass_34', 'd_04');
  3080. INSERT INTO are_given VALUES('98765432073', 'ass_01', 'a_01');
  3081. INSERT INTO are_given VALUES('98765432073', 'ass_02', 'a_02');
  3082. INSERT INTO are_given VALUES('98765432073', 'ass_03', 'a_03');
  3083. INSERT INTO are_given VALUES('98765432073', 'ass_04', 'a_04');
  3084. INSERT INTO are_given VALUES('98765432073', 'ass_11', 'b_01');
  3085. INSERT INTO are_given VALUES('98765432073', 'ass_12', 'b_02');
  3086. INSERT INTO are_given VALUES('98765432073', 'ass_13', 'b_03');
  3087. INSERT INTO are_given VALUES('98765432073', 'ass_14', 'b_04');
  3088. INSERT INTO are_given VALUES('98765432073', 'ass_21', 'c_01');
  3089. INSERT INTO are_given VALUES('98765432073', 'ass_22', 'c_02');
  3090. INSERT INTO are_given VALUES('98765432073', 'ass_23', 'c_03');
  3091. INSERT INTO are_given VALUES('98765432073', 'ass_24', 'c_04');
  3092. INSERT INTO are_given VALUES('98765432073', 'ass_31', 'd_01');
  3093. INSERT INTO are_given VALUES('98765432073', 'ass_32', 'd_02');
  3094. INSERT INTO are_given VALUES('98765432073', 'ass_33', 'd_03');
  3095. INSERT INTO are_given VALUES('98765432073', 'ass_34', 'd_04');
  3096. INSERT INTO are_given VALUES('98765432072', 'ass_01', 'a_01');
  3097. INSERT INTO are_given VALUES('98765432072', 'ass_02', 'a_02');
  3098. INSERT INTO are_given VALUES('98765432072', 'ass_03', 'a_03');
  3099. INSERT INTO are_given VALUES('98765432072', 'ass_04', 'a_04');
  3100. INSERT INTO are_given VALUES('98765432072', 'ass_11', 'b_01');
  3101. INSERT INTO are_given VALUES('98765432072', 'ass_12', 'b_02');
  3102. INSERT INTO are_given VALUES('98765432072', 'ass_13', 'b_03');
  3103. INSERT INTO are_given VALUES('98765432072', 'ass_14', 'b_04');
  3104. INSERT INTO are_given VALUES('98765432072', 'ass_21', 'c_01');
  3105. INSERT INTO are_given VALUES('98765432072', 'ass_22', 'c_02');
  3106. INSERT INTO are_given VALUES('98765432072', 'ass_23', 'c_03');
  3107. INSERT INTO are_given VALUES('98765432072', 'ass_24', 'c_04');
  3108. INSERT INTO are_given VALUES('98765432072', 'ass_31', 'd_01');
  3109. INSERT INTO are_given VALUES('98765432072', 'ass_32', 'd_02');
  3110. INSERT INTO are_given VALUES('98765432072', 'ass_33', 'd_03');
  3111. INSERT INTO are_given VALUES('98765432072', 'ass_34', 'd_04');
  3112. INSERT INTO are_given VALUES('98765432071', 'ass_01', 'a_01');
  3113. INSERT INTO are_given VALUES('98765432071', 'ass_02', 'a_02');
  3114. INSERT INTO are_given VALUES('98765432071', 'ass_03', 'a_03');
  3115. INSERT INTO are_given VALUES('98765432071', 'ass_04', 'a_04');
  3116. INSERT INTO are_given VALUES('98765432071', 'ass_11', 'b_01');
  3117. INSERT INTO are_given VALUES('98765432071', 'ass_12', 'b_02');
  3118. INSERT INTO are_given VALUES('98765432071', 'ass_13', 'b_03');
  3119. INSERT INTO are_given VALUES('98765432071', 'ass_14', 'b_04');
  3120. INSERT INTO are_given VALUES('98765432071', 'ass_21', 'c_01');
  3121. INSERT INTO are_given VALUES('98765432071', 'ass_22', 'c_02');
  3122. INSERT INTO are_given VALUES('98765432071', 'ass_23', 'c_03');
  3123. INSERT INTO are_given VALUES('98765432071', 'ass_24', 'c_04');
  3124. INSERT INTO are_given VALUES('98765432071', 'ass_31', 'd_01');
  3125. INSERT INTO are_given VALUES('98765432071', 'ass_32', 'd_02');
  3126. INSERT INTO are_given VALUES('98765432071', 'ass_33', 'd_03');
  3127. INSERT INTO are_given VALUES('98765432071', 'ass_34', 'd_04');
  3128. INSERT INTO are_given VALUES('98765432070', 'ass_01', 'a_01');
  3129. INSERT INTO are_given VALUES('98765432070', 'ass_02', 'a_02');
  3130. INSERT INTO are_given VALUES('98765432070', 'ass_03', 'a_03');
  3131. INSERT INTO are_given VALUES('98765432070', 'ass_04', 'a_04');
  3132. INSERT INTO are_given VALUES('98765432070', 'ass_11', 'b_01');
  3133. INSERT INTO are_given VALUES('98765432070', 'ass_12', 'b_02');
  3134. INSERT INTO are_given VALUES('98765432070', 'ass_13', 'b_03');
  3135. INSERT INTO are_given VALUES('98765432070', 'ass_14', 'b_04');
  3136. INSERT INTO are_given VALUES('98765432070', 'ass_21', 'c_01');
  3137. INSERT INTO are_given VALUES('98765432070', 'ass_22', 'c_02');
  3138. INSERT INTO are_given VALUES('98765432070', 'ass_23', 'c_03');
  3139. INSERT INTO are_given VALUES('98765432070', 'ass_24', 'c_04');
  3140. INSERT INTO are_given VALUES('98765432070', 'ass_31', 'd_01');
  3141. INSERT INTO are_given VALUES('98765432070', 'ass_32', 'd_02');
  3142. INSERT INTO are_given VALUES('98765432070', 'ass_33', 'd_03');
  3143. INSERT INTO are_given VALUES('98765432070', 'ass_34', 'd_04');
  3144. INSERT INTO are_given VALUES('98765432069', 'ass_01', 'a_01');
  3145. INSERT INTO are_given VALUES('98765432069', 'ass_02', 'a_02');
  3146. INSERT INTO are_given VALUES('98765432069', 'ass_03', 'a_03');
  3147. INSERT INTO are_given VALUES('98765432069', 'ass_04', 'a_04');
  3148. INSERT INTO are_given VALUES('98765432069', 'ass_11', 'b_01');
  3149. INSERT INTO are_given VALUES('98765432069', 'ass_12', 'b_02');
  3150. INSERT INTO are_given VALUES('98765432069', 'ass_13', 'b_03');
  3151. INSERT INTO are_given VALUES('98765432069', 'ass_14', 'b_04');
  3152. INSERT INTO are_given VALUES('98765432069', 'ass_21', 'c_01');
  3153. INSERT INTO are_given VALUES('98765432069', 'ass_22', 'c_02');
  3154. INSERT INTO are_given VALUES('98765432069', 'ass_23', 'c_03');
  3155. INSERT INTO are_given VALUES('98765432069', 'ass_24', 'c_04');
  3156. INSERT INTO are_given VALUES('98765432069', 'ass_31', 'd_01');
  3157. INSERT INTO are_given VALUES('98765432069', 'ass_32', 'd_02');
  3158. INSERT INTO are_given VALUES('98765432069', 'ass_33', 'd_03');
  3159. INSERT INTO are_given VALUES('98765432069', 'ass_34', 'd_04');
  3160. INSERT INTO are_given VALUES('98765432068', 'ass_01', 'a_01');
  3161. INSERT INTO are_given VALUES('98765432068', 'ass_02', 'a_02');
  3162. INSERT INTO are_given VALUES('98765432068', 'ass_03', 'a_03');
  3163. INSERT INTO are_given VALUES('98765432068', 'ass_04', 'a_04');
  3164. INSERT INTO are_given VALUES('98765432068', 'ass_11', 'b_01');
  3165. INSERT INTO are_given VALUES('98765432068', 'ass_12', 'b_02');
  3166. INSERT INTO are_given VALUES('98765432068', 'ass_13', 'b_03');
  3167. INSERT INTO are_given VALUES('98765432068', 'ass_14', 'b_04');
  3168. INSERT INTO are_given VALUES('98765432068', 'ass_21', 'c_01');
  3169. INSERT INTO are_given VALUES('98765432068', 'ass_22', 'c_02');
  3170. INSERT INTO are_given VALUES('98765432068', 'ass_23', 'c_03');
  3171. INSERT INTO are_given VALUES('98765432068', 'ass_24', 'c_04');
  3172. INSERT INTO are_given VALUES('98765432068', 'ass_31', 'd_01');
  3173. INSERT INTO are_given VALUES('98765432068', 'ass_32', 'd_02');
  3174. INSERT INTO are_given VALUES('98765432068', 'ass_33', 'd_03');
  3175. INSERT INTO are_given VALUES('98765432068', 'ass_34', 'd_04');
  3176. INSERT INTO are_given VALUES('98765432067', 'ass_01', 'a_01');
  3177. INSERT INTO are_given VALUES('98765432067', 'ass_02', 'a_02');
  3178. INSERT INTO are_given VALUES('98765432067', 'ass_03', 'a_03');
  3179. INSERT INTO are_given VALUES('98765432067', 'ass_04', 'a_04');
  3180. INSERT INTO are_given VALUES('98765432067', 'ass_11', 'b_01');
  3181. INSERT INTO are_given VALUES('98765432067', 'ass_12', 'b_02');
  3182. INSERT INTO are_given VALUES('98765432067', 'ass_13', 'b_03');
  3183. INSERT INTO are_given VALUES('98765432067', 'ass_14', 'b_04');
  3184. INSERT INTO are_given VALUES('98765432067', 'ass_21', 'c_01');
  3185. INSERT INTO are_given VALUES('98765432067', 'ass_22', 'c_02');
  3186. INSERT INTO are_given VALUES('98765432067', 'ass_23', 'c_03');
  3187. INSERT INTO are_given VALUES('98765432067', 'ass_24', 'c_04');
  3188. INSERT INTO are_given VALUES('98765432067', 'ass_31', 'd_01');
  3189. INSERT INTO are_given VALUES('98765432067', 'ass_32', 'd_02');
  3190. INSERT INTO are_given VALUES('98765432067', 'ass_33', 'd_03');
  3191. INSERT INTO are_given VALUES('98765432067', 'ass_34', 'd_04');
  3192. INSERT INTO are_given VALUES('98765432066', 'ass_01', 'a_01');
  3193. INSERT INTO are_given VALUES('98765432066', 'ass_02', 'a_02');
  3194. INSERT INTO are_given VALUES('98765432066', 'ass_03', 'a_03');
  3195. INSERT INTO are_given VALUES('98765432066', 'ass_04', 'a_04');
  3196. INSERT INTO are_given VALUES('98765432066', 'ass_11', 'b_01');
  3197. INSERT INTO are_given VALUES('98765432066', 'ass_12', 'b_02');
  3198. INSERT INTO are_given VALUES('98765432066', 'ass_13', 'b_03');
  3199. INSERT INTO are_given VALUES('98765432066', 'ass_14', 'b_04');
  3200. INSERT INTO are_given VALUES('98765432066', 'ass_21', 'c_01');
  3201. INSERT INTO are_given VALUES('98765432066', 'ass_22', 'c_02');
  3202. INSERT INTO are_given VALUES('98765432066', 'ass_23', 'c_03');
  3203. INSERT INTO are_given VALUES('98765432066', 'ass_24', 'c_04');
  3204. INSERT INTO are_given VALUES('98765432066', 'ass_31', 'd_01');
  3205. INSERT INTO are_given VALUES('98765432066', 'ass_32', 'd_02');
  3206. INSERT INTO are_given VALUES('98765432066', 'ass_33', 'd_03');
  3207. INSERT INTO are_given VALUES('98765432066', 'ass_34', 'd_04');
  3208. INSERT INTO are_given VALUES('98765432065', 'ass_01', 'a_01');
  3209. INSERT INTO are_given VALUES('98765432065', 'ass_02', 'a_02');
  3210. INSERT INTO are_given VALUES('98765432065', 'ass_03', 'a_03');
  3211. INSERT INTO are_given VALUES('98765432065', 'ass_04', 'a_04');
  3212. INSERT INTO are_given VALUES('98765432065', 'ass_11', 'b_01');
  3213. INSERT INTO are_given VALUES('98765432065', 'ass_12', 'b_02');
  3214. INSERT INTO are_given VALUES('98765432065', 'ass_13', 'b_03');
  3215. INSERT INTO are_given VALUES('98765432065', 'ass_14', 'b_04');
  3216. INSERT INTO are_given VALUES('98765432065', 'ass_21', 'c_01');
  3217. INSERT INTO are_given VALUES('98765432065', 'ass_22', 'c_02');
  3218. INSERT INTO are_given VALUES('98765432065', 'ass_23', 'c_03');
  3219. INSERT INTO are_given VALUES('98765432065', 'ass_24', 'c_04');
  3220. INSERT INTO are_given VALUES('98765432065', 'ass_31', 'd_01');
  3221. INSERT INTO are_given VALUES('98765432065', 'ass_32', 'd_02');
  3222. INSERT INTO are_given VALUES('98765432065', 'ass_33', 'd_03');
  3223. INSERT INTO are_given VALUES('98765432065', 'ass_34', 'd_04');
  3224. INSERT INTO are_given VALUES('98765432064', 'ass_01', 'a_01');
  3225. INSERT INTO are_given VALUES('98765432064', 'ass_02', 'a_02');
  3226. INSERT INTO are_given VALUES('98765432064', 'ass_03', 'a_03');
  3227. INSERT INTO are_given VALUES('98765432064', 'ass_04', 'a_04');
  3228. INSERT INTO are_given VALUES('98765432064', 'ass_11', 'b_01');
  3229. INSERT INTO are_given VALUES('98765432064', 'ass_12', 'b_02');
  3230. INSERT INTO are_given VALUES('98765432064', 'ass_13', 'b_03');
  3231. INSERT INTO are_given VALUES('98765432064', 'ass_14', 'b_04');
  3232. INSERT INTO are_given VALUES('98765432064', 'ass_21', 'c_01');
  3233. INSERT INTO are_given VALUES('98765432064', 'ass_22', 'c_02');
  3234. INSERT INTO are_given VALUES('98765432064', 'ass_23', 'c_03');
  3235. INSERT INTO are_given VALUES('98765432064', 'ass_24', 'c_04');
  3236. INSERT INTO are_given VALUES('98765432064', 'ass_31', 'd_01');
  3237. INSERT INTO are_given VALUES('98765432064', 'ass_32', 'd_02');
  3238. INSERT INTO are_given VALUES('98765432064', 'ass_33', 'd_03');
  3239. INSERT INTO are_given VALUES('98765432064', 'ass_34', 'd_04');
  3240. INSERT INTO are_given VALUES('98765432063', 'ass_01', 'a_01');
  3241. INSERT INTO are_given VALUES('98765432063', 'ass_02', 'a_02');
  3242. INSERT INTO are_given VALUES('98765432063', 'ass_03', 'a_03');
  3243. INSERT INTO are_given VALUES('98765432063', 'ass_04', 'a_04');
  3244. INSERT INTO are_given VALUES('98765432063', 'ass_11', 'b_01');
  3245. INSERT INTO are_given VALUES('98765432063', 'ass_12', 'b_02');
  3246. INSERT INTO are_given VALUES('98765432063', 'ass_13', 'b_03');
  3247. INSERT INTO are_given VALUES('98765432063', 'ass_14', 'b_04');
  3248. INSERT INTO are_given VALUES('98765432063', 'ass_21', 'c_01');
  3249. INSERT INTO are_given VALUES('98765432063', 'ass_22', 'c_02');
  3250. INSERT INTO are_given VALUES('98765432063', 'ass_23', 'c_03');
  3251. INSERT INTO are_given VALUES('98765432063', 'ass_24', 'c_04');
  3252. INSERT INTO are_given VALUES('98765432063', 'ass_31', 'd_01');
  3253. INSERT INTO are_given VALUES('98765432063', 'ass_32', 'd_02');
  3254. INSERT INTO are_given VALUES('98765432063', 'ass_33', 'd_03');
  3255. INSERT INTO are_given VALUES('98765432063', 'ass_34', 'd_04');
  3256. INSERT INTO are_given VALUES('98765432062', 'ass_01', 'a_01');
  3257. INSERT INTO are_given VALUES('98765432062', 'ass_02', 'a_02');
  3258. INSERT INTO are_given VALUES('98765432062', 'ass_03', 'a_03');
  3259. INSERT INTO are_given VALUES('98765432062', 'ass_04', 'a_04');
  3260. INSERT INTO are_given VALUES('98765432062', 'ass_11', 'b_01');
  3261. INSERT INTO are_given VALUES('98765432062', 'ass_12', 'b_02');
  3262. INSERT INTO are_given VALUES('98765432062', 'ass_13', 'b_03');
  3263. INSERT INTO are_given VALUES('98765432062', 'ass_14', 'b_04');
  3264. INSERT INTO are_given VALUES('98765432062', 'ass_21', 'c_01');
  3265. INSERT INTO are_given VALUES('98765432062', 'ass_22', 'c_02');
  3266. INSERT INTO are_given VALUES('98765432062', 'ass_23', 'c_03');
  3267. INSERT INTO are_given VALUES('98765432062', 'ass_24', 'c_04');
  3268. INSERT INTO are_given VALUES('98765432062', 'ass_31', 'd_01');
  3269. INSERT INTO are_given VALUES('98765432062', 'ass_32', 'd_02');
  3270. INSERT INTO are_given VALUES('98765432062', 'ass_33', 'd_03');
  3271. INSERT INTO are_given VALUES('98765432062', 'ass_34', 'd_04');
  3272. INSERT INTO are_given VALUES('98765432061', 'ass_01', 'a_01');
  3273. INSERT INTO are_given VALUES('98765432061', 'ass_02', 'a_02');
  3274. INSERT INTO are_given VALUES('98765432061', 'ass_03', 'a_03');
  3275. INSERT INTO are_given VALUES('98765432061', 'ass_04', 'a_04');
  3276. INSERT INTO are_given VALUES('98765432061', 'ass_11', 'b_01');
  3277. INSERT INTO are_given VALUES('98765432061', 'ass_12', 'b_02');
  3278. INSERT INTO are_given VALUES('98765432061', 'ass_13', 'b_03');
  3279. INSERT INTO are_given VALUES('98765432061', 'ass_14', 'b_04');
  3280. INSERT INTO are_given VALUES('98765432061', 'ass_21', 'c_01');
  3281. INSERT INTO are_given VALUES('98765432061', 'ass_22', 'c_02');
  3282. INSERT INTO are_given VALUES('98765432061', 'ass_23', 'c_03');
  3283. INSERT INTO are_given VALUES('98765432061', 'ass_24', 'c_04');
  3284. INSERT INTO are_given VALUES('98765432061', 'ass_31', 'd_01');
  3285. INSERT INTO are_given VALUES('98765432061', 'ass_32', 'd_02');
  3286. INSERT INTO are_given VALUES('98765432061', 'ass_33', 'd_03');
  3287. INSERT INTO are_given VALUES('98765432061', 'ass_34', 'd_04');
  3288. INSERT INTO are_given VALUES('98765432060', 'ass_01', 'a_01');
  3289. INSERT INTO are_given VALUES('98765432060', 'ass_02', 'a_02');
  3290. INSERT INTO are_given VALUES('98765432060', 'ass_03', 'a_03');
  3291. INSERT INTO are_given VALUES('98765432060', 'ass_04', 'a_04');
  3292. INSERT INTO are_given VALUES('98765432060', 'ass_11', 'b_01');
  3293. INSERT INTO are_given VALUES('98765432060', 'ass_12', 'b_02');
  3294. INSERT INTO are_given VALUES('98765432060', 'ass_13', 'b_03');
  3295. INSERT INTO are_given VALUES('98765432060', 'ass_14', 'b_04');
  3296. INSERT INTO are_given VALUES('98765432060', 'ass_21', 'c_01');
  3297. INSERT INTO are_given VALUES('98765432060', 'ass_22', 'c_02');
  3298. INSERT INTO are_given VALUES('98765432060', 'ass_23', 'c_03');
  3299. INSERT INTO are_given VALUES('98765432060', 'ass_24', 'c_04');
  3300. INSERT INTO are_given VALUES('98765432060', 'ass_31', 'd_01');
  3301. INSERT INTO are_given VALUES('98765432060', 'ass_32', 'd_02');
  3302. INSERT INTO are_given VALUES('98765432060', 'ass_33', 'd_03');
  3303. INSERT INTO are_given VALUES('98765432060', 'ass_34', 'd_04');
  3304. INSERT INTO are_given VALUES('98765432059', 'ass_01', 'a_01');
  3305. INSERT INTO are_given VALUES('98765432059', 'ass_02', 'a_02');
  3306. INSERT INTO are_given VALUES('98765432059', 'ass_03', 'a_03');
  3307. INSERT INTO are_given VALUES('98765432059', 'ass_04', 'a_04');
  3308. INSERT INTO are_given VALUES('98765432059', 'ass_11', 'b_01');
  3309. INSERT INTO are_given VALUES('98765432059', 'ass_12', 'b_02');
  3310. INSERT INTO are_given VALUES('98765432059', 'ass_13', 'b_03');
  3311. INSERT INTO are_given VALUES('98765432059', 'ass_14', 'b_04');
  3312. INSERT INTO are_given VALUES('98765432059', 'ass_21', 'c_01');
  3313. INSERT INTO are_given VALUES('98765432059', 'ass_22', 'c_02');
  3314. INSERT INTO are_given VALUES('98765432059', 'ass_23', 'c_03');
  3315. INSERT INTO are_given VALUES('98765432059', 'ass_24', 'c_04');
  3316. INSERT INTO are_given VALUES('98765432059', 'ass_31', 'd_01');
  3317. INSERT INTO are_given VALUES('98765432059', 'ass_32', 'd_02');
  3318. INSERT INTO are_given VALUES('98765432059', 'ass_33', 'd_03');
  3319. INSERT INTO are_given VALUES('98765432059', 'ass_34', 'd_04');
  3320. INSERT INTO are_given VALUES('98765432058', 'ass_01', 'a_01');
  3321. INSERT INTO are_given VALUES('98765432058', 'ass_02', 'a_02');
  3322. INSERT INTO are_given VALUES('98765432058', 'ass_03', 'a_03');
  3323. INSERT INTO are_given VALUES('98765432058', 'ass_04', 'a_04');
  3324. INSERT INTO are_given VALUES('98765432058', 'ass_11', 'b_01');
  3325. INSERT INTO are_given VALUES('98765432058', 'ass_12', 'b_02');
  3326. INSERT INTO are_given VALUES('98765432058', 'ass_13', 'b_03');
  3327. INSERT INTO are_given VALUES('98765432058', 'ass_14', 'b_04');
  3328. INSERT INTO are_given VALUES('98765432058', 'ass_21', 'c_01');
  3329. INSERT INTO are_given VALUES('98765432058', 'ass_22', 'c_02');
  3330. INSERT INTO are_given VALUES('98765432058', 'ass_23', 'c_03');
  3331. INSERT INTO are_given VALUES('98765432058', 'ass_24', 'c_04');
  3332. INSERT INTO are_given VALUES('98765432058', 'ass_31', 'd_01');
  3333. INSERT INTO are_given VALUES('98765432058', 'ass_32', 'd_02');
  3334. INSERT INTO are_given VALUES('98765432058', 'ass_33', 'd_03');
  3335. INSERT INTO are_given VALUES('98765432058', 'ass_34', 'd_04');
  3336. INSERT INTO are_given VALUES('98765432057', 'ass_01', 'a_01');
  3337. INSERT INTO are_given VALUES('98765432057', 'ass_02', 'a_02');
  3338. INSERT INTO are_given VALUES('98765432057', 'ass_03', 'a_03');
  3339. INSERT INTO are_given VALUES('98765432057', 'ass_04', 'a_04');
  3340. INSERT INTO are_given VALUES('98765432057', 'ass_11', 'b_01');
  3341. INSERT INTO are_given VALUES('98765432057', 'ass_12', 'b_02');
  3342. INSERT INTO are_given VALUES('98765432057', 'ass_13', 'b_03');
  3343. INSERT INTO are_given VALUES('98765432057', 'ass_14', 'b_04');
  3344. INSERT INTO are_given VALUES('98765432057', 'ass_21', 'c_01');
  3345. INSERT INTO are_given VALUES('98765432057', 'ass_22', 'c_02');
  3346. INSERT INTO are_given VALUES('98765432057', 'ass_23', 'c_03');
  3347. INSERT INTO are_given VALUES('98765432057', 'ass_24', 'c_04');
  3348. INSERT INTO are_given VALUES('98765432057', 'ass_31', 'd_01');
  3349. INSERT INTO are_given VALUES('98765432057', 'ass_32', 'd_02');
  3350. INSERT INTO are_given VALUES('98765432057', 'ass_33', 'd_03');
  3351. INSERT INTO are_given VALUES('98765432057', 'ass_34', 'd_04');
  3352. INSERT INTO are_given VALUES('98765432056', 'ass_01', 'a_01');
  3353. INSERT INTO are_given VALUES('98765432056', 'ass_02', 'a_02');
  3354. INSERT INTO are_given VALUES('98765432056', 'ass_03', 'a_03');
  3355. INSERT INTO are_given VALUES('98765432056', 'ass_04', 'a_04');
  3356. INSERT INTO are_given VALUES('98765432056', 'ass_11', 'b_01');
  3357. INSERT INTO are_given VALUES('98765432056', 'ass_12', 'b_02');
  3358. INSERT INTO are_given VALUES('98765432056', 'ass_13', 'b_03');
  3359. INSERT INTO are_given VALUES('98765432056', 'ass_14', 'b_04');
  3360. INSERT INTO are_given VALUES('98765432056', 'ass_21', 'c_01');
  3361. INSERT INTO are_given VALUES('98765432056', 'ass_22', 'c_02');
  3362. INSERT INTO are_given VALUES('98765432056', 'ass_23', 'c_03');
  3363. INSERT INTO are_given VALUES('98765432056', 'ass_24', 'c_04');
  3364. INSERT INTO are_given VALUES('98765432056', 'ass_31', 'd_01');
  3365. INSERT INTO are_given VALUES('98765432056', 'ass_32', 'd_02');
  3366. INSERT INTO are_given VALUES('98765432056', 'ass_33', 'd_03');
  3367. INSERT INTO are_given VALUES('98765432056', 'ass_34', 'd_04');
  3368. INSERT INTO are_given VALUES('98765432055', 'ass_01', 'a_01');
  3369. INSERT INTO are_given VALUES('98765432055', 'ass_02', 'a_02');
  3370. INSERT INTO are_given VALUES('98765432055', 'ass_03', 'a_03');
  3371. INSERT INTO are_given VALUES('98765432055', 'ass_04', 'a_04');
  3372. INSERT INTO are_given VALUES('98765432055', 'ass_11', 'b_01');
  3373. INSERT INTO are_given VALUES('98765432055', 'ass_12', 'b_02');
  3374. INSERT INTO are_given VALUES('98765432055', 'ass_13', 'b_03');
  3375. INSERT INTO are_given VALUES('98765432055', 'ass_14', 'b_04');
  3376. INSERT INTO are_given VALUES('98765432055', 'ass_21', 'c_01');
  3377. INSERT INTO are_given VALUES('98765432055', 'ass_22', 'c_02');
  3378. INSERT INTO are_given VALUES('98765432055', 'ass_23', 'c_03');
  3379. INSERT INTO are_given VALUES('98765432055', 'ass_24', 'c_04');
  3380. INSERT INTO are_given VALUES('98765432055', 'ass_31', 'd_01');
  3381. INSERT INTO are_given VALUES('98765432055', 'ass_32', 'd_02');
  3382. INSERT INTO are_given VALUES('98765432055', 'ass_33', 'd_03');
  3383. INSERT INTO are_given VALUES('98765432055', 'ass_34', 'd_04');
  3384. INSERT INTO are_given VALUES('98765432054', 'ass_01', 'a_01');
  3385. INSERT INTO are_given VALUES('98765432054', 'ass_02', 'a_02');
  3386. INSERT INTO are_given VALUES('98765432054', 'ass_03', 'a_03');
  3387. INSERT INTO are_given VALUES('98765432054', 'ass_04', 'a_04');
  3388. INSERT INTO are_given VALUES('98765432054', 'ass_11', 'b_01');
  3389. INSERT INTO are_given VALUES('98765432054', 'ass_12', 'b_02');
  3390. INSERT INTO are_given VALUES('98765432054', 'ass_13', 'b_03');
  3391. INSERT INTO are_given VALUES('98765432054', 'ass_14', 'b_04');
  3392. INSERT INTO are_given VALUES('98765432054', 'ass_21', 'c_01');
  3393. INSERT INTO are_given VALUES('98765432054', 'ass_22', 'c_02');
  3394. INSERT INTO are_given VALUES('98765432054', 'ass_23', 'c_03');
  3395. INSERT INTO are_given VALUES('98765432054', 'ass_24', 'c_04');
  3396. INSERT INTO are_given VALUES('98765432054', 'ass_31', 'd_01');
  3397. INSERT INTO are_given VALUES('98765432054', 'ass_32', 'd_02');
  3398. INSERT INTO are_given VALUES('98765432054', 'ass_33', 'd_03');
  3399. INSERT INTO are_given VALUES('98765432054', 'ass_34', 'd_04');
  3400. INSERT INTO are_given VALUES('98765432053', 'ass_01', 'a_01');
  3401. INSERT INTO are_given VALUES('98765432053', 'ass_02', 'a_02');
  3402. INSERT INTO are_given VALUES('98765432053', 'ass_03', 'a_03');
  3403. INSERT INTO are_given VALUES('98765432053', 'ass_04', 'a_04');
  3404. INSERT INTO are_given VALUES('98765432053', 'ass_11', 'b_01');
  3405. INSERT INTO are_given VALUES('98765432053', 'ass_12', 'b_02');
  3406. INSERT INTO are_given VALUES('98765432053', 'ass_13', 'b_03');
  3407. INSERT INTO are_given VALUES('98765432053', 'ass_14', 'b_04');
  3408. INSERT INTO are_given VALUES('98765432053', 'ass_21', 'c_01');
  3409. INSERT INTO are_given VALUES('98765432053', 'ass_22', 'c_02');
  3410. INSERT INTO are_given VALUES('98765432053', 'ass_23', 'c_03');
  3411. INSERT INTO are_given VALUES('98765432053', 'ass_24', 'c_04');
  3412. INSERT INTO are_given VALUES('98765432053', 'ass_31', 'd_01');
  3413. INSERT INTO are_given VALUES('98765432053', 'ass_32', 'd_02');
  3414. INSERT INTO are_given VALUES('98765432053', 'ass_33', 'd_03');
  3415. INSERT INTO are_given VALUES('98765432053', 'ass_34', 'd_04');
  3416. INSERT INTO are_given VALUES('98765432052', 'ass_01', 'a_01');
  3417. INSERT INTO are_given VALUES('98765432052', 'ass_02', 'a_02');
  3418. INSERT INTO are_given VALUES('98765432052', 'ass_03', 'a_03');
  3419. INSERT INTO are_given VALUES('98765432052', 'ass_04', 'a_04');
  3420. INSERT INTO are_given VALUES('98765432052', 'ass_11', 'b_01');
  3421. INSERT INTO are_given VALUES('98765432052', 'ass_12', 'b_02');
  3422. INSERT INTO are_given VALUES('98765432052', 'ass_13', 'b_03');
  3423. INSERT INTO are_given VALUES('98765432052', 'ass_14', 'b_04');
  3424. INSERT INTO are_given VALUES('98765432052', 'ass_21', 'c_01');
  3425. INSERT INTO are_given VALUES('98765432052', 'ass_22', 'c_02');
  3426. INSERT INTO are_given VALUES('98765432052', 'ass_23', 'c_03');
  3427. INSERT INTO are_given VALUES('98765432052', 'ass_24', 'c_04');
  3428. INSERT INTO are_given VALUES('98765432052', 'ass_31', 'd_01');
  3429. INSERT INTO are_given VALUES('98765432052', 'ass_32', 'd_02');
  3430. INSERT INTO are_given VALUES('98765432052', 'ass_33', 'd_03');
  3431. INSERT INTO are_given VALUES('98765432052', 'ass_34', 'd_04');
  3432. INSERT INTO are_given VALUES('98765432051', 'ass_01', 'a_01');
  3433. INSERT INTO are_given VALUES('98765432051', 'ass_02', 'a_02');
  3434. INSERT INTO are_given VALUES('98765432051', 'ass_03', 'a_03');
  3435. INSERT INTO are_given VALUES('98765432051', 'ass_04', 'a_04');
  3436. INSERT INTO are_given VALUES('98765432051', 'ass_11', 'b_01');
  3437. INSERT INTO are_given VALUES('98765432051', 'ass_12', 'b_02');
  3438. INSERT INTO are_given VALUES('98765432051', 'ass_13', 'b_03');
  3439. INSERT INTO are_given VALUES('98765432051', 'ass_14', 'b_04');
  3440. INSERT INTO are_given VALUES('98765432051', 'ass_21', 'c_01');
  3441. INSERT INTO are_given VALUES('98765432051', 'ass_22', 'c_02');
  3442. INSERT INTO are_given VALUES('98765432051', 'ass_23', 'c_03');
  3443. INSERT INTO are_given VALUES('98765432051', 'ass_24', 'c_04');
  3444. INSERT INTO are_given VALUES('98765432051', 'ass_31', 'd_01');
  3445. INSERT INTO are_given VALUES('98765432051', 'ass_32', 'd_02');
  3446. INSERT INTO are_given VALUES('98765432051', 'ass_33', 'd_03');
  3447. INSERT INTO are_given VALUES('98765432051', 'ass_34', 'd_04');
  3448. INSERT INTO are_given VALUES('98765432050', 'ass_01', 'a_01');
  3449. INSERT INTO are_given VALUES('98765432050', 'ass_02', 'a_02');
  3450. INSERT INTO are_given VALUES('98765432050', 'ass_03', 'a_03');
  3451. INSERT INTO are_given VALUES('98765432050', 'ass_04', 'a_04');
  3452. INSERT INTO are_given VALUES('98765432050', 'ass_11', 'b_01');
  3453. INSERT INTO are_given VALUES('98765432050', 'ass_12', 'b_02');
  3454. INSERT INTO are_given VALUES('98765432050', 'ass_13', 'b_03');
  3455. INSERT INTO are_given VALUES('98765432050', 'ass_14', 'b_04');
  3456. INSERT INTO are_given VALUES('98765432050', 'ass_21', 'c_01');
  3457. INSERT INTO are_given VALUES('98765432050', 'ass_22', 'c_02');
  3458. INSERT INTO are_given VALUES('98765432050', 'ass_23', 'c_03');
  3459. INSERT INTO are_given VALUES('98765432050', 'ass_24', 'c_04');
  3460. INSERT INTO are_given VALUES('98765432050', 'ass_31', 'd_01');
  3461. INSERT INTO are_given VALUES('98765432050', 'ass_32', 'd_02');
  3462. INSERT INTO are_given VALUES('98765432050', 'ass_33', 'd_03');
  3463. INSERT INTO are_given VALUES('98765432050', 'ass_34', 'd_04');
  3464.  
  3465.  
  3466. -- Question 1 : Give the list of teachers (name) and the name of the courses that they are teaching and the name of the courses that they are reviewing.
  3467. -- Hint: There will be a list of teacher names (first and last), teaching courses, reviewing courses.
  3468. -- write the query here
  3469. SELECT name, surname, course_name, review.course_code
  3470. FROM teacher
  3471. JOIN teach ON teacher.bsn = teach.bsn
  3472. JOIN course ON teach.course_code = course.course_code
  3473. JOIN review ON course.course_code = review.course_code;
  3474.  
  3475.  
  3476. -- Question 2: Give the list of students that completed their study programs together with their course points (sum of all the course points for each student).
  3477. -- Hint: There will be a list with first name and last name of students and total points of courses that each student followed.
  3478. -- write the query here
  3479. SELECT name, surname, SUM(study_points)
  3480. FROM study_program
  3481. JOIN completed ON study_program.course_program = completed.course_program
  3482. JOIN student ON completed.student_id = student.student_id
  3483. JOIN teach ON student.student_id = teach.student_id
  3484. JOIN course ON teach.course_code = course.course_code
  3485. GROUP BY name, surname;
  3486.  
  3487.  
  3488. -- Question 3: Give the list of courses (names) that teachers with maximum scale are teaching.
  3489. -- write the query here
  3490. SELECT DISTINCT course_name, name, surname
  3491. FROM course
  3492. JOIN teach ON course.course_code = teach.course_code
  3493. JOIN teacher ON teach.bsn = teacher.bsn
  3494. WHERE scale = (select MAX(scale) FROM teacher);
  3495.  
  3496.  
  3497. -- Question 4: Give the list of students (names) and their assignments together with the number of prerequisites for each assignment.
  3498. -- Hint: There will be a list of students names, code of the assignment, code of the course of the assignment, total number assignments that are required to do the assignment.
  3499. -- write the query here
  3500. SELECT name, surname, are_given.a_code, are_given.course_code, COUNT(is_required_a_code)
  3501. FROM student
  3502. JOIN are_given ON student.student_id = are_given.bsn
  3503. JOIN assignment ON are_given.a_code = assignment.a_code
  3504. JOIN requirement ON assignment.a_code = requirement.required_a_code
  3505. GROUP BY name, surname, are_given.a_code, are_given.course_code;
  3506.  
  3507.  
  3508. -- Question 5: Give a list of teachers (names) that are teaching courses, but do not work on assignments
  3509. -- write the query here
  3510. SELECT DISTINCT name, surname
  3511. FROM teach
  3512. JOIN teacher ON teach.bsn = teacher.bsn
  3513. WHERE teacher.bsn NOT in (SELECT bsn FROM work_on);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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!