• Not a Pro but came up with this query

    with CTE as

    (select ROW_NUMBER() over( partition by CustomerID order by invoiceid) as rn,* from #invoices)

    select t1.invoiceid,t1.customerid,t1.total from CTE t1

    left outer join CTE t2

    on t1.CustomerID = t2.CustomerID

    and t1.rn = t2.rn +1

    where (t1.Total-t2.Total) > 10