LEAD

How can we inspect the subsequent order amount in the stream?

Advanced⏱ 3 Minutes⭐ 1590 XP

🤔 THE QUESTION

How can we inspect the subsequent order amount in the stream?

💡 WHAT IS IT?

LEAD(column) retrieves the value from the subsequent row within the window.

🎯 WHAT IS IT USED FOR?

Forward-looking session analysis, time until next transaction, funnel transition timing.

💻 EXAMPLE

SELECT
order_date,
amount,
LEAD(amount) OVER (ORDER BY order_date) AS next_amount
FROM orders;

Practice typing production-grade SQL code for LEAD.