Common Table Expressions in SQL

Can you explain what a Common Table Expression (CTE) is in SQL? Provide an example scenario where it would be beneficial to use a CTE.

Answer Panel