Question d’entretien chez Microsoft

Write a complete SQL trigger and discuss whether it is optimized.