Rank Error Fingerprints by Customer Impact

SELECT
  error_fingerprint,
  COUNT(*) AS occurrences,
  COUNT(DISTINCT team_id) AS affected_teams
FROM api_requests
WHERE timestamp_utc >= now() - INTERVAL '24 hours'
  AND status_code >= 500
  AND error_fingerprint IS NOT NULL
GROUP BY error_fingerprint
ORDER BY affected_teams DESC, occurrences DESC
LIMIT 20;