1
SQLIntermediate#queries#windows
SQLAdvanced#windows
What do LAG and LEAD do?
They read a value from a previous or following row in the same window, which makes period-over-period comparisons easy without a self join.
Example
SELECT month, revenue,
revenue - LAG(revenue) OVER (ORDER BY month) AS growth
FROM monthly_sales;