Given a synthetic dataset of subscriber interactions, how would you write a SQL query to identify key indicators of user churn?