CODE EXAMPLE FOR SQL

sql decrement value by 1 if not null or zero

update yourTableName set yourColumnName = yourColumnName - 1 where yourColumnName > 0;