SQLize Online / PHPize Online  /  SQLtest Online

create table skill_managers ( manager_id int, first_name varchar(255), last_name varchar(255), age int, gender varchar(1), age_group varchar(255), birth_date date, last_transaction_dt datetime ); insert into skill_managers values (1, 'Ellis', 'Forbes', 27, 'F', '(25:35)', '1993-06-09', '2020-07-19 02:53:30'), (2, 'Piter', 'Robinson', 24, 'M', '(18:25)', '1996-01-05', '2020-04-13 14:25:06'), (3, 'Piter', 'Graham', 23, 'M', '(18:25)', '1997-07-14', '2020-08-21 17:38:26'), (4, 'Abbie', 'Peters', 25, 'M', '(25:35)', '1995-07-22', '2020-05-11 21:45:55'), (5, 'Ellis', 'Cisneros', 25, 'F', '(25:35)', '1995-07-08', '2020-05-13 02:57:06'), (6, 'Darryl', 'Mathis', 29, 'F', '(25:35)', '1991-07-21', '2020-02-21 20:54:37'), (7, 'Kaiden', 'Wall', 38, 'F', '(35:45)', '1982-08-03', '2020-05-11 17:28:26'), (8, 'Ellis', 'Chen', 25, 'F', '(25:35)', '1995-01-01', '2020-11-17 08:09:44'), (9, 'Paul', 'Lucas', 23, 'M', '(18:25)', '1997-11-28', '2020-02-06 09:01:43'), (10, 'Max', 'Kaiser', 21, 'F', '(18:25)', '1999-04-24', '2020-03-27 01:33:20'), (11, 'Lorelei', 'Espinoza', 23, 'F', '(18:25)', '1997-06-02', '2020-12-20 16:18:46'), (12, 'Lacey', 'Petersen', 54, 'F', '(45:100)', '1966-12-05', '2020-07-14 03:45:28'), (13, 'Luna', 'Ferguson', 25, 'F', '(25:35)', '1995-05-10', '2020-11-18 00:10:51'), (14, 'Zoie', 'Soto', 31, 'F', '(25:35)', '1989-08-10', '2020-09-01 16:59:15'), (15, 'Kira', 'Beasley', 23, 'F', '(18:25)', '1997-08-23', '2020-01-24 00:24:14'), (16, 'Vaughn', 'Wilson', 33, 'F', '(25:35)', '1987-12-06', '2020-08-10 12:21:46'), (17, 'Edwin', 'Ochoa', 37, 'M', '(35:45)', '1983-08-09', '2020-09-24 06:26:02'), (18, 'Piter', 'Floyd', 38, 'F', '(35:45)', '1982-02-03', '2020-07-22 14:27:41'), (19, 'Ivan', 'Conway', 41, 'M', '(35:45)', '1979-01-01', '2020-04-10 17:56:49'), (20, 'Max', 'Spears', 25, 'F', '(25:35)', '1995-07-23', '2020-06-03 11:13:00'), (21, 'Kira', 'Kramer', 42, 'M', '(35:45)', '1978-08-21', '2020-02-20 12:36:43'), (22, 'Maximillian', 'Singh', 42, 'M', '(35:45)', '1978-03-08', '2020-04-23 14:01:51'), (23, 'Paityn', 'Watkins', 33, 'M', '(25:35)', '1987-04-17', '2020-08-18 04:28:18'), (24, 'Delaney', 'Osborne', 43, 'F', '(35:45)', '1977-03-03', '2020-03-10 15:07:11'), (25, 'Nataly', 'Davidson', 25, 'F', '(25:35)', '1995-03-24', '2020-09-01 01:40:04'), (26, 'Paris', 'Kane', 33, 'M', '(25:35)', '1987-09-09', '2020-06-18 01:44:25'), (27, 'Jakobe', 'Pratt', 34, 'M', '(25:35)', '1986-02-08', '2020-02-09 02:28:08'), (28, 'Max', 'Austin', 55, 'M', '(45:100)', '1965-09-20', '2020-11-20 00:32:42'), (29, 'Kendrick', 'Blevins', 36, 'M', '(35:45)', '1984-07-08', '2020-05-26 06:06:19'), (30, 'Cole', 'Romero', 25, 'M', '(25:35)', '1995-11-19', '2020-05-19 04:39:32'), (31, 'Demetrius', 'Becker', 38, 'M', '(35:45)', '1982-11-10', '2020-08-17 06:32:15'), (32, 'Matthias', 'Meadows', 35, 'M', '(35:45)', '1985-01-12', '2020-11-20 22:06:34'), (33, 'Dana', 'Villarreal', 34, 'F', '(25:35)', '1986-07-16', '2020-09-22 13:05:08'), (34, 'Martha', 'Kelly', 33, 'F', '(25:35)', '1987-11-15', '2020-06-06 01:46:05'), (35, 'Kira', 'Fleming', 32, 'F', '(25:35)', '1988-04-19', '2020-03-09 15:57:21'), (36, 'Max', 'Bryant', 33, 'F', '(25:35)', '1987-02-18', '2020-08-22 00:42:12'), (37, 'Patrick', 'O`Connor', 29, 'M', '(25:35)', '1991-01-19', '2020-11-23 00:36:54'), (38, 'Kevin', 'O`Sullivan', 31, 'M', '(25:35)', '1989-11-25', '2020-05-12 00:29:04'), (39, 'Marry', 'O`Higgins', 37, 'F', '(35:45)', '1983-03-07', '2020-12-14 05:13:18'), (40, 'Gerald', 'O`Kelly', 35, 'M', '(35:45)', '1985-01-14', '2020-06-28 08:54:50'), (41, 'Thomas', 'MacAuley', 45, 'M', '(45:100)', '1975-02-12', '2020-09-28 01:02:41'), (42, 'John', 'MacBride', 44, 'M', '(35:45)', '1976-12-23', '2020-06-24 20:48:01'), (43, 'Desmond', 'MacCarthy', 41, 'M', '(35:45)', '1979-04-14', '2020-08-10 16:54:30'), (44, 'Elmo', 'MacElroy', 47, 'M', '(45:100)', '1973-07-01', '2020-08-13 09:18:11'), (45, 'Alice', 'Andersson', 42, 'F', '(35:45)', '1978-10-12', '2020-09-15 12:44:33'), (46, 'Olivia', 'Johansson', 47, 'F', '(45:100)', '1973-06-25', '2020-11-15 20:38:26'), (47, 'William', 'Karlsson', 41, 'M', '(35:45)', '1979-12-25', '2020-12-23 16:49:26'), (48, 'Oliver', 'Nilsson', 51, 'M', '(45:100)', '1969-03-02', '2020-07-08 06:34:36'), (49, 'Matteo', 'Eriksson', 47, 'M', '(45:100)', '1973-03-15', '2020-09-03 21:36:56'), (50, 'Luna', 'Korhonen', 37, 'F', '(35:45)', '1983-03-08', '2020-05-07 11:06:04'), (51, 'Mila', 'Virtanen', 36, 'F', '(35:45)', '1984-11-10', '2020-03-10 00:03:29'), (52, 'Alvar', 'Lehtonen', 41, 'M', '(35:45)', '1979-09-09', '2020-10-22 11:13:33'), (53, 'Valter', 'Koskinen', 47, 'M', '(45:100)', '1973-10-05', '2020-11-09 15:22:59'); create table skill_events ( dt_date date, dt_string varchar(25), dt_string_v2 varchar(25), dt_string_v3 varchar(25), dt_bad_string varchar(35), event varchar(35), manager_id int ); insert into skill_events values ('2020-08-09', '2020-08-09', '2020/08/09', '20200809', '2020 year 8 month 9 day', 'purchase', 1), ('2020-08-11', '2020-08-11', '2020/08/11', '20200811', '2020 year 8 month 11 day', 'deal cancellation', 46), ('2020-08-11', '2020-08-11', '2020/08/11', '20200811', '2020 year 8 month 11 day', 'deal cancellation', 23), ('2020-08-13', '2020-08-13', '2020/08/13', '20200813', '2020 year 8 month 13 day', 'deal cancellation', 53), ('2020-08-13', '2020-08-13', '2020/08/13', '20200813', '2020 year 8 month 13 day', 'purchase', 7), ('2020-08-14', '2020-08-14', '2020/08/14', '20200814', '2020 year 8 month 14 day', 'sale', 42), ('2020-08-14', '2020-08-14', '2020/08/14', '20200814', '2020 year 8 month 14 day', 'sale', 33), ('2020-08-15', '2020-08-15', '2020/08/15', '20200815', '2020 year 8 month 15 day', 'deal cancellation', 16), ('2020-08-16', '2020-08-16', '2020/08/16', '20200816', '2020 year 8 month 16 day', 'deal cancellation', 16), ('2020-08-16', '2020-08-16', '2020/08/16', '20200816', '2020 year 8 month 16 day', 'deal cancellation', 15), ('2020-08-16', '2020-08-16', '2020/08/16', '20200816', '2020 year 8 month 16 day', 'purchase', 50), ('2020-08-18', '2020-08-18', '2020/08/18', '20200818', '2020 year 8 month 18 day', 'purchase', 6), ('2020-08-18', '2020-08-18', '2020/08/18', '20200818', '2020 year 8 month 18 day', 'deal cancellation', 29), ('2020-08-18', '2020-08-18', '2020/08/18', '20200818', '2020 year 8 month 18 day', 'deal cancellation', 12), ('2020-08-19', '2020-08-19', '2020/08/19', '20200819', '2020 year 8 month 19 day', 'purchase', 49), ('2020-08-19', '2020-08-19', '2020/08/19', '20200819', '2020 year 8 month 19 day', 'deal cancellation', 6), ('2020-08-20', '2020-08-20', '2020/08/20', '20200820', '2020 year 8 month 20 day', 'deal cancellation', 12), ('2020-08-20', '2020-08-20', '2020/08/20', '20200820', '2020 year 8 month 20 day', 'deal cancellation', 9), ('2020-08-20', '2020-08-20', '2020/08/20', '20200820', '2020 year 8 month 20 day', 'purchase', 36), ('2020-08-20', '2020-08-20', '2020/08/20', '20200820', '2020 year 8 month 20 day', 'purchase', 8), ('2020-08-20', '2020-08-20', '2020/08/20', '20200820', '2020 year 8 month 20 day', 'purchase', 23), ('2020-08-21', '2020-08-21', '2020/08/21', '20200821', '2020 year 8 month 21 day', 'sale', 7), ('2020-08-22', '2020-08-22', '2020/08/22', '20200822', '2020 year 8 month 22 day', 'deal cancellation', 14), ('2020-08-22', '2020-08-22', '2020/08/22', '20200822', '2020 year 8 month 22 day', 'purchase', 20), ('2020-08-22', '2020-08-22', '2020/08/22', '20200822', '2020 year 8 month 22 day', 'purchase', 12), ('2020-08-22', '2020-08-22', '2020/08/22', '20200822', '2020 year 8 month 22 day', 'sale', 28), ('2020-08-22', '2020-08-22', '2020/08/22', '20200822', '2020 year 8 month 22 day', 'deal cancellation', 25), ('2020-08-23', '2020-08-23', '2020/08/23', '20200823', '2020 year 8 month 23 day', 'sale', 3), ('2020-08-23', '2020-08-23', '2020/08/23', '20200823', '2020 year 8 month 23 day', 'deal cancellation', 31), ('2020-08-23', '2020-08-23', '2020/08/23', '20200823', '2020 year 8 month 23 day', 'purchase', 6), ('2020-08-24', '2020-08-24', '2020/08/24', '20200824', '2020 year 8 month 24 day', 'purchase', 15), ('2020-08-25', '2020-08-25', '2020/08/25', '20200825', '2020 year 8 month 25 day', 'sale', 39), ('2020-08-26', '2020-08-26', '2020/08/26', '20200826', '2020 year 8 month 26 day', 'sale', 49), ('2020-08-26', '2020-08-26', '2020/08/26', '20200826', '2020 year 8 month 26 day', 'purchase', 1), ('2020-08-26', '2020-08-26', '2020/08/26', '20200826', '2020 year 8 month 26 day', 'deal cancellation', 50), ('2020-08-26', '2020-08-26', '2020/08/26', '20200826', '2020 year 8 month 26 day', 'purchase', 49), ('2020-08-26', '2020-08-26', '2020/08/26', '20200826', '2020 year 8 month 26 day', 'sale', 47), ('2020-08-27', '2020-08-27', '2020/08/27', '20200827', '2020 year 8 month 27 day', 'deal cancellation', 5), ('2020-08-27', '2020-08-27', '2020/08/27', '20200827', '2020 year 8 month 27 day', 'deal cancellation', 27), ('2020-08-27', '2020-08-27', '2020/08/27', '20200827', '2020 year 8 month 27 day', 'purchase', 27), ('2020-08-27', '2020-08-27', '2020/08/27', '20200827', '2020 year 8 month 27 day', 'deal cancellation', 3), ('2020-08-27', '2020-08-27', '2020/08/27', '20200827', '2020 year 8 month 27 day', 'deal cancellation', 30), ('2020-08-28', '2020-08-28', '2020/08/28', '20200828', '2020 year 8 month 28 day', 'purchase', 28), ('2020-08-29', '2020-08-29', '2020/08/29', '20200829', '2020 year 8 month 29 day', 'purchase', 35), ('2020-08-29', '2020-08-29', '2020/08/29', '20200829', '2020 year 8 month 29 day', 'purchase', 7), ('2020-08-29', '2020-08-29', '2020/08/29', '20200829', '2020 year 8 month 29 day', 'purchase', 49), ('2020-08-29', '2020-08-29', '2020/08/29', '20200829', '2020 year 8 month 29 day', 'deal cancellation', 19), ('2020-08-29', '2020-08-29', '2020/08/29', '20200829', '2020 year 8 month 29 day', 'purchase', 41), ('2020-08-30', '2020-08-30', '2020/08/30', '20200830', '2020 year 8 month 30 day', 'purchase', 51), ('2020-08-30', '2020-08-30', '2020/08/30', '20200830', '2020 year 8 month 30 day', 'sale', 52), ('2020-08-30', '2020-08-30', '2020/08/30', '20200830', '2020 year 8 month 30 day', 'sale', 34), ('2020-08-30', '2020-08-30', '2020/08/30', '20200830', '2020 year 8 month 30 day', 'sale', 2), ('2020-08-30', '2020-08-30', '2020/08/30', '20200830', '2020 year 8 month 30 day', 'deal cancellation', 14), ('2020-08-31', '2020-08-31', '2020/08/31', '20200831', '2020 year 8 month 31 day', 'deal cancellation', 41), ('2020-08-31', '2020-08-31', '2020/08/31', '20200831', '2020 year 8 month 31 day', 'purchase', 35), ('2020-09-01', '2020-09-01', '2020/09/01', '20200901', '2020 year 9 month 1 day', 'sale', 31), ('2020-09-01', '2020-09-01', '2020/09/01', '20200901', '2020 year 9 month 1 day', 'deal cancellation', 19), ('2020-09-01', '2020-09-01', '2020/09/01', '20200901', '2020 year 9 month 1 day', 'sale', 37), ('2020-09-01', '2020-09-01', '2020/09/01', '20200901', '2020 year 9 month 1 day', 'purchase', 6), ('2020-09-01', '2020-09-01', '2020/09/01', '20200901', '2020 year 9 month 1 day', 'purchase', 7), ('2020-09-02', '2020-09-02', '2020/09/02', '20200902', '2020 year 9 month 2 day', 'sale', 6), ('2020-09-02', '2020-09-02', '2020/09/02', '20200902', '2020 year 9 month 2 day', 'deal cancellation', 18), ('2020-09-03', '2020-09-03', '2020/09/03', '20200903', '2020 year 9 month 3 day', 'purchase', 12), ('2020-09-03', '2020-09-03', '2020/09/03', '20200903', '2020 year 9 month 3 day', 'sale', 18), ('2020-09-03', '2020-09-03', '2020/09/03', '20200903', '2020 year 9 month 3 day', 'purchase', 45), ('2020-09-03', '2020-09-03', '2020/09/03', '20200903', '2020 year 9 month 3 day', 'purchase', 35), ('2020-09-03', '2020-09-03', '2020/09/03', '20200903', '2020 year 9 month 3 day', 'deal cancellation', 44), ('2020-09-04', '2020-09-04', '2020/09/04', '20200904', '2020 year 9 month 4 day', 'deal cancellation', 18), ('2020-09-04', '2020-09-04', '2020/09/04', '20200904', '2020 year 9 month 4 day', 'deal cancellation', 15), ('2020-09-04', '2020-09-04', '2020/09/04', '20200904', '2020 year 9 month 4 day', 'purchase', 11), ('2020-09-04', '2020-09-04', '2020/09/04', '20200904', '2020 year 9 month 4 day', 'deal cancellation', 3), ('2020-09-05', '2020-09-05', '2020/09/05', '20200905', '2020 year 9 month 5 day', 'purchase', 46), ('2020-09-05', '2020-09-05', '2020/09/05', '20200905', '2020 year 9 month 5 day', 'sale', 37), ('2020-09-05', '2020-09-05', '2020/09/05', '20200905', '2020 year 9 month 5 day', 'deal cancellation', 38), ('2020-09-06', '2020-09-06', '2020/09/06', '20200906', '2020 year 9 month 6 day', 'purchase', 17), ('2020-09-06', '2020-09-06', '2020/09/06', '20200906', '2020 year 9 month 6 day', 'sale', 48), ('2020-09-06', '2020-09-06', '2020/09/06', '20200906', '2020 year 9 month 6 day', 'sale', 38), ('2020-09-06', '2020-09-06', '2020/09/06', '20200906', '2020 year 9 month 6 day', 'purchase', 36), ('2020-09-07', '2020-09-07', '2020/09/07', '20200907', '2020 year 9 month 7 day', 'purchase', 20), ('2020-09-07', '2020-09-07', '2020/09/07', '20200907', '2020 year 9 month 7 day', 'deal cancellation', 48), ('2020-09-08', '2020-09-08', '2020/09/08', '20200908', '2020 year 9 month 8 day', 'sale', 9), ('2020-09-09', '2020-09-09', '2020/09/09', '20200909', '2020 year 9 month 9 day', 'sale', 48), ('2020-09-10', '2020-09-10', '2020/09/10', '20200910', '2020 year 9 month 10 day', 'purchase', 3), ('2020-09-10', '2020-09-10', '2020/09/10', '20200910', '2020 year 9 month 10 day', 'sale', 26), ('2020-09-11', '2020-09-11', '2020/09/11', '20200911', '2020 year 9 month 11 day', 'purchase', 2), ('2020-09-11', '2020-09-11', '2020/09/11', '20200911', '2020 year 9 month 11 day', 'deal cancellation', 33), ('2020-09-11', '2020-09-11', '2020/09/11', '20200911', '2020 year 9 month 11 day', 'deal cancellation', 9), ('2020-09-11', '2020-09-11', '2020/09/11', '20200911', '2020 year 9 month 11 day', 'sale', 13), ('2020-09-11', '2020-09-11', '2020/09/11', '20200911', '2020 year 9 month 11 day', 'sale', 44), ('2020-09-12', '2020-09-12', '2020/09/12', '20200912', '2020 year 9 month 12 day', 'sale', 47), ('2020-09-13', '2020-09-13', '2020/09/13', '20200913', '2020 year 9 month 13 day', 'purchase', 22), ('2020-09-13', '2020-09-13', '2020/09/13', '20200913', '2020 year 9 month 13 day', 'purchase', 43), ('2020-09-13', '2020-09-13', '2020/09/13', '20200913', '2020 year 9 month 13 day', 'sale', 30), ('2020-09-13', '2020-09-13', '2020/09/13', '20200913', '2020 year 9 month 13 day', 'deal cancellation', 4), ('2020-09-13', '2020-09-13', '2020/09/13', '20200913', '2020 year 9 month 13 day', 'purchase', 51), ('2020-09-14', '2020-09-14', '2020/09/14', '20200914', '2020 year 9 month 14 day', 'deal cancellation', 31), ('2020-09-14', '2020-09-14', '2020/09/14', '20200914', '2020 year 9 month 14 day', 'sale', 19), ('2020-09-14', '2020-09-14', '2020/09/14', '20200914', '2020 year 9 month 14 day', 'purchase', 11), ('2020-09-14', '2020-09-14', '2020/09/14', '20200914', '2020 year 9 month 14 day', 'deal cancellation', 25), ('2020-09-15', '2020-09-15', '2020/09/15', '20200915', '2020 year 9 month 15 day', 'purchase', 12), ('2020-09-15', '2020-09-15', '2020/09/15', '20200915', '2020 year 9 month 15 day', 'deal cancellation', 34), ('2020-09-15', '2020-09-15', '2020/09/15', '20200915', '2020 year 9 month 15 day', 'sale', 11), ('2020-09-16', '2020-09-16', '2020/09/16', '20200916', '2020 year 9 month 16 day', 'purchase', 15), ('2020-09-16', '2020-09-16', '2020/09/16', '20200916', '2020 year 9 month 16 day', 'sale', 9), ('2020-09-16', '2020-09-16', '2020/09/16', '20200916', '2020 year 9 month 16 day', 'purchase', 5), ('2020-09-17', '2020-09-17', '2020/09/17', '20200917', '2020 year 9 month 17 day', 'purchase', 21), ('2020-09-17', '2020-09-17', '2020/09/17', '20200917', '2020 year 9 month 17 day', 'purchase', 32), ('2020-09-17', '2020-09-17', '2020/09/17', '20200917', '2020 year 9 month 17 day', 'deal cancellation', 1), ('2020-09-19', '2020-09-19', '2020/09/19', '20200919', '2020 year 9 month 19 day', 'deal cancellation', 36), ('2020-09-19', '2020-09-19', '2020/09/19', '20200919', '2020 year 9 month 19 day', 'purchase', 3), ('2020-09-19', '2020-09-19', '2020/09/19', '20200919', '2020 year 9 month 19 day', 'purchase', 43), ('2020-09-19', '2020-09-19', '2020/09/19', '20200919', '2020 year 9 month 19 day', 'sale', 25), ('2020-09-20', '2020-09-20', '2020/09/20', '20200920', '2020 year 9 month 20 day', 'sale', 46), ('2020-09-20', '2020-09-20', '2020/09/20', '20200920', '2020 year 9 month 20 day', 'sale', 45), ('2020-09-20', '2020-09-20', '2020/09/20', '20200920', '2020 year 9 month 20 day', 'sale', 35), ('2020-09-20', '2020-09-20', '2020/09/20', '20200920', '2020 year 9 month 20 day', 'purchase', 39), ('2020-09-21', '2020-09-21', '2020/09/21', '20200921', '2020 year 9 month 21 day', 'sale', 52), ('2020-09-21', '2020-09-21', '2020/09/21', '20200921', '2020 year 9 month 21 day', 'purchase', 33), ('2020-09-21', '2020-09-21', '2020/09/21', '20200921', '2020 year 9 month 21 day', 'purchase', 13), ('2020-09-21', '2020-09-21', '2020/09/21', '20200921', '2020 year 9 month 21 day', 'sale', 4), ('2020-09-21', '2020-09-21', '2020/09/21', '20200921', '2020 year 9 month 21 day', 'purchase', 39), ('2020-09-22', '2020-09-22', '2020/09/22', '20200922', '2020 year 9 month 22 day', 'sale', 34), ('2020-09-23', '2020-09-23', '2020/09/23', '20200923', '2020 year 9 month 23 day', 'deal cancellation', 13), ('2020-09-23', '2020-09-23', '2020/09/23', '20200923', '2020 year 9 month 23 day', 'purchase', 44), ('2020-09-23', '2020-09-23', '2020/09/23', '20200923', '2020 year 9 month 23 day', 'purchase', 15), ('2020-09-24', '2020-09-24', '2020/09/24', '20200924', '2020 year 9 month 24 day', 'sale', 7), ('2020-09-24', '2020-09-24', '2020/09/24', '20200924', '2020 year 9 month 24 day', 'deal cancellation', 2), ('2020-09-24', '2020-09-24', '2020/09/24', '20200924', '2020 year 9 month 24 day', 'sale', 32), ('2020-09-24', '2020-09-24', '2020/09/24', '20200924', '2020 year 9 month 24 day', 'sale', 33), ('2020-09-25', '2020-09-25', '2020/09/25', '20200925', '2020 year 9 month 25 day', 'deal cancellation', 35), ('2020-09-28', '2020-09-28', '2020/09/28', '20200928', '2020 year 9 month 28 day', 'sale', 28), ('2020-10-02', '2020-10-02', '2020/10/02', '20201002', '2020 year 10 month 2 day', 'sale', 51), ('2020-10-02', '2020-10-02', '2020/10/02', '20201002', '2020 year 10 month 2 day', 'sale', 5), ('2020-10-02', '2020-10-02', '2020/10/02', '20201002', '2020 year 10 month 2 day', 'sale', 36), ('2020-10-02', '2020-10-02', '2020/10/02', '20201002', '2020 year 10 month 2 day', 'purchase', 40), ('2020-10-02', '2020-10-02', '2020/10/02', '20201002', '2020 year 10 month 2 day', 'sale', 33), ('2020-10-03', '2020-10-03', '2020/10/03', '20201003', '2020 year 10 month 3 day', 'purchase', 42), ('2020-10-07', '2020-10-07', '2020/10/07', '20201007', '2020 year 10 month 7 day', 'deal cancellation', 15), ('2020-10-07', '2020-10-07', '2020/10/07', '20201007', '2020 year 10 month 7 day', 'sale', 8), ('2020-10-07', '2020-10-07', '2020/10/07', '20201007', '2020 year 10 month 7 day', 'purchase', 1), ('2020-10-07', '2020-10-07', '2020/10/07', '20201007', '2020 year 10 month 7 day', 'purchase', 41), ('2020-10-07', '2020-10-07', '2020/10/07', '20201007', '2020 year 10 month 7 day', 'sale', 5), ('2020-10-08', '2020-10-08', '2020/10/08', '20201008', '2020 year 10 month 8 day', 'deal cancellation', 6), ('2020-10-08', '2020-10-08', '2020/10/08', '20201008', '2020 year 10 month 8 day', 'purchase', 24), ('2020-10-08', '2020-10-08', '2020/10/08', '20201008', '2020 year 10 month 8 day', 'deal cancellation', 21), ('2020-10-08', '2020-10-08', '2020/10/08', '20201008', '2020 year 10 month 8 day', 'purchase', 46), ('2020-10-10', '2020-10-10', '2020/10/10', '20201010', '2020 year 10 month 10 day', 'sale', 46), ('2020-10-10', '2020-10-10', '2020/10/10', '20201010', '2020 year 10 month 10 day', 'deal cancellation', 25), ('2020-10-10', '2020-10-10', '2020/10/10', '20201010', '2020 year 10 month 10 day', 'sale', 7), ('2020-10-10', '2020-10-10', '2020/10/10', '20201010', '2020 year 10 month 10 day', 'purchase', 7), ('2020-10-11', '2020-10-11', '2020/10/11', '20201011', '2020 year 10 month 11 day', 'deal cancellation', 6), ('2020-10-11', '2020-10-11', '2020/10/11', '20201011', '2020 year 10 month 11 day', 'sale', 27), ('2020-10-11', '2020-10-11', '2020/10/11', '20201011', '2020 year 10 month 11 day', 'deal cancellation', 38), ('2020-10-12', '2020-10-12', '2020/10/12', '20201012', '2020 year 10 month 12 day', 'deal cancellation', 47), ('2020-10-12', '2020-10-12', '2020/10/12', '20201012', '2020 year 10 month 12 day', 'purchase', 36), ('2020-10-14', '2020-10-14', '2020/10/14', '20201014', '2020 year 10 month 14 day', 'purchase', 15), ('2020-10-14', '2020-10-14', '2020/10/14', '20201014', '2020 year 10 month 14 day', 'deal cancellation', 37), ('2020-10-14', '2020-10-14', '2020/10/14', '20201014', '2020 year 10 month 14 day', 'deal cancellation', 12), ('2020-10-15', '2020-10-15', '2020/10/15', '20201015', '2020 year 10 month 15 day', 'sale', 35), ('2020-10-15', '2020-10-15', '2020/10/15', '20201015', '2020 year 10 month 15 day', 'deal cancellation', 11), ('2020-10-15', '2020-10-15', '2020/10/15', '20201015', '2020 year 10 month 15 day', 'purchase', 45), ('2020-10-15', '2020-10-15', '2020/10/15', '20201015', '2020 year 10 month 15 day', 'purchase', 34), ('2020-10-16', '2020-10-16', '2020/10/16', '20201016', '2020 year 10 month 16 day', 'purchase', 13), ('2020-10-16', '2020-10-16', '2020/10/16', '20201016', '2020 year 10 month 16 day', 'sale', 10), ('2020-10-18', '2020-10-18', '2020/10/18', '20201018', '2020 year 10 month 18 day', 'deal cancellation', 11), ('2020-10-18', '2020-10-18', '2020/10/18', '20201018', '2020 year 10 month 18 day', 'sale', 16), ('2020-10-18', '2020-10-18', '2020/10/18', '20201018', '2020 year 10 month 18 day', 'purchase', 38), ('2020-10-18', '2020-10-18', '2020/10/18', '20201018', '2020 year 10 month 18 day', 'purchase', 50), ('2020-10-18', '2020-10-18', '2020/10/18', '20201018', '2020 year 10 month 18 day', 'purchase', 23), ('2020-10-19', '2020-10-19', '2020/10/19', '20201019', '2020 year 10 month 19 day', 'purchase', 24), ('2020-10-20', '2020-10-20', '2020/10/20', '20201020', '2020 year 10 month 20 day', 'purchase', 21), ('2020-10-20', '2020-10-20', '2020/10/20', '20201020', '2020 year 10 month 20 day', 'deal cancellation', 2), ('2020-10-20', '2020-10-20', '2020/10/20', '20201020', '2020 year 10 month 20 day', 'purchase', 42), ('2020-10-20', '2020-10-20', '2020/10/20', '20201020', '2020 year 10 month 20 day', 'sale', 37), ('2020-10-20', '2020-10-20', '2020/10/20', '20201020', '2020 year 10 month 20 day', 'sale', 10), ('2020-10-21', '2020-10-21', '2020/10/21', '20201021', '2020 year 10 month 21 day', 'sale', 38), ('2020-10-21', '2020-10-21', '2020/10/21', '20201021', '2020 year 10 month 21 day', 'sale', 13), ('2020-10-21', '2020-10-21', '2020/10/21', '20201021', '2020 year 10 month 21 day', 'deal cancellation', 38), ('2020-10-21', '2020-10-21', '2020/10/21', '20201021', '2020 year 10 month 21 day', 'sale', 13), ('2020-10-22', '2020-10-22', '2020/10/22', '20201022', '2020 year 10 month 22 day', 'purchase', 32), ('2020-10-22', '2020-10-22', '2020/10/22', '20201022', '2020 year 10 month 22 day', 'sale', 15), ('2020-10-23', '2020-10-23', '2020/10/23', '20201023', '2020 year 10 month 23 day', 'deal cancellation', 8), ('2020-10-23', '2020-10-23', '2020/10/23', '20201023', '2020 year 10 month 23 day', 'sale', 38), ('2020-10-23', '2020-10-23', '2020/10/23', '20201023', '2020 year 10 month 23 day', 'purchase', 24), ('2020-10-23', '2020-10-23', '2020/10/23', '20201023', '2020 year 10 month 23 day', 'sale', 15), ('2020-10-23', '2020-10-23', '2020/10/23', '20201023', '2020 year 10 month 23 day', 'sale', 35), ('2020-10-25', '2020-10-25', '2020/10/25', '20201025', '2020 year 10 month 25 day', 'purchase', 40), ('2020-10-25', '2020-10-25', '2020/10/25', '20201025', '2020 year 10 month 25 day', 'purchase', 12), ('2020-10-25', '2020-10-25', '2020/10/25', '20201025', '2020 year 10 month 25 day', 'purchase', 31), ('2020-10-27', '2020-10-27', '2020/10/27', '20201027', '2020 year 10 month 27 day', 'deal cancellation', 15), ('2020-10-28', '2020-10-28', '2020/10/28', '20201028', '2020 year 10 month 28 day', 'sale', 50), ('2020-10-28', '2020-10-28', '2020/10/28', '20201028', '2020 year 10 month 28 day', 'deal cancellation', 45), ('2020-10-28', '2020-10-28', '2020/10/28', '20201028', '2020 year 10 month 28 day', 'deal cancellation', 10), ('2020-10-28', '2020-10-28', '2020/10/28', '20201028', '2020 year 10 month 28 day', 'sale', 49), ('2020-10-28', '2020-10-28', '2020/10/28', '20201028', '2020 year 10 month 28 day', 'sale', 21), ('2020-10-29', '2020-10-29', '2020/10/29', '20201029', '2020 year 10 month 29 day', 'purchase', 49), ('2020-10-30', '2020-10-30', '2020/10/30', '20201030', '2020 year 10 month 30 day', 'deal cancellation', 21), ('2020-10-30', '2020-10-30', '2020/10/30', '20201030', '2020 year 10 month 30 day', 'deal cancellation', 33), ('2020-10-30', '2020-10-30', '2020/10/30', '20201030', '2020 year 10 month 30 day', 'deal cancellation', 33), ('2020-10-30', '2020-10-30', '2020/10/30', '20201030', '2020 year 10 month 30 day', 'purchase', 3), ('2020-10-30', '2020-10-30', '2020/10/30', '20201030', '2020 year 10 month 30 day', 'sale', 6), ('2020-11-01', '2020-11-01', '2020/11/01', '20201101', '2020 year 11 month 1 day', 'purchase', 3), ('2020-11-02', '2020-11-02', '2020/11/02', '20201102', '2020 year 11 month 2 day', 'purchase', 18), ('2020-11-02', '2020-11-02', '2020/11/02', '20201102', '2020 year 11 month 2 day', 'purchase', 34), ('2020-11-02', '2020-11-02', '2020/11/02', '20201102', '2020 year 11 month 2 day', 'deal cancellation', 39), ('2020-11-02', '2020-11-02', '2020/11/02', '20201102', '2020 year 11 month 2 day', 'sale', 33), ('2020-11-03', '2020-11-03', '2020/11/03', '20201103', '2020 year 11 month 3 day', 'deal cancellation', 34), ('2020-11-03', '2020-11-03', '2020/11/03', '20201103', '2020 year 11 month 3 day', 'deal cancellation', 22), ('2020-11-03', '2020-11-03', '2020/11/03', '20201103', '2020 year 11 month 3 day', 'purchase', 48), ('2020-11-03', '2020-11-03', '2020/11/03', '20201103', '2020 year 11 month 3 day', 'sale', 15), ('2020-11-04', '2020-11-04', '2020/11/04', '20201104', '2020 year 11 month 4 day', 'sale', 6), ('2020-11-04', '2020-11-04', '2020/11/04', '20201104', '2020 year 11 month 4 day', 'purchase', 31), ('2020-11-04', '2020-11-04', '2020/11/04', '20201104', '2020 year 11 month 4 day', 'purchase', 37), ('2020-11-04', '2020-11-04', '2020/11/04', '20201104', '2020 year 11 month 4 day', 'sale', 3), ('2020-11-04', '2020-11-04', '2020/11/04', '20201104', '2020 year 11 month 4 day', 'sale', 12), ('2020-11-05', '2020-11-05', '2020/11/05', '20201105', '2020 year 11 month 5 day', 'purchase', 19), ('2020-11-05', '2020-11-05', '2020/11/05', '20201105', '2020 year 11 month 5 day', 'sale', 27), ('2020-11-05', '2020-11-05', '2020/11/05', '20201105', '2020 year 11 month 5 day', 'sale', 42), ('2020-11-06', '2020-11-06', '2020/11/06', '20201106', '2020 year 11 month 6 day', 'purchase', 13), ('2020-11-06', '2020-11-06', '2020/11/06', '20201106', '2020 year 11 month 6 day', 'purchase', 39), ('2020-11-06', '2020-11-06', '2020/11/06', '20201106', '2020 year 11 month 6 day', 'purchase', 8), ('2020-11-06', '2020-11-06', '2020/11/06', '20201106', '2020 year 11 month 6 day', 'sale', 46), ('2020-11-06', '2020-11-06', '2020/11/06', '20201106', '2020 year 11 month 6 day', 'purchase', 26), ('2020-11-07', '2020-11-07', '2020/11/07', '20201107', '2020 year 11 month 7 day', 'deal cancellation', 48), ('2020-11-07', '2020-11-07', '2020/11/07', '20201107', '2020 year 11 month 7 day', 'sale', 40), ('2020-11-07', '2020-11-07', '2020/11/07', '20201107', '2020 year 11 month 7 day', 'sale', 25), ('2020-11-07', '2020-11-07', '2020/11/07', '20201107', '2020 year 11 month 7 day', 'sale', 47), ('2020-11-07', '2020-11-07', '2020/11/07', '20201107', '2020 year 11 month 7 day', 'sale', 27), ('2020-11-08', '2020-11-08', '2020/11/08', '20201108', '2020 year 11 month 8 day', 'purchase', 26), ('2020-11-08', '2020-11-08', '2020/11/08', '20201108', '2020 year 11 month 8 day', 'sale', 7), ('2020-11-08', '2020-11-08', '2020/11/08', '20201108', '2020 year 11 month 8 day', 'purchase', 36), ('2020-11-08', '2020-11-08', '2020/11/08', '20201108', '2020 year 11 month 8 day', 'deal cancellation', 41), ('2020-11-09', '2020-11-09', '2020/11/09', '20201109', '2020 year 11 month 9 day', 'deal cancellation', 53), ('2020-11-09', '2020-11-09', '2020/11/09', '20201109', '2020 year 11 month 9 day', 'deal cancellation', 33), ('2020-11-09', '2020-11-09', '2020/11/09', '20201109', '2020 year 11 month 9 day', 'sale', 31), ('2020-11-09', '2020-11-09', '2020/11/09', '20201109', '2020 year 11 month 9 day', 'sale', 16), ('2020-11-10', '2020-11-10', '2020/11/10', '20201110', '2020 year 11 month 10 day', 'deal cancellation', 42), ('2020-11-10', '2020-11-10', '2020/11/10', '20201110', '2020 year 11 month 10 day', 'purchase', 49), ('2020-11-10', '2020-11-10', '2020/11/10', '20201110', '2020 year 11 month 10 day', 'sale', 34), ('2020-11-11', '2020-11-11', '2020/11/11', '20201111', '2020 year 11 month 11 day', 'purchase', 7), ('2020-11-11', '2020-11-11', '2020/11/11', '20201111', '2020 year 11 month 11 day', 'sale', 6), ('2020-11-11', '2020-11-11', '2020/11/11', '20201111', '2020 year 11 month 11 day', 'sale', 4), ('2020-11-12', '2020-11-12', '2020/11/12', '20201112', '2020 year 11 month 12 day', 'purchase', 7), ('2020-11-13', '2020-11-13', '2020/11/13', '20201113', '2020 year 11 month 13 day', 'sale', 21), ('2020-11-13', '2020-11-13', '2020/11/13', '20201113', '2020 year 11 month 13 day', 'purchase', 14), ('2020-11-13', '2020-11-13', '2020/11/13', '20201113', '2020 year 11 month 13 day', 'purchase', 44), ('2020-11-13', '2020-11-13', '2020/11/13', '20201113', '2020 year 11 month 13 day', 'sale', 24), ('2020-11-15', '2020-11-15', '2020/11/15', '20201115', '2020 year 11 month 15 day', 'purchase', 19), ('2020-11-15', '2020-11-15', '2020/11/15', '20201115', '2020 year 11 month 15 day', 'deal cancellation', 40), ('2020-11-15', '2020-11-15', '2020/11/15', '20201115', '2020 year 11 month 15 day', 'sale', 15), ('2020-11-15', '2020-11-15', '2020/11/15', '20201115', '2020 year 11 month 15 day', 'purchase', 25), ('2020-11-16', '2020-11-16', '2020/11/16', '20201116', '2020 year 11 month 16 day', 'sale', 7), ('2020-11-16', '2020-11-16', '2020/11/16', '20201116', '2020 year 11 month 16 day', 'purchase', 40), ('2020-11-16', '2020-11-16', '2020/11/16', '20201116', '2020 year 11 month 16 day', 'deal cancellation', 11), ('2020-11-16', '2020-11-16', '2020/11/16', '20201116', '2020 year 11 month 16 day', 'deal cancellation', 51); create table skill_operation ( year int, month int, day int, event varchar(35), manager_id int ); insert into skill_operation values (2020, 8, 9, 'purchase', 1), (2020, 8, 11, 'deal cancellation', 46), (2020, 8, 11, 'deal cancellation', 23), (2020, 8, 13, 'deal cancellation', 53), (2020, 8, 13, 'purchase', 7), (2020, 8, 14, 'sale', 42), (2020, 8, 14, 'sale', 33), (2020, 8, 15, 'deal cancellation', 16), (2020, 8, 16, 'deal cancellation', 16), (2020, 8, 16, 'deal cancellation', 15), (2020, 8, 16, 'purchase', 50), (2020, 8, 18, 'purchase', 6), (2020, 8, 18, 'deal cancellation', 29), (2020, 8, 18, 'deal cancellation', 12), (2020, 8, 19, 'purchase', 49), (2020, 8, 19, 'deal cancellation', 6), (2020, 8, 20, 'deal cancellation', 12), (2020, 8, 20, 'deal cancellation', 9), (2020, 8, 20, 'purchase', 36), (2020, 8, 20, 'purchase', 8), (2020, 8, 20, 'purchase', 23), (2020, 8, 21, 'sale', 7), (2020, 8, 22, 'deal cancellation', 14), (2020, 8, 22, 'purchase', 20), (2020, 8, 22, 'purchase', 12), (2020, 8, 22, 'sale', 28), (2020, 8, 22, 'deal cancellation', 25), (2020, 8, 23, 'sale', 3), (2020, 8, 23, 'deal cancellation', 31), (2020, 8, 23, 'purchase', 6), (2020, 8, 24, 'purchase', 15), (2020, 8, 25, 'sale', 39), (2020, 8, 26, 'sale', 49), (2020, 8, 26, 'purchase', 1), (2020, 8, 26, 'deal cancellation', 50), (2020, 8, 26, 'purchase', 49), (2020, 8, 26, 'sale', 47), (2020, 8, 27, 'deal cancellation', 5), (2020, 8, 27, 'deal cancellation', 27), (2020, 8, 27, 'purchase', 27), (2020, 8, 27, 'deal cancellation', 3), (2020, 8, 27, 'deal cancellation', 30), (2020, 8, 28, 'purchase', 28), (2020, 8, 29, 'purchase', 35), (2020, 8, 29, 'purchase', 7), (2020, 8, 29, 'purchase', 49), (2020, 8, 29, 'deal cancellation', 19), (2020, 8, 29, 'purchase', 41), (2020, 8, 30, 'purchase', 51), (2020, 8, 30, 'sale', 52), (2020, 8, 30, 'sale', 34), (2020, 8, 30, 'sale', 2), (2020, 8, 30, 'deal cancellation', 14), (2020, 8, 31, 'deal cancellation', 41), (2020, 8, 31, 'purchase', 35), (2020, 9, 1, 'sale', 31), (2020, 9, 1, 'deal cancellation', 19), (2020, 9, 1, 'sale', 37), (2020, 9, 1, 'purchase', 6), (2020, 9, 1, 'purchase', 7), (2020, 9, 2, 'sale', 6), (2020, 9, 2, 'deal cancellation', 18), (2020, 9, 3, 'purchase', 12), (2020, 9, 3, 'sale', 18), (2020, 9, 3, 'purchase', 45), (2020, 9, 3, 'purchase', 35), (2020, 9, 3, 'deal cancellation', 44), (2020, 9, 4, 'deal cancellation', 18), (2020, 9, 4, 'deal cancellation', 15), (2020, 9, 4, 'purchase', 11), (2020, 9, 4, 'deal cancellation', 3), (2020, 9, 5, 'purchase', 46), (2020, 9, 5, 'sale', 37), (2020, 9, 5, 'deal cancellation', 38), (2020, 9, 6, 'purchase', 17), (2020, 9, 6, 'sale', 48), (2020, 9, 6, 'sale', 38), (2020, 9, 6, 'purchase', 36), (2020, 9, 7, 'purchase', 20), (2020, 9, 7, 'deal cancellation', 48), (2020, 9, 8, 'sale', 9), (2020, 9, 9, 'sale', 48), (2020, 9, 10, 'purchase', 3), (2020, 9, 10, 'sale', 26), (2020, 9, 11, 'purchase', 2), (2020, 9, 11, 'deal cancellation', 33), (2020, 9, 11, 'deal cancellation', 9), (2020, 9, 11, 'sale', 13), (2020, 9, 11, 'sale', 44), (2020, 9, 12, 'sale', 47), (2020, 9, 13, 'purchase', 22), (2020, 9, 13, 'purchase', 43), (2020, 9, 13, 'sale', 30), (2020, 9, 13, 'deal cancellation', 4), (2020, 9, 13, 'purchase', 51), (2020, 9, 14, 'deal cancellation', 31), (2020, 9, 14, 'sale', 19), (2020, 9, 14, 'purchase', 11), (2020, 9, 14, 'deal cancellation', 25), (2020, 9, 15, 'purchase', 12), (2020, 9, 15, 'deal cancellation', 34), (2020, 9, 15, 'sale', 11), (2020, 9, 16, 'purchase', 15), (2020, 9, 16, 'sale', 9), (2020, 9, 16, 'purchase', 5), (2020, 9, 17, 'purchase', 21), (2020, 9, 17, 'purchase', 32), (2020, 9, 17, 'deal cancellation', 1), (2020, 9, 19, 'deal cancellation', 36), (2020, 9, 19, 'purchase', 3), (2020, 9, 19, 'purchase', 43), (2020, 9, 19, 'sale', 25), (2020, 9, 20, 'sale', 46), (2020, 9, 20, 'sale', 45), (2020, 9, 20, 'sale', 35), (2020, 9, 20, 'purchase', 39), (2020, 9, 21, 'sale', 52), (2020, 9, 21, 'purchase', 33), (2020, 9, 21, 'purchase', 13), (2020, 9, 21, 'sale', 4), (2020, 9, 21, 'purchase', 39), (2020, 9, 22, 'sale', 34), (2020, 9, 23, 'deal cancellation', 13), (2020, 9, 23, 'purchase', 44), (2020, 9, 23, 'purchase', 15), (2020, 9, 24, 'sale', 7), (2020, 9, 24, 'deal cancellation', 2), (2020, 9, 24, 'sale', 32), (2020, 9, 24, 'sale', 33), (2020, 9, 25, 'deal cancellation', 35), (2020, 9, 28, 'sale', 28), (2020, 10, 2, 'sale', 51), (2020, 10, 2, 'sale', 5), (2020, 10, 2, 'sale', 36), (2020, 10, 2, 'purchase', 40), (2020, 10, 2, 'sale', 33), (2020, 10, 3, 'purchase', 42), (2020, 10, 7, 'deal cancellation', 15), (2020, 10, 7, 'sale', 8), (2020, 10, 7, 'purchase', 1), (2020, 10, 7, 'purchase', 41), (2020, 10, 7, 'sale', 5), (2020, 10, 8, 'deal cancellation', 6), (2020, 10, 8, 'purchase', 24), (2020, 10, 8, 'deal cancellation', 21), (2020, 10, 8, 'purchase', 46), (2020, 10, 10, 'sale', 46), (2020, 10, 10, 'deal cancellation', 25), (2020, 10, 10, 'sale', 7), (2020, 10, 10, 'purchase', 7), (2020, 10, 11, 'deal cancellation', 6), (2020, 10, 11, 'sale', 27), (2020, 10, 11, 'deal cancellation', 38), (2020, 10, 12, 'deal cancellation', 47), (2020, 10, 12, 'purchase', 36), (2020, 10, 14, 'purchase', 15), (2020, 10, 14, 'deal cancellation', 37), (2020, 10, 14, 'deal cancellation', 12), (2020, 10, 15, 'sale', 35), (2020, 10, 15, 'deal cancellation', 11), (2020, 10, 15, 'purchase', 45), (2020, 10, 15, 'purchase', 34), (2020, 10, 16, 'purchase', 13), (2020, 10, 16, 'sale', 10), (2020, 10, 18, 'deal cancellation', 11), (2020, 10, 18, 'sale', 16), (2020, 10, 18, 'purchase', 38), (2020, 10, 18, 'purchase', 50), (2020, 10, 18, 'purchase', 23), (2020, 10, 19, 'purchase', 24), (2020, 10, 20, 'purchase', 21), (2020, 10, 20, 'deal cancellation', 2), (2020, 10, 20, 'purchase', 42), (2020, 10, 20, 'sale', 37), (2020, 10, 20, 'sale', 10), (2020, 10, 21, 'sale', 38), (2020, 10, 21, 'sale', 13), (2020, 10, 21, 'deal cancellation', 38), (2020, 10, 21, 'sale', 13), (2020, 10, 22, 'purchase', 32), (2020, 10, 22, 'sale', 15), (2020, 10, 23, 'deal cancellation', 8), (2020, 10, 23, 'sale', 38), (2020, 10, 23, 'purchase', 24), (2020, 10, 23, 'sale', 15), (2020, 10, 23, 'sale', 35), (2020, 10, 25, 'purchase', 40), (2020, 10, 25, 'purchase', 12), (2020, 10, 25, 'purchase', 31), (2020, 10, 27, 'deal cancellation', 15), (2020, 10, 28, 'sale', 50), (2020, 10, 28, 'deal cancellation', 45), (2020, 10, 28, 'deal cancellation', 10), (2020, 10, 28, 'sale', 49), (2020, 10, 28, 'sale', 21), (2020, 10, 29, 'purchase', 49), (2020, 10, 30, 'deal cancellation', 21), (2020, 10, 30, 'deal cancellation', 33), (2020, 10, 30, 'deal cancellation', 33), (2020, 10, 30, 'purchase', 3), (2020, 10, 30, 'sale', 6), (2020, 11, 1, 'purchase', 3), (2020, 11, 2, 'purchase', 18), (2020, 11, 2, 'purchase', 34), (2020, 11, 2, 'deal cancellation', 39), (2020, 11, 2, 'sale', 33), (2020, 11, 3, 'deal cancellation', 34), (2020, 11, 3, 'deal cancellation', 22), (2020, 11, 3, 'purchase', 48), (2020, 11, 3, 'sale', 15), (2020, 11, 4, 'sale', 6), (2020, 11, 4, 'purchase', 31), (2020, 11, 4, 'purchase', 37), (2020, 11, 4, 'sale', 3), (2020, 11, 4, 'sale', 12), (2020, 11, 5, 'purchase', 19), (2020, 11, 5, 'sale', 27), (2020, 11, 5, 'sale', 42), (2020, 11, 6, 'purchase', 13), (2020, 11, 6, 'purchase', 39), (2020, 11, 6, 'purchase', 8), (2020, 11, 6, 'sale', 46), (2020, 11, 6, 'purchase', 26), (2020, 11, 7, 'deal cancellation', 48), (2020, 11, 7, 'sale', 40), (2020, 11, 7, 'sale', 25), (2020, 11, 7, 'sale', 47), (2020, 11, 7, 'sale', 27), (2020, 11, 8, 'purchase', 26), (2020, 11, 8, 'sale', 7), (2020, 11, 8, 'purchase', 36), (2020, 11, 8, 'deal cancellation', 41), (2020, 11, 9, 'deal cancellation', 53), (2020, 11, 9, 'deal cancellation', 33), (2020, 11, 9, 'sale', 31), (2020, 11, 9, 'sale', 16), (2020, 11, 10, 'deal cancellation', 42), (2020, 11, 10, 'purchase', 49), (2020, 11, 10, 'sale', 34), (2020, 11, 11, 'purchase', 7), (2020, 11, 11, 'sale', 6), (2020, 11, 11, 'sale', 4), (2020, 11, 12, 'purchase', 7), (2020, 11, 13, 'sale', 21), (2020, 11, 13, 'purchase', 14), (2020, 11, 13, 'purchase', 44), (2020, 11, 13, 'sale', 24), (2020, 11, 15, 'purchase', 19), (2020, 11, 15, 'deal cancellation', 40), (2020, 11, 15, 'sale', 15), (2020, 11, 15, 'purchase', 25), (2020, 11, 16, 'sale', 7), (2020, 11, 16, 'purchase', 40), (2020, 11, 16, 'deal cancellation', 11), (2020, 11, 16, 'deal cancellation', 51); select dt_bad_string, concat( trim(replace (substring(dt_bad_string,1,9), 'year','')), '-0', trim(replace (substring(dt_bad_string, 10, 9), 'month', '')), '-', replace (substring(dt_bad_string, 19,2), 'day','')) form from skill_events select dt_bad_string, try_convert(date, concat( trim(replace (substring(dt_bad_string,1,9), 'year','')), '-0', trim(replace (substring(dt_bad_string, 10, 9), 'month', '')), '-', replace (substring(dt_bad_string, 19,2), 'day',''))) form from skill_events select dt_bad_string, cast(concat( trim(replace (substring(dt_bad_string,1,9), 'year','')), '-0', trim(replace (substring(dt_bad_string, 10, 9), 'month', '')), '-', replace (substring(dt_bad_string, 19,2), 'day','')) as date) form from skill_events