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