How_to_retrieve_data_from_a_single_table/exer_5C21.sql

11
32020.42


USE AP;
SELECT COUNT(*)	AS number_of_invoices,
       SUM(invoice_total - payment_total - credit_total) AS total_due
FROM invoices
WHERE invoice_total - payment_total - credit_total > 0;