BIT_AND

1
SELECT
2
  user_group,
3
  BIT_AND(permissions) as common_permissions
4
FROM `project.dataset.user_permissions`
5
GROUP BY user_group;

1
SELECT
2
  BIT_AND(feature_flags) as all_users_have,
3
  BIT_OR(feature_flags) as any_user_has
4
FROM `project.dataset.user_settings`;

1
SELECT
2
  category,
3
  BIT_AND(status_flags) as common_flags,
4
  FORMAT('%b', BIT_AND(status_flags)) as binary_representation
5
FROM `project.dataset.items`
6
GROUP BY category;