Domanda di colloquio di Payoneer

SQL WITH CTE QUESTION AND JOIN