SELECT all patients and understand their basic attributes
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.
| Column | Type | Key |
|---|---|---|
| patient_id | INT | PK |
| first_name | TEXT | |
| last_name | TEXT | |
| date_of_birth | TEXT | |
| gender | TEXT | |
| insurance_type | TEXT | |
| zip_code | TEXT | |
| primary_language | TEXT | |
| is_deceased | INT |
Each hint you reveal reduces the XP you can earn. Try the query first.
Single-table preview from the patient dimension. You want every column but only a small sample of rows.
Star expansion in the SELECT list, plus a row cap at the end of the query.
No WHERE, no ORDER BY — Dr. Okafor is reading the shape of the data, not asking a question of it. Cap at the sample size she requested in the briefing.