Healthcare Analytics Path · Mission 1 of 25Starter

Meet the patients

SELECT all patients and understand their basic attributes

Back to Healthcare Analytics

The Brief

Dr. Amara OkaforChief Quality Officerslack-dm

Good morning. I just started this week and I'm still getting oriented to our data systems. Can you pull the first 10 rows from the patient table so I can see what fields we're working with? I need to understand the shape of our data before I can benchmark anything.

You'll practice

SELECTLIMITData quality

Tables available

dim_patients

Hints (3)

Each hint you reveal reduces the XP you can earn. Try the query first.

Hint 1

Patient data lives in `dim_patients`. You want a small preview, not all 800 rows

Hint 2

Think about how to preview every column without hand-listing them, and how to cap the result at a small sample

Hint 3

`SELECT ___ FROM dim_patients LIMIT ___` — what goes in each blank to get all columns and just 10 rows?