I have a table with columns Date, Login and SLA (takes value 0 or 1).
I have a simple question see below. The problem is that it doesn’t return records if the count is 0. I’ve already tried almost everything and nothing 🙁 Please advise.

SELECT Date, Login, Nz(Count(SLA)), SLA
FROM t_source_org_frt
GROUP BY Date, Login, SLA;