Created
November 4, 2019 19:38
-
-
Save shirankrasnov/49a66221d25e346099f9aad828ae4367 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
drop table if exists logins; | |
CREATE TABLE logins( | |
user_id varchar(300), | |
date date | |
); | |
INSERT INTO logins ( user_id , date ) | |
VALUES | |
('1', '2019-02-15'), | |
('1', '2019-03-04'), | |
('1', '2019-04-20'), | |
('1', '2019-05-15'), | |
('1', '2019-06-13'), | |
('1', '2019-07-08'), | |
('1', '2019-08-11'), | |
('1', '2019-09-12'), | |
('1', '2019-10-06'), | |
('2', '2019-09-19'), | |
('2', '2019-10-06'), | |
('2', '2019-11-23'), | |
('2', '2019-12-22'), | |
('3', '2019-07-07'), | |
('3', '2019-08-25'), | |
('3', '2019-09-05'), | |
('3', '2019-10-05'), | |
('3', '2019-11-28'), | |
('3', '2019-12-10'), | |
('4', '2019-10-03'), | |
('4', '2019-11-02'), | |
('4', '2019-12-01'), | |
('5', '2019-10-27'), | |
('5', '2019-11-20'), | |
('5', '2019-12-26'), | |
('6', '2019-01-22'), | |
('7', '2019-09-04'), | |
('7', '2019-10-19'), | |
('7', '2019-11-06'), | |
('7', '2019-12-25'), | |
('8', '2019-04-18'), | |
('8', '2019-05-13'), | |
('8', '2019-06-18'), | |
('8', '2019-07-16'), | |
('9', '2019-10-12'), | |
('9', '2019-11-15'), | |
('9', '2019-12-04'), | |
('10', '2019-02-01'), | |
('10', '2019-03-28'), | |
('10', '2019-04-15'), | |
('10', '2019-05-20'), | |
('10', '2019-06-09'), | |
('10', '2019-07-19'), | |
('10', '2019-08-26'), | |
('11', '2019-06-02'), | |
('11', '2019-07-04'), | |
('11', '2019-08-04'), | |
('12', '2019-06-07'), | |
('12', '2019-07-01'), | |
('12', '2019-08-21'), | |
('12', '2019-09-19'), | |
('12', '2019-10-07'), | |
('12', '2019-11-25'), | |
('12', '2019-12-15'), | |
('13', '2019-08-28'), | |
('13', '2019-09-22'), | |
('13', '2019-10-09'), | |
('14', '2019-01-22'), | |
('14', '2019-02-18'), | |
('14', '2019-03-17'), | |
('14', '2019-04-27'), | |
('14', '2019-05-19'), | |
('14', '2019-06-21'), | |
('14', '2019-07-10'), | |
('14', '2019-08-25'), | |
('15', '2019-02-02'), | |
('15', '2019-03-23'), | |
('15', '2019-04-18'), | |
('15', '2019-05-10'), | |
('15', '2019-06-02'), | |
('15', '2019-07-27'), | |
('15', '2019-08-27'), | |
('15', '2019-09-13'), | |
('16', '2019-11-03'), | |
('16', '2019-12-14'), | |
('17', '2019-08-06'), | |
('17', '2019-09-19'), | |
('17', '2019-10-04'), | |
('17', '2019-11-25'), | |
('18', '2019-11-17'), | |
('18', '2019-12-05'), | |
('19', '2019-06-24'), | |
('20', '2019-03-02'), | |
('20', '2019-04-19'), | |
('20', '2019-05-14'), | |
('20', '2019-06-04'), | |
('20', '2019-07-13'), | |
('20', '2019-08-05'), | |
('21', '2019-09-09'), | |
('21', '2019-10-04'), | |
('21', '2019-11-03'), | |
('21', '2019-12-18'), | |
('22', '2019-08-19'), | |
('22', '2019-09-08'), | |
('22', '2019-10-27'), | |
('22', '2019-11-26'), | |
('22', '2019-12-11'), | |
('23', '2019-05-01'), | |
('24', '2019-05-06'), | |
('24', '2019-06-25'), | |
('24', '2019-07-12'), | |
('24', '2019-08-08'), | |
('24', '2019-09-28'), | |
('24', '2019-10-13'), | |
('24', '2019-11-20'), | |
('25', '2019-04-27'), | |
('25', '2019-05-11'), | |
('25', '2019-06-17'), | |
('25', '2019-07-27'), | |
('25', '2019-08-24'), | |
('25', '2019-09-25'), | |
('25', '2019-10-06'), | |
('25', '2019-11-22'), | |
('26', '2019-08-09'), | |
('26', '2019-09-26'), | |
('26', '2019-10-03'), | |
('26', '2019-11-25'), | |
('26', '2019-12-12'), | |
('27', '2019-10-28'), | |
('27', '2019-11-05'), | |
('27', '2019-12-17'), | |
('28', '2019-11-04'), | |
('29', '2019-08-19'), | |
('29', '2019-09-05'), | |
('29', '2019-10-11'), | |
('29', '2019-11-04'), | |
('29', '2019-12-14'), | |
('30', '2019-03-10'), | |
('30', '2019-04-05'), | |
('30', '2019-05-13'), | |
('30', '2019-06-18'), | |
('30', '2019-07-27'), | |
('31', '2019-03-26'), | |
('31', '2019-04-24'), | |
('31', '2019-05-09'), | |
('31', '2019-06-03'), | |
('31', '2019-07-13'), | |
('31', '2019-08-04'), | |
('31', '2019-09-17'), | |
('31', '2019-10-08'), | |
('31', '2019-11-12'), | |
('31', '2019-12-24'), | |
('32', '2019-01-03'), | |
('32', '2019-02-19'), | |
('32', '2019-03-06'), | |
('32', '2019-04-12'), | |
('32', '2019-05-16'), | |
('32', '2019-06-24'), | |
('33', '2019-06-10'), | |
('33', '2019-07-06'), | |
('33', '2019-08-17'), | |
('33', '2019-09-03'), | |
('33', '2019-10-10'), | |
('33', '2019-11-13'), | |
('34', '2019-03-03'), | |
('34', '2019-04-06'), | |
('34', '2019-05-04'), | |
('35', '2019-09-01'), | |
('35', '2019-10-02'), | |
('35', '2019-11-28'), | |
('36', '2019-07-08'), | |
('36', '2019-08-25'), | |
('36', '2019-09-22'), | |
('36', '2019-10-15'), | |
('36', '2019-11-25'), | |
('36', '2019-12-22'), | |
('37', '2019-06-26'), | |
('37', '2019-07-05'), | |
('37', '2019-08-02'), | |
('37', '2019-09-08'), | |
('37', '2019-10-18'), | |
('37', '2019-11-08'), | |
('37', '2019-12-27'), | |
('38', '2019-01-02'), | |
('38', '2019-02-26'), | |
('38', '2019-03-02'), | |
('38', '2019-04-22'), | |
('38', '2019-05-12'), | |
('38', '2019-06-23'), | |
('38', '2019-07-14'), | |
('38', '2019-08-10'), | |
('38', '2019-09-19'), | |
('38', '2019-10-16'), | |
('39', '2019-10-06'), | |
('39', '2019-11-02'), | |
('39', '2019-12-02'), | |
('40', '2019-11-17'), | |
('40', '2019-12-13'), | |
('41', '2019-11-05'), | |
('41', '2019-12-26'), | |
('42', '2019-09-07'), | |
('42', '2019-10-09'), | |
('42', '2019-11-08'), | |
('42', '2019-12-11'), | |
('43', '2019-06-20'), | |
('43', '2019-07-07'), | |
('43', '2019-08-27'), | |
('43', '2019-09-21'), | |
('43', '2019-10-08'), | |
('43', '2019-11-10'), | |
('43', '2019-12-04'), | |
('44', '2019-02-20'), | |
('45', '2019-05-02'), | |
('45', '2019-06-10'), | |
('45', '2019-07-09'), | |
('45', '2019-08-10'), | |
('45', '2019-09-11'), | |
('46', '2019-03-02'), | |
('46', '2019-04-08'), | |
('46', '2019-05-13'), | |
('46', '2019-06-24'), | |
('46', '2019-07-20'), | |
('46', '2019-08-04'), | |
('46', '2019-09-04'), | |
('46', '2019-10-17'), | |
('46', '2019-11-14'), | |
('46', '2019-12-06'), | |
('47', '2019-10-28'), | |
('47', '2019-11-28'), | |
('47', '2019-12-17'), | |
('48', '2019-07-21'), | |
('48', '2019-08-03'), | |
('48', '2019-09-19'), | |
('48', '2019-10-13'), | |
('48', '2019-11-04'), | |
('48', '2019-12-22'), | |
('49', '2019-09-28'), | |
('49', '2019-10-03'), | |
('49', '2019-11-04'), | |
('49', '2019-12-15'), | |
('50', '2019-04-25'), | |
('50', '2019-05-28'), | |
('50', '2019-06-26'), | |
('51', '2019-07-22'), | |
('52', '2019-09-20'), | |
('52', '2019-10-11'), | |
('52', '2019-11-05'), | |
('52', '2019-12-06'), | |
('53', '2019-07-25'), | |
('53', '2019-08-10'), | |
('54', '2019-03-08'), | |
('54', '2019-04-12'), | |
('54', '2019-05-14'), | |
('54', '2019-06-09'), | |
('54', '2019-07-22'), | |
('54', '2019-08-09'), | |
('55', '2019-07-02'), | |
('55', '2019-08-23'), | |
('55', '2019-09-04'), | |
('55', '2019-10-15'), | |
('55', '2019-11-07'), | |
('55', '2019-12-04'), | |
('56', '2019-04-03'), | |
('56', '2019-05-13'), | |
('56', '2019-06-26'), | |
('56', '2019-07-18'), | |
('56', '2019-08-01'), | |
('56', '2019-09-21'), | |
('56', '2019-10-05'), | |
('56', '2019-11-20'), | |
('56', '2019-12-13'), | |
('57', '2019-10-24'), | |
('57', '2019-11-20'), | |
('57', '2019-12-23'), | |
('58', '2019-04-09'), | |
('58', '2019-05-23'), | |
('58', '2019-06-17'), | |
('58', '2019-07-17'), | |
('58', '2019-08-26'), | |
('58', '2019-09-14'), | |
('58', '2019-10-01'), | |
('58', '2019-11-27'), | |
('58', '2019-12-02'), | |
('59', '2019-10-20'), | |
('59', '2019-11-13'), | |
('59', '2019-12-16'), | |
('60', '2019-07-14'), | |
('60', '2019-08-19'), | |
('60', '2019-09-23'), | |
('61', '2019-03-27'), | |
('61', '2019-04-01'), | |
('61', '2019-05-02'), | |
('61', '2019-06-19'), | |
('61', '2019-07-10'), | |
('61', '2019-08-14'), | |
('61', '2019-09-18'), | |
('61', '2019-10-07'), | |
('61', '2019-11-18'), | |
('61', '2019-12-25'), | |
('62', '2019-02-21'), | |
('62', '2019-03-08'), | |
('62', '2019-04-15'), | |
('62', '2019-05-24'), | |
('62', '2019-06-15'), | |
('62', '2019-07-25'), | |
('63', '2019-08-04'), | |
('63', '2019-09-23'), | |
('63', '2019-10-19'), | |
('63', '2019-11-26'), | |
('63', '2019-12-12'), | |
('64', '2019-02-10'), | |
('64', '2019-03-09'), | |
('64', '2019-04-05'), | |
('64', '2019-05-23'), | |
('64', '2019-06-24'), | |
('64', '2019-07-26'), | |
('64', '2019-08-01'), | |
('64', '2019-09-03'), | |
('64', '2019-10-09'), | |
('64', '2019-11-11'), | |
('64', '2019-12-14'), | |
('65', '2019-03-12'), | |
('65', '2019-04-06'), | |
('65', '2019-05-10'), | |
('65', '2019-06-08'), | |
('65', '2019-07-13'), | |
('65', '2019-08-25'), | |
('66', '2019-05-09'), | |
('66', '2019-06-24'), | |
('66', '2019-07-16'), | |
('66', '2019-08-01'), | |
('66', '2019-09-17'), | |
('66', '2019-10-08'), | |
('66', '2019-11-10'), | |
('66', '2019-12-12'), | |
('67', '2019-08-11'), | |
('67', '2019-09-15'), | |
('67', '2019-10-22'), | |
('67', '2019-11-13'), | |
('67', '2019-12-19'), | |
('68', '2019-06-24'), | |
('68', '2019-07-05'), | |
('68', '2019-08-14'), | |
('68', '2019-09-03'), | |
('68', '2019-10-13'), | |
('68', '2019-11-09'), | |
('68', '2019-12-26'), | |
('69', '2019-01-23'), | |
('69', '2019-02-09'), | |
('69', '2019-03-09'), | |
('69', '2019-04-12'), | |
('69', '2019-05-14'), | |
('69', '2019-06-18'), | |
('70', '2019-10-13'), | |
('70', '2019-11-12'), | |
('70', '2019-12-25'), | |
('71', '2019-02-21'), | |
('72', '2019-06-05'), | |
('72', '2019-07-28'), | |
('72', '2019-08-16'), | |
('72', '2019-09-22'), | |
('72', '2019-10-22'), | |
('72', '2019-11-20'), | |
('72', '2019-12-04'), | |
('73', '2019-04-28'), | |
('73', '2019-05-23'), | |
('73', '2019-06-23'), | |
('73', '2019-07-24'), | |
('73', '2019-08-17'), | |
('73', '2019-09-26'), | |
('74', '2019-04-14'), | |
('74', '2019-05-14'), | |
('74', '2019-06-24'), | |
('74', '2019-07-13'), | |
('74', '2019-08-17'), | |
('74', '2019-09-05'), | |
('74', '2019-10-24'), | |
('75', '2019-04-15'), | |
('76', '2019-04-18'), | |
('76', '2019-05-02'), | |
('76', '2019-06-07'), | |
('76', '2019-07-02'), | |
('76', '2019-08-19'), | |
('76', '2019-09-23'), | |
('76', '2019-10-01'), | |
('76', '2019-11-28'), | |
('76', '2019-12-10'), | |
('77', '2019-06-05'), | |
('78', '2019-01-24'), | |
('79', '2019-11-15'), | |
('79', '2019-12-18'), | |
('80', '2019-04-18'), | |
('80', '2019-05-18'), | |
('80', '2019-06-24'), | |
('80', '2019-07-28'), | |
('80', '2019-08-13'), | |
('80', '2019-09-07'), | |
('80', '2019-10-17'), | |
('81', '2019-01-13'), | |
('81', '2019-02-19'), | |
('81', '2019-03-09'), | |
('81', '2019-04-23'), | |
('81', '2019-05-28'), | |
('81', '2019-06-14'), | |
('82', '2019-04-18'), | |
('82', '2019-05-01'), | |
('82', '2019-06-20'), | |
('82', '2019-07-02'), | |
('82', '2019-08-26'), | |
('82', '2019-09-03'), | |
('82', '2019-10-27'), | |
('83', '2019-06-27'), | |
('83', '2019-07-09'), | |
('83', '2019-08-14'), | |
('83', '2019-09-22'), | |
('83', '2019-10-07'), | |
('83', '2019-11-03'), | |
('83', '2019-12-02'), | |
('84', '2019-06-25'), | |
('84', '2019-07-17'), | |
('84', '2019-08-17'), | |
('84', '2019-09-19'), | |
('84', '2019-10-25'), | |
('84', '2019-11-05'), | |
('84', '2019-12-28'), | |
('85', '2019-08-02'), | |
('85', '2019-09-19'), | |
('86', '2019-11-05'), | |
('86', '2019-12-03'), | |
('87', '2019-06-06'), | |
('87', '2019-07-08'), | |
('87', '2019-08-18'), | |
('87', '2019-09-18'), | |
('87', '2019-10-14'), | |
('87', '2019-11-23'), | |
('87', '2019-12-16'), | |
('88', '2019-03-04'), | |
('88', '2019-04-08'), | |
('88', '2019-05-10'), | |
('88', '2019-06-05'), | |
('88', '2019-07-01'), | |
('88', '2019-08-08'), | |
('88', '2019-09-13'), | |
('88', '2019-10-02'), | |
('88', '2019-11-26'), | |
('88', '2019-12-15'), | |
('89', '2019-11-19'), | |
('89', '2019-12-20'), | |
('90', '2019-06-21'), | |
('90', '2019-07-18'), | |
('90', '2019-08-05'), | |
('90', '2019-09-22'), | |
('90', '2019-10-02'), | |
('90', '2019-11-27'), | |
('90', '2019-12-28'), | |
('91', '2019-10-14'), | |
('91', '2019-11-05'), | |
('92', '2019-02-12'), | |
('93', '2019-02-28'), | |
('93', '2019-03-21'), | |
('93', '2019-04-26'), | |
('93', '2019-05-06'), | |
('93', '2019-06-03'), | |
('93', '2019-07-17'), | |
('94', '2019-03-08'), | |
('94', '2019-04-07'), | |
('94', '2019-05-20'), | |
('94', '2019-06-02'), | |
('94', '2019-07-05'), | |
('94', '2019-08-17'), | |
('94', '2019-09-20'), | |
('94', '2019-10-15'), | |
('94', '2019-11-22'), | |
('95', '2019-04-15'), | |
('95', '2019-05-15'), | |
('95', '2019-06-21'), | |
('95', '2019-07-19'), | |
('95', '2019-08-03'), | |
('95', '2019-09-11'), | |
('95', '2019-10-03'), | |
('96', '2019-07-20'), | |
('96', '2019-08-02'), | |
('96', '2019-09-15'), | |
('96', '2019-10-18'), | |
('97', '2019-07-11'), | |
('97', '2019-08-17'), | |
('98', '2019-07-26'), | |
('98', '2019-08-17'), | |
('98', '2019-09-21'), | |
('99', '2019-04-15'), | |
('99', '2019-05-26'), | |
('99', '2019-06-14'), | |
('99', '2019-07-21'), | |
('99', '2019-08-15'), | |
('99', '2019-09-17'), | |
('99', '2019-10-04'), | |
('99', '2019-11-18'), | |
('99', '2019-12-23'), | |
('100', '2019-06-22'), | |
('100', '2019-07-18'), | |
('100', '2019-08-28'), | |
('100', '2019-09-24'); | |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment