Q&A about the site for scientific skepticism
DECLARE @troopstrength INT = 75600 DECLARE @troopbonushealth INT = 178.5 DECLARE @troopbonusstrength REAL = 199.5 DECLARE @troopbonusstrength2 INT = 592 DECLARE @troopnumber INT = 79 DECLARE @aydaelevel INT = 45 DECLARE @enemy1strength INT = 1100 DECLARE @enemy1number INT = 8100 DECLARE @enemy2strength INT = 28 DECLARE @enemy2number INT = 140000 SELECT *, damage * @troopnumber totaldamage, iif(damage * @troopnumber > m1health, 0, cast(m1health- damage * @troopnumber as int)+1)*3/ health monster1kill, cast(@enemy1strength * @enemy1number * 3 / damage as int)+1 neededtokill, @enemy1strength * @enemy1number / health kills1, @enemy2strength * @enemy2number / health kills2, (@enemy1strength * @enemy1number + @enemy2strength * @enemy2number)/ health maxkills, iif(damage * @troopnumber > m1health, 0, cast(m1health- damage * @troopnumber as int)+1)*3 FROM (SELECT damage = @troopstrength * (@troopbonusstrength + @troopbonusstrength2 + @aydaelevel+ 100)/100, m1health = @enemy1strength * @enemy1number * 3 , m2health = @enemy2strength * @enemy2number * 3 , health = (@troopbonushealth + @aydaelevel+ 100)/100*@troopstrength*3 )x