Discussion on: 4 Ways to Calculate a Running Total With SQL

[Helen Anderson]

Hi Seattle Data Guy,

Great idea for a post. Analytical Functions and getting your head around self joins is really important.

When you say "See the query below to see how to use an analytic function" are you referring to the video or should there be a code snippet in the post itself?

[SeattleDataGuy]

Hello Helen!

Thank you for pointing that out. I forgot that gists don't work with github.

I changed the programming examples with markdown vs. github.

Cheers,
Ben

[Helen Anderson]

Looking good!

If you'd like the code to be highlighted for SQL all you need to do is add the word sql immediately after your first set of back ticks.

select
    day
   , driver_id
   , sum(profit)
from
    (
   select
        t1.day
      , t2.day      
      , t1.driver_id
      , t2.profit
    from f_daily_rides t1
        join f_daily_rides t2
        on driver_id =driver_id
            and t1.month = t2.month
            and t1.year = t2.year
            and t1.day >=t2.day
) t3
group by day

[SeattleDataGuy]

Oh! I didn't actually know that.

I went back and updated some other posts too that have python and json.

Thanks for all your help!

[Helen Anderson]

No worries Ben, keep the awesome SQL content coming :)