What is a CTE (Common Table Expression) and what advantage does it provide?

Question

SQL Data Analyst — Medium

What is a CTE (Common Table Expression) and what advantage does it provide?

Accepted Answer

A CTE is a named temporary result set defined with WITH in SQL. It improves readability and allows referencing the same subquery multiple times in a query.