Common table expression. I don't know exactly where the "common" part comes from, but I'm guessing because you can use its alias multiple times in the subsequent CTEs and the main query.

Common table expressions: https://www.postgresql.org/docs/current/queries-with.html

common table expression. It's basically like a view that can be defined at the beginning of a query, and can be referenced within that query.

Common Table Expression (the WITH clause).

Common Table Expression

Composable Table Expression.