How_to_retrieve_data_from_a_single_table/exer_5C23.sql

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;