CREATE TRIGGER [CalcStudents]
	ON [Student]
	AFTER INSERT, UPDATE, DELETE
AS
	UPDATE [Group]
	SET [AmountOfStudents] = (SELECT COUNT([GroupID]) FROM [Student] GROUP BY [GroupID])
GO