WITH clause

    1. WITH orders_with_total AS (
    3. SELECT order_id, SUM(total)
    4. GROUP BY order_id;