use of Common table expression and merge statement in sql

Question

i have no idea how can we use common table expression and merge statement in sql at one table.

if anyone know then plz help resolved this problem