How_to_retrieve_data_from_two_or_more_tables/exer_5C48.sql

use ap;

SELECT vendor_id, invoice_number, invoice_total
FROM invoices i
WHERE invoice_total > (SELECT AVG(invoice_total)
FROM invoices
WHERE vendor_id = i.vendor_id)
ORDER BY vendor_id, invoice_total;