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:46 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 (Please refer to codeexample 6-1.) Although this query runs as coded, it contains thislogical error: