By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE t(b int);
INSERT INTO t(b) values (1),(11),(20),(30);
Records: 4 Duplicates: 0 Warnings: 0
SELECT COUNT(CASE WHEN b > 11 THEN 1 END) FROM t;
| COUNT(CASE WHEN b > 11 THEN 1 END) |
|---|
| 2 |