How_to_retrieve_data_from_two_or_more_tables/exer_5C19.sql

USE AP;
	SELECT 'Active' AS source, invoice_number, invoice_date, invoice_total 
	FROM invoices 
	WHERE invoice_date >= '2018_06_01' 
UNION 
    SELECT 'Paid' AS source, invoice_number, invoice_date, invoice_total 
    FROM invoices 
    WHERE invoice_date >= '2018_06_01' 
ORDER BY invoice_total DESC;