How_to_retrieve_data_from_two_or_more_tables/exer_5C51.sql

USE AP;

SELECT vendor_name,
COUNT(*) AS invoice_qty,
ROUND(AVG(invoice_total), 2) AS invoice_avg
FROM vendors JOIN invoices
ON vendors.vendor_id = invoices.vendor_id
GROUP BY vendor_name HAVING AVG(invoice_total) > 500
ORDER BY invoice_qty DESC;