At 2021-02-01T20:14:04-05:00, Matt Zagrabelny <mzagrabe(at)d(dot)umn(dot)edu> sent:
> 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).