By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE sql2 ( id int, rep_age varchar(15) );
INSERT INTO sql2 VALUES (1, ' '),
(2, NULL),
(3, 'a b c'),
(4, 'ef j'),
(5, ' ');
Records: 5 Duplicates: 0 Warnings: 0
SELECT COALESCE(SIGN(LENGTH(rep_age)),0) as rep_age, COUNT(*) as count
FROM sql2
GROUP BY COALESCE(SIGN(LENGTH(rep_age)),0)
| rep_age | count |
|---|---|
| 0 | 1 |
| 1 | 4 |