Test internal Subqueries

SELECT vendor_state, vendor_name,

SUM(invoice_total) AS sum_of_invoices

FROM vendors v JOIN invoices i

ON v.vendor_id = i.vendor_id

GROUP BY vendor_state, vendor_name

You need to run all the internal (Subqueries) that you use by themselves to make sure that the information they yield is what you are expecting