为什么SQL事务没有得到回滚

I'm trying to rollback a transaction if the sum of enrollment for certain classes is over 50. For some reason, even though my if statement equates to true (the sum of the courses is 60) this still ends up deleting the courses. I'm trying to rollback a transaction if the sum