<aside> 💡

CTE stands for "Common Table Expression".

It is like a temporary table that you can create in a SQL query to leverage its output in your final query. It enables to run one complex query in a more readable way and in one single SQL statement.

Use case: you need to compute some data (for example: to calculate a metric, or to fetch users with a specific custom field / paths with a specific skills) before running a final query

</aside>