CREATE DEFINER=CURRENT_USER PROCEDURE `diagnoses_rpt`()
BEGIN
select ROW_NUMBER() OVER (ORDER BY diagnoses) AS Sqn, diagnoses.name as `Diagnoses`,count(*) as count from appointment_consultations 
join appointments on appointments.id = appointment_consultations.appointment_id
join patients on patients.id = appointments.patient_id
join diagnoses on diagnoses.id = appointment_consultations.diagnoses
group by diagnoses;
END
