Add previous column alias to calculate sum/total of last column
Aliases are only available in GROUP BY, ORDER BY or HAVING (aside from direct output).
Found this link as helpful : https://stackoverflow.com/questions/3932205/to-calculate-sum-two-alias-named-columns-in-sql?rq=1

Please check it.