All tasks

Doctor's Patients

Beginner

Output the doctor's name, patient's name, and appointment date for all completed appointments (status = 'completed'). Sort by doctor's name and appointment date.

Category
JOIN
Estimated time
~10 min
Databases
PostgreSQLGreenplum
Tags
JOINфильтрацияWHERE

Sign in to solve

Start Solving