Level 4 - Mid-LevelOutput Prediction Questions
Output: Previous Week Revenue
For week = 2026-01-15, what prev_revenue is returned? SELECT week_start, revenue, LAG(revenue) OVER (ORDER BY week_start) AS prev_revenue FROM weekly_revenue;
For week = 2026-01-15, what prev_revenue is returned? SELECT week_start, revenue, LAG(revenue) OVER (ORDER BY week_start) AS prev_revenue FROM weekly_revenue;