Sql assign

hi all,

i need some help… i have an assignment that is over due by 2 hrs… I need an who knows SQL… I need help to create a trigger… I can create a table but i need a trigger to calcuate 4 marks and add them up automatically… and creates a column for the total automatically…

For example (mark1+mark2+marks3+marks4) = total…

please respond within 26 hrs after seeing these post… i have to hand in results early thursday morning…

have a great day…

n4c