-- product_id is the primary key for this table. -- period_start and period_end indicates the start and end date for sales period, both dates are inclusive. -- The average_daily_sales column holds the ...
(monthly_sales - LAG(monthly_sales) OVER (ORDER BY order_month)) / LAG(monthly_sales) OVER (ORDER BY order_month) AS growth_rate ...