select vendor state, vendor city, vendor name, count(*) as invoice qty, sum(invoice total) as invoice average from invoices join vendors on id