表結(jié)構(gòu):
DROP TABLE IF EXISTS `work_day`;
CREATE TABLE `work_day` (
`date` char(20) NOT NULL COMMENT '日期',
`is_holiday` tinyint(1) DEFAULT NULL COMMENT '是否為假期',
`code` char(1) DEFAULT NULL COMMENT '日期類型:{0:工作日,1:法定假日,2:補班,3:周末假日}',
PRIMARY KEY (`date`)
)
數(shù)據(jù):
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-01-01', 1, '1');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-01-02', 1, '1');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-01-03', 1, '1');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-01-04', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-01-05', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-01-06', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-01-07', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-01-08', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-01-09', 1, '3');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-01-10', 1, '3');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-01-11', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-01-12', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-01-13', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-01-14', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-01-15', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-01-16', 1, '3');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-01-17', 1, '3');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-01-18', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-01-19', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-01-20', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-01-21', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-01-22', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-01-23', 1, '3');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-01-24', 1, '3');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-01-25', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-01-26', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-01-27', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-01-28', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-01-29', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-01-30', 1, '3');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-01-31', 1, '3');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-02-01', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-02-02', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-02-03', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-02-04', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-02-05', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-02-06', 1, '3');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-02-07', 0, '2');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-02-08', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-02-09', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-02-10', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-02-11', 1, '1');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-02-12', 1, '1');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-02-13', 1, '1');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-02-14', 1, '1');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-02-15', 1, '1');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-02-16', 1, '1');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-02-17', 1, '1');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-02-18', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-02-19', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-02-20', 0, '2');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-02-21', 1, '3');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-02-22', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-02-23', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-02-24', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-02-25', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-02-26', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-02-27', 1, '3');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-02-28', 1, '3');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-03-01', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-03-02', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-03-03', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-03-04', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-03-05', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-03-06', 1, '3');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-03-07', 1, '3');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-03-08', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-03-09', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-03-10', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-03-11', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-03-12', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-03-13', 1, '3');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-03-14', 1, '3');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-03-15', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-03-16', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-03-17', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-03-18', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-03-19', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-03-20', 1, '3');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-03-21', 1, '3');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-03-22', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-03-23', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-03-24', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-03-25', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-03-26', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-03-27', 1, '3');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-03-28', 1, '3');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-03-29', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-03-30', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-03-31', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-04-01', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-04-02', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-04-03', 1, '1');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-04-04', 1, '1');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-04-05', 1, '1');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-04-06', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-04-07', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-04-08', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-04-09', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-04-10', 1, '3');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-04-11', 1, '3');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-04-12', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-04-13', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-04-14', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-04-15', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-04-16', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-04-17', 1, '3');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-04-18', 1, '3');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-04-19', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-04-20', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-04-21', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-04-22', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-04-23', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-04-24', 1, '3');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-04-25', 0, '2');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-04-26', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-04-27', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-04-28', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-04-29', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-04-30', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-05-01', 1, '1');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-05-02', 1, '1');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-05-03', 1, '1');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-05-04', 1, '1');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-05-05', 1, '1');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-05-06', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-05-07', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-05-08', 0, '2');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-05-09', 1, '3');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-05-10', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-05-11', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-05-12', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-05-13', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-05-14', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-05-15', 1, '3');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-05-16', 1, '3');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-05-17', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-05-18', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-05-19', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-05-20', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-05-21', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-05-22', 1, '3');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-05-23', 1, '3');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-05-24', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-05-25', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-05-26', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-05-27', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-05-28', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-05-29', 1, '3');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-05-30', 1, '3');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-05-31', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-06-01', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-06-02', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-06-03', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-06-04', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-06-05', 1, '3');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-06-06', 1, '3');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-06-07', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-06-08', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-06-09', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-06-10', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-06-11', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-06-12', 1, '1');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-06-13', 1, '1');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-06-14', 1, '1');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-06-15', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-06-16', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-06-17', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-06-18', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-06-19', 1, '3');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-06-20', 1, '3');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-06-21', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-06-22', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-06-23', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-06-24', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-06-25', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-06-26', 1, '3');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-06-27', 1, '3');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-06-28', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-06-29', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-06-30', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-07-01', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-07-02', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-07-03', 1, '3');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-07-04', 1, '3');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-07-05', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-07-06', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-07-07', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-07-08', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-07-09', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-07-10', 1, '3');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-07-11', 1, '3');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-07-12', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-07-13', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-07-14', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-07-15', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-07-16', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-07-17', 1, '3');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-07-18', 1, '3');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-07-19', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-07-20', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-07-21', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-07-22', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-07-23', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-07-24', 1, '3');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-07-25', 1, '3');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-07-26', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-07-27', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-07-28', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-07-29', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-07-30', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-07-31', 1, '3');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-08-01', 1, '3');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-08-02', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-08-03', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-08-04', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-08-05', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-08-06', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-08-07', 1, '3');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-08-08', 1, '3');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-08-09', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-08-10', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-08-11', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-08-12', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-08-13', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-08-14', 1, '3');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-08-15', 1, '3');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-08-16', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-08-17', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-08-18', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-08-19', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-08-20', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-08-21', 1, '3');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-08-22', 1, '3');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-08-23', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-08-24', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-08-25', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-08-26', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-08-27', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-08-28', 1, '3');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-08-29', 1, '3');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-08-30', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-08-31', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-09-01', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-09-02', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-09-03', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-09-04', 1, '3');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-09-05', 1, '3');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-09-06', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-09-07', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-09-08', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-09-09', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-09-10', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-09-11', 1, '3');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-09-12', 1, '3');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-09-13', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-09-14', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-09-15', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-09-16', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-09-17', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-09-18', 0, '2');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-09-19', 1, '1');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-09-20', 1, '1');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-09-21', 1, '1');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-09-22', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-09-23', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-09-24', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-09-25', 1, '3');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-09-26', 0, '2');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-09-27', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-09-28', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-09-29', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-09-30', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-10-01', 1, '1');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-10-02', 1, '1');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-10-03', 1, '1');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-10-04', 1, '1');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-10-05', 1, '1');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-10-06', 1, '1');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-10-07', 1, '1');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-10-08', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-10-09', 0, '2');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-10-10', 1, '3');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-10-11', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-10-12', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-10-13', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-10-14', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-10-15', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-10-16', 1, '3');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-10-17', 1, '3');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-10-18', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-10-19', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-10-20', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-10-21', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-10-22', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-10-23', 1, '3');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-10-24', 1, '3');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-10-25', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-10-26', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-10-27', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-10-28', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-10-29', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-10-30', 1, '3');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-10-31', 1, '3');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-11-01', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-11-02', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-11-03', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-11-04', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-11-05', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-11-06', 1, '3');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-11-07', 1, '3');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-11-08', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-11-09', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-11-10', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-11-11', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-11-12', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-11-13', 1, '3');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-11-14', 1, '3');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-11-15', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-11-16', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-11-17', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-11-18', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-11-19', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-11-20', 1, '3');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-11-21', 1, '3');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-11-22', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-11-23', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-11-24', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-11-25', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-11-26', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-11-27', 1, '3');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-11-28', 1, '3');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-11-29', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-11-30', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-12-01', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-12-02', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-12-03', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-12-04', 1, '3');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-12-05', 1, '3');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-12-06', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-12-07', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-12-08', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-12-09', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-12-10', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-12-11', 1, '3');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-12-12', 1, '3');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-12-13', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-12-14', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-12-15', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-12-16', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-12-17', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-12-18', 1, '3');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-12-19', 1, '3');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-12-20', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-12-21', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-12-22', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-12-23', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-12-24', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-12-25', 1, '3');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-12-26', 1, '3');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-12-27', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-12-28', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-12-29', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-12-30', 0, '0');
INSERT INTO `test`.`work_day`(`date`, `is_holiday`, `code`) VALUES ('2021-12-31', 0, '0');