Here is the list of solutions that passed the Basic Testing of TSQL Challenge 54 - Find the longest matching area code from phone numbers.

1			AntonioOlmedo_AntonioOlmedo_tsqlchallenge_54_V5323..
2			simondm_simondm_tsqlchallenge_54_V5544.sql
3			charleseads_charleseads_tsqlchallenge_54_V5548.sql
4			mowgli_mowgli_tsqlchallenge_54_V5553.sql
5		Adam Tokarski	Adam_Tokarski_tsqlchallenge_54_V1.sql
6		Ahmed Huq	Ahmed_Huq_tsqlchallenge_54_V1.sql
7		Amit Borhade	Amit_Borhade_tsqlchallenge_54_V1.sql
8		Annamalaisamy Karuppasamy	Annamalaisamy_Karuppasamy_tsqlchallenge_54_V3.sql
9		Artem Antonov	Artem_Antonov_tsqlchallenge_54_V1.sql
10		Arty Kancleris	Arty_Kancleris_tsqlchallenge_54_V1.sql
11		Bakarr Barrie	Bakarr_Barrie_tsqlchallenge_54_V1.sql
12		Beth Seefelt	Beth_Seefelt_tsqlchallenge_54_V2.sql
13		Bhanu Mocharla	Bhanu_Mocharla_tsqlchallenge_54_V1.sql
14		Charles Eads	Charles_Eads_tsqlchallenge_54_V1.sql
15		Chris Strolia-Davis	Chris_Strolia-Davis_tsqlchallenge_54_V1.sql
16		DaeSic Jeon	DaeSic_Jeon_tsqlchallenge_54_V1.sql
17		Damir Myrzabaev	Damir_Myrzabaev_tsqlchallenge_54_V1.sql
18		Dariusz Brejnak	Dariusz_Brejnak_tsqlchallenge_54_V1.sql
19		dave repton	dave_repton_tsqlchallenge_54_V1.sql
20		david betteridge	david_betteridge_tsqlchallenge_54_V1.sql
21		Denier Yannig	Denier_Yannig_tsqlchallenge_54_V1.sql
22		Denier Yannig	Denier_Yannig_tsqlchallenge_54_V2.sql
23		elini ng	elini_ng_tsqlchallenge_54_V1.sql
24		eric nordlander	eric_nordlander_tsqlchallenge_54_V1.sql
25		fery enne	fery_enne_tsqlchallenge_54_V1.sql
26		George Harig	George_Harig_tsqlchallenge_54_V1.sql
27		George Harig	George_Harig_tsqlchallenge_54_V2.sql
28		Giovanni Nobile	Giovanni_Nobile_tsqlchallenge_54_V1.sql
29		Gopinath Srirangan	Gopinath_Srirangan_tsqlchallenge_54_V1.sql
30		Guenter Tschech	Guenter_Tschech_tsqlchallenge_54_V1.sql
31		Gunarathinam M	Gunarathinam_M_tsqlchallenge_54_V1.sql
32		Gunarathinam M	Gunarathinam_M_tsqlchallenge_54_V2.sql
33		Ian Hicks	Ian_Hicks_tsqlchallenge_54_V1.sql
34		Igor Zakharov	Igor_Zakharov_tsqlchallenge_54_V5.sql
35		Igor Zakharov	Igor_Zakharov_tsqlchallenge_54_V6.sql
36		Igor Zakharov	Igor_Zakharov_tsqlchallenge_54_V1.sql
37		Janis Murphy	Janis_Murphy_tsqlchallenge_54_V3.sql
38		Jason Long	Jason_Long_tsqlchallenge_54_V1.sql
39		Jason Long	Jason_Long_tsqlchallenge_54_V2.sql
40		Jesse McLain	Jesse_McLain_tsqlchallenge_54_V2.sql
41		Job Kuyer	Job_Kuyer_tsqlchallenge_54_V1.sql
42		John Bevilaqua	John_Bevilaqua_tsqlchallenge_54_V1.sql
43		John Bevilaqua	John_Bevilaqua_tsqlchallenge_54_V2.sql
44		John Bevilaqua	John_Bevilaqua_tsqlchallenge_54_V3.sql
45		Kashan Siddiqui	Kashan_Siddiqui_tsqlchallenge_54_V1.sql
46		Kevin Bullen	Kevin_Bullen_tsqlchallenge_54_V1.sql
47		Kevin Sun	Kevin_Sun_tsqlchallenge_54_V1.sql
48		Kevin Sun	Kevin_Sun_tsqlchallenge_54_V2.sql
49		leonid koyfman	leonid_koyfman_tsqlchallenge_54_V1.sql
50		Leszek Gniadkowski	Leszek_Gniadkowski_tsqlchallenge_54_V3.sql
51		Leszek Gniadkowski	Leszek_Gniadkowski_tsqlchallenge_54_V4.sql
52		Leszek Gniadkowski	Leszek_Gniadkowski_tsqlchallenge_54_V5.sql
53		Leszek Gniadkowski	Leszek_Gniadkowski_tsqlchallenge_54_V1.sql
54		Leszek Gniadkowski	Leszek_Gniadkowski_tsqlchallenge_54_V2.sql
55		Linson Daniel	Linson_Daniel_tsqlchallenge_54_V1.sql
56		Maciej Chrzanowski	Maciej_Chrzanowski_tsqlchallenge_54_V4.sql
57		Maciej Chrzanowski	Maciej_Chrzanowski_tsqlchallenge_54_V5.sql
58		Maciej Chrzanowski	Maciej_Chrzanowski_tsqlchallenge_54_V1.sql
59		Maciej Chrzanowski	Maciej_Chrzanowski_tsqlchallenge_54_V2.sql
60		Maciej Chrzanowski	Maciej_Chrzanowski_tsqlchallenge_54_V3.sql
61		mark cowne	mark_cowne_tsqlchallenge_54_V1.sql
62		Matt Fraser	Matt_Fraser_tsqlchallenge_54_V1.sql
63		meierruth michael	meierruth_michael_tsqlchallenge_54_V1.sql
64		Michael Johnston	Michael_Johnston_tsqlchallenge_54_V2.sql
65		Mike Scalise	Mike_Scalise_tsqlchallenge_54_V3.sql
66		Mike Scalise	Mike_Scalise_tsqlchallenge_54_V1.sql
67		Mike Scalise	Mike_Scalise_tsqlchallenge_54_V2.sql
68		Milena Sergieva	Milena_Sergieva_tsqlchallenge_54_V1.sql
69		Muhammad Awais Akram	MuhammadAwais_Akram_tsqlchallenge_54_V3.sql
70		Muhammad Awais Akram	MuhammadAwais_Akram_tsqlchallenge_54_V4.sql
71		Muhammad Awais Akram	MuhammadAwais_Akram_tsqlchallenge_54_V5.sql
72		Muhammad Awais Akram	MuhammadAwais_Akram_tsqlchallenge_54_V6.sql
73		Muhammad Awais Akram	MuhammadAwais_Akram_tsqlchallenge_54_V7.sql
74		Muhammad Awais Akram	MuhammadAwais_Akram_tsqlchallenge_54_V8.sql
75		Muhammad Awais Akram	MuhammadAwais_Akram_tsqlchallenge_54_V9.sql
76		Muhammad Awais Akram	MuhammadAwais_Akram_tsqlchallenge_54_V10.sql
77		Muhammad Sali Rawther	MuhammadSali_Rawther_tsqlchallenge_54_V1.sql
78		Nazmul Robin	Nazmul_Robin_tsqlchallenge_54_V1.sql
79		Nik Artemiev	Nik_Artemiev_tsqlchallenge_54_V1.sql
80		Olga Medvedeva	Olga_Medvedeva_tsqlchallenge_54_V1.sql
81		Pakyaraj P	Pakyaraj_P_tsqlchallenge_54_V1.sql
82		Peso Peso	Peso_Peso_tsqlchallenge_54_V1.sql
83		Peso Peso	Peso_Peso_tsqlchallenge_54_V2.sql
84		Peso Peso	Peso_Peso_tsqlchallenge_54_V3.sql
85		Peso Peso	Peso_Peso_tsqlchallenge_54_V4.sql
86		Peter Christiansen	Peter_Christiansen_tsqlchallenge_54_V1.sql
87		peter frissen	peter_frissen_tsqlchallenge_54_V1.sql
88		piers canadas	piers_canadas_tsqlchallenge_54_V1.sql
89		Powichrowski Marek	Powichrowski_Marek_tsqlchallenge_54_V1.sql
90		Pravin Patel	Pravin_Patel_tsqlchallenge_54_V1.sql
91		Rahul Verma	Rahul_Verma_tsqlchallenge_54_V1.sql
92		Ramesh Saive	Ramesh_Saive_tsqlchallenge_54_V1.sql
93		Razvan Socol	Razvan_Socol_tsqlchallenge_54_V1.sql
94		Razvan Socol	Razvan_Socol_tsqlchallenge_54_V2.sql
95		safdar majeed	safdar_majeed_tsqlchallenge_54_V1.sql
96		Saleem S	Saleem_S_tsqlchallenge_54_V1.sql
97		Saleem S	Saleem_S_tsqlchallenge_54_V2.sql
98		Saleem S	Saleem_S_tsqlchallenge_54_V3.sql
99		Saleem S	Saleem_S_tsqlchallenge_54_V4.sql
100		Saleem S	Saleem_S_tsqlchallenge_54_V5.sql
101		Saleem S	Saleem_S_tsqlchallenge_54_V6.sql
102		Sam Jo	Sam_Jo_tsqlchallenge_54_V1.sql
103		sanjay machama	sanjay_machama_tsqlchallenge_54_V1.sql
104		Sean Walker	Sean_Walker_tsqlchallenge_54_V1.sql
105		Shankar Walvekar	Shankar_Walvekar_tsqlchallenge_54_V1.sql
106		SharathChandra Sirisinagandla	SharathChandra_Sirisinagandla_tsqlchallenge_54_V1...
107		Simon D'Morias	Simon_D'Morias_tsqlchallenge_54_V1.sql
108		Siva Prasad Vundavalli	SivaPrasad_Vundavalli_tsqlchallenge_54_V1.sql
109		Siva Prasad Vundavalli	SivaPrasad_Vundavalli_tsqlchallenge_54_V2.sql
110		Siva Prasad Vundavalli	SivaPrasad_Vundavalli_tsqlchallenge_54_V3.sql
111		Slobodan Bogunovic	Slobodan_Bogunovic_tsqlchallenge_54_V1.sql
112		Stefan G	Stefan_G_tsqlchallenge_54_V1.sql
113		Stephen Sabey	Stephen_Sabey_tsqlchallenge_54_V1.sql
114		Steve Benkosky	Steve_Benkosky_tsqlchallenge_54_V2.sql
115		Steve Benkosky	Steve_Benkosky_tsqlchallenge_54_V1.sql
116		Subhrajit Chatterjee	Subhrajit_Chatterjee_tsqlchallenge_54_V1.sql
117		Szymon Wojcik	Szymon_Wojcik_tsqlchallenge_54_V1.sql
118		Thiago Dantas	Thiago_Dantas_tsqlchallenge_54_V1.sql
119		Tim Bailey	Tim_Bailey_tsqlchallenge_54_V1.sql
120		Vadim Orlov	Vadim_Orlov_tsqlchallenge_54_V1.sql
121		vamsee Krishna	vamsee_Krishna_tsqlchallenge_54_V1.sql
122		vangel paronov	vangel_paronov_tsqlchallenge_54_V1.sql
123		WS Drools	WS_Drools_tsqlchallenge_54_V2.sql
124		Zbigniew Borowski	Zbigniew_Borowski_tsqlchallenge_54_V1.sql
125		Zbigniew Borowski	Zbigniew_Borowski_tsqlchallenge_54_V2.sql
126		Zbigniew Borowski	Zbigniew_Borowski_tsqlchallenge_54_V3.sql
127		Zbigniew Borowski	Zbigniew_Borowski_tsqlchallenge_54_V4.sql
128		Zbigniew Borowski	Zbigniew_Borowski_tsqlchallenge_54_V5.sql
129		Zhong Yu	Zhong_Yu_tsqlchallenge_54_V1.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.