I have one douby,while defining cte you have used cte to join within the with clause,if that is correct then you can try this:

Here you can create row_number column in...