By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table tbl (id int, position text, experience int, salary int);
insert into tbl values (1, "top", 90, 1500), (2, "bottom", 100, 1500), (3, "top", 90, 750), (4, "left", 90, 1000), (5, "right", 100, 1300), (6, "top", 90, 1500), (7, "left", 80, 2000), (8, "top", 80, 1000), (9, "bottom", 100, 2000), (10, "left", 100, 2000);
Records: 10 Duplicates: 0 Warnings: 0
select position, sum(experience=100) from tbl group by position
| position | sum(experience=100) |
|---|---|
| top | 0 |
| bottom | 2 |
| left | 1 |
| right | 1 |