common table in sql code example

Example: what is common table expression in sql

CTE generates a temporary result that will further 
be used by select, update, delete.