Advertisement
MartinDevillers

UTL_DateAddWorkingDays SQL Test Script

Sep 20th, 2012
853
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 46.08 KB | None | 0 0
  1. SET DATEFIRST 7 -- Default, added for clarity, may be omitted
  2. SELECT DATA.DATE, DATA.days, (SELECT DATE FROM UTL_DateAddWorkingDays(DATA.DATE, DATA.days)) AS RESULT, (CASE WHEN (SELECT DATE FROM UTL_DateAddWorkingDays(DATA.DATE, DATA.days)) = DATA.expected THEN 'Y' ELSE 'N' END) AS expected_result  
  3. FROM
  4. (SELECT '09-21-2013' AS DATE, 279 AS days, '10-16-2014' AS expected UNION
  5. SELECT '07-25-1982', 221, '05-30-1983' UNION
  6. SELECT '04-08-2028', 233, '02-28-2029' UNION
  7. SELECT '06-27-2007', 15, '07-18-2007' UNION
  8. SELECT '11-19-2021', 157, '06-28-2022' UNION
  9. SELECT '10-27-2019', 16, '11-18-2019' UNION
  10. SELECT '06-26-2011', 343, '10-17-2012' UNION
  11. SELECT '01-06-2002', 226, '11-18-2002' UNION
  12. SELECT '11-18-1987', 381, '05-04-1989' UNION
  13. SELECT '05-10-1971', 478, '03-08-1973' UNION
  14. SELECT '08-04-2000', 136, '02-12-2001' UNION
  15. SELECT '09-10-2024', 228, '07-25-2025' UNION
  16. SELECT '03-12-1978', 359, '07-26-1979' UNION
  17. SELECT '06-06-2007', 439, '02-10-2009' UNION
  18. SELECT '09-24-2019', 339, '01-11-2021' UNION
  19. SELECT '03-25-2007', 448, '12-10-2008' UNION
  20. SELECT '10-05-1975', 322, '12-28-1976' UNION
  21. SELECT '03-27-2019', 240, '02-26-2020' UNION
  22. SELECT '08-22-2009', 50, '10-30-2009' UNION
  23. SELECT '08-04-2013', 452, '04-28-2015' UNION
  24. SELECT '06-15-1981', 162, '01-27-1982' UNION
  25. SELECT '06-23-2010', 404, '01-10-2012' UNION
  26. SELECT '09-26-2017', 147, '04-19-2018' UNION
  27. SELECT '08-09-2001', 143, '02-26-2002' UNION
  28. SELECT '03-06-2019', 34, '04-23-2019' UNION
  29. SELECT '08-18-2007', 463, '05-27-2009' UNION
  30. SELECT '11-02-1983', 450, '07-24-1985' UNION
  31. SELECT '02-05-2010', 53, '04-21-2010' UNION
  32. SELECT '11-14-2006', 74, '02-26-2007' UNION
  33. SELECT '07-07-2010', 309, '09-13-2011' UNION
  34. SELECT '04-23-1970', 31, '06-05-1970' UNION
  35. SELECT '08-26-1986', 494, '07-18-1988' UNION
  36. SELECT '06-08-1993', 253, '05-27-1994' UNION
  37. SELECT '01-08-2001', 248, '12-20-2001' UNION
  38. SELECT '07-03-2020', 371, '12-06-2021' UNION
  39. SELECT '11-04-1994', 349, '03-07-1996' UNION
  40. SELECT '10-19-2006', 284, '11-21-2007' UNION
  41. SELECT '03-17-1980', 125, '09-08-1980' UNION
  42. SELECT '07-02-2029', 131, '01-01-2030' UNION
  43. SELECT '07-18-2020', 258, '07-14-2021' UNION
  44. SELECT '01-14-2028', 77, '05-02-2028' UNION
  45. SELECT '08-16-2018', 276, '09-06-2019' UNION
  46. SELECT '11-09-2010', 32, '12-23-2010' UNION
  47. SELECT '06-06-1997', 35, '07-25-1997' UNION
  48. SELECT '02-13-1983', 225, '12-23-1983' UNION
  49. SELECT '05-23-1971', 101, '10-11-1971' UNION
  50. SELECT '01-14-2024', 481, '11-17-2025' UNION
  51. SELECT '01-18-2029', 139, '08-01-2029' UNION
  52. SELECT '07-21-2028', 162, '03-06-2029' UNION
  53. SELECT '11-24-1995', 486, '10-06-1997' UNION
  54. SELECT '02-25-1985', 89, '06-28-1985' UNION
  55. SELECT '06-22-2022', 257, '06-16-2023' UNION
  56. SELECT '11-01-1991', 345, '02-26-1993' UNION
  57. SELECT '03-14-1977', 290, '04-24-1978' UNION
  58. SELECT '04-07-1985', 392, '10-07-1986' UNION
  59. SELECT '07-16-1977', 327, '10-17-1978' UNION
  60. SELECT '01-03-1990', 438, '09-09-1991' UNION
  61. SELECT '10-18-2012', 127, '04-15-2013' UNION
  62. SELECT '06-06-1985', 443, '02-17-1987' UNION
  63. SELECT '08-09-1999', 184, '04-21-2000' UNION
  64. SELECT '11-17-1984', 0, '11-17-1984' UNION
  65. SELECT '11-05-2029', 386, '04-29-2031' UNION
  66. SELECT '03-02-1975', 55, '05-16-1975' UNION
  67. SELECT '02-23-2013', 321, '05-19-2014' UNION
  68. SELECT '03-23-2004', 429, '11-14-2005' UNION
  69. SELECT '10-22-1996', 230, '09-09-1997' UNION
  70. SELECT '09-12-1990', 323, '12-09-1991' UNION
  71. SELECT '07-03-2029', 311, '09-11-2030' UNION
  72. SELECT '10-15-2029', 68, '01-17-2030' UNION
  73. SELECT '07-19-1970', 189, '04-08-1971' UNION
  74. SELECT '04-22-2021', 259, '04-20-2022' UNION
  75. SELECT '06-15-2019', 81, '10-07-2019' UNION
  76. SELECT '07-09-2008', 124, '12-30-2008' UNION
  77. SELECT '06-25-2018', 168, '02-14-2019' UNION
  78. SELECT '02-18-1981', 102, '07-10-1981' UNION
  79. SELECT '06-21-2002', 241, '05-26-2003' UNION
  80. SELECT '05-04-1976', 429, '12-26-1977' UNION
  81. SELECT '08-18-2003', 7, '08-27-2003' UNION
  82. SELECT '06-27-2004', 61, '09-20-2004' UNION
  83. SELECT '04-18-1977', 399, '10-27-1978' UNION
  84. SELECT '03-01-1985', 222, '01-07-1986' UNION
  85. SELECT '10-23-1987', 265, '10-28-1988' UNION
  86. SELECT '03-26-2027', 425, '11-10-2028' UNION
  87. SELECT '06-23-2023', 178, '02-28-2024' UNION
  88. SELECT '04-12-2003', 195, '01-09-2004' UNION
  89. SELECT '08-17-1995', 465, '05-29-1997' UNION
  90. SELECT '04-19-2024', 171, '12-16-2024' UNION
  91. SELECT '09-06-1998', 454, '06-01-2000' UNION
  92. SELECT '10-26-2001', 135, '05-03-2002' UNION
  93. SELECT '04-06-1999', 130, '10-05-1999' UNION
  94. SELECT '07-25-2006', 180, '04-03-2007' UNION
  95. SELECT '09-04-2015', 51, '11-16-2015' UNION
  96. SELECT '08-16-2006', 408, '03-10-2008' UNION
  97. SELECT '03-11-2021', 296, '04-29-2022' UNION
  98. SELECT '01-15-2009', 497, '12-13-2010' UNION
  99. SELECT '06-02-1979', 76, '09-17-1979' UNION
  100. SELECT '01-09-2029', 17, '02-01-2029' UNION
  101. SELECT '07-24-2001', 112, '12-27-2001' UNION
  102. SELECT '02-21-1976', 416, '09-26-1977' UNION
  103. SELECT '03-05-2015', 61, '05-29-2015' UNION
  104. SELECT '07-20-1980', 414, '02-18-1982' UNION
  105. SELECT '05-02-1983', 140, '11-14-1983' UNION
  106. SELECT '04-17-1999', 207, '02-01-2000' UNION
  107. SELECT '03-03-2017', 67, '06-06-2017' UNION
  108. SELECT '09-11-2001', 360, '01-28-2003' UNION
  109. SELECT '01-16-1997', 20, '02-13-1997' UNION
  110. SELECT '04-19-2016', 353, '08-25-2017' UNION
  111. SELECT '06-23-1997', 211, '04-14-1998' UNION
  112. SELECT '05-23-2024', 290, '07-03-2025' UNION
  113. SELECT '03-25-2015', 292, '05-06-2016' UNION
  114. SELECT '01-15-2029', 80, '05-07-2029' UNION
  115. SELECT '05-12-2027', 461, '02-15-2029' UNION
  116. SELECT '08-09-1973', 499, '07-09-1975' UNION
  117. SELECT '06-19-2021', 47, '08-24-2021' UNION
  118. SELECT '08-02-2029', 441, '04-11-2031' UNION
  119. SELECT '04-23-2012', 469, '02-07-2014' UNION
  120. SELECT '03-14-2001', 192, '12-07-2001' UNION
  121. SELECT '06-11-1992', 145, '12-31-1992' UNION
  122. SELECT '09-20-2019', 202, '06-30-2020' UNION
  123. SELECT '05-03-2002', 167, '12-24-2002' UNION
  124. SELECT '09-18-2024', 411, '04-16-2026' UNION
  125. SELECT '10-16-1984', 225, '08-27-1985' UNION
  126. SELECT '08-16-2014', 31, '09-29-2014' UNION
  127. SELECT '01-24-1980', 327, '04-27-1981' UNION
  128. SELECT '07-18-1984', 390, '01-15-1986' UNION
  129. SELECT '01-15-2025', 267, '01-23-2026' UNION
  130. SELECT '01-05-1985', 37, '02-26-1985' UNION
  131. SELECT '03-16-2013', 283, '04-16-2014' UNION
  132. SELECT '08-27-2006', 462, '06-03-2008' UNION
  133. SELECT '11-19-2011', 340, '03-08-2013' UNION
  134. SELECT '01-18-2007', 328, '04-22-2008' UNION
  135. SELECT '04-03-2025', 395, '10-08-2026' UNION
  136. SELECT '01-05-2024', 463, '10-15-2025' UNION
  137. SELECT '04-11-2017', 435, '12-11-2018' UNION
  138. SELECT '02-16-1983', 109, '07-19-1983' UNION
  139. SELECT '06-20-2010', 240, '05-20-2011' UNION
  140. SELECT '01-13-1979', 233, '12-05-1979' UNION
  141. SELECT '11-27-1974', 121, '05-15-1975' UNION
  142. SELECT '11-05-2024', 436, '07-08-2026' UNION
  143. SELECT '10-17-1994', 468, '08-01-1996' UNION
  144. SELECT '05-05-2024', 325, '08-01-2025' UNION
  145. SELECT '07-22-1975', 161, '03-03-1976' UNION
  146. SELECT '02-19-1988', 283, '03-22-1989' UNION
  147. SELECT '06-01-1995', 71, '09-08-1995' UNION
  148. SELECT '02-14-1990', 455, '11-13-1991' UNION
  149. SELECT '08-20-2022', 473, '06-12-2024' UNION
  150. SELECT '11-01-1976', 411, '05-30-1978' UNION
  151. SELECT '06-13-1978', 170, '02-06-1979' UNION
  152. SELECT '07-09-2000', 148, '01-31-2001' UNION
  153. SELECT '01-11-1988', 265, '01-16-1989' UNION
  154. SELECT '02-05-1984', 489, '12-19-1985' UNION
  155. SELECT '05-23-1985', 211, '03-14-1986' UNION
  156. SELECT '01-15-2027', 121, '07-05-2027' UNION
  157. SELECT '08-02-1993', 133, '02-03-1994' UNION
  158. SELECT '03-15-2009', 84, '07-09-2009' UNION
  159. SELECT '11-05-2006', 393, '05-07-2008' UNION
  160. SELECT '04-02-2007', 398, '10-09-2008' UNION
  161. SELECT '08-23-1980', 130, '02-20-1981' UNION
  162. SELECT '11-19-2016', 373, '04-25-2018' UNION
  163. SELECT '09-19-1999', 351, '01-22-2001' UNION
  164. SELECT '07-24-1976', 62, '10-19-1976' UNION
  165. SELECT '03-26-2029', 412, '10-23-2030' UNION
  166. SELECT '01-18-2003', 46, '03-24-2003' UNION
  167. SELECT '03-25-2001', 137, '10-02-2001' UNION
  168. SELECT '05-10-2026', 455, '02-04-2028' UNION
  169. SELECT '01-07-1991', 120, '06-24-1991' UNION
  170. SELECT '04-13-1980', 216, '02-09-1981' UNION
  171. SELECT '04-21-1970', 461, '01-26-1972' UNION
  172. SELECT '10-02-2002', 7, '10-11-2002' UNION
  173. SELECT '01-22-1975', 201, '10-30-1975' UNION
  174. SELECT '03-07-1994', 64, '06-03-1994' UNION
  175. SELECT '09-20-1974', 277, '10-14-1975' UNION
  176. SELECT '05-22-1972', 63, '08-17-1972' UNION
  177. SELECT '09-10-1993', 42, '11-09-1993' UNION
  178. SELECT '07-26-1990', 354, '12-04-1991' UNION
  179. SELECT '06-22-2015', 124, '12-11-2015' UNION
  180. SELECT '08-15-1986', 342, '12-08-1987' UNION
  181. SELECT '10-05-1979', 440, '06-12-1981' UNION
  182. SELECT '11-14-2003', 62, '02-10-2004' UNION
  183. SELECT '02-05-2017', 223, '12-13-2017' UNION
  184. SELECT '11-11-2002', 308, '01-15-2004' UNION
  185. SELECT '08-15-2000', 384, '02-04-2002' UNION
  186. SELECT '11-19-1999', 232, '10-10-2000' UNION
  187. SELECT '01-18-1976', 449, '10-06-1977' UNION
  188. SELECT '11-24-1994', 181, '08-04-1995' UNION
  189. SELECT '01-11-1980', 71, '04-21-1980' UNION
  190. SELECT '11-16-1982', 217, '09-15-1983' UNION
  191. SELECT '03-08-1986', 112, '08-12-1986' UNION
  192. SELECT '06-05-1997', 420, '01-14-1999' UNION
  193. SELECT '03-20-1977', 309, '05-25-1978' UNION
  194. SELECT '09-06-1980', 91, '01-12-1981' UNION
  195. SELECT '08-21-1984', 237, '07-18-1985' UNION
  196. SELECT '07-20-1988', 406, '02-08-1990' UNION
  197. SELECT '09-08-1985', 248, '08-20-1986' UNION
  198. SELECT '03-11-2001', 293, '04-24-2002' UNION
  199. SELECT '02-14-1975', 129, '08-14-1975' UNION
  200. SELECT '05-01-2010', 310, '07-08-2011' UNION
  201. SELECT '09-21-2025', 111, '02-23-2026' UNION
  202. SELECT '03-06-1984', 198, '12-07-1984' UNION
  203. SELECT '03-25-2021', 248, '03-08-2022' UNION
  204. SELECT '01-04-1979', 332, '04-14-1980' UNION
  205. SELECT '06-27-2001', 330, '10-02-2002' UNION
  206. SELECT '08-09-1983', 438, '04-12-1985' UNION
  207. SELECT '02-15-2017', 34, '04-04-2017' UNION
  208. SELECT '11-14-1986', 396, '05-23-1988' UNION
  209. SELECT '02-15-2013', 248, '01-29-2014' UNION
  210. SELECT '06-16-2019', 8, '06-26-2019' UNION
  211. SELECT '10-18-2006', 152, '05-18-2007' UNION
  212. SELECT '10-12-1990', 0, '10-12-1990' UNION
  213. SELECT '10-20-2028', 99, '03-08-2029' UNION
  214. SELECT '04-11-1998', 129, '10-08-1998' UNION
  215. SELECT '10-12-1998', 43, '12-10-1998' UNION
  216. SELECT '02-04-2012', 457, '11-05-2013' UNION
  217. SELECT '02-22-2012', 7, '03-02-2012' UNION
  218. SELECT '08-23-2002', 18, '09-18-2002' UNION
  219. SELECT '11-02-2024', 180, '07-11-2025' UNION
  220. SELECT '01-15-1971', 444, '09-28-1972' UNION
  221. SELECT '06-03-2013', 221, '04-08-2014' UNION
  222. SELECT '04-09-1981', 188, '12-29-1981' UNION
  223. SELECT '04-01-2015', 464, '01-10-2017' UNION
  224. SELECT '06-09-1973', 246, '05-20-1974' UNION
  225. SELECT '09-16-2015', 112, '02-19-2016' UNION
  226. SELECT '05-13-1977', 165, '12-30-1977' UNION
  227. SELECT '08-08-1970', 263, '08-11-1971' UNION
  228. SELECT '01-07-1987', 231, '11-26-1987' UNION
  229. SELECT '06-10-1991', 91, '10-15-1991' UNION
  230. SELECT '08-20-1971', 206, '06-05-1972' UNION
  231. SELECT '05-08-2017', 124, '10-27-2017' UNION
  232. SELECT '11-27-2007', 212, '09-18-2008' UNION
  233. SELECT '07-17-2008', 146, '02-06-2009' UNION
  234. SELECT '04-21-1995', 156, '11-27-1995' UNION
  235. SELECT '09-12-1974', 249, '08-27-1975' UNION
  236. SELECT '09-03-1970', 359, '01-19-1972' UNION
  237. SELECT '07-16-1973', 254, '07-05-1974' UNION
  238. SELECT '02-13-1977', 40, '04-08-1977' UNION
  239. SELECT '02-12-1970', 359, '06-30-1971' UNION
  240. SELECT '03-20-1978', 45, '05-22-1978' UNION
  241. SELECT '10-24-2012', 367, '03-21-2014' UNION
  242. SELECT '11-01-1995', 22, '12-01-1995' UNION
  243. SELECT '01-04-2016', 125, '06-27-2016' UNION
  244. SELECT '03-11-1983', 3, '03-16-1983' UNION
  245. SELECT '06-06-1989', 36, '07-26-1989' UNION
  246. SELECT '06-09-1990', 262, '06-11-1991' UNION
  247. SELECT '06-08-1975', 124, '11-27-1975' UNION
  248. SELECT '01-05-2023', 427, '08-26-2024' UNION
  249. SELECT '04-22-1973', 72, '07-31-1973' UNION
  250. SELECT '04-08-2024', 55, '06-24-2024' UNION
  251. SELECT '06-20-2000', 36, '08-09-2000' UNION
  252. SELECT '03-24-1970', 399, '10-04-1971' UNION
  253. SELECT '05-11-2016', 302, '07-07-2017' UNION
  254. SELECT '07-21-1971', 120, '01-05-1972' UNION
  255. SELECT '04-18-2003', 448, '01-05-2005' UNION
  256. SELECT '09-05-2009', 365, '01-28-2011' UNION
  257. SELECT '03-06-2023', 438, '11-07-2024' UNION
  258. SELECT '03-03-1995', 485, '01-10-1997' UNION
  259. SELECT '01-16-1985', 409, '08-12-1986' UNION
  260. SELECT '03-14-2014', 430, '11-06-2015' UNION
  261. SELECT '06-13-2010', 234, '05-05-2011' UNION
  262. SELECT '07-23-2008', 212, '05-15-2009' UNION
  263. SELECT '06-16-2006', 277, '07-10-2007' UNION
  264. SELECT '05-13-2011', 365, '10-05-2012' UNION
  265. SELECT '01-06-1991', 374, '06-11-1992' UNION
  266. SELECT '11-10-1971', 261, '11-09-1972' UNION
  267. SELECT '05-10-1989', 467, '02-22-1991' UNION
  268. SELECT '11-14-1974', 166, '07-04-1975' UNION
  269. SELECT '09-06-2020', 90, '01-08-2021' UNION
  270. SELECT '08-03-1988', 162, '03-17-1989' UNION
  271. SELECT '09-08-1995', 444, '05-22-1997' UNION
  272. SELECT '06-08-2010', 426, '01-25-2012' UNION
  273. SELECT '10-13-2008', 370, '03-15-2010' UNION
  274. SELECT '09-23-1972', 349, '01-24-1974' UNION
  275. SELECT '11-04-1976', 111, '04-08-1977' UNION
  276. SELECT '10-10-1982', 336, '01-23-1984' UNION
  277. SELECT '03-20-1972', 453, '12-13-1973' UNION
  278. SELECT '03-12-1980', 338, '06-29-1981' UNION
  279. SELECT '10-09-2025', 134, '04-15-2026' UNION
  280. SELECT '06-23-2012', 390, '12-20-2013' UNION
  281. SELECT '06-09-1979', 126, '12-03-1979' UNION
  282. SELECT '09-08-1998', 35, '10-27-1998' UNION
  283. SELECT '06-02-2027', 181, '02-10-2028' UNION
  284. SELECT '10-04-2002', 260, '10-03-2003' UNION
  285. SELECT '07-23-1994', 210, '05-12-1995' UNION
  286. SELECT '05-19-2019', 182, '01-28-2020' UNION
  287. SELECT '09-23-1994', 89, '01-26-1995' UNION
  288. SELECT '07-27-1996', 318, '10-15-1997' UNION
  289. SELECT '05-02-1975', 352, '09-07-1976' UNION
  290. SELECT '02-06-2006', 143, '08-24-2006' UNION
  291. SELECT '08-26-2027', 326, '11-24-2028' UNION
  292. SELECT '01-04-1982', 29, '02-12-1982' UNION
  293. SELECT '09-24-2014', 51, '12-04-2014' UNION
  294. SELECT '05-26-2007', 390, '11-21-2008' UNION
  295. SELECT '11-23-2019', 347, '03-23-2021' UNION
  296. SELECT '02-18-2026', 200, '11-25-2026' UNION
  297. SELECT '05-08-2001', 86, '09-05-2001' UNION
  298. SELECT '05-25-2017', 160, '01-04-2018' UNION
  299. SELECT '07-13-1994', 88, '11-14-1994' UNION
  300. SELECT '01-05-1995', 175, '09-07-1995' UNION
  301. SELECT '09-12-2008', 316, '11-30-2009' UNION
  302. SELECT '10-01-2012', 335, '01-13-2014' UNION
  303. SELECT '04-24-1994', 332, '08-01-1995' UNION
  304. SELECT '06-10-1984', 422, '01-21-1986' UNION
  305. SELECT '06-04-1971', 387, '11-28-1972' UNION
  306. SELECT '11-08-2017', 163, '06-25-2018' UNION
  307. SELECT '06-19-2023', 35, '08-07-2023' UNION
  308. SELECT '09-10-2027', 400, '03-23-2029' UNION
  309. SELECT '06-02-2016', 87, '10-03-2016' UNION
  310. SELECT '11-19-2010', 316, '02-06-2012' UNION
  311. SELECT '07-21-1995', 249, '07-04-1996' UNION
  312. SELECT '03-02-2002', 449, '11-20-2003' UNION
  313. SELECT '07-05-1982', 440, '03-12-1984' UNION
  314. SELECT '05-16-2023', 339, '09-02-2024' UNION
  315. SELECT '02-21-1999', 88, '06-23-1999' UNION
  316. SELECT '11-20-1981', 315, '02-04-1983' UNION
  317. SELECT '01-25-2025', 376, '07-06-2026' UNION
  318. SELECT '02-05-1997', 9, '02-18-1997' UNION
  319. SELECT '06-10-2021', 98, '10-26-2021' UNION
  320. SELECT '09-22-1982', 317, '12-09-1983' UNION
  321. SELECT '09-24-1997', 173, '05-25-1998' UNION
  322. SELECT '06-25-2007', 192, '03-19-2008' UNION
  323. SELECT '05-19-2026', 285, '06-22-2027' UNION
  324. SELECT '06-12-1985', 243, '05-19-1986' UNION
  325. SELECT '02-16-2023', 229, '01-03-2024' UNION
  326. SELECT '04-13-1991', 17, '05-07-1991' UNION
  327. SELECT '02-01-1997', 200, '11-07-1997' UNION
  328. SELECT '05-13-1972', 358, '09-26-1973' UNION
  329. SELECT '02-20-1988', 195, '11-18-1988' UNION
  330. SELECT '04-01-1974', 228, '02-13-1975' UNION
  331. SELECT '06-23-1980', 39, '08-15-1980' UNION
  332. SELECT '07-21-1999', 167, '03-10-2000' UNION
  333. SELECT '10-09-1973', 35, '11-27-1973' UNION
  334. SELECT '04-08-1982', 68, '07-13-1982' UNION
  335. SELECT '10-25-1991', 241, '09-28-1992' UNION
  336. SELECT '06-10-1996', 284, '07-11-1997' UNION
  337. SELECT '11-07-2023', 71, '02-14-2024' UNION
  338. SELECT '01-12-2017', 266, '01-19-2018' UNION
  339. SELECT '02-08-1977', 427, '09-28-1978' UNION
  340. SELECT '05-15-2000', 429, '01-04-2002' UNION
  341. SELECT '08-10-1992', 85, '12-07-1992' UNION
  342. SELECT '05-14-1973', 490, '03-31-1975' UNION
  343. SELECT '07-02-2020', 122, '12-21-2020' UNION
  344. SELECT '06-01-1997', 333, '09-09-1998' UNION
  345. SELECT '03-05-1979', 260, '03-03-1980' UNION
  346. SELECT '07-15-1990', 4, '07-19-1990' UNION
  347. SELECT '09-26-1996', 48, '12-03-1996' UNION
  348. SELECT '05-18-1972', 492, '04-08-1974' UNION
  349. SELECT '01-04-1986', 376, '06-15-1987' UNION
  350. SELECT '02-14-1979', 245, '01-23-1980' UNION
  351. SELECT '04-09-1997', 107, '09-05-1997' UNION
  352. SELECT '02-02-1970', 298, '03-25-1971' UNION
  353. SELECT '07-19-1976', 125, '01-10-1977' UNION
  354. SELECT '01-15-1981', 373, '06-22-1982' UNION
  355. SELECT '04-20-1979', 141, '11-05-1979' UNION
  356. SELECT '05-26-1997', 209, '03-13-1998' UNION
  357. SELECT '01-27-2026', 213, '11-20-2026' UNION
  358. SELECT '03-14-1994', 487, '01-24-1996' UNION
  359. SELECT '08-02-2014', 31, '09-15-2014' UNION
  360. SELECT '04-27-1989', 139, '11-08-1989' UNION
  361. SELECT '04-27-2012', 213, '02-20-2013' UNION
  362. SELECT '05-22-2013', 127, '11-15-2013' UNION
  363. SELECT '05-17-2000', 411, '12-13-2001' UNION
  364. SELECT '03-01-1997', 21, '03-31-1997' UNION
  365. SELECT '10-08-1990', 479, '08-07-1992' UNION
  366. SELECT '08-05-1982', 421, '03-16-1984' UNION
  367. SELECT '08-14-1976', 247, '07-26-1977' UNION
  368. SELECT '06-12-2027', 417, '01-16-2029' UNION
  369. SELECT '05-16-1990', 52, '07-27-1990' UNION
  370. SELECT '06-19-1995', 280, '07-15-1996' UNION
  371. SELECT '08-25-1985', 24, '09-26-1985' UNION
  372. SELECT '08-14-2009', 255, '08-06-2010' UNION
  373. SELECT '01-20-2009', 215, '11-17-2009' UNION
  374. SELECT '01-03-1973', 27, '02-09-1973' UNION
  375. SELECT '02-09-1979', 497, '01-06-1981' UNION
  376. SELECT '04-08-2022', 28, '05-18-2022' UNION
  377. SELECT '09-14-2026', 9, '09-25-2026' UNION
  378. SELECT '11-17-2008', 415, '06-21-2010' UNION
  379. SELECT '08-20-1981', 246, '07-30-1982' UNION
  380. SELECT '02-05-2014', 213, '12-01-2014' UNION
  381. SELECT '01-23-1982', 468, '11-09-1983' UNION
  382. SELECT '11-22-2014', 149, '06-18-2015' UNION
  383. SELECT '06-26-1991', 131, '12-26-1991' UNION
  384. SELECT '08-19-1981', 473, '06-13-1983' UNION
  385. SELECT '10-04-1994', 450, '06-25-1996' UNION
  386. SELECT '06-24-1982', 362, '11-14-1983' UNION
  387. SELECT '10-07-1993', 173, '06-07-1994' UNION
  388. SELECT '07-09-1990', 15, '07-30-1990' UNION
  389. SELECT '10-22-2028', 436, '06-24-2030' UNION
  390. SELECT '04-09-1997', 469, '01-26-1999' UNION
  391. SELECT '03-18-2028', 59, '06-08-2028' UNION
  392. SELECT '04-18-2029', 243, '03-25-2030' UNION
  393. SELECT '09-03-1971', 439, '05-10-1973' UNION
  394. SELECT '04-07-1971', 356, '08-17-1972' UNION
  395. SELECT '02-15-1978', 420, '09-26-1979' UNION
  396. SELECT '05-27-2015', 391, '11-24-2016' UNION
  397. SELECT '10-08-1982', 153, '05-11-1983' UNION
  398. SELECT '09-14-2024', 29, '10-24-2024' UNION
  399. SELECT '02-25-2001', 8, '03-07-2001' UNION
  400. SELECT '09-20-2020', 16, '10-12-2020' UNION
  401. SELECT '09-09-1985', 287, '10-15-1986' UNION
  402. SELECT '05-01-2000', 344, '08-24-2001' UNION
  403. SELECT '01-20-2009', 176, '09-23-2009' UNION
  404. SELECT '06-05-2018', 273, '06-21-2019' UNION
  405. SELECT '10-25-1983', 42, '12-22-1983' UNION
  406. SELECT '04-16-1974', 103, '09-06-1974' UNION
  407. SELECT '01-10-1986', 425, '08-28-1987' UNION
  408. SELECT '03-24-1991', 196, '12-23-1991' UNION
  409. SELECT '06-16-1992', 499, '05-16-1994' UNION
  410. SELECT '05-08-1976', 381, '10-24-1977' UNION
  411. SELECT '07-18-2024', 420, '02-26-2026' UNION
  412. SELECT '02-07-1974', 24, '03-13-1974' UNION
  413. SELECT '05-22-2029', 486, '04-02-2031' UNION
  414. SELECT '08-27-2019', 465, '06-08-2021' UNION
  415. SELECT '02-09-1981', 243, '01-14-1982' UNION
  416. SELECT '02-09-1975', 225, '12-19-1975' UNION
  417. SELECT '04-27-1982', 153, '11-26-1982' UNION
  418. SELECT '03-12-2024', 414, '10-13-2025' UNION
  419. SELECT '02-05-2005', 232, '12-27-2005' UNION
  420. SELECT '09-04-2010', 72, '12-14-2010' UNION
  421. SELECT '04-24-2016', 491, '03-12-2018' UNION
  422. SELECT '10-16-1994', 366, '03-11-1996' UNION
  423. SELECT '08-22-2002', 493, '07-13-2004' UNION
  424. SELECT '09-19-1975', 373, '02-23-1977' UNION
  425. SELECT '03-18-1986', 368, '08-14-1987' UNION
  426. SELECT '11-05-1979', 401, '05-19-1981' UNION
  427. SELECT '11-11-2026', 339, '02-29-2028' UNION
  428. SELECT '06-07-1997', 228, '04-22-1998' UNION
  429. SELECT '02-20-2029', 398, '08-30-2030' UNION
  430. SELECT '04-01-1987', 154, '11-03-1987' UNION
  431. SELECT '03-21-2016', 125, '09-12-2016' UNION
  432. SELECT '05-20-1992', 403, '12-06-1993' UNION
  433. SELECT '05-06-1999', 242, '04-10-2000' UNION
  434. SELECT '05-27-1975', 418, '12-31-1976' UNION
  435. SELECT '01-02-1978', 223, '11-09-1978' UNION
  436. SELECT '10-08-2001', 22, '11-07-2001' UNION
  437. SELECT '04-27-1994', 468, '02-12-1996' UNION
  438. SELECT '10-13-1974', 462, '07-20-1976' UNION
  439. SELECT '04-26-1979', 459, '01-28-1981' UNION
  440. SELECT '10-12-1980', 240, '09-11-1981' UNION
  441. SELECT '07-06-1983', 14, '07-26-1983' UNION
  442. SELECT '09-10-1988', 300, '11-03-1989' UNION
  443. SELECT '10-18-1980', 114, '03-26-1981' UNION
  444. SELECT '07-22-1988', 448, '04-11-1990' UNION
  445. SELECT '08-23-2028', 7, '09-01-2028' UNION
  446. SELECT '09-20-1997', 306, '11-23-1998' UNION
  447. SELECT '03-09-2028', 383, '08-28-2029' UNION
  448. SELECT '01-18-1996', 125, '07-11-1996' UNION
  449. SELECT '07-06-2007', 474, '04-30-2009' UNION
  450. SELECT '03-20-2011', 317, '06-05-2012' UNION
  451. SELECT '05-21-2029', 100, '10-08-2029' UNION
  452. SELECT '03-17-1983', 284, '04-18-1984' UNION
  453. SELECT '01-26-2002', 229, '12-12-2002' UNION
  454. SELECT '05-01-1972', 213, '02-22-1973' UNION
  455. SELECT '07-02-2020', 19, '07-29-2020' UNION
  456. SELECT '07-05-1996', 50, '09-13-1996' UNION
  457. SELECT '05-17-1982', 366, '10-11-1983' UNION
  458. SELECT '10-06-1992', 367, '03-03-1994' UNION
  459. SELECT '03-01-2028', 33, '04-17-2028' UNION
  460. SELECT '06-11-1971', 375, '11-17-1972' UNION
  461. SELECT '09-07-2008', 186, '05-25-2009' UNION
  462. SELECT '03-06-1977', 106, '08-01-1977' UNION
  463. SELECT '09-03-2002', 53, '11-15-2002' UNION
  464. SELECT '08-06-1981', 197, '05-10-1982' UNION
  465. SELECT '08-27-1983', 411, '03-25-1985' UNION
  466. SELECT '10-06-2007', 348, '02-04-2009' UNION
  467. SELECT '03-14-2021', 417, '10-18-2022' UNION
  468. SELECT '11-11-1993', 156, '06-17-1994' UNION
  469. SELECT '04-11-1981', 343, '08-04-1982' UNION
  470. SELECT '09-27-1992', 3, '09-30-1992' UNION
  471. SELECT '05-06-1981', 290, '06-16-1982' UNION
  472. SELECT '02-15-2013', 138, '08-28-2013' UNION
  473. SELECT '07-23-1971', 181, '04-03-1972' UNION
  474. SELECT '07-04-2002', 375, '12-11-2003' UNION
  475. SELECT '06-15-2003', 452, '03-08-2005' UNION
  476. SELECT '05-23-2013', 295, '07-10-2014' UNION
  477. SELECT '09-25-1993', 444, '06-08-1995' UNION
  478. SELECT '06-01-1988', 217, '03-31-1989' UNION
  479. SELECT '11-17-2011', 121, '05-04-2012' UNION
  480. SELECT '07-27-2012', 376, '01-06-2014' UNION
  481. SELECT '03-22-2010', 381, '09-06-2011' UNION
  482. SELECT '01-21-1976', 310, '03-30-1977' UNION
  483. SELECT '08-04-1980', 417, '03-10-1982' UNION
  484. SELECT '01-08-1986', 415, '08-12-1987' UNION
  485. SELECT '07-05-2003', 468, '04-20-2005' UNION
  486. SELECT '08-27-1980', 256, '08-20-1981' UNION
  487. SELECT '05-19-2006', 277, '06-12-2007' UNION
  488. SELECT '10-02-2026', 469, '07-20-2028' UNION
  489. SELECT '09-07-2004', 259, '09-05-2005' UNION
  490. SELECT '01-13-2003', 184, '09-26-2003' UNION
  491. SELECT '04-20-1971', 328, '07-21-1972' UNION
  492. SELECT '03-05-1992', 306, '05-07-1993' UNION
  493. SELECT '09-19-2011', 52, '11-30-2011' UNION
  494. SELECT '01-16-1996', 5, '01-23-1996' UNION
  495. SELECT '04-05-1983', 356, '08-15-1984' UNION
  496. SELECT '03-19-1991', 146, '10-09-1991' UNION
  497. SELECT '03-08-2005', 251, '02-22-2006' UNION
  498. SELECT '09-08-2020', 253, '08-27-2021' UNION
  499. SELECT '09-25-1977', 442, '06-05-1979' UNION
  500. SELECT '04-04-2026', 205, '01-15-2027' UNION
  501. SELECT '01-24-1984', 73, '05-04-1984' UNION
  502. SELECT '11-14-1982', 271, '11-28-1983' UNION
  503. SELECT '03-08-1981', 126, '08-31-1981' UNION
  504. SELECT '09-01-2023', 401, '03-17-2025' UNION
  505. SELECT '05-02-2007', 93, '09-10-2007' UNION
  506. SELECT '08-21-2025', 466, '06-04-2027' UNION
  507. SELECT '02-27-2001', 311, '05-08-2002' UNION
  508. SELECT '08-02-1976', 456, '05-02-1978' UNION
  509. SELECT '09-13-1979', 146, '04-04-1980' UNION
  510. SELECT '06-03-1991', 328, '09-03-1992' UNION
  511. SELECT '08-09-2011', 304, '10-08-2012' UNION
  512. SELECT '01-17-1998', 180, '09-25-1998' UNION
  513. SELECT '02-08-2017', 260, '02-07-2018' UNION
  514. SELECT '11-14-1985', 288, '12-23-1986' UNION
  515. SELECT '11-18-1987', 14, '12-08-1987' UNION
  516. SELECT '10-12-2027', 256, '10-04-2028' UNION
  517. SELECT '05-03-1979', 73, '08-14-1979' UNION
  518. SELECT '08-12-1987', 44, '10-13-1987' UNION
  519. SELECT '05-14-1989', 101, '10-02-1989' UNION
  520. SELECT '02-13-1991', 246, '01-23-1992' UNION
  521. SELECT '07-23-2003', 498, '06-20-2005' UNION
  522. SELECT '07-18-1995', 107, '12-14-1995' UNION
  523. SELECT '10-01-1985', 219, '08-04-1986' UNION
  524. SELECT '01-19-2024', 403, '08-06-2025' UNION
  525. SELECT '09-13-1987', 50, '11-20-1987' UNION
  526. SELECT '06-03-2026', 38, '07-27-2026' UNION
  527. SELECT '02-06-2010', 429, '09-29-2011' UNION
  528. SELECT '04-06-1997', 58, '06-25-1997' UNION
  529. SELECT '02-13-1997', 167, '10-06-1997' UNION
  530. SELECT '05-03-1973', 305, '07-04-1974' UNION
  531. SELECT '10-24-2013', 193, '07-22-2014' UNION
  532. SELECT '01-06-2012', 134, '07-12-2012' UNION
  533. SELECT '08-25-2012', 281, '09-23-2013' UNION
  534. SELECT '04-16-2013', 49, '06-24-2013' UNION
  535. SELECT '09-09-2002', 120, '02-24-2003' UNION
  536. SELECT '09-21-1991', 492, '08-10-1993' UNION
  537. SELECT '10-27-2010', 381, '04-12-2012' UNION
  538. SELECT '04-21-2005', 425, '12-07-2006' UNION
  539. SELECT '10-11-2011', 30, '11-22-2011' UNION
  540. SELECT '08-10-2004', 334, '11-21-2005' UNION
  541. SELECT '11-05-2029', 379, '04-18-2031' UNION
  542. SELECT '08-11-1991', 55, '10-25-1991' UNION
  543. SELECT '05-22-2004', 152, '12-21-2004' UNION
  544. SELECT '10-07-1976', 465, '07-20-1978' UNION
  545. SELECT '10-20-1976', 411, '05-18-1978' UNION
  546. SELECT '05-19-1971', 170, '01-12-1972' UNION
  547. SELECT '01-24-2026', 440, '10-01-2027' UNION
  548. SELECT '06-14-2028', 429, '02-05-2030' UNION
  549. SELECT '08-07-1993', 219, '06-09-1994' UNION
  550. SELECT '01-17-2008', 9, '01-30-2008' UNION
  551. SELECT '10-06-1999', 114, '03-14-2000' UNION
  552. SELECT '05-21-2004', 420, '12-30-2005' UNION
  553. SELECT '05-26-2005', 343, '09-19-2006' UNION
  554. SELECT '06-18-2028', 281, '07-16-2029' UNION
  555. SELECT '09-23-1984', 150, '04-19-1985' UNION
  556. SELECT '06-04-2017', 40, '07-28-2017' UNION
  557. SELECT '11-25-2020', 227, '10-08-2021' UNION
  558. SELECT '09-08-2006', 53, '11-22-2006' UNION
  559. SELECT '08-09-1986', 84, '12-04-1986' UNION
  560. SELECT '05-21-1984', 243, '04-25-1985' UNION
  561. SELECT '01-08-1989', 266, '01-15-1990' UNION
  562. SELECT '10-24-2002', 422, '06-07-2004' UNION
  563. SELECT '08-06-1970', 410, '03-02-1972' UNION
  564. SELECT '04-07-1980', 486, '02-16-1982' UNION
  565. SELECT '02-11-2013', 321, '05-06-2014' UNION
  566. SELECT '04-07-2001', 386, '09-30-2002' UNION
  567. SELECT '10-12-1979', 143, '04-30-1980' UNION
  568. SELECT '06-09-1982', 399, '12-20-1983' UNION
  569. SELECT '04-27-1972', 381, '10-12-1973' UNION
  570. SELECT '07-15-1983', 9, '07-28-1983' UNION
  571. SELECT '01-12-1972', 456, '10-11-1973' UNION
  572. SELECT '06-25-2007', 479, '04-24-2009' UNION
  573. SELECT '04-12-1997', 67, '07-15-1997' UNION
  574. SELECT '02-26-1974', 18, '03-22-1974' UNION
  575. SELECT '06-11-2017', 352, '10-16-2018' UNION
  576. SELECT '07-18-1995', 272, '08-01-1996' UNION
  577. SELECT '05-21-1992', 423, '01-04-1994' UNION
  578. SELECT '06-21-1990', 64, '09-19-1990' UNION
  579. SELECT '04-17-2004', 229, '03-03-2005' UNION
  580. SELECT '04-05-2020', 340, '07-23-2021' UNION
  581. SELECT '05-23-2025', 424, '01-07-2027' UNION
  582. SELECT '03-20-1971', 462, '12-26-1972' UNION
  583. SELECT '11-27-1992', 349, '03-31-1994' UNION
  584. SELECT '10-17-1983', 227, '08-29-1984' UNION
  585. SELECT '10-15-1996', 111, '03-19-1997' UNION
  586. SELECT '01-17-2012', 496, '12-11-2013' UNION
  587. SELECT '04-16-2006', 354, '08-23-2007' UNION
  588. SELECT '06-06-2001', 232, '04-26-2002' UNION
  589. SELECT '08-22-1992', 484, '06-30-1994' UNION
  590. SELECT '09-14-2015', 90, '01-18-2016' UNION
  591. SELECT '10-13-2009', 198, '07-16-2010' UNION
  592. SELECT '01-25-1999', 371, '06-27-2000' UNION
  593. SELECT '02-01-2015', 477, '11-29-2016' UNION
  594. SELECT '11-27-2016', 421, '07-09-2018' UNION
  595. SELECT '10-07-2019', 360, '02-22-2021' UNION
  596. SELECT '01-11-2007', 442, '09-22-2008' UNION
  597. SELECT '06-09-2015', 260, '06-07-2016' UNION
  598. SELECT '07-19-1972', 323, '10-15-1973' UNION
  599. SELECT '05-16-1992', 426, '01-03-1994' UNION
  600. SELECT '03-14-2006', 279, '04-09-2007' UNION
  601. SELECT '10-26-1994', 194, '07-25-1995' UNION
  602. SELECT '03-19-1998', 220, '01-21-1999' UNION
  603. SELECT '11-04-2013', 465, '08-17-2015' UNION
  604. SELECT '09-15-2002', 320, '12-05-2003' UNION
  605. SELECT '07-18-1996', 494, '06-10-1998' UNION
  606. SELECT '05-19-2013', 65, '08-16-2013' UNION
  607. SELECT '05-16-1997', 207, '03-03-1998' UNION
  608. SELECT '02-07-1992', 302, '04-06-1993' UNION
  609. SELECT '08-09-1990', 403, '02-25-1992' UNION
  610. SELECT '01-12-1974', 260, '01-10-1975' UNION
  611. SELECT '10-22-2019', 50, '12-31-2019' UNION
  612. SELECT '09-03-1999', 294, '10-19-2000' UNION
  613. SELECT '11-11-2018', 15, '11-30-2018' UNION
  614. SELECT '06-23-2004', 7, '07-02-2004' UNION
  615. SELECT '09-26-1977', 48, '12-01-1977' UNION
  616. SELECT '03-02-2009', 296, '04-20-2010' UNION
  617. SELECT '06-17-2012', 434, '02-13-2014' UNION
  618. SELECT '09-16-1998', 219, '07-20-1999' UNION
  619. SELECT '02-05-1980', 415, '09-08-1981' UNION
  620. SELECT '07-18-2005', 346, '11-14-2006' UNION
  621. SELECT '11-17-1986', 225, '09-28-1987' UNION
  622. SELECT '03-01-2013', 414, '10-02-2014' UNION
  623. SELECT '04-19-2020', 128, '10-14-2020' UNION
  624. SELECT '04-24-1974', 274, '05-13-1975' UNION
  625. SELECT '03-11-2019', 477, '01-06-2021' UNION
  626. SELECT '03-04-1979', 30, '04-13-1979' UNION
  627. SELECT '11-24-1991', 229, '10-08-1992' UNION
  628. SELECT '01-12-1990', 259, '01-10-1991' UNION
  629. SELECT '03-23-1980', 335, '07-03-1981' UNION
  630. SELECT '07-24-2010', 256, '07-18-2011' UNION
  631. SELECT '09-01-2000', 83, '12-27-2000' UNION
  632. SELECT '04-10-1973', 425, '11-26-1974' UNION
  633. SELECT '07-01-1985', 189, '03-21-1986' UNION
  634. SELECT '08-15-1982', 24, '09-16-1982' UNION
  635. SELECT '06-03-2022', 377, '11-14-2023' UNION
  636. SELECT '07-14-1990', 416, '02-17-1992' UNION
  637. SELECT '02-03-2022', 414, '09-06-2023' UNION
  638. SELECT '03-24-1999', 99, '08-10-1999' UNION
  639. SELECT '10-13-1990', 199, '07-18-1991' UNION
  640. SELECT '11-27-1982', 20, '12-24-1982' UNION
  641. SELECT '01-06-2005', 361, '05-26-2006' UNION
  642. SELECT '01-09-2029', 243, '12-14-2029' UNION
  643. SELECT '09-22-2012', 61, '12-17-2012' UNION
  644. SELECT '02-05-2001', 471, '11-26-2002' UNION
  645. SELECT '03-08-1986', 446, '11-23-1987' UNION
  646. SELECT '06-10-1983', 33, '07-27-1983' UNION
  647. SELECT '09-02-2014', 166, '04-22-2015' UNION
  648. SELECT '02-23-1984', 460, '11-28-1985' UNION
  649. SELECT '01-05-2002', 162, '08-20-2002' UNION
  650. SELECT '09-23-1991', 412, '04-21-1993' UNION
  651. SELECT '07-04-2021', 365, '11-25-2022' UNION
  652. SELECT '09-19-1993', 109, '02-17-1994' UNION
  653. SELECT '06-04-2012', 4, '06-08-2012' UNION
  654. SELECT '02-22-2009', 30, '04-03-2009' UNION
  655. SELECT '02-27-2009', 92, '07-07-2009' UNION
  656. SELECT '11-07-1970', 292, '12-21-1971' UNION
  657. SELECT '10-16-2025', 228, '09-01-2026' UNION
  658. SELECT '10-16-2027', 257, '10-10-2028' UNION
  659. SELECT '06-01-1991', 315, '08-14-1992' UNION
  660. SELECT '07-19-1995', 488, '06-02-1997' UNION
  661. SELECT '10-18-1977', 368, '03-16-1979' UNION
  662. SELECT '10-08-1970', 219, '08-11-1971' UNION
  663. SELECT '02-19-1984', 116, '07-30-1984' UNION
  664. SELECT '08-23-2016', 442, '05-03-2018' UNION
  665. SELECT '06-22-1990', 257, '06-18-1991' UNION
  666. SELECT '03-07-1980', 426, '10-26-1981' UNION
  667. SELECT '07-18-2025', 96, '12-01-2025' UNION
  668. SELECT '02-18-1974', 17, '03-13-1974' UNION
  669. SELECT '01-02-1997', 91, '05-09-1997' UNION
  670. SELECT '06-16-1990', 42, '08-14-1990' UNION
  671. SELECT '02-06-2006', 431, '10-02-2007' UNION
  672. SELECT '04-20-1980', 352, '08-25-1981' UNION
  673. SELECT '02-08-2008', 447, '10-27-2009' UNION
  674. SELECT '02-22-2018', 452, '11-18-2019' UNION
  675. SELECT '09-22-2003', 201, '06-29-2004' UNION
  676. SELECT '01-10-1980', 33, '02-26-1980' UNION
  677. SELECT '07-21-1997', 384, '01-08-1999' UNION
  678. SELECT '07-15-2005', 419, '02-22-2007' UNION
  679. SELECT '08-25-2027', 21, '09-23-2027' UNION
  680. SELECT '05-19-1971', 290, '06-28-1972' UNION
  681. SELECT '11-15-2022', 463, '08-23-2024' UNION
  682. SELECT '09-07-2023', 151, '04-05-2024' UNION
  683. SELECT '02-17-1982', 282, '03-18-1983' UNION
  684. SELECT '02-25-2011', 272, '03-13-2012' UNION
  685. SELECT '02-11-2016', 274, '03-01-2017' UNION
  686. SELECT '11-03-2004', 5, '11-10-2004' UNION
  687. SELECT '05-26-2006', 44, '07-27-2006' UNION
  688. SELECT '09-24-1985', 84, '01-20-1986' UNION
  689. SELECT '03-15-1976', 117, '08-25-1976' UNION
  690. SELECT '05-05-2001', 359, '09-19-2002' UNION
  691. SELECT '06-16-1994', 223, '04-25-1995' UNION
  692. SELECT '11-04-1971', 387, '04-30-1973' UNION
  693. SELECT '04-08-2019', 438, '12-10-2020' UNION
  694. SELECT '02-01-2029', 448, '10-22-2030' UNION
  695. SELECT '06-09-2020', 227, '04-22-2021' UNION
  696. SELECT '02-02-2017', 229, '12-20-2017' UNION
  697. SELECT '05-13-1985', 232, '04-02-1986' UNION
  698. SELECT '08-01-2008', 169, '03-26-2009' UNION
  699. SELECT '08-04-2028', 52, '10-17-2028' UNION
  700. SELECT '08-27-1994', 314, '11-09-1995' UNION
  701. SELECT '02-08-1988', 451, '10-31-1989' UNION
  702. SELECT '01-05-1999', 491, '11-22-2000' UNION
  703. SELECT '08-11-1983', 496, '07-05-1985' UNION
  704. SELECT '08-25-1976', 137, '03-04-1977' UNION
  705. SELECT '02-05-1995', 286, '03-11-1996' UNION
  706. SELECT '08-04-2001', 77, '11-20-2001' UNION
  707. SELECT '11-25-1990', 154, '06-27-1991' UNION
  708. SELECT '10-14-2029', 90, '02-15-2030' UNION
  709. SELECT '08-05-2002', 313, '10-16-2003' UNION
  710. SELECT '02-27-2022', 125, '08-19-2022' UNION
  711. SELECT '06-07-1986', 1, '06-09-1986' UNION
  712. SELECT '01-07-1986', 129, '07-07-1986' UNION
  713. SELECT '10-19-2015', 158, '05-26-2016' UNION
  714. SELECT '05-04-1998', 312, '07-14-1999' UNION
  715. SELECT '02-16-1971', 280, '03-14-1972' UNION
  716. SELECT '10-27-1976', 159, '06-07-1977' UNION
  717. SELECT '03-13-1979', 210, '01-01-1980' UNION
  718. SELECT '04-11-2003', 140, '10-24-2003' UNION
  719. SELECT '11-09-1977', 21, '12-08-1977' UNION
  720. SELECT '02-24-1995', 153, '09-27-1995' UNION
  721. SELECT '08-15-2012', 60, '11-07-2012' UNION
  722. SELECT '02-20-1983', 61, '05-16-1983' UNION
  723. SELECT '06-17-2004', 379, '11-30-2005' UNION
  724. SELECT '05-04-2004', 201, '02-09-2005' UNION
  725. SELECT '11-23-1998', 32, '01-06-1999' UNION
  726. SELECT '09-19-2004', 233, '08-10-2005' UNION
  727. SELECT '05-06-1997', 270, '05-19-1998' UNION
  728. SELECT '01-06-1976', 449, '09-26-1977' UNION
  729. SELECT '03-24-1983', 231, '02-10-1984' UNION
  730. SELECT '10-03-1989', 494, '08-26-1991' UNION
  731. SELECT '04-23-2000', 15, '05-12-2000' UNION
  732. SELECT '08-20-2012', 358, '01-02-2014' UNION
  733. SELECT '10-16-2017', 254, '10-05-2018' UNION
  734. SELECT '09-20-1987', 447, '06-06-1989' UNION
  735. SELECT '01-18-2026', 409, '08-12-2027' UNION
  736. SELECT '02-01-2028', 256, '01-24-2029' UNION
  737. SELECT '08-15-1990', 156, '03-21-1991' UNION
  738. SELECT '08-03-2002', 298, '09-24-2003' UNION
  739. SELECT '10-16-2019', 123, '04-06-2020' UNION
  740. SELECT '08-21-2027', 405, '03-09-2029' UNION
  741. SELECT '06-21-2011', 107, '11-17-2011' UNION
  742. SELECT '08-17-1999', 207, '06-01-2000' UNION
  743. SELECT '11-14-2001', 119, '04-30-2002' UNION
  744. SELECT '04-01-1982', 168, '11-23-1982' UNION
  745. SELECT '04-19-1989', 3, '04-24-1989' UNION
  746. SELECT '05-05-1977', 53, '07-19-1977' UNION
  747. SELECT '11-19-2019', 214, '09-14-2020' UNION
  748. SELECT '06-26-1985', 138, '01-06-1986' UNION
  749. SELECT '10-04-1988', 249, '09-18-1989' UNION
  750. SELECT '09-01-1994', 327, '12-04-1995' UNION
  751. SELECT '02-22-1974', 291, '04-07-1975' UNION
  752. SELECT '10-11-1979', 275, '10-30-1980' UNION
  753. SELECT '03-25-2020', 319, '06-15-2021' UNION
  754. SELECT '09-19-2028', 150, '04-17-2029' UNION
  755. SELECT '08-11-1988', 263, '08-15-1989' UNION
  756. SELECT '03-05-1970', 21, '04-03-1970' UNION
  757. SELECT '03-25-1972', 180, '12-01-1972' UNION
  758. SELECT '06-25-1979', 265, '06-30-1980' UNION
  759. SELECT '01-25-1988', 2, '01-27-1988' UNION
  760. SELECT '07-26-2006', 486, '06-05-2008' UNION
  761. SELECT '02-16-2005', 14, '03-08-2005' UNION
  762. SELECT '04-09-2003', 278, '05-03-2004' UNION
  763. SELECT '10-06-1979', 385, '03-27-1981' UNION
  764. SELECT '06-18-1993', 448, '03-08-1995' UNION
  765. SELECT '09-15-2027', 463, '06-25-2029' UNION
  766. SELECT '01-11-2025', 164, '08-28-2025' UNION
  767. SELECT '05-09-1988', 468, '02-22-1990' UNION
  768. SELECT '08-19-2020', 361, '01-06-2022' UNION
  769. SELECT '05-26-2012', 434, '01-23-2014' UNION
  770. SELECT '02-13-2006', 372, '07-18-2007' UNION
  771. SELECT '05-06-2026', 164, '12-22-2026' UNION
  772. SELECT '02-04-1989', 411, '09-03-1990' UNION
  773. SELECT '01-02-1992', 435, '09-02-1993' UNION
  774. SELECT '01-02-1972', 284, '02-01-1973' UNION
  775. SELECT '03-20-2014', 84, '07-16-2014' UNION
  776. SELECT '05-20-2027', 236, '04-14-2028' UNION
  777. SELECT '06-02-1978', 482, '04-08-1980' UNION
  778. SELECT '09-09-2003', 408, '04-01-2005' UNION
  779. SELECT '09-27-1985', 277, '10-21-1986' UNION
  780. SELECT '01-01-2019', 74, '04-15-2019' UNION
  781. SELECT '06-15-1985', 404, '01-01-1987' UNION
  782. SELECT '10-19-2007', 344, '02-12-2009' UNION
  783. SELECT '05-04-1992', 172, '12-30-1992' UNION
  784. SELECT '04-22-1994', 285, '05-26-1995' UNION
  785. SELECT '08-06-2008', 425, '03-24-2010' UNION
  786. SELECT '02-08-1974', 298, '04-02-1975' UNION
  787. SELECT '03-17-2013', 118, '08-28-2013' UNION
  788. SELECT '06-21-1971', 332, '09-27-1972' UNION
  789. SELECT '07-25-1984', 228, '06-10-1985' UNION
  790. SELECT '11-23-2018', 157, '07-02-2019' UNION
  791. SELECT '05-16-2017', 91, '09-20-2017' UNION
  792. SELECT '11-12-2008', 473, '09-06-2010' UNION
  793. SELECT '05-25-1971', 47, '07-29-1971' UNION
  794. SELECT '02-02-2022', 38, '03-28-2022' UNION
  795. SELECT '11-03-1984', 197, '08-06-1985' UNION
  796. SELECT '05-19-1982', 439, '01-24-1984' UNION
  797. SELECT '06-03-2007', 414, '01-01-2009' UNION
  798. SELECT '04-21-1993', 366, '09-15-1994' UNION
  799. SELECT '10-02-2023', 351, '02-04-2025' UNION
  800. SELECT '01-26-2005', 389, '07-25-2006' UNION
  801. SELECT '08-06-2019', 299, '09-28-2020' UNION
  802. SELECT '08-22-2005', 46, '10-25-2005' UNION
  803. SELECT '10-06-2000', 426, '05-27-2002' UNION
  804. SELECT '05-03-2020', 170, '12-25-2020' UNION
  805. SELECT '08-16-2012', 90, '12-20-2012' UNION
  806. SELECT '07-15-2021', 345, '11-10-2022' UNION
  807. SELECT '02-06-2009', 496, '01-03-2011' UNION
  808. SELECT '05-14-1975', 73, '08-25-1975' UNION
  809. SELECT '04-16-1970', 271, '04-30-1971' UNION
  810. SELECT '01-08-1983', 484, '11-15-1984' UNION
  811. SELECT '01-09-2010', 276, '01-31-2011' UNION
  812. SELECT '10-25-1976', 220, '08-29-1977' UNION
  813. SELECT '08-27-2016', 438, '05-02-2018' UNION
  814. SELECT '09-25-2001', 122, '03-14-2002' UNION
  815. SELECT '06-26-1976', 207, '04-12-1977' UNION
  816. SELECT '09-01-1996', 73, '12-11-1996' UNION
  817. SELECT '01-23-1991', 266, '01-30-1992' UNION
  818. SELECT '07-04-2022', 322, '09-27-2023' UNION
  819. SELECT '07-14-1995', 426, '03-03-1997' UNION
  820. SELECT '01-16-1985', 377, '06-27-1986' UNION
  821. SELECT '09-06-1986', 182, '05-19-1987' UNION
  822. SELECT '07-17-1992', 120, '01-01-1993' UNION
  823. SELECT '04-12-1992', 347, '08-10-1993' UNION
  824. SELECT '10-15-1977', 438, '06-20-1979' UNION
  825. SELECT '02-06-2029', 14, '02-26-2029' UNION
  826. SELECT '05-16-1973', 104, '10-09-1973' UNION
  827. SELECT '04-13-2006', 466, '01-25-2008' UNION
  828. SELECT '01-27-1985', 54, '04-11-1985' UNION
  829. SELECT '02-04-2026', 337, '05-21-2027' UNION
  830. SELECT '08-21-2004', 369, '01-19-2006' UNION
  831. SELECT '07-05-1997', 277, '07-28-1998' UNION
  832. SELECT '05-14-1977', 272, '05-30-1978' UNION
  833. SELECT '07-24-1974', 45, '09-25-1974' UNION
  834. SELECT '07-19-2018', 453, '04-14-2020' UNION
  835. SELECT '01-21-1982', 15, '02-11-1982' UNION
  836. SELECT '08-27-1979', 154, '03-28-1980' UNION
  837. SELECT '04-21-1990', 475, '02-14-1992' UNION
  838. SELECT '10-08-2014', 180, '06-17-2015' UNION
  839. SELECT '06-16-1994', 228, '05-02-1995' UNION
  840. SELECT '01-03-1982', 95, '05-14-1982' UNION
  841. SELECT '11-24-2019', 319, '02-11-2021' UNION
  842. SELECT '10-09-1982', 194, '07-07-1983' UNION
  843. SELECT '03-13-1999', 287, '04-18-2000' UNION
  844. SELECT '09-16-2023', 383, '03-05-2025' UNION
  845. SELECT '10-06-2007', 404, '04-23-2009' UNION
  846. SELECT '07-22-2010', 108, '12-21-2010' UNION
  847. SELECT '06-19-1989', 170, '02-12-1990' UNION
  848. SELECT '03-19-2028', 97, '08-01-2028' UNION
  849. SELECT '07-06-2025', 123, '12-24-2025' UNION
  850. SELECT '04-03-2019', 224, '02-11-2020' UNION
  851. SELECT '04-13-1970', 250, '03-29-1971' UNION
  852. SELECT '08-13-1992', 330, '11-18-1993' UNION
  853. SELECT '09-23-2022', 181, '06-05-2023' UNION
  854. SELECT '03-15-2017', 133, '09-18-2017' UNION
  855. SELECT '08-09-1975', 360, '12-24-1976' UNION
  856. SELECT '11-11-1982', 125, '05-05-1983' UNION
  857. SELECT '04-18-2002', 159, '11-27-2002' UNION
  858. SELECT '04-26-2002', 145, '11-15-2002' UNION
  859. SELECT '09-22-2015', 154, '04-25-2016' UNION
  860. SELECT '04-23-1976', 305, '06-24-1977' UNION
  861. SELECT '01-13-1971', 87, '05-14-1971' UNION
  862. SELECT '04-11-1994', 331, '07-18-1995' UNION
  863. SELECT '11-05-1972', 84, '03-01-1973' UNION
  864. SELECT '05-07-1971', 23, '06-09-1971' UNION
  865. SELECT '03-26-2027', 52, '06-08-2027' UNION
  866. SELECT '02-04-1974', 269, '02-14-1975' UNION
  867. SELECT '06-17-2021', 15, '07-08-2021' UNION
  868. SELECT '03-05-1998', 393, '09-07-1999' UNION
  869. SELECT '08-19-2018', 85, '12-14-2018' UNION
  870. SELECT '03-23-2000', 102, '08-14-2000' UNION
  871. SELECT '11-08-2022', 304, '01-08-2024' UNION
  872. SELECT '09-08-1981', 191, '06-02-1982' UNION
  873. SELECT '09-10-2000', 444, '05-23-2002' UNION
  874. SELECT '09-15-1990', 430, '05-08-1992' UNION
  875. SELECT '11-09-2024', 433, '07-08-2026' UNION
  876. SELECT '05-06-2013', 417, '12-10-2014' UNION
  877. SELECT '04-10-2015', 167, '12-01-2015' UNION
  878. SELECT '01-15-2010', 361, '06-06-2011' UNION
  879. SELECT '09-07-1991', 47, '11-12-1991' UNION
  880. SELECT '06-10-2023', 40, '08-04-2023' UNION
  881. SELECT '03-14-1986', 361, '08-03-1987' UNION
  882. SELECT '04-12-2021', 40, '06-07-2021' UNION
  883. SELECT '10-08-1979', 288, '11-13-1980' UNION
  884. SELECT '11-13-2024', 253, '11-03-2025' UNION
  885. SELECT '05-23-2017', 413, '12-21-2018' UNION
  886. SELECT '11-20-1995', 218, '09-19-1996' UNION
  887. SELECT '07-15-1982', 295, '09-01-1983' UNION
  888. SELECT '05-27-2000', 200, '03-02-2001' UNION
  889. SELECT '03-16-2004', 248, '02-25-2005' UNION
  890. SELECT '06-27-2021', 243, '06-01-2022' UNION
  891. SELECT '04-05-2025', 413, '11-04-2026' UNION
  892. SELECT '11-22-2019', 193, '08-19-2020' UNION
  893. SELECT '08-09-1986', 221, '06-15-1987' UNION
  894. SELECT '06-18-2009', 176, '02-19-2010' UNION
  895. SELECT '01-15-2000', 113, '06-21-2000' UNION
  896. SELECT '10-16-2015', 359, '03-02-2017' UNION
  897. SELECT '10-01-2022', 339, '01-18-2024' UNION
  898. SELECT '11-18-1993', 161, '07-01-1994' UNION
  899. SELECT '04-25-1997', 74, '08-07-1997' UNION
  900. SELECT '10-17-2015', 116, '03-28-2016' UNION
  901. SELECT '02-09-2019', 390, '08-07-2020' UNION
  902. SELECT '06-20-1978', 24, '07-24-1978' UNION
  903. SELECT '03-27-2004', 386, '09-19-2005' UNION
  904. SELECT '09-20-2026', 39, '11-12-2026' UNION
  905. SELECT '06-26-2011', 480, '04-26-2013' UNION
  906. SELECT '02-27-2027', 147, '09-21-2027' UNION
  907. SELECT '11-27-1974', 153, '06-30-1975' UNION
  908. SELECT '06-17-2007', 313, '08-27-2008' UNION
  909. SELECT '04-11-1997', 307, '06-16-1998' UNION
  910. SELECT '09-16-2002', 167, '05-07-2003' UNION
  911. SELECT '11-03-1977', 76, '02-17-1978' UNION
  912. SELECT '10-11-2029', 355, '02-20-2031' UNION
  913. SELECT '10-13-2007', 146, '05-05-2008' UNION
  914. SELECT '08-08-2025', 346, '12-07-2026' UNION
  915. SELECT '01-20-1978', 77, '05-09-1978' UNION
  916. SELECT '05-12-2003', 34, '06-27-2003' UNION
  917. SELECT '04-09-2008', 328, '07-13-2009' UNION
  918. SELECT '02-15-1990', 448, '11-05-1991' UNION
  919. SELECT '07-23-2022', 6, '08-01-2022' UNION
  920. SELECT '10-09-1971', 92, '02-15-1972' UNION
  921. SELECT '03-19-2006', 400, '09-28-2007' UNION
  922. SELECT '04-19-1973', 402, '11-04-1974' UNION
  923. SELECT '08-13-1971', 258, '08-09-1972' UNION
  924. SELECT '05-22-1975', 344, '09-15-1976' UNION
  925. SELECT '01-14-2001', 321, '04-08-2002' UNION
  926. SELECT '08-10-2004', 251, '07-27-2005' UNION
  927. SELECT '07-12-1986', 151, '02-09-1987' UNION
  928. SELECT '03-18-2019', 148, '10-10-2019' UNION
  929. SELECT '06-15-2013', 140, '12-27-2013' UNION
  930. SELECT '07-01-2014', 163, '02-13-2015' UNION
  931. SELECT '06-18-2009', 319, '09-08-2010' UNION
  932. SELECT '01-22-2008', 224, '12-01-2008' UNION
  933. SELECT '02-14-2020', 497, '01-11-2022' UNION
  934. SELECT '08-17-1989', 439, '04-24-1991' UNION
  935. SELECT '02-15-2024', 250, '01-30-2025' UNION
  936. SELECT '05-27-2023', 384, '11-14-2024' UNION
  937. SELECT '02-22-1972', 278, '03-16-1973' UNION
  938. SELECT '06-26-2022', 451, '03-18-2024' UNION
  939. SELECT '03-27-1971', 31, '05-10-1971' UNION
  940. SELECT '08-24-1975', 125, '02-13-1976' UNION
  941. SELECT '11-13-2014', 333, '02-23-2016' UNION
  942. SELECT '08-27-2016', 33, '10-12-2016' UNION
  943. SELECT '08-11-2024', 285, '09-12-2025' UNION
  944. SELECT '06-12-1976', 129, '12-09-1976' UNION
  945. SELECT '10-17-2001', 234, '09-10-2002' UNION
  946. SELECT '03-16-1983', 170, '11-09-1983' UNION
  947. SELECT '07-27-1982', 69, '11-01-1982' UNION
  948. SELECT '07-22-2010', 90, '11-25-2010' UNION
  949. SELECT '03-21-1989', 459, '12-24-1990' UNION
  950. SELECT '04-27-2026', 186, '01-12-2027' UNION
  951. SELECT '09-18-1982', 99, '02-03-1983' UNION
  952. SELECT '05-22-1977', 255, '05-12-1978' UNION
  953. SELECT '08-15-2015', 111, '01-18-2016' UNION
  954. SELECT '05-01-1977', 242, '04-04-1978' UNION
  955. SELECT '02-13-1993', 93, '06-23-1993' UNION
  956. SELECT '10-11-2011', 180, '06-19-2012' UNION
  957. SELECT '03-07-2022', 416, '10-10-2023' UNION
  958. SELECT '06-09-2015', 99, '10-26-2015' UNION
  959. SELECT '03-08-2021', 250, '02-21-2022' UNION
  960. SELECT '05-06-2006', 419, '12-13-2007' UNION
  961. SELECT '06-11-2017', 470, '03-29-2019' UNION
  962. SELECT '07-02-1970', 467, '04-17-1972' UNION
  963. SELECT '04-15-1985', 410, '11-10-1986' UNION
  964. SELECT '09-19-2021', 189, '06-09-2022' UNION
  965. SELECT '04-09-1989', 464, '01-17-1991' UNION
  966. SELECT '11-21-1977', 116, '05-02-1978' UNION
  967. SELECT '04-10-1994', 454, '01-04-1996' UNION
  968. SELECT '06-24-1977', 7, '07-05-1977' UNION
  969. SELECT '07-11-2024', 117, '12-23-2024' UNION
  970. SELECT '06-10-1996', 156, '01-14-1997' UNION
  971. SELECT '04-16-1978', 238, '03-14-1979' UNION
  972. SELECT '06-09-2029', 26, '07-16-2029' UNION
  973. SELECT '10-05-2002', 165, '05-23-2003' UNION
  974. SELECT '04-20-1973', 410, '11-15-1974' UNION
  975. SELECT '02-15-2012', 332, '05-24-2013' UNION
  976. SELECT '02-22-1982', 365, '07-18-1983' UNION
  977. SELECT '06-25-1994', 124, '12-15-1994' UNION
  978. SELECT '05-26-1994', 438, '01-30-1996' UNION
  979. SELECT '01-22-2025', 403, '08-10-2026' UNION
  980. SELECT '04-07-1992', 453, '12-31-1993' UNION
  981. SELECT '04-10-1970', 120, '09-25-1970' UNION
  982. SELECT '06-26-1991', 305, '08-26-1992' UNION
  983. SELECT '07-15-2023', 143, '01-31-2024' UNION
  984. SELECT '08-03-2025', 3, '08-06-2025' UNION
  985. SELECT '10-03-2000', 240, '09-04-2001' UNION
  986. SELECT '01-18-2004', 53, '03-31-2004' UNION
  987. SELECT '04-11-2026', 28, '05-20-2026' UNION
  988. SELECT '11-12-2000', 209, '08-30-2001' UNION
  989. SELECT '07-18-2024', 454, '04-15-2026' UNION
  990. SELECT '07-11-2016', 430, '03-05-2018' UNION
  991. SELECT '04-10-2003', 414, '11-10-2004' UNION
  992. SELECT '08-26-2024', 122, '02-12-2025' UNION
  993. SELECT '09-09-2024', 265, '09-15-2025' UNION
  994. SELECT '09-09-1982', 463, '06-19-1984' UNION
  995. SELECT '03-08-2009', 30, '04-17-2009' UNION
  996. SELECT '10-03-1978', 493, '08-22-1980' UNION
  997. SELECT '02-11-1978', 147, '09-05-1978' UNION
  998. SELECT '03-07-1971', 469, '12-21-1972' UNION
  999. SELECT '03-26-1998', 134, '09-30-1998' UNION
  1000. SELECT '09-06-2013', 148, '04-02-2014' UNION
  1001. SELECT '02-05-1990', 366, '07-02-1991' UNION
  1002. SELECT '10-06-2006', 78, '01-24-2007' UNION
  1003. SELECT '09-07-1987', 263, '09-08-1988' UNION
  1004. SELECT '04-20-1986', 328, '07-22-1987') AS DATA
  1005. ORDER BY expected_result
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement