My colleague and SQL Server MVP Jacob Sebastian runs a blog called Beyond Relational which primarily helps people to enhance their T-SQL query writing skills.
Jacob also holds a T-SQL Challenge every now and then on his blog. These TSQL Challenges pose exciting real world problems that we as programmers face in our projects and they require a decent amount of T-SQL Knowledge to solve. Each T-SQL challenge comes with Sample Scripts and Expected Results. You just have to write the best possible TSQL query to solve the challenge.
So if you are a T-SQL programmer who loves to take on these challenges or learn how to best solve these challenge, then here’s a new T-SQL challenge Jacob has come up with
Description: The recent 24-hours-of-pass or more widely known as #24HOP on twitter and other social media was one of the most exciting SQL Server events that happened recently. For this challenge, we created some (fake) attendance data for this event. Your task is to count the number of attendees who watched the complete presentation of each speaker. Click here.