By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table marks (marks int);
insert into marks values (10), (11);
alter table marks add divisible_by_ten char(3);
update marks
set divisible_by_ten = case when marks % 10 = 0 then 'yes' else 'no' end;
select * from marks;
Records: 2 Duplicates: 0 Warnings: 0
Records: 0 Duplicates: 0 Warnings: 0
Rows matched: 2 Changed: 2 Warnings: 0
| marks | divisible_by_ten |
|---|---|
| 10 | yes |
| 11 | no |