can you do something like this simplifying it: SELECT quarter_number, net_revenue, LAG(net_revenue) OVER (ORDER BY quarter_number) AS previous_quarter_revenue, ROUND( (net_revenue - LAG(net_revenue) OVER (ORDER BY quarter_number)) / NULLIF(LAG(net_revenue) OVER (ORDER BY quarter_number), 0) * 100, 2 ) AS qoq_percentage_change FROM ( SELECT quarter_number, SUM(quantity * (vehicle_price - discount)) AS net_revenue FROM order_t GROUP BY quarter_number ) AS sub ORDER BY quarter_number