House top vendors (non-personnel)

Custom SQL query returning 100 rows (hide)

SELECT vendor_name,
    COUNT(*) AS n_transactions,
    ROUND(SUM(amount), 2) AS total_paid,
    COUNT(DISTINCT organization) AS n_offices,
    MIN(quarter) AS first_quarter,
    MAX(quarter) AS last_quarter
FROM house_disbursements_nonpersonnel
WHERE vendor_name IS NOT NULL AND vendor_name != ''
GROUP BY vendor_name
ORDER BY total_paid DESC
LIMIT 100

Edit SQL