SQL-complete-tutorial

1
CREATE TABLE orders_archived AS
2
SELECT * FROM orders;
3

4
TRUNCATE TABLE orders_archived;
5

6
-- use a subquery in insert into statement to fill in the table
7
INSERT INTO orders_archived
8
SELECT *
9
FROM orders
10
WHERE order_date < '2019-01-01';
11

12
-- use a JOIN subquery in insert into statement to fill in the table
13
USE sql_invoicing;
14
DROP TABLE invoices_archived;
15

16
CREATE TABLE invoices_archived AS
17
SELECT 
18
	i.invoice_id,
19
    i.number,
20
    c.name AS client,
21
    i.invoice_total,
22
    i.payment_total,
23
    i.invoice_date,
24
    i.due_date,
25
    i.payment_date
26
FROM invoices i 
27
JOIN clients c
28
	USING (client_id)
29
WHERE payment_date IS NOT NULL;