We have a situation in which we need to update records based on existing data in table, this is query which i created manually, just to explain this query updates prize field data using amount field by subtracting its 51 percent value.We have a situation in which we need to update