58

Experienced Doctors

MediumJOINWHERECOUNT

Problem Description

Write a SQL query to find doctors with more than 10 years of experience and their total appointment count.

Expected Columns

  • doctor_name
  • experience_years
  • total_appointments

Example Output

| doctor_name | experience_years | total_appointments | |-------------|------------------|-------------------| | Dr. Arun Chatterjee | 15 | 3 | | Dr. Rakesh Sinha | 20 | 3 | | ... | ... | ... |

Hints

Unlocks after 2 more attempts
Submit your solution to unlock hints

Related Topics

JOINWHERECOUNTGROUP BY
//#58 Experienced Doctors
Medium

Loading schema...

Loading editor...

No results yet

Run a query to see results