• Using inner join A.id=B.id-1

    Using cte expression and join