Top Lobbying Firms (Registrants)

Custom SQL query returning 100 rows (hide)

SELECT registrant_name, COUNT(*) AS activity_count, COUNT(DISTINCT client_name) AS unique_clients, COUNT(DISTINCT issue_code) AS issue_areas, CAST(SUM(income_amount) AS INTEGER) AS total_income, MIN(filing_year) AS first_year, MAX(filing_year) AS last_year FROM lobbying_activities WHERE income_amount > 0 GROUP BY registrant_name ORDER BY total_income DESC LIMIT 100

Edit SQL