Postgresql To Return 0 when Null
Use max(coalesce(logincount, 0)) to avoid NULLs

According to Postgres docs (9.6):


  The COALESCE function returns the first of its arguments that is not null. Null is returned only if all arguments are null. It is often used to substitute a default value for null values when data is retrieved for display, for example: