TSQL Challenge 19 - All solutions

Here is the list of submissions we received for TSQL Challenge 19.

1	Aleksey Shtepa	Aleksey_Shtepa_tsqlchallenge_19.sql
2	angella jagdeo	angella_jagdeo_tsqlchallenge_19.sql
3	anulas vp	anulas_vp_tsqlchallenge_19.sql
4	Arshad Kalam	Arshad_Kalam_TSQLChallange19.sql
5	arshad kalam	TSQL challange 19.sql
6	Bharath Chummalkar	Bharath_Chummalkar_tsqlchallenge_19.sql
7	bret warnick	bret_warnick_tsqlchallenge_19.sql
8	Carl Federl	Carl_Federl_TSQLChallenge_19.sql
9	Carl Federl	Carl_Federl_TSQLChallenge_19_v2.sql
10	chenghui wang	chenghui_wang_tsqlchallenge_19.sql
11	Chetan Jain	Chetan_Jain_TSQLChallenge_19.sql
12	Chris Kulisz	Chris_Kulisz_tsqlchallenge_19.sql
13	Dalius Macernius	Dalius_Macernius_tsqlchallenge_19.sql
14	Dave Ballantyne	Dave_Ballantyne_tsqlchallenge_19.sql
15	Dave Ballantyne	Dave_Ballantyne_tsqlchallenge_19_V2.sql
16	Dave Ballantyne	Dave_Ballantyne_tsqlchallenge_19_V3.sql
17	david betteridge	david_betteridge_tsqlchallenge_19_entry.sql
18	david betteridge	david_betteridge_tsqlchallenge_19_entry2.sql
19	david itzkowitz	david_itzkowitz_tsqlchallenge_19.sql
20	Dean Stillson	Dean_Stillson_tsqlchallenge_19.sql
21	Denis Oksanich	Denis_Oksanich_tsqlchallenge_19.sql
22	eric nordlander	eric_nordlander_tsqlchallenge_19.sql
23	erick bailey	erick_bailey_tsqlchallenge_19_v2.sql
24	erick bailey	erick_bailey_tsqlchallenge_19.sql
25	fabien contaminard	fabien_contaminard_tsqlchallenge_19_v2.sql
26	fabien contaminard	fabien_contaminard_tsqlchallenge_19.sql
27	Gangadhar Naidu	Gangadhar_Naidu_tsqlchallenge_19.sql
28	Geri Reshef	Geri_Reshef_tsqlchallenge_19.sql
29	gustavo gonzalez	gustavo_gonzalez_tsqlchallenge_19.sql
30	Gyan Koju	Gyan_Koju_tsqlchallenge_19.sql
31	igor malinkin	igor_malinkin_tsqlchallenge_19.sql
32	Jacky Yin	jacky_yin_tsqlchallenge_19.sql
33	Jason Whitney	Jason_Whitney_tsqlchallenge_19_v1.sql
34	Jason Whitney	Jason_Whitney_tsqlchallenge_19_v2.sql
35	Jason Whitney	Jason_Whitney_tsqlchallenge_19_v3.sql
36	Jason Whitney	Jason_Whitney_tsqlchallenge_19_v4.sql
37	jeff schwartzmann	jeff_schwartzmann_tsqlchallenge_19.sql
38	jeff schwartzmann	jeff_schwartzmann_tsqlchallenge_19_v2.sql
39	Jesse Roberge	Jesse_Roberge_tsqlchallenge_19_V3.sql
40	Jesse Roberge	Jesse_Roberge_tsqlchallenge_19.sql
41	Jesse Roberge	Jesse_Roberge_tsqlchallenge_19_V2.sql
42	jose chama	jose_chama_tsqlchallenge_19_v3.sql
43	jose chama	jose_chama_tsqlchallenge_19.sql
44	jose chama	jose_chama_tsqlchallenge_19_v2.sql
45	Jose Cruz	Jose_Cruz_tsqlchallenge_19.sql
46	Karin Nooteboom	Karin_Nooteboom_tsqlchallenge_19_2.sql
47	Karin Nooteboom	Karin_Nooteboom_tsqlchallenge_19_3.sql
48	Karin Nooteboom	Karin_Nooteboom_tsqlchallenge_19_1.sql
49	Karin Nooteboom	Karin_Nooteboom_tsqlchallenge_19.sql
50	kevin suchlicki	kevin_suchlicki_tsqlchallenge_19.sql
51	Leszek Gniadkowski	Leszek_Gniadkowski_tsqlchallenge_19_v4.sql
52	Leszek Gniadkowski	Leszek_Gniadkowski_tsqlchallenge_19_v3.sql
53	Leszek Gniadkowski	Leszek_Gniadkowski_tsqlchallenge_19_v1.sql
54	Leszek Gniadkowski	Leszek_Gniadkowski_tsqlchallenge_19_v2.sql
55	lisa kwok	lisa_kwok_tsqlchallenge_19.sql
56	liu abc	liu_abc_tsqlchallenge_19.sql
57	Madhangi Ramasamy	Madhangi_Ramasamy_tsqlchallenge_19.sql
58	mark cowne	mark_cowne_tsqlchallenge_19.sql
59	Michael Lewis	Michael_Lewis_tsqlchallenge_19.sql
60	Michal Poreba	Michal_Poreba_tsqlchallenge_19.sql
61	Michal Stanek	Michal_Stanek_tsqlchallenge_19.sql
62	Mitesh Oswal	TSQLChallange19_Mitesh_oswal.sql
63	morten nilsen	morten_nilsen_tsqlchallenge_19.sql
64	Mueller Lutz	Mueller_Lutz_tsqlchallenge_19_V1.sql
65	Mueller Lutz	Mueller_Lutz_tsqlchallenge_19_V2.sql
66	Muhammad AlPasha	Muhammad_AlPasha_tsqlchallenge_19_V6.sql
67	Muhammad AlPasha	Muhammad_AlPasha_tsqlchallenge_19_V7.sql
68	Muhammad AlPasha	Muhammad_AlPasha_tsqlchallenge_19_V8.sql
69	Muhammad AlPasha	Muhammad_AlPasha_tsqlchallenge_19_V9.sql
70	Muhammad Pasha	muhammad_al_pasha_tsqlchallenge_19.sql
71	Muhammad Pasha	muhammad_pasha_tsqlchallenge_19_V5.sql
72	Narasimhan Jayachandran	Narasimhan_Jayachandran_tsqlchallenge_19.sql
73	nicolo africa	nicolo_africa_tsqlchallenge_19.sql
74	niladri biswas	niladri_biswas_tsqlchallenge_19.sql
75	Nilay Chaudhari	Nilay_Chaudhari_tsqlchallenge_19_V3.sql
76	Nilay Chaudhari	Challange19submission.SQL
77	Nilay Chaudhari	Nilay_Chaudhari_tsqlchallenge_19_V2.sql
78	Par Eriksson	Par_Eriksson_TSQL_Challenge19.sql
79	parth patel	parth_patel_tsqlchallenge_19.sql
80	Patrick Fowler	Patrick_Fowler TSQLChallenge_19.sql
81	paul atkinson	paul_atkinson_tsqlchallenge_19.sql
82	Pragnesh Patel	Pragnesh_Patel_tsqlchallenge_19_v2.sql
83	Pragnesh Patel	Pragnesh_Patel_tsqlchallenge_19.sql
84	Rajasekar Dhanakodi	Rajasekar_Dhanakodi_tsqlchallenge_19.sql
85	Rakesh Kikani	Rakesh_Kikani_tsqlchallenge_19.sql
86	ramesh saive	ramesh_saive_challenge_19.sql
87	rami reddy	rami_reddy_tsqlchallenge_19.sql
88	Rami reddy	tsqlChallenge19.sql
89	Randy Derby	Randy_Derby_TSQLchallenge_19.sql
90	Randy Derby	Randy_Derby_TSQLchallenge_19_V2.sql
91	rashid saleem	rashid_saleem_tsqlchallenge_19.sql
92	regan wick	regan_wick_tsqlchallenge_19_v1.sql
93	reich jesse	reich_jesse_tsqlchallenge_19.sql
94	Ricky Freyre	Ricky_Freyre_sqlchallenge_19.sql
95	Ricky Freyre	Ricky_Freyre_tsqlchallenge_19_v2.sql
96	Ricky Freyre	Ricky_Freyre_tsqlchallenge_19_v3.sql
97	rob farley	rob_farley_tsqlchallenge_19.sql
98	robert cavill	robert_cavill_tsqlchallenge_19.sql
99	roberto reyes	roberto_reyes_tsqlchallenge_19.sql
100	roby hoye	roby_van_hoye_tsqlchallenge_19.sql
101	roland bouman	roland_bouman_tsqlchallenge_19.sql
102	ron moses	ron_moses_tsqlchallenge_19.sql
103	Ryan Randall	Ryan_Randall_tsqlchallenge_19.sql
104	Saif Hasan	Saif_Hasan_TsqlChallenge_19_V2.sql
105	Saif Hasan	Saif_Hasan_TsqlChallege_19.sql
106	Saif Hasan	Saif_Hasan_TsqlChallenge_19.sql
107	Serge Jacquemin	Serge_Jacquemin_tsqlchallenge_19_v2.sql
108	Serge Jacquemin	Serge_Jacquemin_tsqlchallenge_19.sql
109	Seth Phelabaum	Seth_Phelabaum_TSQLChallenge_19_v2.sql
110	Seth Phelabaum	Seth_Phelabaum_TSQLChallenge_19.sql
111	Soren Kongstad	Soren_Kongstad_tsqlchallenge_19.sql
112	stephen horne	stephen_horne_tsqlchallenge_19.sql
113	syed alam	syed_mehroz_alam_tsqlchallenge_19_1.sql
114	syed alam	syed_mehroz_alam_tsqlchallenge_19_2.sql
115	tomas boixet	tomas_boixet_tsqlchallenge_19.sql
116	Vijayakumar Kamalanathan	TSQL-Challenge-19.sql
117	Walter Bhaskar	Walter_Bhaskar_tsqlchallenge_19.sql
118	Zubair Khalid	Zubair_Khalid_tsqlchallenge_19.sql