I've just finished watching the video from the @GuyInACube about Common Table Expressions
and I noticed that in several comments there was the request to explain what is the difference between Common Table Expressions, Views and Temp Tables.
This is quite a common question, and it is time to give it a simple, concise, and clear answer...