how we can perform acid Operations in sql with examples

Example: how we can perform acid Operations in sql with examples

Transaction 1: Begin X=X+50, Y = Y-50 END
Transaction 2: Begin X=1.1*X, Y=1.1*Y END