How_to_retrieve_data_from_a_single_table/exer_5C10.sql

USE AP;
SELECT invoice_number, vendor_name, invoice_due_date,
       invoice_total - payment_total - credit_total AS balance_due
FROM vendors v JOIN invoices i
     ON v.vendor_id = i.vendor_id
WHERE  invoice_total - payment_total - credit_total > 0
ORDER BY invoice_due_date DESC;