Doctor Revenue Report

Write a SQL query to calculate total consultation revenue for each doctor.

Expected Columns

• doctor_name
• specialization
• total_patients
• total_revenue

Example Output

| doctor_name | specialization | total_patients | total_revenue | |-------------|----------------|----------------|---------------| | Dr. Arun Chatterjee | Cardiology | 3 | 4500 | | Dr. Rakesh Sinha | Neurology | 3 | 6000 | | ... | ... | ... | ... |