LeetCode SQL Medium

Currently Playing: Leetcode MEDIUM 1454 - Active Users - How to find CONSECUTIVE Anything - Explained by EDS

Question: https://leetcode.com/problems/active-users/description/ SQL Schema: Create table If Not Exists Accounts (id int, name varchar(10)) Create table If Not Exists Logins (id int, login_date date) Truncate table Accounts insert into Accounts (id, name) values ('1', 'Winston') insert into Accounts (id, name) values ('7', 'Jonathan') Truncate table Logins insert into Logins (id, login_date) values ('7', '2020-05-30') insert into Logins (id, login_date) values ('1', '2020-05-30') insert into Logins (id, login_date) values ('7', '2020-05-31') insert into Logins (id, login_date) values ('7', '2020-06-01') insert into Logins (id, login_date) values ('7', '2020-06-02') insert into Logins (id, login_date) values ('7', '2020-06-02') insert into Logins (id, login_date) values ('7', '2020-06-03') insert into Logins (id, login_date) values ('1', '2020-06-07') insert into Logins (id, login_date) values ('7', '2020-06-10') Pandas Schema: data = [[1, 'Winston'], [7, 'Jonathan']] accounts = pd.DataFrame(data, columns=['id', 'name']).astype({'id':'Int64', 'name':'object'}) data = [[7, '2020-05-30'], [1, '2020-05-30'], [7, '2020-05-31'], [7, '2020-06-01'], [7, '2020-06-02'], [7, '2020-06-02'], [7, '2020-06-03'], [1, '2020-06-07'], [7, '2020-06-10']] logins = pd.DataFrame(data, columns=['id', 'login_date']).astype({'id':'Int64', 'login_date':'datetime64[ns]'}) #datascience #mysqltutorials #leetcodesolutions