Senate top offices by spending

Custom SQL query returning 50 rows (hide)

SELECT office_name, office_party,
    COUNT(DISTINCT report_id) AS reports,
    COUNT(*) AS rows,
    ROUND(AVG(total_funding), 2) AS avg_total_funding,
    ROUND(SUM(CASE WHEN line_category IS NULL THEN net_funds END), 2) AS sum_office_level_net_funds
FROM senate_office_totals
WHERE office_name IS NOT NULL
GROUP BY office_name, office_party
ORDER BY sum_office_level_net_funds DESC
LIMIT 50

Edit SQL