SELECT vendor_state, vendor_city, vendor_name, COUNT(*) AS invoice_qty, SUM(invoice_total) AS invoice_average FROM invoi
Posted: Fri Jul 01, 2022 5:47 am
SELECT vendor_state, vendor_city, vendor_name, COUNT(*) ASinvoice_qty, SUM(invoice_total) AS invoice_average FROM invoicesJOIN vendors ON invoices.vendor_id = vendors.vendor_id WHEREvendor_state < 'e' GROUP BY vendor_state, vendor_city,vendor_name HAVING SUM(invoice_total) > 500 ORDER BYvendor_state, vendor_city, vendor_name