Cold Case~62min

The Recruits Who Never Set Foot On A Team

6 applicants (APP-501 through APP-506) were admitted under the 'athletic_recruit' category — bypassing the standard 1200+ SAT threshold with scores of 860-940 — and none of them has ever appeared on any athletic roster: no tryout, no team, nothing. All 6 were approved by the same admissions officer, OFF-04. APP-777 was also admitted as an athletic_recruit by OFF-04 and never appears on a roster either, but there's a documented injury_disqualifications record showing she was medically disqualified after enrollment — a real recruit who got hurt, not a laundered admission slot.

Tables you'll query

applicantsadmission_decisionsathletic_rostersinjury_disqualifications

What you'll learn

JOINsAggregations & GROUP BYString Functions
Investigate this case →