Skip to main content
Journey Uncommon Logo
JourneyUncommon
mediumSQLwindow functions ROW_NUMBER RANKSingle-choice MCQ

What does this query produce in the prev_amount column for the very first row of each partition?

SELECT region, day, amount, LAG(amount, 1, 0) OVER ( PARTITION BY region ORDER BY day ) AS prev_amount FROM sales;