Home › SQL Server Challenges › TSQL Challenges

TSQL Challenge 35

Tue, 11/16/2010 - 11:09 — jacob


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

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.

Since it was a live meeting, the chances of someone getting disconnected and getting back on line is quite common. So the definition of 'people who attended the complete presentation' is a little tricky. Each session is broken into the following

5 minute introduction by the moderator
40 minutes session by the speaker
10 Minute Q&A controlled by the moderator
5 Minute thank you note
Only if an attendee has attended all the 4 items listed above, s/he should be considered a 'full attendee'. It is quite natural that the attendee gets disconnected and connects back. So there is a minimum attendance time specified for each item.