How_to_insert_update_and_delete_data/demo-queries-from slides-1.sql

CREATE TABLE invoices_copy AS
SELECT *
FROM invoices;

CREATE TABLE old_invoices AS
SELECT *
FROM invoices
WHERE invoice_total - payment_total - credit_total = 0;

CREATE TABLE vendor_balances AS
SELECT vendor_id, SUM(invoice_total) AS sum_of_invoices
FROM invoices
WHERE (invoice_total - payment_total - credit_total) <> 0
GROUP BY vendor_id;

DROP TABLE old_invoices;