LeetCode SQL Medium

Currently Playing: Leetcode MEDIUM 3204 - Bitwise User Permissions Analysis - Explained by Everyday Data Science

Question: https://leetcode.com/problems/bitwise-user-permissions-analysis/description/ SQL Schema: Create table if not exists user_permissions(user_id int, permissions int) Truncate table user_permissions insert into user_permissions (user_id, permissions) values ('1', '5') insert into user_permissions (user_id, permissions) values ('2', '12') insert into user_permissions (user_id, permissions) values ('3', '7') insert into user_permissions (user_id, permissions) values ('4', '3') Pandas Schema: data = [[1, 5], [2, 12], [3, 7], [4, 3]] user_permissions = pd.DataFrame({ 'user_id': pd.Series(dtype='int'), 'permissions': pd.Series(dtype='int') }) #leetcodesolutions #datascience #sql