What is a CTE and when would you use it in SQL?

Question Explain

This question tests knowledge of modern SQL features for improving code readability and modularity.