no_employer.sql

; Find the top ten PACs by total contributions from individuals with no employer listed.
select b.cmte_nm as committee_name, a.committee_ID, a.total_contribution
from (select individual_contribution."CMTE_ID" as committee_ID, sum(individual_contribution."TRANSACTION_AMT")
as total_contribution from individual_contribution
where "ENTITY_TP"='IND' and ("EMPLOYER" in ('NONE', 'UNEMPLOYED', 'NOT EMPLOYED', 'N/A', 'NO EMPLOYER', 'NONE GIVEN')
or "EMPLOYER" is null) group by individual_contribution."CMTE_ID")
as a join committee
as b on a.committee_ID = b.cmte_id
order by total_contribution desc;