create table installs( user_id int, installed_at timestamp, game varchar(32) ); create table sessions( user_id int, created_at timestamp, game varchar(32) ); insert into installs (user_id, installed_at, game) values (1, '2020-06-07 13:47:00', 'game_7'),(2, '2020-06-04 08:10:33', 'game_1'),(3, '2020-05-23 23:33:33', 'game_1'),(4, '2020-05-27 00:03:17', 'game_7'),(5, '2020-05-13 00:39:30', 'game_9'),(6, '2020-06-03 17:18:53', 'game_3'),(7, '2020-05-20 13:01:38', 'game_3'),(8, '2020-05-12 13:14:02', 'game_5'),(9, '2020-05-29 23:49:04', 'game_6'), (10, '2020-05-26 18:31:55', 'game_2'),(11, '2020-05-17 00:17:56', 'game_3'),(12, '2020-05-23 21:16:12', 'game_3'),(13, '2020-06-06 15:46:57', 'game_6'),(14, '2020-06-07 06:58:57', 'game_5'),(15, '2020-05-29 13:01:36', 'game_7'),(16, '2020-05-22 10:22:29', 'game_5'),(17, '2020-05-24 05:46:11', 'game_8'),(18, '2020-06-01 12:33:56', 'game_7'),(19, '2020-05-31 07:06:49', 'game_3'); insert into sessions (user_id, created_at, game) values (1, '2020-06-08 10:34:37', 'game_7') ,(1, '2020-06-07 14:53:22', 'game_7') ,(1, '2020-06-08 11:30:52', 'game_7') ,(1, '2020-06-08 08:43:10', 'game_7') ,(1, '2020-06-08 10:01:33', 'game_7') ,(1, '2020-06-07 21:30:31', 'game_7') ,(1, '2020-06-07 23:57:44', 'game_7') ,(2, '2020-06-04 09:25:42', 'game_1') ,(2, '2020-06-05 01:55:07', 'game_1') ,(3, '2020-05-25 21:06:30', 'game_1') ,(3, '2020-05-27 13:29:55', 'game_1') ,(3, '2020-06-03 12:02:14', 'game_1') ,(3, '2020-06-02 23:42:33', 'game_1') ,(3, '2020-06-06 19:36:45', 'game_1') ,(4, '2020-05-31 12:11:10', 'game_7') ,(4, '2020-06-04 05:17:37', 'game_7') ,(4, '2020-06-08 03:05:07', 'game_7') ,(4, '2020-06-03 12:46:00', 'game_7') ,(4, '2020-06-05 06:53:12', 'game_7') ,(4, '2020-05-28 13:51:43', 'game_7') ,(4, '2020-06-08 02:53:08', 'game_7') ,(5, '2020-05-31 14:57:04', 'game_9') ,(5, '2020-05-24 11:52:36', 'game_9') ,(5, '2020-06-04 15:06:33', 'game_9') ,(5, '2020-05-31 21:49:48', 'game_9') ,(5, '2020-05-25 03:30:55', 'game_9') ,(5, '2020-05-22 03:07:07', 'game_9') ,(6, '2020-06-08 08:28:22', 'game_3') ,(6, '2020-06-07 15:23:33', 'game_3') ,(6, '2020-06-04 09:59:31', 'game_3') ,(7, '2020-06-04 19:46:01', 'game_3') ,(7, '2020-05-27 14:22:47', 'game_3') ,(7, '2020-05-30 14:49:00', 'game_3') ,(7, '2020-05-28 05:12:30', 'game_3') ,(7, '2020-05-24 16:31:16', 'game_3') ,(7, '2020-06-06 10:59:06', 'game_3') ,(7, '2020-05-25 14:32:35', 'game_3') ,(8, '2020-05-20 14:42:31', 'game_5') ,(9, '2020-06-04 09:29:57', 'game_6') ,(9, '2020-05-30 05:57:15', 'game_6') ,(9, '2020-06-06 21:21:21', 'game_6') ,(9, '2020-06-02 22:58:42', 'game_6') ,(9, '2020-06-05 17:55:45', 'game_6') ,(9, '2020-06-04 09:42:17', 'game_6') ,(10, '2020-06-02 21:06:04', 'game_2') ,(10, '2020-05-29 20:46:19', 'game_2') ,(10, '2020-05-30 20:45:26', 'game_2') ,(10, '2020-06-06 07:18:20', 'game_2') ,(10, '2020-06-05 00:27:05', 'game_2') ,(10, '2020-06-01 06:10:09', 'game_2') ,(10, '2020-06-05 18:48:04', 'game_2') ,(10, '2020-05-30 17:27:34', 'game_2') ,(11, '2020-05-26 11:33:40', 'game_3') ,(12, '2020-05-30 05:45:03', 'game_3') ,(13, '2020-06-07 21:38:12', 'game_6') ,(13, '2020-06-07 02:00:13', 'game_6') ,(13, '2020-06-08 04:22:52', 'game_6') ,(13, '2020-06-07 18:52:01', 'game_6') ,(13, '2020-06-08 09:03:58', 'game_6') ,(13, '2020-06-08 10:08:30', 'game_6') ,(14, '2020-06-08 02:19:04', 'game_5') ,(17, '2020-05-27 12:35:48', 'game_8') ,(17, '2020-05-25 16:18:19', 'game_8') ,(17, '2020-06-02 17:25:33', 'game_8') ,(18, '2020-06-01 15:21:27', 'game_7') ,(18, '2020-06-07 21:55:47', 'game_7') ,(18, '2020-06-07 10:42:20', 'game_7') ,(18, '2020-06-02 13:43:27', 'game_7') ,(18, '2020-06-02 03:58:08', 'game_7') ,(18, '2020-06-07 13:21:14', 'game_7') ,(18, '2020-06-08 09:38:20', 'game_7') ,(19, '2020-06-05 06:56:08', 'game_3') ,(19, '2020-06-04 22:02:40', 'game_3') ,(19, '2020-06-07 19:22:31', 'game_3') ,(19, '2020-06-04 03:20:04', 'game_3') ,(19, '2020-06-04 07:32:44', 'game_3') ,(19, '2020-05-31 17:09:39', 'game_3');