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 happened recently. This challenge has a (fake) reference to the 24 Hours of PASS event and your task is to count the number of attendees who watched the complete presentation of each speaker.

http://beyondrelational.com/blogs/tc/archive/2010/07/26/tsql-challenge-35-find-the-total-number-of-full-attendees-in-each-24-hop-session.aspx