TSQL Challenge 20 - Winners

Here are the winners of TSQL Challenge 20

maciej pilecki	View Profile\|Solution	10 SQL Stars
Mario Puskaric	View Profile\|Solution	9 SQL Stars
Adán Bucio	View Profile\|Solution	9 SQL Stars
Eric Freeman	View Profile\|Solution	8 SQL Stars
reich jesse	View Profile\|Solution	7 SQL Stars
brad mullins	View Profile\|Solution	7 SQL Stars
Jason Whitney	View Profile\|Solution	7 SQL Stars
Arumugam Thiraviam	View Profile\|Solution	6 SQL Stars
alun davies	View Profile\|Solution	5 SQL Stars
Razvan Socol	View Profile\|Solution	5 SQL Stars
niladri biswas	View Profile\|Solution	4 SQL Stars
piotr mis	View Profile\|Solution	4 SQL Stars
Jon Cooney	View Profile\|Solution	4 SQL Stars
Michael Lewis	View Profile\|Solution	3 SQL Stars
Seth Phelabaum	View Profile\|Solution	2 SQL Stars
andrey myasnikov	View Profile\|Solution	2 SQL Stars
david daxzeal	View Profile\|Solution	2 SQL Stars
Kevin Kershaw	View Profile\|Solution	1 SQL Stars

Can you beat these solutions?

Do you think you can come up with a better solutions? If you have a better performing query, Send us your solution. See this page to view the performance comparison of winning solutions.