Compare to the previous row with LAG

sql

SELECT
  order_date,
  daily_revenue,
  daily_revenue - LAG(daily_revenue) OVER (ORDER BY order_date) AS delta
FROM daily_order_metrics;

Explanation

`LAG` is excellent for trend analysis and time-series deltas.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Same sheet · prioritizing window functions

Rank a user's orders by recency.

Open In sheetsqlsame section

Compute cumulative revenue by day.

Open In sheetsqlsame section

Rank categories by revenue without gaps.

Open In sheetsqlsame section

Return the total number of rows in a table.

Count orders by status.

Calculate totals and averages.