SELECT (followers – LAG(followers) OVER (ORDER BY date)) / LAG(followers) OVER (ORDER BY date) AS follower_growth_rate FROM instagram_table;