First hit on Google for “sql cte” gives me: CTE (Common Table Expression) and this page: https://www.geeksforgeeks.org/cte-in-sql/

For anyone who doesn't know, CTE = common table expression, which is a part of a query representing a temporary result set that can be referenced from other parts of a query.