with recursive</code> works, at the beginning, a bit like the <code>with</code> queries ( without <code>recursive</code>)</li>
<li>It will evaluate the non-recursive term first, to initialise the result set</li>
<li>Then it will start evaluating the recursive term multiple times, in a loop, until no new rows are added to the results
<ul>
<li>each time it evaluates the recursive term, it will try to add new rows to the result set</li>
<li>the recursive term is correlated to the <code>cte_name</code></li>
</u