43

Doctor Appointment Count

MediumJOINCOUNTGROUP BY

Problem Description

Write a SQL query to count how many appointments each doctor has had.

Expected Columns

doctor_name
appointment_count

Example Output

| doctor_name | appointment_count | |-------------|-------------------| | Dr. Arun Chatterjee | 3 | | Dr. Rakesh Sinha | 3 | | ... | ... |

Hints

Unlocks after 2 more attempts

Submit your solution to unlock hints

//#43 Doctor Appointment Count

Medium

Loading schema...

Loading editor...

No results yet

Run a query to see results