Mysql - get sum() result in another column
If you want both values in the result, you can nest them as in:

select user_total_point, (user_total_point * 100) as hundred_times
from (
    select sum(user_point) as user_total_point
    from users
) as tmp;


Renaming ( as user_total_point ) happens last, so you can not reference that at the same level as you are defining it. The name does not exist yet when you reference it.