SQL

Consider hte query shown. SELECT vendor_state, vendor_city COUNT ROUND(AVG(invoice total),2) AS invoice_avg FROM invoices JOIN vendors ON invoices.vendor_id- vendors.vendor_id GROUP BY vendor_state, vendor_city ORDER BY vendor_state, vendor_city What does the query tell a manager in a business context? The quer tells the manager how many invoices and the average amount o an invoice for all the vendors n a particular state or al the states where there are vendors with at least one invoice. The query tells the manager how many invoices and the total amount of all the invoices for all the vendors in a particular city, or all the cities where there are vendors with at least one invoice. The query tells the manager how many invoices and the average amount of an invoice for all the vendors in a particular city for all the cities where there are vendors with at least one invoce The query tells the manager how many invoices and the total amount of all the invoices for all the vendors in a particular state, for all the states where there are vendors with at least one invoice