SQL Analyst Challenge Room
Real analyst scenarios. Real database schemas. You write the queries. No multiple choice - just SQL.
How It Works
Pick a Challenge
Read the scenario brief. Each one is a real analyst situation - a missing charge, a migration gap, a HIPAA audit.
Query the Schema
You get a database schema and a SQL workspace. Write queries to investigate - no hints required, but available if you're stuck.
Find the Answer
Submit what you found. Correct answers unlock the full solution with explanation of the query logic and the real-world lesson.
Read the Debrief
Every challenge ends with a practitioner debrief - what this looks like in a real Epic, Medicaid, or enterprise environment.
A physician signed a progress note two hours ago but no charge appeared in the charge review queue. The revenue cycle manager is asking why. Find the gap before the end of shift.
Three days after a data migration, registration staff report that some patients appear twice in the system. Find the duplicates - and identify which record is the correct one to keep.
The CMO's monthly LOS dashboard shows average inpatient LOS of 2.1 days. The prior system showed 2.6 days for the same population. The query is running - but something is wrong with the math.
A patient filed a complaint. They believe their records were accessed by someone with no clinical relationship. You have the Epic audit log. Find every access event that cannot be justified by a treating relationship.
Claims denial rate spiked 12% last quarter. Nobody caught it until the CFO asked. Your job: find which payer, which service type, and which denial reason code is responsible - before the next executive meeting.
The nightly ETL ran without errors. But the quality team's reports show yesterday's data. Somewhere between the extract and the load, records are being dropped. Find where the count breaks.
Epic's pre-computed READMISSION_FLG shows 4.2% for Q1. The CMO's target is 4.0%. But the quality director believes the metric includes planned readmissions that CMS excludes. Write the query that proves - or disproves - the discrepancy.
T-MSIS data shows 847 members who received services but were not enrolled on the date of service. Find the members, the gaps in eligibility, and the dollar exposure.