Update SQL_Class_5.txt

shashank-mishra219 · web-flow · commit 0e6b8570846a · 2022-11-13T12:45:10.000+05:30
diff --git a/SQL_Class_5.txt b/SQL_Class_5.txt
@@ -223,3 +223,12 @@ select sales_date,
        lag(sales_amount, 1, 0) over(order by sales_date) as prev_day_sales,
        sales_amount - lag(sales_amount, 1, 0) over(order by sales_date) as sales_diff
 from daily_sales;
+
+# Diff between lead and lag
+select *,
+      lag(sales_amount, 1) over(order by sales_date) as pre_day_sales
+from daily_sales;
+
+select *,
+      lead(sales_amount, 1) over(order by sales_date) as next_day_sales
+from daily_sales;
