SQL window function II: percent growth

SQL

***VERY IMPORTANT***
TAKE NOTE OF THE PARENTHESIS
TAKE NOT OF 0.0 TO MAKE SURE COMPUTATION IS IN FLOAT

select date_trunc('month', created_at)::date as date
  , count(*) as count
  , round(((100.0 / (lag(count(*)) over (order by date_trunc('month', created_at)::date asc))) * count(*)) -100, 1) || '%' as percent_growth 
from posts 
group by date
order by date asc
changjulian17
Did you find this snippet useful?

Sign up for free to to add this to your code library

Getting the Last Record Using Rank Function - T-SQL Example
SQL

T-SQL

40
Getting the Date for the Previous Saturday with T-SQL
SQL

T-SQL

29
Remove Leading Zeros from a Field with T-SQL
SQL

T-SQL | Data Cleaning

8
left join LATERAL
SQL

6
SQL generate_series, dayofweek(DOW), weekday, functions
SQL

6
median
SQL

5
SQL RANK
SQL

5
EXISTS
SQL

4
SQL creating a view
SQL

4
SQL window function
SQL

4