← Home
S
SQL Dojo
Practice workspace
0 / 20 solved
Questions
Schema
📋 patients
id
INTEGER PK
name
TEXT
age
INTEGER
gender
TEXT
ward
TEXT
admitted
DATE
diagnosis
TEXT
💊 medications
id
INTEGER PK
patient_id
INTEGER FK
drug_name
TEXT
dose
TEXT
route
TEXT
frequency
TEXT
prescribed_by
TEXT
📊 observations
id
INTEGER PK
patient_id
INTEGER FK
recorded_at
DATETIME
bp_systolic
INTEGER
bp_diastolic
INTEGER
heart_rate
INTEGER
spo2
INTEGER
temp
REAL
nurse
TEXT
🏥 procedures
id
INTEGER PK
patient_id
INTEGER FK
procedure_name
TEXT
performed_on
DATE
performed_by
TEXT
duration_mins
INTEGER
outcome
TEXT
Select a question to begin
Choose a question from the list on the left, or just write your own SQL below and hit Run.
Show hint
▶ Run
⌘↵
Clear
Check answer
Show solution
1
Run a query to see results here
Ready
Home
› SQL Dojo