Compute churn and revenue churn in SQL

You are given a PostgreSQL table named subscription_monthly_snapshot that stores one end-of-month snapshot per customer. Its columns are: user_id (VARCHAR(10)), snapshot_date (DATE), is_active (SMALLINT), mrr (DECIMAL(10,2)), and load_ts (TIMESTAMP). The same (user_id, snapshot_date) pair may appear more than once because multiple loads can be ingested. In that case, keep only the row with the latest load_ts. For August 2025, produce one row containing these four values:…