一个案例告诉你,MySQL如何查询今天、昨天、近7天、近30天、本月、上个月、本季度、上季度、本年、上一年数据

参考博客

mysql查询当天/昨天/近7天/近30天/本月/上个月/本季度/上季度/本年/上一年 数据

正文内容

创建测试案例(也可直接使用附录MySQL脚本生成数据)

1、新建测试表

CREATE TABLE example (
    id INT AUTO_INCREMENT PRIMARY KEY,
    date_column DATE,
    data VARCHAR(255)
);

2、初始化测试数据

本案例使用存储过程初始化数据,具体分两步:
1、定义存储过程
2、调用存储过程

具体脚本如下,可按自己需求创建相关数据做测试。

=====================================================================================================================生成今天的数据-ok
-- 定义存储过程
DELIMITER $$

CREATE PROCEDURE GenerateTodayData()
BEGIN
    DECLARE currentDate DATE;
    SET currentDate = CURDATE();
    INSERT INTO example (date_column, data) VALUES (currentDate, 'Data for today');
END$$

DELIMITER ;


-- 调用存储过程
CALL GenerateTodayData();

=====================================================================================================================生成昨天的数据-ok

-- 定义存储过程
DELIMITER $$

CREATE PROCEDURE GenerateYesterdayData()
BEGIN
    DECLARE yesterdayDate DATE;
    SET yesterdayDate = CURDATE() - INTERVAL 1 DAY;

    INSERT INTO example (date_column, data) VALUES (yesterdayDate, 'Data for yesterday');
END$$

DELIMITER ;


-- 调用存储过程
CALL GenerateYesterdayData();

=====================================================================================================================生成近7天的数据-ok
-- 定义存储过程
DELIMITER $$

CREATE PROCEDURE GenerateLast7DaysData()
BEGIN
    DECLARE currentDate DATE;
    DECLARE i INT DEFAULT 0;
    SET currentDate = CURDATE();

    WHILE i < 7 DO
        INSERT INTO example (date_column, data) VALUES (currentDate - INTERVAL i DAY, CONCAT('Data for day ', i));
        SET i = i + 1;
    END WHILE;
END$$

DELIMITER ;


-- 调用存储过程
CALL GenerateLast7DaysData();

=====================================================================================================================生成本月的每天数据-ok
-- 定义存储过程
DELIMITER $$

CREATE PROCEDURE GenerateCurrentMonthData()
BEGIN
    DECLARE currentDate DATE;
    DECLARE daysInMonth INT;
    SET currentDate = DATE_FORMAT(NOW(), '%Y-%m-01');
    SET daysInMonth = DAY(LAST_DAY(currentDate));

    SET @i = 0;
    WHILE @i < daysInMonth DO
        INSERT INTO example (date_column, data) VALUES (currentDate + INTERVAL @i DAY, CONCAT('Data for day ', @i + 1));
        SET @i = @i + 1;
    END WHILE;
END$$

DELIMITER ;


-- 调用存储过程
CALL GenerateCurrentMonthData();

=====================================================================================================================生成上个月的数据-ok
-- 定义存储过程
DELIMITER $$

CREATE PROCEDURE GenerateLastMonthData()
BEGIN
    DECLARE lastMonthStart DATE;
    DECLARE lastMonthEnd DATE;
    DECLARE lastMonthDays INT;

    SET lastMonthStart = DATE_FORMAT(NOW() - INTERVAL 1 MONTH, '%Y-%m-01');
    SET lastMonthEnd = LAST_DAY(lastMonthStart);
    SET lastMonthDays = DAY(lastMonthEnd);

    SET @i = 0;
    WHILE @i < lastMonthDays DO
        INSERT INTO example (date_column, data) VALUES (lastMonthStart + INTERVAL @i DAY, CONCAT('Data for day ', @i + 1, ' of last month'));
        SET @i = @i + 1;
    END WHILE;
END$$

DELIMITER ;


-- 调用存储过程
CALL GenerateLastMonthData();

=====================================================================================================================生成本季度的数据-ok
-- 定义存储过程
DELIMITER $$

CREATE PROCEDURE GenerateCurrentQuarterData()
BEGIN
    DECLARE currentQuarterStart DATE;
    DECLARE currentQuarterEnd DATE;
    DECLARE currentQuarterDays INT;

    -- 计算本季度的开始日期
    SET currentQuarterStart = MAKEDATE(YEAR(NOW()), 1) + INTERVAL (QUARTER(NOW()) - 1) * 3 MONTH;
    -- 计算本季度的结束日期
    SET currentQuarterEnd = LAST_DAY(currentQuarterStart + INTERVAL 2 MONTH);
    -- 计算本季度的天数
    SET currentQuarterDays = DATEDIFF(currentQuarterEnd, currentQuarterStart) + 1;

    -- 生成本季度的数据
    SET @i = 0;
    WHILE @i < currentQuarterDays DO
        INSERT INTO example (date_column, data) VALUES (currentQuarterStart + INTERVAL @i DAY, CONCAT('Data for day ', @i + 1, ' of current quarter'));
        SET @i = @i + 1;
    END WHILE;
END$$

DELIMITER ;


-- 调用存储过程
CALL GenerateCurrentQuarterData();

=====================================================================================================================生成上季度的数据-ok
-- 定义存储过程
DELIMITER $$

CREATE PROCEDURE GenerateLastQuarterData()
BEGIN
    DECLARE lastQuarterStart DATE;
    DECLARE lastQuarterEnd DATE;
    DECLARE lastQuarterDays INT;

    -- 计算上季度的开始和结束日期
    SET lastQuarterStart = MAKEDATE(YEAR(CURRENT_DATE - INTERVAL 3 MONTH), 1) + INTERVAL QUARTER(CURRENT_DATE - INTERVAL 3 MONTH) QUARTER - INTERVAL 1 QUARTER;
    SET lastQuarterEnd = LAST_DAY(lastQuarterStart + INTERVAL 2 MONTH);

    -- 计算上季度的天数
    SET lastQuarterDays = DATEDIFF(lastQuarterEnd, lastQuarterStart) + 1;

    -- 生成上季度的数据
    SET @i = 0;
    WHILE @i < lastQuarterDays DO
        INSERT INTO example (date_column, data) VALUES (lastQuarterStart + INTERVAL @i DAY, CONCAT('Data for day ', @i + 1, ' of last quarter'));
        SET @i = @i + 1;
    END WHILE;
END$$

DELIMITER ;


-- 调用存储过程
CALL GenerateLastQuarterData();

=====================================================================================================================生成本年的数据-ok
-- 定义存储过程
DELIMITER $$

CREATE PROCEDURE GenerateCurrentYearData()
BEGIN
    DECLARE currentYearStart DATE;
    DECLARE currentYearEnd DATE;
    DECLARE currentYearDays INT;

    SET currentYearStart = DATE_FORMAT(NOW(), '%Y-01-01');
    SET currentYearEnd = DATE_FORMAT(NOW(), '%Y-12-31');
    SET currentYearDays = DATEDIFF(currentYearEnd, currentYearStart) + 1;

    SET @i = 0;
    WHILE @i < currentYearDays DO
        INSERT INTO example (date_column, data) VALUES (currentYearStart + INTERVAL @i DAY, CONCAT('Data for day ', @i + 1, ' of current year'));
        SET @i = @i + 1;
    END WHILE;
END$$

DELIMITER ;


-- 调用存储过程
CALL GenerateCurrentYearData();

=====================================================================================================================生成上一年的数据-ok
-- 定义存储过程
DELIMITER $$

CREATE PROCEDURE GenerateLastYearData()
BEGIN
    DECLARE lastYearStart DATE;
    DECLARE lastYearEnd DATE;
    DECLARE lastYearDays INT;

    SET lastYearStart = DATE_FORMAT(NOW() - INTERVAL 1 YEAR, '%Y-01-01');
    SET lastYearEnd = DATE_FORMAT(NOW() - INTERVAL 1 YEAR, '%Y-12-31');
    SET lastYearDays = DATEDIFF(lastYearEnd, lastYearStart) + 1;

    SET @i = 0;
    WHILE @i < lastYearDays DO
        INSERT INTO example (date_column, data) VALUES (lastYearStart + INTERVAL @i DAY, CONCAT('Data for day ', @i + 1, ' of last year'));
        SET @i = @i + 1;
    END WHILE;
END$$

DELIMITER ;


-- 调用存储过程
CALL GenerateLastYearData();

MySQL调试

查询今日数据

SELECT * FROM example WHERE TO_DAYS(date_column) = TO_DAYS(now());

执行结果:
在这里插入图片描述

查询昨天数据

SELECT * FROM example WHERE TO_DAYS(NOW()) - TO_DAYS(date_column) = 1;

执行结果:
在这里插入图片描述

查询近7天数据

SELECT * FROM example WHERE DATE_SUB(CURDATE(), INTERVAL 7 DAY) <= DATE(date_column);

-- 注意:使用存储过程把未来的数据也生成了,需要加过滤掉,正常查询使用上面一条就可以
SELECT * FROM example WHERE DATE_SUB(CURDATE(), INTERVAL 7 DAY) <= DATE(date_column) AND TO_DAYS(date_column) <= TO_DAYS(now());

