House: personnel vs non-personnel spending per office

Custom SQL query returning 200 rows (hide)

SELECT np.quarter, np.organization,
    ROUND(SUM(np.amount), 2) AS nonpersonnel,
    (SELECT ROUND(SUM(total_amount),2) FROM house_disbursements_personnel_agg pa
     WHERE pa.quarter = np.quarter AND pa.organization = np.organization) AS personnel
FROM house_disbursements_nonpersonnel np
GROUP BY np.quarter, np.organization
HAVING nonpersonnel > 10000
ORDER BY np.quarter DESC, (nonpersonnel + COALESCE(personnel, 0)) DESC
LIMIT 200

Edit SQL