select count(id) from call_records where id is null;
count
═══════
0
(1 row)
Time: 0.673 ms
Which field is count(*) counting if it is counting nulls?
-m
What you're overlooking is that, at least to my reading of your original query, id would be null for any dates that do not have any corresponding call_records (because you used a left join).
