create trigger on northwind datase .. please help

I don't have problem with sending an email, the problem is that the table Orders don't have the total price

the order price is in the Order details table!

thank you for the help btw