Database Challenges

Here is the list of solutions that passed the Basic Testing of TSQL Challenge 20.

1		Adán Bucio	Adán_Bucio_tsqlchallenge_20_v3.sql
2		Adán Bucio	Adán_Bucio_tsqlchallenge_20_v4.sql
3		alun davies	alun_davies_tsqlchallenge_20.sql
4		Anders Uhl	Anders_Uhl_tsqlchallenge_20_v1.sql
5		andrey myasnikov	andrey_myasnikov_tsqlchallenge_20_v1.sql
6		anthony gebhardt	anthony_gebhardt_tsqlchallenge_20.sql
7		antonio facturan	antonio_facturan_tsqlchallenge_20.sql
8		Arumugam Thiraviam	Arumugam_Thiraviam_TSQLChallenge_20_2_v1.sql
9		Arumugam Thiraviam	Arumugam_Thiraviam_TSQLChallenge_20_2_v2.sql
10		aurelien verla	aurelien_verla_tsqlchallenge_20.sql
11		barbara gunion	barbara_gunion_tsqlchallenge_20_v1.sql
12		Benjamin Valet Valet	benjamin_valet_tsqlchallenge_20.sql
13		brad mullins	brad_mullins_tsqlchallenge_20.sql
14		bret warnick	bret_warnick_tsqlchallenge_20_v2.sql
15		Dalibor Margotic	Dalibor_Margotic_tsqlchallenge_20.sql
16		Dalius Macernius	Dalius_Macernius_tsqlchallenge_20.sql
17		dave repton	dave_repton_tsqlchallenge_20.sql
18		david betteridge	david_betteridge_tsqlchallenge_20_b.sql
19		david daxzeal	david_daxzeal_tsqlchallenge_20.sql
20		david linetsky	david_linetsky_tsqlchallenge_20.sql
21		Dean Stillson	Dean_Stillson_tsqlchallenge_20.sql
22		dimitar dimitrov	dimitar_dimitrov_tsqlchallenge_20_v1.sql
23		Divya Agrawal	Divya_Agrawal_tsqlchallenge_20.sql
24		dragoslav djordjevic	dragoslav_djordjevic_tsqlchallenge_20.sql
25		eric cockrell	eric_cockrell_tsqlchallenge_20_v1.sql
26		Eric Freeman	Eric_Freeman_tsqlchallenge_20_v1.sql
27		Eric Freeman	Eric_Freeman_tsqlchallenge_20_v2.sql
28		eric nordlander	eric_nordlander_tsqlchallenge_20.sql
29		erick bailey	erick_bailey_tsqlchallenge_20_v2.sql
30		fabien contaminard	fabien_contaminard_tsqlchallenge_20.sql
31		Gangadhar Naidu	Gangadhar_Naidu_tsqlchallenge_20.sql
32		Geri Reshef	Geri_Reshef_tsqlchallenge_20.sql
33		gustavo gonzalez	gustavo_gonzalez_tsqlchallenge_20.sql
34		jacek szarapa	jacek_szarapa_tsqlchallenge_20.sql
35		jagat patel	jagat_patel_tsqlchallenge_20.sql
36		Janson James	Janson_James_tsqlchallenge_20.sql
37		Jason Whitney	Jason_Whitney_tsqlchallenge_20.sql
38		jeff hadden	jeff_hadden_tsqlchallenge_20.sql
39		jeff schwartzmann	jeff_schwartzmann_tsqlchallenge_20.sql
40		jeff schwartzmann	jeff_schwartzmann_tsqlchallenge_20_v2.sql
41		Jesse Roberge	Jesse_Roberge_tsqlchallenge_20.sql
42		Jim Gawn Gawn	Jim_Gawn_TSQLChallenge_20.sql
43		john stradling	john_stradling_tsqlchallenge_20.sql
44		Jon Cooney	Jon_Cooney_tsqlchallenge_20.sql
45		Jose Chama	Jose_Chama_tsqlchallenge_20.sql
46		Jose Cruz	Jose_Cruz_tsqlchallenge_20_c.sql
47		Josh Schindler	Josh_Schindler_tsqlchallenge_20.sql
48		Josh Shilling	Josh_Shilling_tsqlchallenge_20.sql
49		kamaludeen mohamedbatcha	kamaludeen_mohamedbatcha_tsqlchallenge_20.sql
50		kamaludeen mohamedbatcha	kamaludeen_mohamedbatcha_tsqlchallenge_20_Alternat..
51		Karin Nooteboom	Karin_Nooteboom_tsqlchallenge_20.sql
52		Kevin Kershaw	Kevin_Kershaw_tsqlchallenge_20.sql
53		leigh waldie	leigh_waldie_tsqlchallenge_20.sql
54		leonid koyfman	leonid_koyfman_tsqlchallenge_20_v2.sql
55		leszek g	leszek_g_tsqlchallenge_20_v20.sql
56		leszek g	leszek_g_tsqlchallenge_20_v22.sql
57		leszek g	leszek_g_tsqlchallenge_20_v99.sql
58		Leszek Gniadkowski	Leszek_Gniadkowski_tsqlchallenge_20.sql
59		leszek gniadkowski	leszek_gniadkowski_tsqlchallenge_20_v5.sql
60		leszek gniadkowski	leszek_gniadkowski_tsqlchallenge_20_v6.sql
61		leszek gniadkowski	leszek_gniadkowski_tsqlchallenge_20_v7.sql
62		leszek gniadkowski	leszek_gniadkowski_tsqlchallenge_20_v8.sql
63		letser herrera	letser_herrera_tsqlchallenge_20_v2.sql
64		letser herrera	letser_herrera_tsqlchallenge_20_v3.sql
65		letser herrera	letser_herrera_tsqlchallenge_20.sql
66		lisa k	lisa_k_tsqlchallenge_20.sql
67		louis hillebrand	louis_hillebrand_tsqlchallenge_20.sql
68		louis hillebrand	louis_hillebrand_tsqlchallenge_20_v1.sql
69		Luis Patricio	Luis_Patricio_tsqlchallenge_20.sql
70		maciej pilecki	maciej_pilecki_tsqlchallenge_20.sql
71		Madhangi Ramasamy	Madhangi_Ramasamy_tsqlchallenge_20_WithCTE.sql
72		Marek Powichrowski	Marek_Powichrowski_tsqlchallenge_20.sql
73		Mario Puskaric	Mario_Puskaric_tsqlchallenge_20.sql
74		Mario Puskaric	Mario_Puskaric_tsqlchallenge_20_v2.sql
75		mark cowne	mark_cowne_tsqlchallenge_20_V2.sql
76		Michael Lewis	Michael_Lewis_tsqlchallenge_20.sql
77		michal dvorak	michal_dvorak_tsqlchallenge_20_v2.sql
78		michal mutka	michal_mutka_tsqlchallenge_20.sql
79		michal poreba	michal_poreba_tsqlchallenge_20.sql
80		mikael weghammar	mikael_weghammar_tsqlchallenge_20.sql
81		Mueller Lutz	Mueller_Lutz_tsqlchallenge_20.sql
82		Muhammad Pasha	muhammad_al_pasha_tsqlchallenge_20_2.sql
83		Narasimhan Jayachandran	Narasimhan_Jayachandran_tsqlchallenge_20.sql
84		niladri biswas	niladri_biswas_tsqlchallenge_20_v1.sql
85		niladri biswas	niladri_biswas_tsqlchallenge_20_v2.sql
86		niladri biswas	niladri_biswas_tsqlchallenge_20_v3.sql
87		niladri biswas	niladri_biswas_tsqlchallenge_20_v4.sql
88		odenbreit frank	odenbreit_frank_tsqlchallenge_20.sql
89		Par Eriksson	Par_Eriksson_tsqlchallenge_20.sql
90		parth patel	parth_patel_tsqlchallenge_20.sql
91		Patrick Fowler TSQLChallenge	Patrick_Fowler_TSQLChallenge_20.sql
92		paul atkinson	paul_atkinson_tsqlchallenge_20.sql
93		pawel potasinski	pawel_potasinski_tsqlchallenge_20.sql
94		pedro cunha	pedro_cunha_tsqlchallenge_20.sql
95		piotr mis	piotr_mis_tsqlchallenge_20_v1.sql
96		Pragnesh Patel	Pragnesh_Patel_tsqlchallenge_20.sql
97		ramesh saive	ramesh_saive_tsqlchallenge_20.sql
98		rashid saleem	rashid_saleem_tsqlchallenge_20.sql
99		Razvan Socol	Razvan_Socol_tsqlchallenge_20.sql
100		regan wick	regan_wick_tsqlchallenge_20_v1.sql
101		regan wick	regan_wick_tsqlchallenge_20_v2.sql
102		regan wick	regan_wick_tsqlchallenge_20_v3.sql
103		regan wick	regan_wick_tsqlchallenge_20_v4.sql
104		regan wick	regan_wick_tsqlchallenge_20_v5.sql
105		reich jesse	reich_jesse_tsqlchallenge_20.sql
106		rob farley	rob_farley5_tsqlchallenge_20.sql
107		Ruchay Sohawan	Ruchay_Sohawan_tsqlchallenge_20.sql
108		ryan duclos	ryan_duclos_tsqlchallenge_20_v1.sql
109		Ryan Randall	Ryan_Randall_tsqlchallenge_20_v1.sql
110		Ryan Randall	Ryan_Randall_tsqlchallenge_20_v2.sql
111		Saif Hasan	Saif_Hasan_tsqlchallenge_20.sql
112		Sean Walker	Sean_Walker_tsqlchallenge_20.sql
113		Serge Jacquemin	Serge_Jacquemin_tsqlchallenge_20v3.sql
114		Seth Phelabaum	Seth_Phelabaum_tsqlchallenge_20.sql
115		sgmunson sgmunson	sgmunson_sgmunson_tsqlchallenge_20.sql
116		spark s	spark_s_tsqlchallenge_20.sql
117		spark s	spark_s_tsqlchallenge_20_v2.sql
118		Srinivasan A	Srinivasan_A_tsqlchallenge_20.sql
119		stephen horne	stephen_horne_tsqlchallenge_20_v1.sql
120		steve t	steve_t_tsqlchallenge_20.sql
121		Steyer Vincent	Steyer_Vincent_tsqlchallenge_20.sql
122		syed alam	syed_mehroz_alam_tsqlchallenge_20_v2.sql
123		tim bruce	tim_bruce_tsqlchallenge_20.sql
124		tim lehner	tim_lehner_tsqlchallenge_20.sql
125		tomas boixet	tomas_boixet_tsqlchallenge_20.sql
126		Vamsi Bogullu	Vamsi_Bogullu_tsqlchallenge_20_v1.sql
127		Vamsi Bogullu	Vamsi_Bogullu_tsqlchallenge_20_v2.sql
128		w Bob	w_Bob_tsqlchallenge_20.sql
129		will spurgeon	will_spurgeon_tsqlchallenge_20.sql
130		yonghang wang	yonghang_wang_tsqlchallenge_20_v2.sql

Note that the challenges are 'always ON', which means that you can submit a solution at any time. You can submit a new solution even after the results are published. If your solution is disqualified due to one of the reasons given above, you can re-submit a new version of the challenge at any time.

Never submitted a solution? Or got a new/different version? Submit it