SQL check if group contains NULL

Question

Is there any function to check if a column in a group contains a NULL, alternatively how would I solve this? Example below of data structure.

id | value
----------
1  | NULL
1  | 56
2  | 98
2  | 14

Result:

id | value
----------
1  | 1
2  | 0

Answer 1

try

select id, 
       count(*) - count(value) as null_value_count
from your_table
group by id

SQLFiddle demo