CTEs, Views or Temp Tables?

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,

The post CTEs, Views or Temp Tables? appeared first on Azure SQL Devs’ Corner.