How_to_retrieve_data_from_a_single_table/exer_5C26.sql

USE ap;
SELECT vendor_id,ROUND(AVG(invoice_total), 2) AS average_invoice_amount
FROM invoices
GROUP BY vendor_id
HAVING AVG(invoice_total) > 2000
ORDER BY average_invoice_amount DESC;