Cumulative total over time in SQL#

This is a quick trick for creating a cumulative chart of the total number of items created over time based just on their creation date.

• Example below which shows number of repositories I have created over time
• Cumulative stars for a GitHub repository over time

1
select
2
  created_at,
3
  (
4
    select
5
      count(*)
6
    from
7
      repos repos2
8
    where
9
      repos2.owner = 9599
10
      and repos2.created_at <= repos.created_at
11
  ) as cumulative
12
from
13
  repos
14
where
15
  "owner" = 9599
16
order by
17
  created_at desc

I imagine there’s a more elegant way to do this using a window function but this works fine.