Example of metrics query for article

metrics_query_example.sql

WITH month_0 AS
         (
             SELECT user_id,
                    metric_a
             FROM analytics_table
             WHERE execution_date = < month_0 >
         ),
     month_1 AS
         (
             SELECT user_id,
                    metric_a
             FROM analytics_table
             WHERE execution_date = < month_1 >
         )
SELECT user_id,
       ABS(m1.metric_a - m0.metric_a) AS abs_shift
FROM month_0 AS m0
         INNER JOIN month_1 AS m1 USING (user_id)
WHERE abs_shift > < X >