BOOL_AND

1
SELECT
2
  order_id,
3
  BOOL_AND(is_approved) as all_approved
4
FROM order_items
5
GROUP BY order_id;

1
SELECT
2
  batch_id,
3
  BOOL_AND(is_validated) as fully_validated,
4
  BOOL_AND(is_processed) as fully_processed,
5
  COUNT(*) as record_count
6
FROM batch_records
7
GROUP BY batch_id;

1
SELECT
2
  department,
3
  BOOL_AND(completed_training) as all_trained,
4
  BOOL_AND(signed_policy) as all_signed,
5
  CASE
6
    WHEN BOOL_AND(completed_training AND signed_policy)
7
    THEN 'Compliant'
8
    ELSE 'Non-Compliant'
9
  END as compliance_status
10
FROM employees
11
GROUP BY department;