July 27, 2010

TSQL Challenge - Find the total number of 'Full Attendees' in each 24 HOP Session

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

Problem: Find the total number of 'Full Attendees' in each 24 HOP Session

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.

Good luck!

About The Author

Suprotim Agarwal, ASP.NET Architecture MVP works as an Architect Consultant and provides consultancy on how to design and develop Web applications.

Suprotim is also the founder and primary contributor to DevCurry, DotNetCurry and SQLServerCurry. He has also written an EBook 51 Recipes using jQuery with ASP.NET Controls.

Follow him on twitter @suprotimagarwal

No comments: