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, MCSD, MCAD, MCDBA, MCSE, is the founder of DotNetCurry, DNC Magazine for Developers, SQLServerCurry and DevCurry. He has also authored a couple of books 51 Recipes using jQuery with ASP.NET Controls and a new one recently at The Absolutely Awesome jQuery CookBook.

Suprotim has received the prestigous Microsoft MVP award for nine times in a row now. In a professional capacity, he is the CEO of A2Z Knowledge Visuals Pvt Ltd, a digital group that represents premium web sites and digital publications comprising of Professional web, windows, mobile and cloud developers, technical managers, and architects.

Get in touch with him on Twitter @suprotimagarwal, LinkedIn or befriend him on Facebook