SELECT on_case AS investigating_id, COUNT(*) AS report_count
FROM investigation.mirrored_reports
GROUP BY on_case
ORDER BY report_count DESC, investigating_id ASC
