Scenario: Churn Risk Candidates

Find active subscribers with no app session in last 30 days and no payment in last 45 days. Return subscriber_id.

subscribers(id, status), app_sessions(id, subscriber_id, session_time), payments(id, subscriber_id, payment_time)