select count(*) from emails
where id <= 0
group by emails.id

sqlite> select count(*) from emails where id <= 0;
0
sqlite> select count(*) from emails where id <= 0 group by emails.id;
sqlite>