path: root/rushs/data-clash/step-1/tracking.sql

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