3204. Bitwise User Permissions Analysis

SQL

SELECT
  BIT_AND(permissions) AS common_perms,
  BIT_OR(permissions) AS any_perms
FROM user_permissions;