Which is not true about CTE?

Select Answer:

It is used for Temporary results

It is similar to Derived table

It can be used in Multiple SQL statements

It can be used in Single SQL statements

It will be available for the duration of the query