1454 活跃用户
SQL架构
Create table If Not Exists Accounts_1454 (id int, name varchar(10));
Create table If Not Exists Logins_1454 (id int, login_date date);
Truncate table Accounts_1454;
insert into Accounts_1454 (id, name) values ('1', 'Winston');
insert into Accounts_1454 (id, name) values ('7', 'Jonathan');
Truncate table Logins_1454;
insert into Logins_1454 (id, login_date) values ('7', '2020-05-30');
insert into Logins_1454 (id, login_date) values ('1', '2020-05-30');
insert into Logins_1454 (id, login_date) values ('7', '2020-05-31');
insert into Logins_1454 (id, login_date) values ('7', '2020-06-01');
insert into Logins_1454 (id, login_date) values ('7', '2020-06-02');
insert into Logins_1454 (id, login_date) values ('7', '2020-06-02');
insert into Logins_1454 (id, login_date) values ('7',