By converting Skip/Take to RowNumber we can convert apply operation to equivalent join operation. We already do this for first level. We can explore further down to apply conversion in more scenario.
A common case of it being pushed down to 2nd level is another join on subquery (generally a reference navigation with filtered include)