LOGICAL_AND

1
SELECT
2
  order_id,
3
  LOGICAL_AND(is_approved) as all_items_approved
4
FROM `project.dataset.order_items`
5
GROUP BY order_id;

1
SELECT
2
  department,
3
  LOGICAL_AND(training_completed) as all_trained,
4
  LOGICAL_AND(certification_valid) as all_certified,
5
  LOGICAL_AND(background_check_passed) as all_cleared
6
FROM `project.dataset.employees`
7
GROUP BY department;

1
SELECT
2
  table_name,
3
  LOGICAL_AND(is_valid) as all_valid,
4
  LOGICAL_AND(is_complete) as all_complete,
5
  COUNT(*) as total_records
6
FROM `project.dataset.data_quality_log`
7
WHERE check_date = CURRENT_DATE()
8
GROUP BY table_name;