SELECT vendor_state, vendor_city, vendor_name, COUNT(*) AS invoice_qty, SUM(invoice_total) AS invoice_average FROM invoi

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899603
Joined: Mon Aug 02, 2021 8:13 am

SELECT vendor_state, vendor_city, vendor_name, COUNT(*) AS invoice_qty, SUM(invoice_total) AS invoice_average FROM invoi

Post by answerhappygod »

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
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Top
Post Reply

Return to “Archived Questions & Answers”