Count NULL as 0?

[sibertius]

@lurtnowski

which returns three users.
Problem is, I have 5 users (two of them haven’t done anything)
Can I get a query which would also include them to show that they have done nothing?

coalesce(device_id,0) converts NULL to 0