Business Analyst: What is a CTE (Common Table Expression)?

1WITH CustomerTotals AS (
2  SELECT customer_id, SUM(amount) as total
3  FROM orders
4  GROUP BY customer_id
5)
6SELECT c.name, ct.total
7FROM customers c
8INNER JOIN CustomerTotals ct ON c.id = ct.customer_id
9WHERE ct.total > 1000;