44

Patient Diagnosis List

MediumJOINWHERENULL

Problem Description

Write a SQL query to list all patients with their diagnosis (only completed appointments).

Expected Columns

  • patient_name
  • diagnosis

Example Output

| patient_name | diagnosis | |--------------|-----------| | Ramesh Pandey | Hypertension | | Sarita Devi | Eczema | | ... | ... |

Hints

Unlocks after 2 more attempts
Submit your solution to unlock hints
//#44 Patient Diagnosis List
Medium

Loading schema...

Loading editor...

No results yet

Run a query to see results