执行结果:
![在这里插入图片描述](https://img-blog.csdnimg.cn/direct/ab4e962262ab41159786464187103ffd.png

注意: 本案例使用存储过程把未来的数据也生成了,需要加过滤掉,正常查询使用上面一条就可以。第一条查询结果如下(其他同理,就不在做多余解释):
在这里插入图片描述

查询近30天数据

-- 近30天
SELECT * FROM example WHERE DATE_SUB(CURDATE(), INTERVAL 30 DAY) <= DATE(date_column);

-- 注意:使用存储过程把未来的数据也生成了,需要加过滤掉,正常查询使用上面一条就可以
SELECT * FROM example WHERE DATE_SUB(CURDATE(), INTERVAL 30 DAY) <= DATE(date_column) AND TO_DAYS(date_column) <= TO_DAYS(now());

执行结果:
在这里插入图片描述

查询本月数据

-- 本月
SELECT * FROM example WHERE DATE_FORMAT(date_column, '%Y%m') = DATE_FORMAT(CURDATE(), '%Y%m');

执行结果:
在这里插入图片描述

查询上个月数据

-- 上个月
SELECT * FROM example WHERE PERIOD_DIFF(DATE_FORMAT(now(), '%Y%m') , DATE_FORMAT(date_column, '%Y%m')) = 1;

执行结果:
在这里插入图片描述

查询本季度数据

-- 本季度
SELECT * FROM example WHERE QUARTER(date_column) = QUARTER(NOW());

-- 注意:使用存储过程把未来的数据也生成了,需要加过滤掉,正常查询使用上面一条就可以
SELECT * FROM example WHERE QUARTER(date_column) = QUARTER(NOW()) AND TO_DAYS(date_column) <= TO_DAYS(now());

执行结果:
在这里插入图片描述

查询上季度数据

-- 上季度
SELECT * FROM example WHERE QUARTER(date_column) = QUARTER(DATE_SUB(NOW(), INTERVAL 1 QUARTER));

执行结果:
在这里插入图片描述

查询本年数据

-- 本年
SELECT * FROM example WHERE YEAR(date_column) = YEAR(NOW());

-- 注意:使用存储过程把未来的数据也生成了,需要加过滤掉,正常查询使用上面一条就可以
SELECT * FROM example WHERE YEAR(date_column) = YEAR(NOW()) AND TO_DAYS(date_column) <= TO_DAYS(now());

执行结果:
在这里插入图片描述

查询上一年数据

-- 上一年
SELECT * FROM example WHERE YEAR(date_column) = YEAR(DATE_SUB(NOW(), INTERVAL 1 YEAR));

执行结果:
在这里插入图片描述

附录

附录1:完整调试语句

-- 今天
SELECT * FROM example WHERE TO_DAYS(date_column) = TO_DAYS(now());

-- 昨天
SELECT * FROM example WHERE TO_DAYS(NOW()) - TO_DAYS(date_column) = 1;
-- 昨天(加今天的)
SELECT * FROM example WHERE TO_DAYS(NOW()) - TO_DAYS(date_column) <= 1;

-- 近7天
SELECT * FROM example WHERE DATE_SUB(CURDATE(), INTERVAL 7 DAY) <= DATE(date_column);
-- 注意:使用存储过程把未来的数据也生成了,需要加过滤掉,正常查询使用上面一条就可以
SELECT * FROM example WHERE DATE_SUB(CURDATE(), INTERVAL 7 DAY) <= DATE(date_column) AND TO_DAYS(date_column) <= TO_DAYS(now());

-- 近30天
SELECT * FROM example WHERE DATE_SUB(CURDATE(), INTERVAL 30 DAY) <= DATE(date_column);
-- 注意:使用存储过程把未来的数据也生成了,需要加过滤掉,正常查询使用上面一条就可以
SELECT * FROM example WHERE DATE_SUB(CURDATE(), INTERVAL 30 DAY) <= DATE(date_column) AND TO_DAYS(date_column) <= TO_DAYS(now());


-- 本月
SELECT * FROM example WHERE DATE_FORMAT(date_column, '%Y%m') = DATE_FORMAT(CURDATE(), '%Y%m');


-- 上个月
SELECT * FROM example WHERE PERIOD_DIFF(DATE_FORMAT(now(), '%Y%m') , DATE_FORMAT(date_column, '%Y%m')) = 1;


-- 本季度
SELECT * FROM example WHERE QUARTER(date_column) = QUARTER(NOW());

-- 注意:使用存储过程把未来的数据也生成了,需要加过滤掉,正常查询使用上面一条就可以
SELECT * FROM example WHERE QUARTER(date_column) = QUARTER(NOW()) AND TO_DAYS(date_column) <= TO_DAYS(now());

-- 上季度
SELECT * FROM example WHERE QUARTER(date_column) = QUARTER(DATE_SUB(NOW(), INTERVAL 1 QUARTER));


-- 本年
SELECT * FROM example WHERE YEAR(date_column) = YEAR(NOW());

-- 注意:使用存储过程把未来的数据也生成了,需要加过滤掉,正常查询使用上面一条就可以
SELECT * FROM example WHERE YEAR(date_column) = YEAR(NOW()) AND TO_DAYS(date_column) <= TO_DAYS(now());


-- 上一年
SELECT * FROM example WHERE YEAR(date_column) = YEAR(DATE_SUB(NOW(), INTERVAL 1 YEAR));

附录2:完整MySql数据

/*
 Navicat Premium Data Transfer

 Source Server         : mysql@localhost
 Source Server Type    : MySQL
 Source Server Version : 50716 (5.7.16-log)
 Source Host           : localhost:3306
 Source Schema         : test

 Target Server Type    : MySQL
 Target Server Version : 50716 (5.7.16-log)
 File Encoding         : 65001

 Date: 31/05/2024 16:11:25
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for example
-- ----------------------------
DROP TABLE IF EXISTS `example`;
CREATE TABLE `example`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date_column` date NULL DEFAULT NULL,
  `data` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 984 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of example
-- ----------------------------
INSERT INTO `example` VALUES (1, '2024-05-31', 'Data for today');
INSERT INTO `example` VALUES (2, '2024-05-30', 'Data for yesterday');
INSERT INTO `example` VALUES (3, '2024-05-31', 'Data for day 0');
INSERT INTO `example` VALUES (4, '2024-05-30', 'Data for day 1');
INSERT INTO `example` VALUES (5, '2024-05-29', 'Data for day 2');
INSERT INTO `example` VALUES (6, '2024-05-28', 'Data for day 3');
INSERT INTO `example` VALUES (7, '2024-05-27', 'Data for day 4');
INSERT INTO `example` VALUES (8, '2024-05-26', 'Data for day 5');
INSERT INTO `example` VALUES (9, '2024-05-25', 'Data for day 6');
INSERT INTO `example` VALUES (10, '2024-05-01', 'Data for day 1');
INSERT INTO `example` VALUES (11, '2024-05-02', 'Data for day 2');
INSERT INTO `example` VALUES (12, '2024-05-03', 'Data for day 3');
INSERT INTO `example` VALUES (13, '2024-05-04', 'Data for day 4');
INSERT INTO `example` VALUES (14, '2024-05-05', 'Data for day 5');
INSERT INTO `example` VALUES (15, '2024-05-06', 'Data for day 6');
INSERT INTO `example` VALUES (16, '2024-05-07', 'Data for day 7');
INSERT INTO `example` VALUES (17, '2024-05-08', 'Data for day 8');
INSERT INTO `example` VALUES (18, '2024-05-09', 'Data for day 9');
INSERT INTO `example` VALUES (19, '2024-05-10', 'Data for day 10');
INSERT INTO `example` VALUES (20, '2024-05-11', 'Data for day 11');
INSERT INTO `example` VALUES (21, '2024-05-12', 'Data for day 12');
INSERT INTO `example` VALUES (22, '2024-05-13', 'Data for day 13');
INSERT INTO `example` VALUES (23, '2024-05-14', 'Data for day 14');
INSERT INTO `example` VALUES (24, '2024-05-15', 'Data for day 15');
INSERT INTO `example` VALUES (25, '2024-05-16', 'Data for day 16');
INSERT INTO `example` VALUES (26, '2024-05-17', 'Data for day 17');
INSERT INTO `example` VALUES (27, '2024-05-18', 'Data for day 18');
INSERT INTO `example` VALUES (28, '2024-05-19', 'Data for day 19');
INSERT INTO `example` VALUES (29, '2024-05-20', 'Data for day 20');
INSERT INTO `example` VALUES (30, '2024-05-21', 'Data for day 21');
INSERT INTO `example` VALUES (31, '2024-05-22', 'Data for day 22');
INSERT INTO `example` VALUES (32, '2024-05-23', 'Data for day 23');
INSERT INTO `example` VALUES (33, '2024-05-24', 'Data for day 24');
INSERT INTO `example` VALUES (34, '2024-05-25', 'Data for day 25');
INSERT INTO `example` VALUES (35, '2024-05-26', 'Data for day 26');
INSERT INTO `example` VALUES (36, '2024-05-27', 'Data for day 27');
INSERT INTO `example` VALUES (37, '2024-05-28', 'Data for day 28');
INSERT INTO `example` VALUES (38, '2024-05-29', 'Data for day 29');
INSERT INTO `example` VALUES (39, '2024-05-30', 'Data for day 30');
INSERT INTO `example` VALUES (40, '2024-05-31', 'Data for day 31');
INSERT INTO `example` VALUES (41, '2024-04-01', 'Data for day 1 of last month');
INSERT INTO `example` VALUES (42, '2024-04-02', 'Data for day 2 of last month');
INSERT INTO `example` VALUES (43, '2024-04-03', 'Data for day 3 of last month');
INSERT INTO `example` VALUES (44, '2024-04-04', 'Data for day 4 of last month');
INSERT INTO `example` VALUES (45, '2024-04-05', 'Data for day 5 of last month');
INSERT INTO `example` VALUES (46, '2024-04-06', 'Data for day 6 of last month');
INSERT INTO `example` VALUES (47, '2024-04-07', 'Data for day 7 of last month');
INSERT INTO `example` VALUES (48, '2024-04-08', 'Data for day 8 of last month');
INSERT INTO `example` VALUES (49, '2024-04-09', 'Data for day 9 of last month');
INSERT INTO `example` VALUES (50, '2024-04-10', 'Data for day 10 of last month');
INSERT INTO `example` VALUES (51, '2024-04-11', 'Data for day 11 of last month');
INSERT INTO `example` VALUES (52, '2024-04-12', 'Data for day 12 of last month');
INSERT INTO `example` VALUES (53, '2024-04-13', 'Data for day 13 of last month');
INSERT INTO `example` VALUES (54, '2024-04-14', 'Data for day 14 of last month');
INSERT INTO `example` VALUES (55, '2024-04-15', 'Data for day 15 of last month');
INSERT INTO `example` VALUES (56, '2024-04-16', 'Data for day 16 of last month');
INSERT INTO `example` VALUES (57, '2024-04-17', 'Data for day 17 of last month');
INSERT INTO `example` VALUES (58, '2024-04-18', 'Data for day 18 of last month');
INSERT INTO `example` VALUES (59, '2024-04-19', 'Data for day 19 of last month');
INSERT INTO `example` VALUES (60, '2024-04-20', 'Data for day 20 of last month');
INSERT INTO `example` VALUES (61, '2024-04-21', 'Data for day 21 of last month');
INSERT INTO `example` VALUES (62, '2024-04-22', 'Data for day 22 of last month');
INSERT INTO `example` VALUES (63, '2024-04-23', 'Data for day 23 of last month');
INSERT INTO `example` VALUES (64, '2024-04-24', 'Data for day 24 of last month');
INSERT INTO `example` VALUES (65, '2024-04-25', 'Data for day 25 of last month');
INSERT INTO `example` VALUES (66, '2024-04-26', 'Data for day 26 of last month');
INSERT INTO `example` VALUES (67, '2024-04-27', 'Data for day 27 of last month');
INSERT INTO `example` VALUES (68, '2024-04-28', 'Data for day 28 of last month');
INSERT INTO `example` VALUES (69, '2024-04-29', 'Data for day 29 of last month');
INSERT INTO `example` VALUES (70, '2024-04-30', 'Data for day 30 of last month');
INSERT INTO `example` VALUES (71, '2024-04-01', 'Data for day 1 of current quarter');
INSERT INTO `example` VALUES (72, '2024-04-02', 'Data for day 2 of current quarter');
INSERT INTO `example` VALUES (73, '2024-04-03', 'Data for day 3 of current quarter');
INSERT INTO `example` VALUES (74, '2024-04-04', 'Data for day 4 of current quarter');
INSERT INTO `example` VALUES (75, '2024-04-05', 'Data for day 5 of current quarter');
INSERT INTO `example` VALUES (76, '2024-04-06', 'Data for day 6 of current quarter');
INSERT INTO `example` VALUES (77, '2024-04-07', 'Data for day 7 of current quarter');
INSERT INTO `example` VALUES (78, '2024-04-08', 'Data for day 8 of current quarter');
INSERT INTO `example` VALUES (79, '2024-04-09', 'Data for day 9 of current quarter');
INSERT INTO `example` VALUES (80, '2024-04-10', 'Data for day 10 of current quarter');
INSERT INTO `example` VALUES (81, '2024-04-11', 'Data for day 11 of current quarter');
INSERT INTO `example` VALUES (82, '2024-04-12', 'Data for day 12 of current quarter');
INSERT INTO `example` VALUES (83, '2024-04-13', 'Data for day 13 of current quarter');
INSERT INTO `example` VALUES (84, '2024-04-14', 'Data for day 14 of current quarter');
INSERT INTO `example` VALUES (85, '2024-04-15', 'Data for day 15 of current quarter');
INSERT INTO `example` VALUES (86, '2024-04-16', 'Data for day 16 of current quarter');
INSERT INTO `example` VALUES (87, '2024-04-17', 'Data for day 17 of current quarter');
INSERT INTO `example` VALUES (88, '2024-04-18', 'Data for day 18 of current quarter');
INSERT INTO `example` VALUES (89, '2024-04-19', 'Data for day 19 of current quarter');
INSERT INTO `example` VALUES (90, '2024-04-20', 'Data for day 20 of current quarter');
INSERT INTO `example` VALUES (91, '2024-04-21', 'Data for day 21 of current quarter');
INSERT INTO `example` VALUES (92, '2024-04-22', 'Data for day 22 of current quarter');
INSERT INTO `example` VALUES (93, '2024-04-23', 'Data for day 23 of current quarter');
INSERT INTO `example` VALUES (94, '2024-04-24', 'Data for day 24 of current quarter');
INSERT INTO `example` VALUES (95, '2024-04-25', 'Data for day 25 of current quarter');
INSERT INTO `example` VALUES (96, '2024-04-26', 'Data for day 26 of current quarter');
INSERT INTO `example` VALUES (97, '2024-04-27', 'Data for day 27 of current quarter');
INSERT INTO `example` VALUES (98, '2024-04-28', 'Data for day 28 of current quarter');
INSERT INTO `example` VALUES (99, '2024-04-29', 'Data for day 29 of current quarter');
INSERT INTO `example` VALUES (100, '2024-04-30', 'Data for day 30 of current quarter');
INSERT INTO `example` VALUES (101, '2024-05-01', 'Data for day 31 of current quarter');
INSERT INTO `example` VALUES (102, '2024-05-02', 'Data for day 32 of current quarter');
INSERT INTO `example` VALUES (103, '2024-05-03', 'Data for day 33 of current quarter');
INSERT INTO `example` VALUES (104, '2024-05-04', 'Data for day 34 of current quarter');
INSERT INTO `example` VALUES (105, '2024-05-05', 'Data for day 35 of current quarter');
INSERT INTO `example` VALUES (106, '2024-05-06', 'Data for day 36 of current quarter');
INSERT INTO `example` VALUES (107, '2024-05-07', 'Data for day 37 of current quarter');
INSERT INTO `example` VALUES (108, '2024-05-08', 'Data for day 38 of current quarter');
INSERT INTO `example` VALUES (109, '2024-05-09', 'Data for day 39 of current quarter');
INSERT INTO `example` VALUES (110, '2024-05-10', 'Data for day 40 of current quarter');
INSERT INTO `example` VALUES (111, '2024-05-11', 'Data for day 41 of current quarter');
INSERT INTO `example` VALUES (112, '2024-05-12', 'Data for day 42 of current quarter');
INSERT INTO `example` VALUES (113, '2024-05-13', 'Data for day 43 of current quarter');
INSERT INTO `example` VALUES (114, '2024-05-14', 'Data for day 44 of current quarter');
INSERT INTO `example` VALUES (115, '2024-05-15', 'Data for day 45 of current quarter');
INSERT INTO `example` VALUES (116, '2024-05-16', 'Data for day 46 of current quarter');
INSERT INTO `example` VALUES (117, '2024-05-17', 'Data for day 47 of current quarter');
INSERT INTO `example` VALUES (118, '2024-05-18', 'Data for day 48 of current quarter');
INSERT INTO `example` VALUES (119, '2024-05-19', 'Data for day 49 of current quarter');
INSERT INTO `example` VALUES (120, '2024-05-20', 'Data for day 50 of current quarter');
INSERT INTO `example` VALUES (121, '2024-05-21', 'Data for day 51 of current quarter');
INSERT INTO `example` VALUES (122, '2024-05-22', 'Data for day 52 of current quarter');
INSERT INTO `example` VALUES (123, '2024-05-23', 'Data for day 53 of current quarter');
INSERT INTO `example` VALUES (124, '2024-05-24', 'Data for day 54 of current quarter');
INSERT INTO `example` VALUES (125, '2024-05-25', 'Data for day 55 of current quarter');
INSERT INTO `example` VALUES (126, '2024-05-26', 'Data for day 56 of current quarter');
INSERT INTO `example` VALUES (127, '2024-05-27', 'Data for day 57 of current quarter');
INSERT INTO `example` VALUES (128, '2024-05-28', 'Data for day 58 of current quarter');
INSERT INTO `example` VALUES (129, '2024-05-29', 'Data for day 59 of current quarter');
INSERT INTO `example` VALUES (130, '2024-05-30', 'Data for day 60 of current quarter');
INSERT INTO `example` VALUES (131, '2024-05-31', 'Data for day 61 of current quarter');
INSERT INTO `example` VALUES (132, '2024-06-01', 'Data for day 62 of current quarter');
INSERT INTO `example` VALUES (133, '2024-06-02', 'Data for day 63 of current quarter');
INSERT INTO `example` VALUES (134, '2024-06-03', 'Data for day 64 of current quarter');
INSERT INTO `example` VALUES (135, '2024-06-04', 'Data for day 65 of current quarter');
INSERT INTO `example` VALUES (136, '2024-06-05', 'Data for day 66 of current quarter');
INSERT INTO `example` VALUES (137, '2024-06-06', 'Data for day 67 of current quarter');
INSERT INTO `example` VALUES (138, '2024-06-07', 'Data for day 68 of current quarter');
INSERT INTO `example` VALUES (139, '2024-06-08', 'Data for day 69 of current quarter');
INSERT INTO `example` VALUES (140, '2024-06-09', 'Data for day 70 of current quarter');
INSERT INTO `example` VALUES (141, '2024-06-10', 'Data for day 71 of current quarter');
INSERT INTO `example` VALUES (142, '2024-06-11', 'Data for day 72 of current quarter');
INSERT INTO `example` VALUES (143, '2024-06-12', 'Data for day 73 of current quarter');
INSERT INTO `example` VALUES (144, '2024-06-13', 'Data for day 74 of current quarter');
INSERT INTO `example` VALUES (145, '2024-06-14', 'Data for day 75 of current quarter');
INSERT INTO `example` VALUES (146, '2024-06-15', 'Data for day 76 of current quarter');
INSERT INTO `example` VALUES (147, '2024-06-16', 'Data for day 77 of current quarter');
INSERT INTO `example` VALUES (148, '2024-06-17', 'Data for day 78 of current quarter');
INSERT INTO `example` VALUES (149, '2024-06-18', 'Data for day 79 of current quarter');
INSERT INTO `example` VALUES (150, '2024-06-19', 'Data for day 80 of current quarter');
INSERT INTO `example` VALUES (151, '2024-06-20', 'Data for day 81 of current quarter');
INSERT INTO `example` VALUES (152, '2024-06-21', 'Data for day 82 of current quarter');
INSERT INTO `example` VALUES (153, '2024-06-22', 'Data for day 83 of current quarter');
INSERT INTO `example` VALUES (154, '2024-06-23', 'Data for day 84 of current quarter');
INSERT INTO `example` VALUES (155, '2024-06-24', 'Data for day 85 of current quarter');
INSERT INTO `example` VALUES (156, '2024-06-25', 'Data for day 86 of current quarter');
INSERT INTO `example` VALUES (157, '2024-06-26', 'Data for day 87 of current quarter');
INSERT INTO `example` VALUES (158, '2024-06-27', 'Data for day 88 of current quarter');
INSERT INTO `example` VALUES (159, '2024-06-28', 'Data for day 89 of current quarter');
INSERT INTO `example` VALUES (160, '2024-06-29', 'Data for day 90 of current quarter');
INSERT INTO `example` VALUES (161, '2024-06-30', 'Data for day 91 of current quarter');
INSERT INTO `example` VALUES (162, '2024-01-01', 'Data for day 1 of last quarter');
INSERT INTO `example` VALUES (163, '2024-01-02', 'Data for day 2 of last quarter');
INSERT INTO `example` VALUES (164, '2024-01-03', 'Data for day 3 of last quarter');
INSERT INTO `example` VALUES (165, '2024-01-04', 'Data for day 4 of last quarter');
INSERT INTO `example` VALUES (166, '2024-01-05', 'Data for day 5 of last quarter');
INSERT INTO `example` VALUES (167, '2024-01-06', 'Data for day 6 of last quarter');
INSERT INTO `example` VALUES (168, '2024-01-07', 'Data for day 7 of last quarter');
INSERT INTO `example` VALUES (169, '2024-01-08', 'Data for day 8 of last quarter');
INSERT INTO `example` VALUES (170, '2024-01-09', 'Data for day 9 of last quarter');
INSERT INTO `example` VALUES (171, '2024-01-10', 'Data for day 10 of last quarter');
INSERT INTO `example` VALUES (172, '2024-01-11', 'Data for day 11 of last quarter');
INSERT INTO `example` VALUES (173, '2024-01-12', 'Data for day 12 of last quarter');
INSERT INTO `example` VALUES (174, '2024-01-13', 'Data for day 13 of last quarter');
INSERT INTO `example` VALUES (175, '2024-01-14', 'Data for day 14 of last quarter');
INSERT INTO `example` VALUES (176, '2024-01-15', 'Data for day 15 of last quarter');
INSERT INTO `example` VALUES (177, '2024-01-16', 'Data for day 16 of last quarter');
INSERT INTO `example` VALUES (178, '2024-01-17', 'Data for day 17 of last quarter');
INSERT INTO `example` VALUES (179, '2024-01-18', 'Data for day 18 of last quarter');
INSERT INTO `example` VALUES (180, '2024-01-19', 'Data for day 19 of last quarter');
INSERT INTO `example` VALUES (181, '2024-01-20', 'Data for day 20 of last quarter');
INSERT INTO `example` VALUES (182, '2024-01-21', 'Data for day 21 of last quarter');
INSERT INTO `example` VALUES (183, '2024-01-22', 'Data for day 22 of last quarter');
INSERT INTO `example` VALUES (184, '2024-01-23', 'Data for day 23 of last quarter');
INSERT INTO `example` VALUES (185, '2024-01-24', 'Data for day 24 of last quarter');
INSERT INTO `example` VALUES (186, '2024-01-25', 'Data for day 25 of last quarter');
INSERT INTO `example` VALUES (187, '2024-01-26', 'Data for day 26 of last quarter');
INSERT INTO `example` VALUES (188, '2024-01-27', 'Data for day 27 of last quarter');
INSERT INTO `example` VALUES (189, '2024-01-28', 'Data for day 28 of last quarter');
INSERT INTO `example` VALUES (190, '2024-01-29', 'Data for day 29 of last quarter');
INSERT INTO `example` VALUES (191, '2024-01-30', 'Data for day 30 of last quarter');
INSERT INTO `example` VALUES (192, '2024-01-31', 'Data for day 31 of last quarter');
INSERT INTO `example` VALUES (193, '2024-02-01', 'Data for day 32 of last quarter');
INSERT INTO `example` VALUES (194, '2024-02-02', 'Data for day 33 of last quarter');
INSERT INTO `example` VALUES (195, '2024-02-03', 'Data for day 34 of last quarter');
INSERT INTO `example` VALUES (196, '2024-02-04', 'Data for day 35 of last quarter');
INSERT INTO `example` VALUES (197, '2024-02-05', 'Data for day 36 of last quarter');
INSERT INTO `example` VALUES (198, '2024-02-06', 'Data for day 37 of last quarter');
INSERT INTO `example` VALUES (199, '2024-02-07', 'Data for day 38 of last quarter');
INSERT INTO `example` VALUES (200, '2024-02-08', 'Data for day 39 of last quarter');
INSERT INTO `example` VALUES (201, '2024-02-09', 'Data for day 40 of last quarter');
INSERT INTO `example` VALUES (202, '2024-02-10', 'Data for day 41 of last quarter');
INSERT INTO `example` VALUES (203, '2024-02-11', 'Data for day 42 of last quarter');
INSERT INTO `example` VALUES (204, '2024-02-12', 'Data for day 43 of last quarter');
INSERT INTO `example` VALUES (205, '2024-02-13', 'Data for day 44 of last quarter');
INSERT INTO `example` VALUES (206, '2024-02-14', 'Data for day 45 of last quarter');
INSERT INTO `example` VALUES (207, '2024-02-15', 'Data for day 46 of last quarter');
INSERT INTO `example` VALUES (208, '2024-02-16', 'Data for day 47 of last quarter');
INSERT INTO `example` VALUES (209, '2024-02-17', 'Data for day 48 of last quarter');
INSERT INTO `example` VALUES (210, '2024-02-18', 'Data for day 49 of last quarter');
INSERT INTO `example` VALUES (211, '2024-02-19', 'Data for day 50 of last quarter');
INSERT INTO `example` VALUES (212, '2024-02-20', 'Data for day 51 of last quarter');
INSERT INTO `example` VALUES (213, '2024-02-21', 'Data for day 52 of last quarter');
INSERT INTO `example` VALUES (214, '2024-02-22', 'Data for day 53 of last quarter');
INSERT INTO `example` VALUES (215, '2024-02-23', 'Data for day 54 of last quarter');
INSERT INTO `example` VALUES (216, '2024-02-24', 'Data for day 55 of last quarter');
INSERT INTO `example` VALUES (217, '2024-02-25', 'Data for day 56 of last quarter');
INSERT INTO `example` VALUES (218, '2024-02-26', 'Data for day 57 of last quarter');
INSERT INTO `example` VALUES (219, '2024-02-27', 'Data for day 58 of last quarter');
INSERT INTO `example` VALUES (220, '2024-02-28', 'Data for day 59 of last quarter');
INSERT INTO `example` VALUES (221, '2024-02-29', 'Data for day 60 of last quarter');
INSERT INTO `example` VALUES (222, '2024-03-01', 'Data for day 61 of last quarter');
INSERT INTO `example` VALUES (223, '2024-03-02', 'Data for day 62 of last quarter');
INSERT INTO `example` VALUES (224, '2024-03-03', 'Data for day 63 of last quarter');
INSERT INTO `example` VALUES (225, '2024-03-04', 'Data for day 64 of last quarter');
INSERT INTO `example` VALUES (226, '2024-03-05', 'Data for day 65 of last quarter');
INSERT INTO `example` VALUES (227, '2024-03-06', 'Data for day 66 of last quarter');
INSERT INTO `example` VALUES (228, '2024-03-07', 'Data for day 67 of last quarter');
INSERT INTO `example` VALUES (229, '2024-03-08', 'Data for day 68 of last quarter');
INSERT INTO `example` VALUES (230, '2024-03-09', 'Data for day 69 of last quarter');
INSERT INTO `example` VALUES (231, '2024-03-10', 'Data for day 70 of last quarter');
INSERT INTO `example` VALUES (232, '2024-03-11', 'Data for day 71 of last quarter');
INSERT INTO `example` VALUES (233, '2024-03-12', 'Data for day 72 of last quarter');
INSERT INTO `example` VALUES (234, '2024-03-13', 'Data for day 73 of last quarter');
INSERT INTO `example` VALUES (235, '2024-03-14', 'Data for day 74 of last quarter');
INSERT INTO `example` VALUES (236, '2024-03-15', 'Data for day 75 of last quarter');
INSERT INTO `example` VALUES (237, '2024-03-16', 'Data for day 76 of last quarter');
INSERT INTO `example` VALUES (238, '2024-03-17', 'Data for day 77 of last quarter');
INSERT INTO `example` VALUES (239, '2024-03-18', 'Data for day 78 of last quarter');
INSERT INTO `example` VALUES (240, '2024-03-19', 'Data for day 79 of last quarter');
INSERT INTO `example` VALUES (241, '2024-03-20', 'Data for day 80 of last quarter');
INSERT INTO `example` VALUES (242, '2024-03-21', 'Data for day 81 of last quarter');
INSERT INTO `example` VALUES (243, '2024-03-22', 'Data for day 82 of last quarter');
INSERT INTO `example` VALUES (244, '2024-03-23', 'Data for day 83 of last quarter');
INSERT INTO `example` VALUES (245, '2024-03-24', 'Data for day 84 of last quarter');
INSERT INTO `example` VALUES (246, '2024-03-25', 'Data for day 85 of last quarter');
INSERT INTO `example` VALUES (247, '2024-03-26', 'Data for day 86 of last quarter');
INSERT INTO `example` VALUES (248, '2024-03-27', 'Data for day 87 of last quarter');
INSERT INTO `example` VALUES (249, '2024-03-28', 'Data for day 88 of last quarter');
INSERT INTO `example` VALUES (250, '2024-03-29', 'Data for day 89 of last quarter');
INSERT INTO `example` VALUES (251, '2024-03-30', 'Data for day 90 of last quarter');
INSERT INTO `example` VALUES (252, '2024-03-31', 'Data for day 91 of last quarter');
INSERT INTO `example` VALUES (253, '2024-01-01', 'Data for day 1 of current year');
INSERT INTO `example` VALUES (254, '2024-01-02', 'Data for day 2 of current year');
INSERT INTO `example` VALUES (255, '2024-01-03', 'Data for day 3 of current year');
INSERT INTO `example` VALUES (256, '2024-01-04', 'Data for day 4 of current year');
INSERT INTO `example` VALUES (257, '2024-01-05', 'Data for day 5 of current year');
INSERT INTO `example` VALUES (258, '2024-01-06', 'Data for day 6 of current year');
INSERT INTO `example` VALUES (259, '2024-01-07', 'Data for day 7 of current year');
INSERT INTO `example` VALUES (260, '2024-01-08', 'Data for day 8 of current year');
INSERT INTO `example` VALUES (261, '2024-01-09', 'Data for day 9 of current year');
INSERT INTO `example` VALUES (262, '2024-01-10', 'Data for day 10 of current year');
INSERT INTO `example` VALUES (263, '2024-01-11', 'Data for day 11 of current year');
INSERT INTO `example` VALUES (264, '2024-01-12', 'Data for day 12 of current year');
INSERT INTO `example` VALUES (265, '2024-01-13', 'Data for day 13 of current year');
INSERT INTO `example` VALUES (266, '2024-01-14', 'Data for day 14 of current year');
INSERT INTO `example` VALUES (267, '2024-01-15', 'Data for day 15 of current year');
INSERT INTO `example` VALUES (268, '2024-01-16', 'Data for day 16 of current year');
INSERT INTO `example` VALUES (269, '2024-01-17', 'Data for day 17 of current year');
INSERT INTO `example` VALUES (270, '2024-01-18', 'Data for day 18 of current year');
INSERT INTO `example` VALUES (271, '2024-01-19', 'Data for day 19 of current year');
INSERT INTO `example` VALUES (272, '2024-01-20', 'Data for day 20 of current year');
INSERT INTO `example` VALUES (273, '2024-01-21', 'Data for day 21 of current year');
INSERT INTO `example` VALUES (274, '2024-01-22', 'Data for day 22 of current year');
INSERT INTO `example` VALUES (275, '2024-01-23', 'Data for day 23 of current year');
INSERT INTO `example` VALUES (276, '2024-01-24', 'Data for day 24 of current year');
INSERT INTO `example` VALUES (277, '2024-01-25', 'Data for day 25 of current year');
INSERT INTO `example` VALUES (278, '2024-01-26', 'Data for day 26 of current year');
INSERT INTO `example` VALUES (279, '2024-01-27', 'Data for day 27 of current year');
INSERT INTO `example` VALUES (280, '2024-01-28', 'Data for day 28 of current year');
INSERT INTO `example` VALUES (281, '2024-01-29', 'Data for day 29 of current year');
INSERT INTO `example` VALUES (282, '2024-01-30', 'Data for day 30 of current year');
INSERT INTO `example` VALUES (283, '2024-01-31', 'Data for day 31 of current year');
INSERT INTO `example` VALUES (284, '2024-02-01', 'Data for day 32 of current year');
INSERT INTO `example` VALUES (285, '2024-02-02', 'Data for day 33 of current year');
INSERT INTO `example` VALUES (286, '2024-02-03', 'Data for day 34 of current year');
INSERT INTO `example` VALUES (287, '2024-02-04', 'Data for day 35 of current year');
INSERT INTO `example` VALUES (288, '2024-02-05', 'Data for day 36 of current year');
INSERT INTO `example` VALUES (289, '2024-02-06', 'Data for day 37 of current year');
INSERT INTO `example` VALUES (290, '2024-02-07', 'Data for day 38 of current year');
INSERT INTO `example` VALUES (291, '2024-02-08', 'Data for day 39 of current year');
INSERT INTO `example` VALUES (292, '2024-02-09', 'Data for day 40 of current year');
INSERT INTO `example` VALUES (293, '2024-02-10', 'Data for day 41 of current year');
INSERT INTO `example` VALUES (294, '2024-02-11', 'Data for day 42 of current year');
INSERT INTO `example` VALUES (295, '2024-02-12', 'Data for day 43 of current year');
INSERT INTO `example` VALUES (296, '2024-02-13', 'Data for day 44 of current year');
INSERT INTO `example` VALUES (297, '2024-02-14', 'Data for day 45 of current year');
INSERT INTO `example` VALUES (298, '2024-02-15', 'Data for day 46 of current year');
INSERT INTO `example` VALUES (299, '2024-02-16', 'Data for day 47 of current year');
INSERT INTO `example` VALUES (300, '2024-02-17', 'Data for day 48 of current year');
INSERT INTO `example` VALUES (301, '2024-02-18', 'Data for day 49 of current year');
INSERT INTO `example` VALUES (302, '2024-02-19', 'Data for day 50 of current year');
INSERT INTO `example` VALUES (303, '2024-02-20', 'Data for day 51 of current year');
INSERT INTO `example` VALUES (304, '2024-02-21', 'Data for day 52 of current year');
INSERT INTO `example` VALUES (305, '2024-02-22', 'Data for day 53 of current year');
INSERT INTO `example` VALUES (306, '2024-02-23', 'Data for day 54 of current year');
INSERT INTO `example` VALUES (307, '2024-02-24', 'Data for day 55 of current year');
INSERT INTO `example` VALUES (308, '2024-02-25', 'Data for day 56 of current year');
INSERT INTO `example` VALUES (309, '2024-02-26', 'Data for day 57 of current year');
INSERT INTO `example` VALUES (310, '2024-02-27', 'Data for day 58 of current year');
INSERT INTO `example` VALUES (311, '2024-02-28', 'Data for day 59 of current year');
INSERT INTO `example` VALUES (312, '2024-02-29', 'Data for day 60 of current year');
INSERT INTO `example` VALUES (313, '2024-03-01', 'Data for day 61 of current year');
INSERT INTO `example` VALUES (314, '2024-03-02', 'Data for day 62 of current year');
INSERT INTO `example` VALUES (315, '2024-03-03', 'Data for day 63 of current year');
INSERT INTO `example` VALUES (316, '2024-03-04', 'Data for day 64 of current year');
INSERT INTO `example` VALUES (317, '2024-03-05', 'Data for day 65 of current year');
INSERT INTO `example` VALUES (318, '2024-03-06', 'Data for day 66 of current year');
INSERT INTO `example` VALUES (319, '2024-03-07', 'Data for day 67 of current year');
INSERT INTO `example` VALUES (320, '2024-03-08', 'Data for day 68 of current year');
INSERT INTO `example` VALUES (321, '2024-03-09', 'Data for day 69 of current year');
INSERT INTO `example` VALUES (322, '2024-03-10', 'Data for day 70 of current year');
INSERT INTO `example` VALUES (323, '2024-03-11', 'Data for day 71 of current year');
INSERT INTO `example` VALUES (324, '2024-03-12', 'Data for day 72 of current year');
INSERT INTO `example` VALUES (325, '2024-03-13', 'Data for day 73 of current year');
INSERT INTO `example` VALUES (326, '2024-03-14', 'Data for day 74 of current year');
INSERT INTO `example` VALUES (327, '2024-03-15', 'Data for day 75 of current year');
INSERT INTO `example` VALUES (328, '2024-03-16', 'Data for day 76 of current year');
INSERT INTO `example` VALUES (329, '2024-03-17', 'Data for day 77 of current year');
INSERT INTO `example` VALUES (330, '2024-03-18', 'Data for day 78 of current year');
INSERT INTO `example` VALUES (331, '2024-03-19', 'Data for day 79 of current year');
INSERT INTO `example` VALUES (332, '2024-03-20', 'Data for day 80 of current year');
INSERT INTO `example` VALUES (333, '2024-03-21', 'Data for day 81 of current year');
INSERT INTO `example` VALUES (334, '2024-03-22', 'Data for day 82 of current year');
INSERT INTO `example` VALUES (335, '2024-03-23', 'Data for day 83 of current year');
INSERT INTO `example` VALUES (336, '2024-03-24', 'Data for day 84 of current year');
INSERT INTO `example` VALUES (337, '2024-03-25', 'Data for day 85 of current year');
INSERT INTO `example` VALUES (338, '2024-03-26', 'Data for day 86 of current year');
INSERT INTO `example` VALUES (339, '2024-03-27', 'Data for day 87 of current year');
INSERT INTO `example` VALUES (340, '2024-03-28', 'Data for day 88 of current year');
INSERT INTO `example` VALUES (341, '2024-03-29', 'Data for day 89 of current year');
INSERT INTO `example` VALUES (342, '2024-03-30', 'Data for day 90 of current year');
INSERT INTO `example` VALUES (343, '2024-03-31', 'Data for day 91 of current year');
INSERT INTO `example` VALUES (344, '2024-04-01', 'Data for day 92 of current year');
INSERT INTO `example` VALUES (345, '2024-04-02', 'Data for day 93 of current year');
INSERT INTO `example` VALUES (346, '2024-04-03', 'Data for day 94 of current year');
INSERT INTO `example` VALUES (347, '2024-04-04', 'Data for day 95 of current year');
INSERT INTO `example` VALUES (348, '2024-04-05', 'Data for day 96 of current year');
INSERT INTO `example` VALUES (349, '2024-04-06', 'Data for day 97 of current year');
INSERT INTO `example` VALUES (350, '2024-04-07', 'Data for day 98 of current year');
INSERT INTO `example` VALUES (351, '2024-04-08', 'Data for day 99 of current year');
INSERT INTO `example` VALUES (352, '2024-04-09', 'Data for day 100 of current year');
INSERT INTO `example` VALUES (353, '2024-04-10', 'Data for day 101 of current year');
INSERT INTO `example` VALUES (354, '2024-04-11', 'Data for day 102 of current year');
INSERT INTO `example` VALUES (355, '2024-04-12', 'Data for day 103 of current year');
INSERT INTO `example` VALUES (356, '2024-04-13', 'Data for day 104 of current year');
INSERT INTO `example` VALUES (357, '2024-04-14', 'Data for day 105 of current year');
INSERT INTO `example` VALUES (358, '2024-04-15', 'Data for day 106 of current year');
INSERT INTO `example` VALUES (359, '2024-04-16', 'Data for day 107 of current year');
INSERT INTO `example` VALUES (360, '2024-04-17', 'Data for day 108 of current year');
INSERT INTO `example` VALUES (361, '2024-04-18', 'Data for day 109 of current year');
INSERT INTO `example` VALUES (362, '2024-04-19', 'Data for day 110 of current year');
INSERT INTO `example` VALUES (363, '2024-04-20', 'Data for day 111 of current year');
INSERT INTO `example` VALUES (364, '2024-04-21', 'Data for day 112 of current year');
INSERT INTO `example` VALUES (365, '2024-04-22', 'Data for day 113 of current year');
INSERT INTO `example` VALUES (366, '2024-04-23', 'Data for day 114 of current year');
INSERT INTO `example` VALUES (367, '2024-04-24', 'Data for day 115 of current year');
INSERT INTO `example` VALUES (368, '2024-04-25', 'Data for day 116 of current year');
INSERT INTO `example` VALUES (369, '2024-04-26', 'Data for day 117 of current year');
INSERT INTO `example` VALUES (370, '2024-04-27', 'Data for day 118 of current year');
INSERT INTO `example` VALUES (371, '2024-04-28', 'Data for day 119 of current year');
INSERT INTO `example` VALUES (372, '2024-04-29', 'Data for day 120 of current year');
INSERT INTO `example` VALUES (373, '2024-04-30', 'Data for day 121 of current year');
INSERT INTO `example` VALUES (374, '2024-05-01', 'Data for day 122 of current year');
INSERT INTO `example` VALUES (375, '2024-05-02', 'Data for day 123 of current year');
INSERT INTO `example` VALUES (376, '2024-05-03', 'Data for day 124 of current year');
INSERT INTO `example` VALUES (377, '2024-05-04', 'Data for day 125 of current year');
INSERT INTO `example` VALUES (378, '2024-05-05', 'Data for day 126 of current year');
INSERT INTO `example` VALUES (379, '2024-05-06', 'Data for day 127 of current year');
INSERT INTO `example` VALUES (380, '2024-05-07', 'Data for day 128 of current year');
INSERT INTO `example` VALUES (381, '2024-05-08', 'Data for day 129 of current year');
INSERT INTO `example` VALUES (382, '2024-05-09', 'Data for day 130 of current year');
INSERT INTO `example` VALUES (383, '2024-05-10', 'Data for day 131 of current year');
INSERT INTO `example` VALUES (384, '2024-05-11', 'Data for day 132 of current year');
INSERT INTO `example` VALUES (385, '2024-05-12', 'Data for day 133 of current year');
INSERT INTO `example` VALUES (386, '2024-05-13', 'Data for day 134 of current year');
INSERT INTO `example` VALUES (387, '2024-05-14', 'Data for day 135 of current year');
INSERT INTO `example` VALUES (388, '2024-05-15', 'Data for day 136 of current year');
INSERT INTO `example` VALUES (389, '2024-05-16', 'Data for day 137 of current year');
INSERT INTO `example` VALUES (390, '2024-05-17', 'Data for day 138 of current year');
INSERT INTO `example` VALUES (391, '2024-05-18', 'Data for day 139 of current year');
INSERT INTO `example` VALUES (392, '2024-05-19', 'Data for day 140 of current year');
INSERT INTO `example` VALUES (393, '2024-05-20', 'Data for day 141 of current year');
INSERT INTO `example` VALUES (394, '2024-05-21', 'Data for day 142 of current year');
INSERT INTO `example` VALUES (395, '2024-05-22', 'Data for day 143 of current year');
INSERT INTO `example` VALUES (396, '2024-05-23', 'Data for day 144 of current year');
INSERT INTO `example` VALUES (397, '2024-05-24', 'Data for day 145 of current year');
INSERT INTO `example` VALUES (398, '2024-05-25', 'Data for day 146 of current year');
INSERT INTO `example` VALUES (399, '2024-05-26', 'Data for day 147 of current year');
INSERT INTO `example` VALUES (400, '2024-05-27', 'Data for day 148 of current year');
INSERT INTO `example` VALUES (401, '2024-05-28', 'Data for day 149 of current year');
INSERT INTO `example` VALUES (402, '2024-05-29', 'Data for day 150 of current year');
INSERT INTO `example` VALUES (403, '2024-05-30', 'Data for day 151 of current year');
INSERT INTO `example` VALUES (404, '2024-05-31', 'Data for day 152 of current year');
INSERT INTO `example` VALUES (405, '2024-06-01', 'Data for day 153 of current year');
INSERT INTO `example` VALUES (406, '2024-06-02', 'Data for day 154 of current year');
INSERT INTO `example` VALUES (407, '2024-06-03', 'Data for day 155 of current year');
INSERT INTO `example` VALUES (408, '2024-06-04', 'Data for day 156 of current year');
INSERT INTO `example` VALUES (409, '2024-06-05', 'Data for day 157 of current year');
INSERT INTO `example` VALUES (410, '2024-06-06', 'Data for day 158 of current year');
INSERT INTO `example` VALUES (411, '2024-06-07', 'Data for day 159 of current year');
INSERT INTO `example` VALUES (412, '2024-06-08', 'Data for day 160 of current year');
INSERT INTO `example` VALUES (413, '2024-06-09', 'Data for day 161 of current year');
INSERT INTO `example` VALUES (414, '2024-06-10', 'Data for day 162 of current year');
INSERT INTO `example` VALUES (415, '2024-06-11', 'Data for day 163 of current year');
INSERT INTO `example` VALUES (416, '2024-06-12', 'Data for day 164 of current year');
INSERT INTO `example` VALUES (417, '2024-06-13', 'Data for day 165 of current year');
INSERT INTO `example` VALUES (418, '2024-06-14', 'Data for day 166 of current year');
INSERT INTO `example` VALUES (419, '2024-06-15', 'Data for day 167 of current year');
INSERT INTO `example` VALUES (420, '2024-06-16', 'Data for day 168 of current year');
INSERT INTO `example` VALUES (421, '2024-06-17', 'Data for day 169 of current year');
INSERT INTO `example` VALUES (422, '2024-06-18', 'Data for day 170 of current year');
INSERT INTO `example` VALUES (423, '2024-06-19', 'Data for day 171 of current year');
INSERT INTO `example` VALUES (424, '2024-06-20', 'Data for day 172 of current year');
INSERT INTO `example` VALUES (425, '2024-06-21', 'Data for day 173 of current year');
INSERT INTO `example` VALUES (426, '2024-06-22', 'Data for day 174 of current year');
INSERT INTO `example` VALUES (427, '2024-06-23', 'Data for day 175 of current year');
INSERT INTO `example` VALUES (428, '2024-06-24', 'Data for day 176 of current year');
INSERT INTO `example` VALUES (429, '2024-06-25', 'Data for day 177 of current year');
INSERT INTO `example` VALUES (430, '2024-06-26', 'Data for day 178 of current year');
INSERT INTO `example` VALUES (431, '2024-06-27', 'Data for day 179 of current year');
INSERT INTO `example` VALUES (432, '2024-06-28', 'Data for day 180 of current year');
INSERT INTO `example` VALUES (433, '2024-06-29', 'Data for day 181 of current year');
INSERT INTO `example` VALUES (434, '2024-06-30', 'Data for day 182 of current year');
INSERT INTO `example` VALUES (435, '2024-07-01', 'Data for day 183 of current year');
INSERT INTO `example` VALUES (436, '2024-07-02', 'Data for day 184 of current year');
INSERT INTO `example` VALUES (437, '2024-07-03', 'Data for day 185 of current year');
INSERT INTO `example` VALUES (438, '2024-07-04', 'Data for day 186 of current year');
INSERT INTO `example` VALUES (439, '2024-07-05', 'Data for day 187 of current year');
INSERT INTO `example` VALUES (440, '2024-07-06', 'Data for day 188 of current year');
INSERT INTO `example` VALUES (441, '2024-07-07', 'Data for day 189 of current year');
INSERT INTO `example` VALUES (442, '2024-07-08', 'Data for day 190 of current year');
INSERT INTO `example` VALUES (443, '2024-07-09', 'Data for day 191 of current year');
INSERT INTO `example` VALUES (444, '2024-07-10', 'Data for day 192 of current year');
INSERT INTO `example` VALUES (445, '2024-07-11', 'Data for day 193 of current year');
INSERT INTO `example` VALUES (446, '2024-07-12', 'Data for day 194 of current year');
INSERT INTO `example` VALUES (447, '2024-07-13', 'Data for day 195 of current year');
INSERT INTO `example` VALUES (448, '2024-07-14', 'Data for day 196 of current year');
INSERT INTO `example` VALUES (449, '2024-07-15', 'Data for day 197 of current year');
INSERT INTO `example` VALUES (450, '2024-07-16', 'Data for day 198 of current year');
INSERT INTO `example` VALUES (451, '2024-07-17', 'Data for day 199 of current year');
INSERT INTO `example` VALUES (452, '2024-07-18', 'Data for day 200 of current year');
INSERT INTO `example` VALUES (453, '2024-07-19', 'Data for day 201 of current year');
INSERT INTO `example` VALUES (454, '2024-07-20', 'Data for day 202 of current year');
INSERT INTO `example` VALUES (455, '2024-07-21', 'Data for day 203 of current year');
INSERT INTO `example` VALUES (456, '2024-07-22', 'Data for day 204 of current year');
INSERT INTO `example` VALUES (457, '2024-07-23', 'Data for day 205 of current year');
INSERT INTO `example` VALUES (458, '2024-07-24', 'Data for day 206 of current year');
INSERT INTO `example` VALUES (459, '2024-07-25', 'Data for day 207 of current year');
INSERT INTO `example` VALUES (460, '2024-07-26', 'Data for day 208 of current year');
INSERT INTO `example` VALUES (461, '2024-07-27', 'Data for day 209 of current year');
INSERT INTO `example` VALUES (462, '2024-07-28', 'Data for day 210 of current year');
INSERT INTO `example` VALUES (463, '2024-07-29', 'Data for day 211 of current year');
INSERT INTO `example` VALUES (464, '2024-07-30', 'Data for day 212 of current year');
INSERT INTO `example` VALUES (465, '2024-07-31', 'Data for day 213 of current year');
INSERT INTO `example` VALUES (466, '2024-08-01', 'Data for day 214 of current year');
INSERT INTO `example` VALUES (467, '2024-08-02', 'Data for day 215 of current year');
INSERT INTO `example` VALUES (468, '2024-08-03', 'Data for day 216 of current year');
INSERT INTO `example` VALUES (469, '2024-08-04', 'Data for day 217 of current year');
INSERT INTO `example` VALUES (470, '2024-08-05', 'Data for day 218 of current year');
INSERT INTO `example` VALUES (471, '2024-08-06', 'Data for day 219 of current year');
INSERT INTO `example` VALUES (472, '2024-08-07', 'Data for day 220 of current year');
INSERT INTO `example` VALUES (473, '2024-08-08', 'Data for day 221 of current year');
INSERT INTO `example` VALUES (474, '2024-08-09', 'Data for day 222 of current year');
INSERT INTO `example` VALUES (475, '2024-08-10', 'Data for day 223 of current year');
INSERT INTO `example` VALUES (476, '2024-08-11', 'Data for day 224 of current year');
INSERT INTO `example` VALUES (477, '2024-08-12', 'Data for day 225 of current year');
INSERT INTO `example` VALUES (478, '2024-08-13', 'Data for day 226 of current year');
INSERT INTO `example` VALUES (479, '2024-08-14', 'Data for day 227 of current year');
INSERT INTO `example` VALUES (480, '2024-08-15', 'Data for day 228 of current year');
INSERT INTO `example` VALUES (481, '2024-08-16', 'Data for day 229 of current year');
INSERT INTO `example` VALUES (482, '2024-08-17', 'Data for day 230 of current year');
INSERT INTO `example` VALUES (483, '2024-08-18', 'Data for day 231 of current year');
INSERT INTO `example` VALUES (484, '2024-08-19', 'Data for day 232 of current year');
INSERT INTO `example` VALUES (485, '2024-08-20', 'Data for day 233 of current year');
INSERT INTO `example` VALUES (486, '2024-08-21', 'Data for day 234 of current year');
INSERT INTO `example` VALUES (487, '2024-08-22', 'Data for day 235 of current year');
INSERT INTO `example` VALUES (488, '2024-08-23', 'Data for day 236 of current year');
INSERT INTO `example` VALUES (489, '2024-08-24', 'Data for day 237 of current year');
INSERT INTO `example` VALUES (490, '2024-08-25', 'Data for day 238 of current year');
INSERT INTO `example` VALUES (491, '2024-08-26', 'Data for day 239 of current year');
INSERT INTO `example` VALUES (492, '2024-08-27', 'Data for day 240 of current year');
INSERT INTO `example` VALUES (493, '2024-08-28', 'Data for day 241 of current year');
INSERT INTO `example` VALUES (494, '2024-08-29', 'Data for day 242 of current year');
INSERT INTO `example` VALUES (495, '2024-08-30', 'Data for day 243 of current year');
INSERT INTO `example` VALUES (496, '2024-08-31', 'Data for day 244 of current year');
INSERT INTO `example` VALUES (497, '2024-09-01', 'Data for day 245 of current year');
INSERT INTO `example` VALUES (498, '2024-09-02', 'Data for day 246 of current year');
INSERT INTO `example` VALUES (499, '2024-09-03', 'Data for day 247 of current year');
INSERT INTO `example` VALUES (500, '2024-09-04', 'Data for day 248 of current year');
INSERT INTO `example` VALUES (501, '2024-09-05', 'Data for day 249 of current year');
INSERT INTO `example` VALUES (502, '2024-09-06', 'Data for day 250 of current year');
INSERT INTO `example` VALUES (503, '2024-09-07', 'Data for day 251 of current year');
INSERT INTO `example` VALUES (504, '2024-09-08', 'Data for day 252 of current year');
INSERT INTO `example` VALUES (505, '2024-09-09', 'Data for day 253 of current year');
INSERT INTO `example` VALUES (506, '2024-09-10', 'Data for day 254 of current year');
INSERT INTO `example` VALUES (507, '2024-09-11', 'Data for day 255 of current year');
INSERT INTO `example` VALUES (508, '2024-09-12', 'Data for day 256 of current year');
INSERT INTO `example` VALUES (509, '2024-09-13', 'Data for day 257 of current year');
INSERT INTO `example` VALUES (510, '2024-09-14', 'Data for day 258 of current year');
INSERT INTO `example` VALUES (511, '2024-09-15', 'Data for day 259 of current year');
INSERT INTO `example` VALUES (512, '2024-09-16', 'Data for day 260 of current year');
INSERT INTO `example` VALUES (513, '2024-09-17', 'Data for day 261 of current year');
INSERT INTO `example` VALUES (514, '2024-09-18', 'Data for day 262 of current year');
INSERT INTO `example` VALUES (515, '2024-09-19', 'Data for day 263 of current year');
INSERT INTO `example` VALUES (516, '2024-09-20', 'Data for day 264 of current year');
INSERT INTO `example` VALUES (517, '2024-09-21', 'Data for day 265 of current year');
INSERT INTO `example` VALUES (518, '2024-09-22', 'Data for day 266 of current year');
INSERT INTO `example` VALUES (519, '2024-09-23', 'Data for day 267 of current year');
INSERT INTO `example` VALUES (520, '2024-09-24', 'Data for day 268 of current year');
INSERT INTO `example` VALUES (521, '2024-09-25', 'Data for day 269 of current year');
INSERT INTO `example` VALUES (522, '2024-09-26', 'Data for day 270 of current year');
INSERT INTO `example` VALUES (523, '2024-09-27', 'Data for day 271 of current year');
INSERT INTO `example` VALUES (524, '2024-09-28', 'Data for day 272 of current year');
INSERT INTO `example` VALUES (525, '2024-09-29', 'Data for day 273 of current year');
INSERT INTO `example` VALUES (526, '2024-09-30', 'Data for day 274 of current year');
INSERT INTO `example` VALUES (527, '2024-10-01', 'Data for day 275 of current year');
INSERT INTO `example` VALUES (528, '2024-10-02', 'Data for day 276 of current year');
INSERT INTO `example` VALUES (529, '2024-10-03', 'Data for day 277 of current year');
INSERT INTO `example` VALUES (530, '2024-10-04', 'Data for day 278 of current year');
INSERT INTO `example` VALUES (531, '2024-10-05', 'Data for day 279 of current year');
INSERT INTO `example` VALUES (532, '2024-10-06', 'Data for day 280 of current year');
INSERT INTO `example` VALUES (533, '2024-10-07', 'Data for day 281 of current year');
INSERT INTO `example` VALUES (534, '2024-10-08', 'Data for day 282 of current year');
INSERT INTO `example` VALUES (535, '2024-10-09', 'Data for day 283 of current year');
INSERT INTO `example` VALUES (536, '2024-10-10', 'Data for day 284 of current year');
INSERT INTO `example` VALUES (537, '2024-10-11', 'Data for day 285 of current year');
INSERT INTO `example` VALUES (538, '2024-10-12', 'Data for day 286 of current year');
INSERT INTO `example` VALUES (539, '2024-10-13', 'Data for day 287 of current year');
INSERT INTO `example` VALUES (540, '2024-10-14', 'Data for day 288 of current year');
INSERT INTO `example` VALUES (541, '2024-10-15', 'Data for day 289 of current year');
INSERT INTO `example` VALUES (542, '2024-10-16', 'Data for day 290 of current year');
INSERT INTO `example` VALUES (543, '2024-10-17', 'Data for day 291 of current year');
INSERT INTO `example` VALUES (544, '2024-10-18', 'Data for day 292 of current year');
INSERT INTO `example` VALUES (545, '2024-10-19', 'Data for day 293 of current year');
INSERT INTO `example` VALUES (546, '2024-10-20', 'Data for day 294 of current year');
INSERT INTO `example` VALUES (547, '2024-10-21', 'Data for day 295 of current year');
INSERT INTO `example` VALUES (548, '2024-10-22', 'Data for day 296 of current year');
INSERT INTO `example` VALUES (549, '2024-10-23', 'Data for day 297 of current year');
INSERT INTO `example` VALUES (550, '2024-10-24', 'Data for day 298 of current year');
INSERT INTO `example` VALUES (551, '2024-10-25', 'Data for day 299 of current year');
INSERT INTO `example` VALUES (552, '2024-10-26', 'Data for day 300 of current year');
INSERT INTO `example` VALUES (553, '2024-10-27', 'Data for day 301 of current year');
INSERT INTO `example` VALUES (554, '2024-10-28', 'Data for day 302 of current year');
INSERT INTO `example` VALUES (555, '2024-10-29', 'Data for day 303 of current year');
INSERT INTO `example` VALUES (556, '2024-10-30', 'Data for day 304 of current year');
INSERT INTO `example` VALUES (557, '2024-10-31', 'Data for day 305 of current year');
INSERT INTO `example` VALUES (558, '2024-11-01', 'Data for day 306 of current year');
INSERT INTO `example` VALUES (559, '2024-11-02', 'Data for day 307 of current year');
INSERT INTO `example` VALUES (560, '2024-11-03', 'Data for day 308 of current year');
INSERT INTO `example` VALUES (561, '2024-11-04', 'Data for day 309 of current year');
INSERT INTO `example` VALUES (562, '2024-11-05', 'Data for day 310 of current year');
INSERT INTO `example` VALUES (563, '2024-11-06', 'Data for day 311 of current year');
INSERT INTO `example` VALUES (564, '2024-11-07', 'Data for day 312 of current year');
INSERT INTO `example` VALUES (565, '2024-11-08', 'Data for day 313 of current year');
INSERT INTO `example` VALUES (566, '2024-11-09', 'Data for day 314 of current year');
INSERT INTO `example` VALUES (567, '2024-11-10', 'Data for day 315 of current year');
INSERT INTO `example` VALUES (568, '2024-11-11', 'Data for day 316 of current year');
INSERT INTO `example` VALUES (569, '2024-11-12', 'Data for day 317 of current year');
INSERT INTO `example` VALUES (570, '2024-11-13', 'Data for day 318 of current year');
INSERT INTO `example` VALUES (571, '2024-11-14', 'Data for day 319 of current year');
INSERT INTO `example` VALUES (572, '2024-11-15', 'Data for day 320 of current year');
INSERT INTO `example` VALUES (573, '2024-11-16', 'Data for day 321 of current year');
INSERT INTO `example` VALUES (574, '2024-11-17', 'Data for day 322 of current year');
INSERT INTO `example` VALUES (575, '2024-11-18', 'Data for day 323 of current year');
INSERT INTO `example` VALUES (576, '2024-11-19', 'Data for day 324 of current year');
INSERT INTO `example` VALUES (577, '2024-11-20', 'Data for day 325 of current year');
INSERT INTO `example` VALUES (578, '2024-11-21', 'Data for day 326 of current year');
INSERT INTO `example` VALUES (579, '2024-11-22', 'Data for day 327 of current year');
INSERT INTO `example` VALUES (580, '2024-11-23', 'Data for day 328 of current year');
INSERT INTO `example` VALUES (581, '2024-11-24', 'Data for day 329 of current year');
INSERT INTO `example` VALUES (582, '2024-11-25', 'Data for day 330 of current year');
INSERT INTO `example` VALUES (583, '2024-11-26', 'Data for day 331 of current year');
INSERT INTO `example` VALUES (584, '2024-11-27', 'Data for day 332 of current year');
INSERT INTO `example` VALUES (585, '2024-11-28', 'Data for day 333 of current year');
INSERT INTO `example` VALUES (586, '2024-11-29', 'Data for day 334 of current year');
INSERT INTO `example` VALUES (587, '2024-11-30', 'Data for day 335 of current year');
INSERT INTO `example` VALUES (588, '2024-12-01', 'Data for day 336 of current year');
INSERT INTO `example` VALUES (589, '2024-12-02', 'Data for day 337 of current year');
INSERT INTO `example` VALUES (590, '2024-12-03', 'Data for day 338 of current year');
INSERT INTO `example` VALUES (591, '2024-12-04', 'Data for day 339 of current year');
INSERT INTO `example` VALUES (592, '2024-12-05', 'Data for day 340 of current year');
INSERT INTO `example` VALUES (593, '2024-12-06', 'Data for day 341 of current year');
INSERT INTO `example` VALUES (594, '2024-12-07', 'Data for day 342 of current year');
INSERT INTO `example` VALUES (595, '2024-12-08', 'Data for day 343 of current year');
INSERT INTO `example` VALUES (596, '2024-12-09', 'Data for day 344 of current year');
INSERT INTO `example` VALUES (597, '2024-12-10', 'Data for day 345 of current year');
INSERT INTO `example` VALUES (598, '2024-12-11', 'Data for day 346 of current year');
INSERT INTO `example` VALUES (599, '2024-12-12', 'Data for day 347 of current year');
INSERT INTO `example` VALUES (600, '2024-12-13', 'Data for day 348 of current year');
INSERT INTO `example` VALUES (601, '2024-12-14', 'Data for day 349 of current year');
INSERT INTO `example` VALUES (602, '2024-12-15', 'Data for day 350 of current year');
INSERT INTO `example` VALUES (603, '2024-12-16', 'Data for day 351 of current year');
INSERT INTO `example` VALUES (604, '2024-12-17', 'Data for day 352 of current year');
INSERT INTO `example` VALUES (605, '2024-12-18', 'Data for day 353 of current year');
INSERT INTO `example` VALUES (606, '2024-12-19', 'Data for day 354 of current year');
INSERT INTO `example` VALUES (607, '2024-12-20', 'Data for day 355 of current year');
INSERT INTO `example` VALUES (608, '2024-12-21', 'Data for day 356 of current year');
INSERT INTO `example` VALUES (609, '2024-12-22', 'Data for day 357 of current year');
INSERT INTO `example` VALUES (610, '2024-12-23', 'Data for day 358 of current year');
INSERT INTO `example` VALUES (611, '2024-12-24', 'Data for day 359 of current year');
INSERT INTO `example` VALUES (612, '2024-12-25', 'Data for day 360 of current year');
INSERT INTO `example` VALUES (613, '2024-12-26', 'Data for day 361 of current year');
INSERT INTO `example` VALUES (614, '2024-12-27', 'Data for day 362 of current year');
INSERT INTO `example` VALUES (615, '2024-12-28', 'Data for day 363 of current year');
INSERT INTO `example` VALUES (616, '2024-12-29', 'Data for day 364 of current year');
INSERT INTO `example` VALUES (617, '2024-12-30', 'Data for day 365 of current year');
INSERT INTO `example` VALUES (618, '2024-12-31', 'Data for day 366 of current year');
INSERT INTO `example` VALUES (619, '2023-01-01', 'Data for day 1 of last year');
INSERT INTO `example` VALUES (620, '2023-01-02', 'Data for day 2 of last year');
INSERT INTO `example` VALUES (621, '2023-01-03', 'Data for day 3 of last year');
INSERT INTO `example` VALUES (622, '2023-01-04', 'Data for day 4 of last year');
INSERT INTO `example` VALUES (623, '2023-01-05', 'Data for day 5 of last year');
INSERT INTO `example` VALUES (624, '2023-01-06', 'Data for day 6 of last year');
INSERT INTO `example` VALUES (625, '2023-01-07', 'Data for day 7 of last year');
INSERT INTO `example` VALUES (626, '2023-01-08', 'Data for day 8 of last year');
INSERT INTO `example` VALUES (627, '2023-01-09', 'Data for day 9 of last year');
INSERT INTO `example` VALUES (628, '2023-01-10', 'Data for day 10 of last year');
INSERT INTO `example` VALUES (629, '2023-01-11', 'Data for day 11 of last year');
INSERT INTO `example` VALUES (630, '2023-01-12', 'Data for day 12 of last year');
INSERT INTO `example` VALUES (631, '2023-01-13', 'Data for day 13 of last year');
INSERT INTO `example` VALUES (632, '2023-01-14', 'Data for day 14 of last year');
INSERT INTO `example` VALUES (633, '2023-01-15', 'Data for day 15 of last year');
INSERT INTO `example` VALUES (634, '2023-01-16', 'Data for day 16 of last year');
INSERT INTO `example` VALUES (635, '2023-01-17', 'Data for day 17 of last year');
INSERT INTO `example` VALUES (636, '2023-01-18', 'Data for day 18 of last year');
INSERT INTO `example` VALUES (637, '2023-01-19', 'Data for day 19 of last year');
INSERT INTO `example` VALUES (638, '2023-01-20', 'Data for day 20 of last year');
INSERT INTO `example` VALUES (639, '2023-01-21', 'Data for day 21 of last year');
INSERT INTO `example` VALUES (640, '2023-01-22', 'Data for day 22 of last year');
INSERT INTO `example` VALUES (641, '2023-01-23', 'Data for day 23 of last year');
INSERT INTO `example` VALUES (642, '2023-01-24', 'Data for day 24 of last year');
INSERT INTO `example` VALUES (643, '2023-01-25', 'Data for day 25 of last year');
INSERT INTO `example` VALUES (644, '2023-01-26', 'Data for day 26 of last year');
INSERT INTO `example` VALUES (645, '2023-01-27', 'Data for day 27 of last year');
INSERT INTO `example` VALUES (646, '2023-01-28', 'Data for day 28 of last year');
INSERT INTO `example` VALUES (647, '2023-01-29', 'Data for day 29 of last year');
INSERT INTO `example` VALUES (648, '2023-01-30', 'Data for day 30 of last year');
INSERT INTO `example` VALUES (649, '2023-01-31', 'Data for day 31 of last year');
INSERT INTO `example` VALUES (650, '2023-02-01', 'Data for day 32 of last year');
INSERT INTO `example` VALUES (651, '2023-02-02', 'Data for day 33 of last year');
INSERT INTO `example` VALUES (652, '2023-02-03', 'Data for day 34 of last year');
INSERT INTO `example` VALUES (653, '2023-02-04', 'Data for day 35 of last year');
INSERT INTO `example` VALUES (654, '2023-02-05', 'Data for day 36 of last year');
INSERT INTO `example` VALUES (655, '2023-02-06', 'Data for day 37 of last year');
INSERT INTO `example` VALUES (656, '2023-02-07', 'Data for day 38 of last year');
INSERT INTO `example` VALUES (657, '2023-02-08', 'Data for day 39 of last year');
INSERT INTO `example` VALUES (658, '2023-02-09', 'Data for day 40 of last year');
INSERT INTO `example` VALUES (659, '2023-02-10', 'Data for day 41 of last year');
INSERT INTO `example` VALUES (660, '2023-02-11', 'Data for day 42 of last year');
INSERT INTO `example` VALUES (661, '2023-02-12', 'Data for day 43 of last year');
INSERT INTO `example` VALUES (662, '2023-02-13', 'Data for day 44 of last year');
INSERT INTO `example` VALUES (663, '2023-02-14', 'Data for day 45 of last year');
INSERT INTO `example` VALUES (664, '2023-02-15', 'Data for day 46 of last year');
INSERT INTO `example` VALUES (665, '2023-02-16', 'Data for day 47 of last year');
INSERT INTO `example` VALUES (666, '2023-02-17', 'Data for day 48 of last year');
INSERT INTO `example` VALUES (667, '2023-02-18', 'Data for day 49 of last year');
INSERT INTO `example` VALUES (668, '2023-02-19', 'Data for day 50 of last year');
INSERT INTO `example` VALUES (669, '2023-02-20', 'Data for day 51 of last year');
INSERT INTO `example` VALUES (670, '2023-02-21', 'Data for day 52 of last year');
INSERT INTO `example` VALUES (671, '2023-02-22', 'Data for day 53 of last year');
INSERT INTO `example` VALUES (672, '2023-02-23', 'Data for day 54 of last year');
INSERT INTO `example` VALUES (673, '2023-02-24', 'Data for day 55 of last year');
INSERT INTO `example` VALUES (674, '2023-02-25', 'Data for day 56 of last year');
INSERT INTO `example` VALUES (675, '2023-02-26', 'Data for day 57 of last year');
INSERT INTO `example` VALUES (676, '2023-02-27', 'Data for day 58 of last year');
INSERT INTO `example` VALUES (677, '2023-02-28', 'Data for day 59 of last year');
INSERT INTO `example` VALUES (678, '2023-03-01', 'Data for day 60 of last year');
INSERT INTO `example` VALUES (679, '2023-03-02', 'Data for day 61 of last year');
INSERT INTO `example` VALUES (680, '2023-03-03', 'Data for day 62 of last year');
INSERT INTO `example` VALUES (681, '2023-03-04', 'Data for day 63 of last year');
INSERT INTO `example` VALUES (682, '2023-03-05', 'Data for day 64 of last year');
INSERT INTO `example` VALUES (683, '2023-03-06', 'Data for day 65 of last year');
INSERT INTO `example` VALUES (684, '2023-03-07', 'Data for day 66 of last year');
INSERT INTO `example` VALUES (685, '2023-03-08', 'Data for day 67 of last year');
INSERT INTO `example` VALUES (686, '2023-03-09', 'Data for day 68 of last year');
INSERT INTO `example` VALUES (687, '2023-03-10', 'Data for day 69 of last year');
INSERT INTO `example` VALUES (688, '2023-03-11', 'Data for day 70 of last year');
INSERT INTO `example` VALUES (689, '2023-03-12', 'Data for day 71 of last year');
INSERT INTO `example` VALUES (690, '2023-03-13', 'Data for day 72 of last year');
INSERT INTO `example` VALUES (691, '2023-03-14', 'Data for day 73 of last year');
INSERT INTO `example` VALUES (692, '2023-03-15', 'Data for day 74 of last year');
INSERT INTO `example` VALUES (693, '2023-03-16', 'Data for day 75 of last year');
INSERT INTO `example` VALUES (694, '2023-03-17', 'Data for day 76 of last year');
INSERT INTO `example` VALUES (695, '2023-03-18', 'Data for day 77 of last year');
INSERT INTO `example` VALUES (696, '2023-03-19', 'Data for day 78 of last year');
INSERT INTO `example` VALUES (697, '2023-03-20', 'Data for day 79 of last year');
INSERT INTO `example` VALUES (698, '2023-03-21', 'Data for day 80 of last year');
INSERT INTO `example` VALUES (699, '2023-03-22', 'Data for day 81 of last year');
INSERT INTO `example` VALUES (700, '2023-03-23', 'Data for day 82 of last year');
INSERT INTO `example` VALUES (701, '2023-03-24', 'Data for day 83 of last year');
INSERT INTO `example` VALUES (702, '2023-03-25', 'Data for day 84 of last year');
INSERT INTO `example` VALUES (703, '2023-03-26', 'Data for day 85 of last year');
INSERT INTO `example` VALUES (704, '2023-03-27', 'Data for day 86 of last year');
INSERT INTO `example` VALUES (705, '2023-03-28', 'Data for day 87 of last year');
INSERT INTO `example` VALUES (706, '2023-03-29', 'Data for day 88 of last year');
INSERT INTO `example` VALUES (707, '2023-03-30', 'Data for day 89 of last year');
INSERT INTO `example` VALUES (708, '2023-03-31', 'Data for day 90 of last year');
INSERT INTO `example` VALUES (709, '2023-04-01', 'Data for day 91 of last year');
INSERT INTO `example` VALUES (710, '2023-04-02', 'Data for day 92 of last year');
INSERT INTO `example` VALUES (711, '2023-04-03', 'Data for day 93 of last year');
INSERT INTO `example` VALUES (712, '2023-04-04', 'Data for day 94 of last year');
INSERT INTO `example` VALUES (713, '2023-04-05', 'Data for day 95 of last year');
INSERT INTO `example` VALUES (714, '2023-04-06', 'Data for day 96 of last year');
INSERT INTO `example` VALUES (715, '2023-04-07', 'Data for day 97 of last year');
INSERT INTO `example` VALUES (716, '2023-04-08', 'Data for day 98 of last year');
INSERT INTO `example` VALUES (717, '2023-04-09', 'Data for day 99 of last year');
INSERT INTO `example` VALUES (718, '2023-04-10', 'Data for day 100 of last year');
INSERT INTO `example` VALUES (719, '2023-04-11', 'Data for day 101 of last year');
INSERT INTO `example` VALUES (720, '2023-04-12', 'Data for day 102 of last year');
INSERT INTO `example` VALUES (721, '2023-04-13', 'Data for day 103 of last year');
INSERT INTO `example` VALUES (722, '2023-04-14', 'Data for day 104 of last year');
INSERT INTO `example` VALUES (723, '2023-04-15', 'Data for day 105 of last year');
INSERT INTO `example` VALUES (724, '2023-04-16', 'Data for day 106 of last year');
INSERT INTO `example` VALUES (725, '2023-04-17', 'Data for day 107 of last year');
INSERT INTO `example` VALUES (726, '2023-04-18', 'Data for day 108 of last year');
INSERT INTO `example` VALUES (727, '2023-04-19', 'Data for day 109 of last year');
INSERT INTO `example` VALUES (728, '2023-04-20', 'Data for day 110 of last year');
INSERT INTO `example` VALUES (729, '2023-04-21', 'Data for day 111 of last year');
INSERT INTO `example` VALUES (730, '2023-04-22', 'Data for day 112 of last year');
INSERT INTO `example` VALUES (731, '2023-04-23', 'Data for day 113 of last year');
INSERT INTO `example` VALUES (732, '2023-04-24', 'Data for day 114 of last year');
INSERT INTO `example` VALUES (733, '2023-04-25', 'Data for day 115 of last year');
INSERT INTO `example` VALUES (734, '2023-04-26', 'Data for day 116 of last year');
INSERT INTO `example` VALUES (735, '2023-04-27', 'Data for day 117 of last year');
INSERT INTO `example` VALUES (736, '2023-04-28', 'Data for day 118 of last year');
INSERT INTO `example` VALUES (737, '2023-04-29', 'Data for day 119 of last year');
INSERT INTO `example` VALUES (738, '2023-04-30', 'Data for day 120 of last year');
INSERT INTO `example` VALUES (739, '2023-05-01', 'Data for day 121 of last year');
INSERT INTO `example` VALUES (740, '2023-05-02', 'Data for day 122 of last year');
INSERT INTO `example` VALUES (741, '2023-05-03', 'Data for day 123 of last year');
INSERT INTO `example` VALUES (742, '2023-05-04', 'Data for day 124 of last year');
INSERT INTO `example` VALUES (743, '2023-05-05', 'Data for day 125 of last year');
INSERT INTO `example` VALUES (744, '2023-05-06', 'Data for day 126 of last year');
INSERT INTO `example` VALUES (745, '2023-05-07', 'Data for day 127 of last year');
INSERT INTO `example` VALUES (746, '2023-05-08', 'Data for day 128 of last year');
INSERT INTO `example` VALUES (747, '2023-05-09', 'Data for day 129 of last year');
INSERT INTO `example` VALUES (748, '2023-05-10', 'Data for day 130 of last year');
INSERT INTO `example` VALUES (749, '2023-05-11', 'Data for day 131 of last year');
INSERT INTO `example` VALUES (750, '2023-05-12', 'Data for day 132 of last year');
INSERT INTO `example` VALUES (751, '2023-05-13', 'Data for day 133 of last year');
INSERT INTO `example` VALUES (752, '2023-05-14', 'Data for day 134 of last year');
INSERT INTO `example` VALUES (753, '2023-05-15', 'Data for day 135 of last year');
INSERT INTO `example` VALUES (754, '2023-05-16', 'Data for day 136 of last year');
INSERT INTO `example` VALUES (755, '2023-05-17', 'Data for day 137 of last year');
INSERT INTO `example` VALUES (756, '2023-05-18', 'Data for day 138 of last year');
INSERT INTO `example` VALUES (757, '2023-05-19', 'Data for day 139 of last year');
INSERT INTO `example` VALUES (758, '2023-05-20', 'Data for day 140 of last year');
INSERT INTO `example` VALUES (759, '2023-05-21', 'Data for day 141 of last year');
INSERT INTO `example` VALUES (760, '2023-05-22', 'Data for day 142 of last year');
INSERT INTO `example` VALUES (761, '2023-05-23', 'Data for day 143 of last year');
INSERT INTO `example` VALUES (762, '2023-05-24', 'Data for day 144 of last year');
INSERT INTO `example` VALUES (763, '2023-05-25', 'Data for day 145 of last year');
INSERT INTO `example` VALUES (764, '2023-05-26', 'Data for day 146 of last year');
INSERT INTO `example` VALUES (765, '2023-05-27', 'Data for day 147 of last year');
INSERT INTO `example` VALUES (766, '2023-05-28', 'Data for day 148 of last year');
INSERT INTO `example` VALUES (767, '2023-05-29', 'Data for day 149 of last year');
INSERT INTO `example` VALUES (768, '2023-05-30', 'Data for day 150 of last year');
INSERT INTO `example` VALUES (769, '2023-05-31', 'Data for day 151 of last year');
INSERT INTO `example` VALUES (770, '2023-06-01', 'Data for day 152 of last year');
INSERT INTO `example` VALUES (771, '2023-06-02', 'Data for day 153 of last year');
INSERT INTO `example` VALUES (772, '2023-06-03', 'Data for day 154 of last year');
INSERT INTO `example` VALUES (773, '2023-06-04', 'Data for day 155 of last year');
INSERT INTO `example` VALUES (774, '2023-06-05', 'Data for day 156 of last year');
INSERT INTO `example` VALUES (775, '2023-06-06', 'Data for day 157 of last year');
INSERT INTO `example` VALUES (776, '2023-06-07', 'Data for day 158 of last year');
INSERT INTO `example` VALUES (777, '2023-06-08', 'Data for day 159 of last year');
INSERT INTO `example` VALUES (778, '2023-06-09', 'Data for day 160 of last year');
INSERT INTO `example` VALUES (779, '2023-06-10', 'Data for day 161 of last year');
INSERT INTO `example` VALUES (780, '2023-06-11', 'Data for day 162 of last year');
INSERT INTO `example` VALUES (781, '2023-06-12', 'Data for day 163 of last year');
INSERT INTO `example` VALUES (782, '2023-06-13', 'Data for day 164 of last year');
INSERT INTO `example` VALUES (783, '2023-06-14', 'Data for day 165 of last year');
INSERT INTO `example` VALUES (784, '2023-06-15', 'Data for day 166 of last year');
INSERT INTO `example` VALUES (785, '2023-06-16', 'Data for day 167 of last year');
INSERT INTO `example` VALUES (786, '2023-06-17', 'Data for day 168 of last year');
INSERT INTO `example` VALUES (787, '2023-06-18', 'Data for day 169 of last year');
INSERT INTO `example` VALUES (788, '2023-06-19', 'Data for day 170 of last year');
INSERT INTO `example` VALUES (789, '2023-06-20', 'Data for day 171 of last year');
INSERT INTO `example` VALUES (790, '2023-06-21', 'Data for day 172 of last year');
INSERT INTO `example` VALUES (791, '2023-06-22', 'Data for day 173 of last year');
INSERT INTO `example` VALUES (792, '2023-06-23', 'Data for day 174 of last year');
INSERT INTO `example` VALUES (793, '2023-06-24', 'Data for day 175 of last year');
INSERT INTO `example` VALUES (794, '2023-06-25', 'Data for day 176 of last year');
INSERT INTO `example` VALUES (795, '2023-06-26', 'Data for day 177 of last year');
INSERT INTO `example` VALUES (796, '2023-06-27', 'Data for day 178 of last year');
INSERT INTO `example` VALUES (797, '2023-06-28', 'Data for day 179 of last year');
INSERT INTO `example` VALUES (798, '2023-06-29', 'Data for day 180 of last year');
INSERT INTO `example` VALUES (799, '2023-06-30', 'Data for day 181 of last year');
INSERT INTO `example` VALUES (800, '2023-07-01', 'Data for day 182 of last year');
INSERT INTO `example` VALUES (801, '2023-07-02', 'Data for day 183 of last year');
INSERT INTO `example` VALUES (802, '2023-07-03', 'Data for day 184 of last year');
INSERT INTO `example` VALUES (803, '2023-07-04', 'Data for day 185 of last year');
INSERT INTO `example` VALUES (804, '2023-07-05', 'Data for day 186 of last year');
INSERT INTO `example` VALUES (805, '2023-07-06', 'Data for day 187 of last year');
INSERT INTO `example` VALUES (806, '2023-07-07', 'Data for day 188 of last year');
INSERT INTO `example` VALUES (807, '2023-07-08', 'Data for day 189 of last year');
INSERT INTO `example` VALUES (808, '2023-07-09', 'Data for day 190 of last year');
INSERT INTO `example` VALUES (809, '2023-07-10', 'Data for day 191 of last year');
INSERT INTO `example` VALUES (810, '2023-07-11', 'Data for day 192 of last year');
INSERT INTO `example` VALUES (811, '2023-07-12', 'Data for day 193 of last year');
INSERT INTO `example` VALUES (812, '2023-07-13', 'Data for day 194 of last year');
INSERT INTO `example` VALUES (813, '2023-07-14', 'Data for day 195 of last year');
INSERT INTO `example` VALUES (814, '2023-07-15', 'Data for day 196 of last year');
INSERT INTO `example` VALUES (815, '2023-07-16', 'Data for day 197 of last year');
INSERT INTO `example` VALUES (816, '2023-07-17', 'Data for day 198 of last year');
INSERT INTO `example` VALUES (817, '2023-07-18', 'Data for day 199 of last year');
INSERT INTO `example` VALUES (818, '2023-07-19', 'Data for day 200 of last year');
INSERT INTO `example` VALUES (819, '2023-07-20', 'Data for day 201 of last year');
INSERT INTO `example` VALUES (820, '2023-07-21', 'Data for day 202 of last year');
INSERT INTO `example` VALUES (821, '2023-07-22', 'Data for day 203 of last year');
INSERT INTO `example` VALUES (822, '2023-07-23', 'Data for day 204 of last year');
INSERT INTO `example` VALUES (823, '2023-07-24', 'Data for day 205 of last year');
INSERT INTO `example` VALUES (824, '2023-07-25', 'Data for day 206 of last year');
INSERT INTO `example` VALUES (825, '2023-07-26', 'Data for day 207 of last year');
INSERT INTO `example` VALUES (826, '2023-07-27', 'Data for day 208 of last year');
INSERT INTO `example` VALUES (827, '2023-07-28', 'Data for day 209 of last year');
INSERT INTO `example` VALUES (828, '2023-07-29', 'Data for day 210 of last year');
INSERT INTO `example` VALUES (829, '2023-07-30', 'Data for day 211 of last year');
INSERT INTO `example` VALUES (830, '2023-07-31', 'Data for day 212 of last year');
INSERT INTO `example` VALUES (831, '2023-08-01', 'Data for day 213 of last year');
INSERT INTO `example` VALUES (832, '2023-08-02', 'Data for day 214 of last year');
INSERT INTO `example` VALUES (833, '2023-08-03', 'Data for day 215 of last year');
INSERT INTO `example` VALUES (834, '2023-08-04', 'Data for day 216 of last year');
INSERT INTO `example` VALUES (835, '2023-08-05', 'Data for day 217 of last year');
INSERT INTO `example` VALUES (836, '2023-08-06', 'Data for day 218 of last year');
INSERT INTO `example` VALUES (837, '2023-08-07', 'Data for day 219 of last year');
INSERT INTO `example` VALUES (838, '2023-08-08', 'Data for day 220 of last year');
INSERT INTO `example` VALUES (839, '2023-08-09', 'Data for day 221 of last year');
INSERT INTO `example` VALUES (840, '2023-08-10', 'Data for day 222 of last year');
INSERT INTO `example` VALUES (841, '2023-08-11', 'Data for day 223 of last year');
INSERT INTO `example` VALUES (842, '2023-08-12', 'Data for day 224 of last year');
INSERT INTO `example` VALUES (843, '2023-08-13', 'Data for day 225 of last year');
INSERT INTO `example` VALUES (844, '2023-08-14', 'Data for day 226 of last year');
INSERT INTO `example` VALUES (845, '2023-08-15', 'Data for day 227 of last year');
INSERT INTO `example` VALUES (846, '2023-08-16', 'Data for day 228 of last year');
INSERT INTO `example` VALUES (847, '2023-08-17', 'Data for day 229 of last year');
INSERT INTO `example` VALUES (848, '2023-08-18', 'Data for day 230 of last year');
INSERT INTO `example` VALUES (849, '2023-08-19', 'Data for day 231 of last year');
INSERT INTO `example` VALUES (850, '2023-08-20', 'Data for day 232 of last year');
INSERT INTO `example` VALUES (851, '2023-08-21', 'Data for day 233 of last year');
INSERT INTO `example` VALUES (852, '2023-08-22', 'Data for day 234 of last year');
INSERT INTO `example` VALUES (853, '2023-08-23', 'Data for day 235 of last year');
INSERT INTO `example` VALUES (854, '2023-08-24', 'Data for day 236 of last year');
INSERT INTO `example` VALUES (855, '2023-08-25', 'Data for day 237 of last year');
INSERT INTO `example` VALUES (856, '2023-08-26', 'Data for day 238 of last year');
INSERT INTO `example` VALUES (857, '2023-08-27', 'Data for day 239 of last year');
INSERT INTO `example` VALUES (858, '2023-08-28', 'Data for day 240 of last year');
INSERT INTO `example` VALUES (859, '2023-08-29', 'Data for day 241 of last year');
INSERT INTO `example` VALUES (860, '2023-08-30', 'Data for day 242 of last year');
INSERT INTO `example` VALUES (861, '2023-08-31', 'Data for day 243 of last year');
INSERT INTO `example` VALUES (862, '2023-09-01', 'Data for day 244 of last year');
INSERT INTO `example` VALUES (863, '2023-09-02', 'Data for day 245 of last year');
INSERT INTO `example` VALUES (864, '2023-09-03', 'Data for day 246 of last year');
INSERT INTO `example` VALUES (865, '2023-09-04', 'Data for day 247 of last year');
INSERT INTO `example` VALUES (866, '2023-09-05', 'Data for day 248 of last year');
INSERT INTO `example` VALUES (867, '2023-09-06', 'Data for day 249 of last year');
INSERT INTO `example` VALUES (868, '2023-09-07', 'Data for day 250 of last year');
INSERT INTO `example` VALUES (869, '2023-09-08', 'Data for day 251 of last year');
INSERT INTO `example` VALUES (870, '2023-09-09', 'Data for day 252 of last year');
INSERT INTO `example` VALUES (871, '2023-09-10', 'Data for day 253 of last year');
INSERT INTO `example` VALUES (872, '2023-09-11', 'Data for day 254 of last year');
INSERT INTO `example` VALUES (873, '2023-09-12', 'Data for day 255 of last year');
INSERT INTO `example` VALUES (874, '2023-09-13', 'Data for day 256 of last year');
INSERT INTO `example` VALUES (875, '2023-09-14', 'Data for day 257 of last year');
INSERT INTO `example` VALUES (876, '2023-09-15', 'Data for day 258 of last year');
INSERT INTO `example` VALUES (877, '2023-09-16', 'Data for day 259 of last year');
INSERT INTO `example` VALUES (878, '2023-09-17', 'Data for day 260 of last year');
INSERT INTO `example` VALUES (879, '2023-09-18', 'Data for day 261 of last year');
INSERT INTO `example` VALUES (880, '2023-09-19', 'Data for day 262 of last year');
INSERT INTO `example` VALUES (881, '2023-09-20', 'Data for day 263 of last year');
INSERT INTO `example` VALUES (882, '2023-09-21', 'Data for day 264 of last year');
INSERT INTO `example` VALUES (883, '2023-09-22', 'Data for day 265 of last year');
INSERT INTO `example` VALUES (884, '2023-09-23', 'Data for day 266 of last year');
INSERT INTO `example` VALUES (885, '2023-09-24', 'Data for day 267 of last year');
INSERT INTO `example` VALUES (886, '2023-09-25', 'Data for day 268 of last year');
INSERT INTO `example` VALUES (887, '2023-09-26', 'Data for day 269 of last year');
INSERT INTO `example` VALUES (888, '2023-09-27', 'Data for day 270 of last year');
INSERT INTO `example` VALUES (889, '2023-09-28', 'Data for day 271 of last year');
INSERT INTO `example` VALUES (890, '2023-09-29', 'Data for day 272 of last year');
INSERT INTO `example` VALUES (891, '2023-09-30', 'Data for day 273 of last year');
INSERT INTO `example` VALUES (892, '2023-10-01', 'Data for day 274 of last year');
INSERT INTO `example` VALUES (893, '2023-10-02', 'Data for day 275 of last year');
INSERT INTO `example` VALUES (894, '2023-10-03', 'Data for day 276 of last year');
INSERT INTO `example` VALUES (895, '2023-10-04', 'Data for day 277 of last year');
INSERT INTO `example` VALUES (896, '2023-10-05', 'Data for day 278 of last year');
INSERT INTO `example` VALUES (897, '2023-10-06', 'Data for day 279 of last year');
INSERT INTO `example` VALUES (898, '2023-10-07', 'Data for day 280 of last year');
INSERT INTO `example` VALUES (899, '2023-10-08', 'Data for day 281 of last year');
INSERT INTO `example` VALUES (900, '2023-10-09', 'Data for day 282 of last year');
INSERT INTO `example` VALUES (901, '2023-10-10', 'Data for day 283 of last year');
INSERT INTO `example` VALUES (902, '2023-10-11', 'Data for day 284 of last year');
INSERT INTO `example` VALUES (903, '2023-10-12', 'Data for day 285 of last year');
INSERT INTO `example` VALUES (904, '2023-10-13', 'Data for day 286 of last year');
INSERT INTO `example` VALUES (905, '2023-10-14', 'Data for day 287 of last year');
INSERT INTO `example` VALUES (906, '2023-10-15', 'Data for day 288 of last year');
INSERT INTO `example` VALUES (907, '2023-10-16', 'Data for day 289 of last year');
INSERT INTO `example` VALUES (908, '2023-10-17', 'Data for day 290 of last year');
INSERT INTO `example` VALUES (909, '2023-10-18', 'Data for day 291 of last year');
INSERT INTO `example` VALUES (910, '2023-10-19', 'Data for day 292 of last year');
INSERT INTO `example` VALUES (911, '2023-10-20', 'Data for day 293 of last year');
INSERT INTO `example` VALUES (912, '2023-10-21', 'Data for day 294 of last year');
INSERT INTO `example` VALUES (913, '2023-10-22', 'Data for day 295 of last year');
INSERT INTO `example` VALUES (914, '2023-10-23', 'Data for day 296 of last year');
INSERT INTO `example` VALUES (915, '2023-10-24', 'Data for day 297 of last year');
INSERT INTO `example` VALUES (916, '2023-10-25', 'Data for day 298 of last year');
INSERT INTO `example` VALUES (917, '2023-10-26', 'Data for day 299 of last year');
INSERT INTO `example` VALUES (918, '2023-10-27', 'Data for day 300 of last year');
INSERT INTO `example` VALUES (919, '2023-10-28', 'Data for day 301 of last year');
INSERT INTO `example` VALUES (920, '2023-10-29', 'Data for day 302 of last year');
INSERT INTO `example` VALUES (921, '2023-10-30', 'Data for day 303 of last year');
INSERT INTO `example` VALUES (922, '2023-10-31', 'Data for day 304 of last year');
INSERT INTO `example` VALUES (923, '2023-11-01', 'Data for day 305 of last year');
INSERT INTO `example` VALUES (924, '2023-11-02', 'Data for day 306 of last year');
INSERT INTO `example` VALUES (925, '2023-11-03', 'Data for day 307 of last year');
INSERT INTO `example` VALUES (926, '2023-11-04', 'Data for day 308 of last year');
INSERT INTO `example` VALUES (927, '2023-11-05', 'Data for day 309 of last year');
INSERT INTO `example` VALUES (928, '2023-11-06', 'Data for day 310 of last year');
INSERT INTO `example` VALUES (929, '2023-11-07', 'Data for day 311 of last year');
INSERT INTO `example` VALUES (930, '2023-11-08', 'Data for day 312 of last year');
INSERT INTO `example` VALUES (931, '2023-11-09', 'Data for day 313 of last year');
INSERT INTO `example` VALUES (932, '2023-11-10', 'Data for day 314 of last year');
INSERT INTO `example` VALUES (933, '2023-11-11', 'Data for day 315 of last year');
INSERT INTO `example` VALUES (934, '2023-11-12', 'Data for day 316 of last year');
INSERT INTO `example` VALUES (935, '2023-11-13', 'Data for day 317 of last year');
INSERT INTO `example` VALUES (936, '2023-11-14', 'Data for day 318 of last year');
INSERT INTO `example` VALUES (937, '2023-11-15', 'Data for day 319 of last year');
INSERT INTO `example` VALUES (938, '2023-11-16', 'Data for day 320 of last year');
INSERT INTO `example` VALUES (939, '2023-11-17', 'Data for day 321 of last year');
INSERT INTO `example` VALUES (940, '2023-11-18', 'Data for day 322 of last year');
INSERT INTO `example` VALUES (941, '2023-11-19', 'Data for day 323 of last year');
INSERT INTO `example` VALUES (942, '2023-11-20', 'Data for day 324 of last year');
INSERT INTO `example` VALUES (943, '2023-11-21', 'Data for day 325 of last year');
INSERT INTO `example` VALUES (944, '2023-11-22', 'Data for day 326 of last year');
INSERT INTO `example` VALUES (945, '2023-11-23', 'Data for day 327 of last year');
INSERT INTO `example` VALUES (946, '2023-11-24', 'Data for day 328 of last year');
INSERT INTO `example` VALUES (947, '2023-11-25', 'Data for day 329 of last year');
INSERT INTO `example` VALUES (948, '2023-11-26', 'Data for day 330 of last year');
INSERT INTO `example` VALUES (949, '2023-11-27', 'Data for day 331 of last year');
INSERT INTO `example` VALUES (950, '2023-11-28', 'Data for day 332 of last year');
INSERT INTO `example` VALUES (951, '2023-11-29', 'Data for day 333 of last year');
INSERT INTO `example` VALUES (952, '2023-11-30', 'Data for day 334 of last year');
INSERT INTO `example` VALUES (953, '2023-12-01', 'Data for day 335 of last year');
INSERT INTO `example` VALUES (954, '2023-12-02', 'Data for day 336 of last year');
INSERT INTO `example` VALUES (955, '2023-12-03', 'Data for day 337 of last year');
INSERT INTO `example` VALUES (956, '2023-12-04', 'Data for day 338 of last year');
INSERT INTO `example` VALUES (957, '2023-12-05', 'Data for day 339 of last year');
INSERT INTO `example` VALUES (958, '2023-12-06', 'Data for day 340 of last year');
INSERT INTO `example` VALUES (959, '2023-12-07', 'Data for day 341 of last year');
INSERT INTO `example` VALUES (960, '2023-12-08', 'Data for day 342 of last year');
INSERT INTO `example` VALUES (961, '2023-12-09', 'Data for day 343 of last year');
INSERT INTO `example` VALUES (962, '2023-12-10', 'Data for day 344 of last year');
INSERT INTO `example` VALUES (963, '2023-12-11', 'Data for day 345 of last year');
INSERT INTO `example` VALUES (964, '2023-12-12', 'Data for day 346 of last year');
INSERT INTO `example` VALUES (965, '2023-12-13', 'Data for day 347 of last year');
INSERT INTO `example` VALUES (966, '2023-12-14', 'Data for day 348 of last year');
INSERT INTO `example` VALUES (967, '2023-12-15', 'Data for day 349 of last year');
INSERT INTO `example` VALUES (968, '2023-12-16', 'Data for day 350 of last year');
INSERT INTO `example` VALUES (969, '2023-12-17', 'Data for day 351 of last year');
INSERT INTO `example` VALUES (970, '2023-12-18', 'Data for day 352 of last year');
INSERT INTO `example` VALUES (971, '2023-12-19', 'Data for day 353 of last year');
INSERT INTO `example` VALUES (972, '2023-12-20', 'Data for day 354 of last year');
INSERT INTO `example` VALUES (973, '2023-12-21', 'Data for day 355 of last year');
INSERT INTO `example` VALUES (974, '2023-12-22', 'Data for day 356 of last year');
INSERT INTO `example` VALUES (975, '2023-12-23', 'Data for day 357 of last year');
INSERT INTO `example` VALUES (976, '2023-12-24', 'Data for day 358 of last year');
INSERT INTO `example` VALUES (977, '2023-12-25', 'Data for day 359 of last year');
INSERT INTO `example` VALUES (978, '2023-12-26', 'Data for day 360 of last year');
INSERT INTO `example` VALUES (979, '2023-12-27', 'Data for day 361 of last year');
INSERT INTO `example` VALUES (980, '2023-12-28', 'Data for day 362 of last year');
INSERT INTO `example` VALUES (981, '2023-12-29', 'Data for day 363 of last year');
INSERT INTO `example` VALUES (982, '2023-12-30', 'Data for day 364 of last year');
INSERT INTO `example` VALUES (983, '2023-12-31', 'Data for day 365 of last year');

SET FOREIGN_KEY_CHECKS = 1;

完结~~ 撒花~~
在这里插入图片描述

您的点赞和留言是我前进的动力和支持,也是我不断进步的关键。
如果您觉得我的文章有价值,请不要吝啬您的赞和留言哦!
  • 3
    点赞
  • 8
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值