CODE EXAMPLE FOR SQL

what is common table expression in sql

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