0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professionals and students of engineering

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 * 
FROM
(SELECT @troopstrength * 
(@troopbonusstrength + @troopbonusstrength2 + @aydaelevel+ 100)/100*@troopnumber  damage,
@enemy1strength * @enemy1number * 3 m1health,
@enemy2strength * @enemy2number * 3 m2health
)x

fork query

edited jul 31 21

created jul 31 21 anonymous