You may need to cast your host variable to a string representation, since you are concatenating strings together to build your SQL query. Also, make sure you have a leading space in "as Previous_Amount FROM [pensions]" so that the result is something like
SELECT [Previous Amount] * 3 as...