mcculley/total_contribution_by_employer.sql

Last active September 20, 2020 21:35

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/mcculley/1fabbc1f903a02be292e149ece1847f8.js"></script>
Save mcculley/1fabbc1f903a02be292e149ece1847f8 to your computer and use it in GitHub Desktop.

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