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