11 Labels

-- 11_labels: Keep future outcomes separate from features
-- Read-only reference query. Setup must be loaded first.
SELECT c.customer_id,
 CASE WHEN EXISTS (SELECT 1 FROM aabha_sql.orders AS o WHERE o.customer_id=c.customer_id
 AND o.status='completed' AND o.order_date>=DATE '2025-03-01'
 AND o.order_date<DATE '2025-04-01') THEN 1 ELSE 0 END AS bought_in_march
FROM aabha_sql.customers AS c WHERE c.signup_date<DATE '2025-03-01' ORDER BY c.customer_id;