How to display a certain level of nesting from a category tree?

Question

SQL

There is a view category table id name parent_id.
It is necessary to display all categories of the 3rd level.

Answer 1

Almost every example of a recursive cte just illustrates the expansion of a tree into a flat structure and at least id, parent id and nesting level appear there.
That is, the addition of any of these examples with the condition where level = N (or rather level <= N) will give the universal desired result.