Skip to content

Instantly share code, notes, and snippets.

@mcculley

mcculley/total_contribution_by_employer.sql

Last active September 20, 2020 21:35
Star
Embed
What would you like to do?
Learn more about clone URLs
Download ZIP
Raw
total_contribution_by_employer.sql
select individual_contribution."EMPLOYER" as employer, sum(individual_contribution."TRANSACTION_AMT") as total_contribution from individual_contribution where "ENTITY_TP"='IND' group by individual_contribution."EMPLOYER"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment