Calculating and rounding up
I have a table which shows prize money for an event. I need to have it increased by (50*50)/2 shown as increased_prize and then rounded off to the nearest whole number.

an example of my table is as follows:

    event_id   ranking     prize
    1          1           120
    1          2           60
    2          1           10
    2          2           5

Thank you for any help provided.
Calculating and rounding up
===

I have a table which shows prize money for an event. I need to have it increased by (50*50)/2 shown as increased_prize and then rounded off to the nearest whole number.

an example of my table is as follows:

    event_id   ranking     prize
    1          1           120
    1          2           60
    2          1           10
    2          2           5

Thank you for any help provided.