🥧 Reporte: Consultas por Especialidad

Consulta SQL (JOIN)

SELECT e.nombre AS especialidad, COUNT(c.id) AS total_consultas
FROM consultas c
INNER JOIN doctores d ON c.doctor_id = d.id
INNER JOIN especialidades e ON d.especialidad_id = e.id
GROUP BY e.nombre
ORDER BY total_consultas DESC;

Tabla de Resultados