I'm assuming there's something going wrong in the

LAG() / LEAD()

logic.