dbt - Advanced Patterns
Given this dbt model SQL code using CTEs, what will be the final output table's column
total_sales?
WITH sales AS (
SELECT customer_id, amount
FROM {{ ref('raw_sales') }}
),
filtered_sales AS (
SELECT customer_id, amount
FROM sales
WHERE amount > 100
)
SELECT customer_id, SUM(amount) AS total_sales
FROM filtered_sales
GROUP BY customer_id