Gifts to a candidate

Custom SQL query returning 2,000 rows (hide)

select donor_name, employer, city, state, zip,
       sum(amount) as total, count(*) as gifts
from public_contributions
where candidate_name like '%' || :candidate || '%'
group by canon_id
order by total desc

Edit SQL