Calculate Monthly Provider Completion Rates

Tell me about your experience with SQL and Python, and how you use them to analyze business problems.

Use the provided Zocdoc provider and appointment data to demonstrate this with a query covering January and February 2025. Include only active providers with at least two appointment requests in a month.

Output

1. One row per qualifying provider and month
2. Columns: provider_name, appointment_month, appointment_requests, completed_appointments, and completion_rate
3. Sort by appointment_month, then provider_name

Output details

• Use appointment timestamps from 2025-01-01 inclusive through 2025-03-01 exclusive.
• Represent appointment_month as the first day of each month.
• Sort appointment_month ascending, then provider_name ascending.
• Calculate completion_rate as completed requests divided by total requests, multiplied by 100, rounded to 2 decimal places.