Calculate Cumulative Sum (Running Total)
SELECT column1, column2, SUM(column3) OVER (ORDER BY column1) as cumulative_sum FROM your_table;
This will create a new column called cumulative_sum that shows the running total of values in column3 for each row, ordered by column1. You can also use the PARTITION BY clause to group the running total by a specific column.
SELECT sales, quantity, SUM(quantity) OVER (ORDER BY sales) as cumulative_sum FROM bookshop_sales;
This SQL query selects the columns order_id and quantity from the table bookshop_sales. It also creates a new column called cumulative_sum using the SUM function with the OVER clause, which calculates the cumulative sum of the sales column ordered by the order_id column.