How_to_retrieve_data_from_two_or_more_tables/exer_5C30.sql

use ap;

SELECT vendor_name,
(SELECT MAX(invoice_date) FROM invoices
WHERE vendor_id = vendors.vendor_id) AS latest_inv
FROM vendors
ORDER BY latest_inv DESC;