updating table with calculated results

[Harland Oracle]

All:
I have a batting2022 table that has an int field called "fldpct". This table also has playerID and yearID.

I have a Fielding table that has all the fielding stats in it by playerID, and yearID
the fields are: Assists (a), Putouts (po) and Errors (e)
fldpct=1-(e/(a+po+e))
this will return a decimal number. round up the decimal number to a 3-digit integer (x1000). If this number is >=999 then fldpct=999

write the fldpct to the batting table.

thanks in advance