QID interview question

Explain the local temporary tables, CTE, etc.