By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE test (status_to VARCHAR(255));
SELECT count(nullif(status_to = 'Draft',0)), SUM(status_to = 'Draft') FROM test;
| count(nullif(status_to = 'Draft',0)) | SUM(status_to = 'Draft') |
|---|---|
| 0 | null |
insert into test values (null);
SELECT count(nullif(status_to = 'Draft',0)), SUM(status_to = 'Draft') FROM test;
| count(nullif(status_to = 'Draft',0)) | SUM(status_to = 'Draft') |
|---|---|
| 0 | null |
insert into test values ('A');
SELECT count(nullif(status_to = 'Draft',0)), SUM(status_to = 'Draft') FROM test;
| count(nullif(status_to = 'Draft',0)) | SUM(status_to = 'Draft') |
|---|---|
| 0 | 0 |