BOOL_AND

1
SELECT 
2
  project_id,
3
  BOOL_AND(is_completed) AS all_tasks_done
4
FROM tasks
5
GROUP BY project_id;

1
SELECT 
2
  batch_id,
3
  BOOL_AND(is_valid) AS batch_valid,
4
  BOOL_AND(is_processed) AS batch_processed
5
FROM records
6
GROUP BY batch_id;

1
SELECT project_id
2
FROM tasks
3
GROUP BY project_id
4
HAVING BOOL_AND(is_completed) = true;