Skip to content

Instantly share code, notes, and snippets.

@mcculley

mcculley/total_contribution_by_employer.sql

Last active September 20, 2020 21:35
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save mcculley/1fabbc1f903a02be292e149ece1847f8 to your computer and use it in GitHub Desktop.
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