I've been asked write a statement that does the following: "increase the money by power 2 then divide it by 2. Round the results to whole numbers".

This is the [table](http://i.stack.imgur.com/t1zQU.png)

This is what I've got so far

```
SELECT event_id, place, money, 
POWER(money,2)/2 as x,
ROUND(x,0) as 'new money'
FROM PRIZE 
ORDER BY event_id, place; 

```

I can't figure out how to round x in the same statement - I guess the value hasn't been created yet?

Thanks