对分组的查询结果执行逻辑检查

I have data set as follows,

我的数据集如下,

job_id | status 
-------|-------
  100  |   0
  100  |   0
  102  |   1
  102  |   0
  104  |   1
  104  |   1
---------------
job_id