How_to_code_subqueries/exercise_5.sql

SELECT SUM(max_invoice_total) AS total_max
FROM (SELECT vendor_id, MAX(invoice_total) AS max_invoice_total
FROM invoices
WHERE invoice_total - payment_total - credit_total > 0
GROUP BY vendor_id) t;