Complex~36min
The Enrollment Yield That's Backwards
Measured 30 days before the deposit deadline, digital_ads looks like the worst recruiting channel by far — 22.5% yield versus counselor_referral's 85%. Digital_ads applicants just decide late: by the actual deadline, digital_ads finishes at 90% yield, the single best channel, while counselor_referral ends at 89%. campus_visit also improves between snapshots (75% to 80%), but its rank never changes — only digital_ads flips from worst to best.
Tables you'll query
applicants
What you'll learn
CTEs (WITH clause)Window FunctionsDate & Time Functions