Untitled

From Rude Sloth, 2 Months ago, written in Plain Text, viewed 77 times.

URL http://codebin.org/view/e19781b8 Embed

Download Paste or View Raw

with pob as 
(select date_trunc('month', created_at)::date as dt, 
        SUM(costs)
from tools_shop.costs c
group by dt
order by dt)
 
select pob.dt, pob.sum, 
    (pob.sum - lag(pob.sum) over (order by pob.dt)) as delta
from pob

Reply to "Untitled"

Here you can reply to the paste above

Author What's your name?

Title Give your paste a title.

Language What language is your paste written in?

Your paste Paste your paste here

Create Shorturl Create a shorter url that redirects to your paste?

Private Private paste aren't shown in recent listings.

Delete After When should we delete your paste?