CREATE TABLE orders_archived AS
    SELECT * FROM orders

    INSERT orders_archived
    SELECT *
    FROM orders
    WHERE order_date < ‘2019-01-01’

    CREATE TABLE payments_archived AS
    SELECT *
    FROM invoices i
    JOIN client c
    USING (client_id)
    WHERE payment_date IN NOT NULL