BIT_OR

1
-- Permission: 1=read, 2=write, 4=delete, 8=admin
2
SELECT
3
  team_id,
4
  BIT_OR(user_permissions) as team_capabilities
5
FROM team_members
6
GROUP BY team_id;

1
SELECT
2
  batch_id,
3
  BIT_OR(error_flags) as all_errors,
4
  COUNT(*) as record_count
5
FROM processing_logs
6
WHERE date = CURRENT_DATE
7
GROUP BY batch_id;

1
SELECT
2
  region,
3
  BIT_OR(supported_features) as available_features,
4
  TO_BASE(BIT_OR(supported_features), 2) as binary_view
5
FROM service_availability
6
GROUP BY region;