sql query to modify the selected value from database [closed]

update table1 set numberfield = numberfield - 7

if numberfield is 30, then numberfield = 30 – 7, difference will be the new value of the field