How_to_retrieve_data_from_two_or_more_tables/exer_5C52.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 WHERE invoice_total > 500
GROUP BY vendor_name
ORDER BY invoice_qty DESC;