(monthly_sales - LAG(monthly_sales) OVER (ORDER BY order_month)) / LAG(monthly_sales) OVER (ORDER BY order_month) AS growth_rate ...

SELECT ROUND(SUM(payment_value),2) AS Total_Revenue FROM order_payments; SELECT ROUND(AVG(payment_value),2) AS Average_Order_Value FROM order_payments; ...