Donors giving across many races

Custom SQL query returning 100 rows (hide)

select donor_name, employer, city, state,
       count(distinct campaign_id) as candidates,
       count(distinct office_name) as offices,
       sum(amount) as total_given
from public_contributions
group by canon_id
having candidates >= 3
order by candidates desc, total_given desc
limit 100

Edit SQL