How_to_retrieve_data_from_a_single_table/demo-queries-from slides-2.sql

--A SELECT statement that renames the columns in the result se
SELECT invoice_number AS "Invoice Number", invoice_date AS Date,
       invoice_total AS Total
FROM invoices;

--A SELECT statement that renames the columns in the result se
SELECT invoice_number, invoice_date, invoice_total,
       invoice_total - payment_total - credit_total
FROM invoices;