Help on "At least one" query writing
SELECT `id_`, 
       MAX(CASE WHEN `value1` = 'b' THEN 1 ELSE 0 END) as `is_b`
  FROM `t1`
 GROUP BY `id_`
 ORDER BY `id_`;

If you want that to go into result, slap an INSERT on top of it.