Single-table SELECT with multi-column projection and a categorical WHERE filter. Practice exact-string filtering on a network_status enum, multi-column projection, and stable ordering — the simplest building block of the network-roster reports.
Contracting outreach for Q1 starts Monday and I need the full out-of-network provider roster in front of me. From dim_providers_payer, give me every provider whose network_status is 'out-of-network' — provider_id, npi, specialty, and state — sorted by provider_id ascending so the list is stable across reruns. The OON book is where the leakage lives; every provider on this list is either a contracting target or a leakage hotspot we need to redirect members away from.
| Column | Type | Key |
|---|---|---|
| provider_id | INT | PK |
| npi | TEXT | |
| specialty | TEXT | |
| network_status | TEXT | |
| tin | TEXT | |
| state | TEXT |
Each hint you reveal reduces the XP you can earn. Try the query first.
Single-table SELECT — no joins, no aggregation. The whole task is a filtered projection from one dimension table.
Filter on the network_status enum. The literal value uses lowercase with a hyphen — exact text match is what TEXT comparison requires; any deviation in case or punctuation silently returns zero rows.
ORDER BY a column that's already in the SELECT list is the easy case (which this is). Worth knowing for later: SQLite is happy to ORDER BY a column you didn't project — useful when you want a stable sort but don't want to widen the report.