Untitled

 avatar
unknown
plain_text
2 years ago
336 B
3
Indexable
WITH
    gr_mon AS (SELECT CAST(DATE_TRUNC('month', created_at) AS date) AS month,
                      SUM(costs) AS month_cost      
               FROM tools_shop.costs
               GROUP BY month) 

SELECT *,
       month_cost - LAG(month_cost, 1, month_cost) OVER (ORDER BY month_cost) AS costs_from_previous
FROM gr_mon
Editor is loading...