Scenario: Renewal Risk Watchlist

Business ask: list active subscriptions expiring in the next 7 days, where no renewal payment exists in the last 30 days. Return customer_id and expiry_date.

subscriptions(id, customer_id, status, expiry_date), payments(id, customer_id, payment_date, payment_type)