I'm fairly new to SQL and i had to do some calculations using a table.Imagine we have a table with fields : ID - Name - Val1 - Val2 ; Lets say i want to add up 2 values and add it to my query result.I can do that easily with a sub query such as:

select val1+val2 as valtotal,* from my table.

Now if i want to do some more process on valtotal, i use a derived table such as;

select valtotal*3 as ValMoreCalculated,* from
(select val1+val2 as valtotal,* from my table) AS A

A bit more code maybe??

select ValMoreCalculated/valtotal as ValEvenMoreCalc ,* from 
(select valtotal*3 as ValMoreCalculated,* from
    (select val1+val2 as valtotal,* from my table) AS A)AS B

So if i want to do more calculations with the ValMoreCalculated do i have to go through another derived table? Name it as B for example? Is there an easier way to achieve this in SQL?

PS:the title is a bit off i know,but couldn't figure out what to name it :P