Healthcare Database SQL Practice Exercises
Hospital and clinic system with patients, doctors, appointments, and diagnoses
3 ExercisesBeginner to Advanced Level
Patient and Doctor Queries
Beginner01
SELECT from patients and doctors with filtering and sorting
Topics Covered:
SELECTWHEREORDER BY
Sample Query:
SELECT first_name, last_name, specialty FROM doctors WHERE department_id = 1;Appointments and Departments
Intermediate02
JOIN appointments with patients, doctors, and departments
Topics Covered:
JOINGROUP BYCOUNT
Sample Query:
SELECT dep.department_name, COUNT(a.appointment_id) as appointment_count FROM ap...Diagnoses and Conditions
Intermediate03
Analyze diagnoses with patients and date filtering
Topics Covered:
JOINWHEREDate filtering
Sample Query:
SELECT p.last_name, di.condition_name, di.diagnosis_date FROM diagnoses di JOIN ...Ready for Free Practice?
Explore the healthcare database database on your own. Write any SQL query and see results instantly.
Open SQL Practice Environment