Create a department performance dashboard. For each department, show: department name, total number of unique patients seen, total visits, average days between a patient's first and last visit (rounded to 1 decimal, as avg_visit_span_days), and total revenue (rounded to 2 decimals). Only include departments that have had at least one visit. Order by total_revenue descending.
Schema
🔑idINT
first_nameTEXT
last_nameTEXT
specialtyTEXT
🔗department_idINT
emailTEXT
phoneTEXT
hire_dateTEXT
salaryREAL
postgresql
Run your query to see results
Press Ctrl + Enter to execute