How_to_retrieve_data_from_two_or_more_tables/exec_5C39.sql

USE AP;

SELECT invoice_number, invoice_date, invoice_total
FROM invoices
WHERE invoice_total >
(SELECT AVG(invoice_total)
FROM invoices)
ORDER BY invoice_total;