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);
create view marks_10 as
select
marks,
case when marks % 10 = 0 then 'yes' else 'no' end as divisible_by_10
from marks;
select * from marks_10;
Records: 2 Duplicates: 0 Warnings: 0
| marks | divisible_by_10 |
|---|---|
| 10 | yes |
| 11 | no |