#447 Doctors with More Than a Given Number of Appointments

Companies:

Unknown company

Themes:

SQLAggregationPractice

The following tables are given:

Appointment
id | patient_id | doctor_id | date
...

Doctor
id | full_name
...

Find doctors who performed more than 10 appointments on 2-10-2025.

Display the doctor's id, name, and appointment count.

Question review

Mentor

Answer as you would in a real interview. I’ll ask follow-up questions, then compare your answer with the reference answer and show your accuracy as a %.

Sign in to start the dialogue The mentor keeps the context of the current question and your previous messages.