mysql5.7计算环比增长率

已于 2024-03-26 10:10:51 修改
阅读量365 收藏 8
点赞数 7
分类专栏： 数据库 文章标签： mysql
于 2024-03-25 12:20:24 首次发布
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_44505204/article/details/137010366
版权

在数据统计中我们经常会进行一些数据统计其中比较常见的就有环比增长率（例如我们想要计算每月营销金额的环比增长率   （本月销售金额-上月销售金额）/上月销售金额）

脚本准备

CREATE TABLE `sales_data` (
  `product_id` int(11) DEFAULT NULL,
  `sale_date` date DEFAULT NULL,
  `sale_amount` decimal(10,2) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (539, '2024-03-21', 523.79);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (171, '2024-03-20', 854.48);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (419, '2024-03-20', 24.47);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (840, '2024-03-11', 33.43);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (644, '2024-03-09', 860.50);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (272, '2024-02-25', 732.64);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (305, '2024-02-16', 356.57);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (686, '2024-02-11', 681.56);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (69, '2023-12-25', 231.61);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (529, '2023-12-23', 891.63);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (702, '2023-12-06', 132.29);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (111, '2023-11-23', 997.80);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (37, '2023-11-22', 222.73);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (234, '2023-11-22', 545.93);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (577, '2023-10-21', 211.81);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (621, '2023-10-12', 576.51);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (729, '2023-10-12', 721.71);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (813, '2023-10-08', 578.87);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (96, '2023-10-08', 318.78);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (303, '2023-09-21', 115.39);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (705, '2023-08-27', 845.84);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (396, '2023-08-25', 853.14);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (157, '2023-08-12', 881.98);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (276, '2023-08-09', 958.11);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (546, '2023-08-09', 647.88);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (629, '2023-08-02', 251.19);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (840, '2023-08-01', 401.74);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (970, '2023-07-28', 224.49);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (431, '2023-07-12', 641.73);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (359, '2023-06-28', 974.85);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (519, '2023-06-23', 177.86);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (289, '2023-06-02', 905.70);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (987, '2023-05-23', 427.71);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (903, '2023-05-16', 63.30);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (518, '2023-05-13', 604.79);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (706, '2023-05-06', 674.24);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (839, '2023-05-01', 902.68);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (450, '2023-04-30', 74.00);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (696, '2023-04-08', 226.85);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (121, '2023-02-23', 163.60);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (544, '2023-02-19', 149.70);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (60, '2023-02-14', 979.89);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (487, '2023-02-06', 682.31);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (967, '2023-01-27', 532.48);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (834, '2023-01-14', 549.47);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (733, '2023-01-04', 663.23);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (856, '2022-12-28', 631.87);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (13, '2022-12-28', 684.95);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (903, '2022-12-22', 616.03);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (468, '2022-12-18', 256.78);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (166, '2022-12-02', 131.70);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (696, '2022-11-09', 372.47);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (952, '2022-11-08', 704.24);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (357, '2022-10-28', 823.51);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (704, '2022-10-13', 669.97);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (36, '2022-10-11', 689.05);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (968, '2022-09-25', 808.00);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (625, '2022-09-24', 998.31);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (174, '2022-09-13', 133.15);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (484, '2022-09-03', 117.42);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (233, '2022-08-30', 886.02);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (19, '2022-08-11', 301.20);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (756, '2022-08-04', 691.03);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (272, '2022-07-28', 55.56);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (148, '2022-07-23', 768.14);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (798, '2022-06-21', 41.07);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (522, '2022-06-19', 105.16);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (518, '2022-05-25', 160.96);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (782, '2022-05-24', 427.85);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (801, '2022-05-21', 914.49);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (583, '2022-05-19', 248.88);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (88, '2022-05-03', 285.30);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (171, '2022-04-26', 992.54);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (293, '2022-04-18', 709.20);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (315, '2022-04-11', 734.69);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (635, '2022-04-03', 671.18);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (141, '2022-03-20', 274.09);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (167, '2022-03-13', 409.04);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (495, '2022-03-12', 59.55);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (452, '2022-03-08', 454.75);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (304, '2022-02-15', 906.91);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (925, '2022-02-13', 563.30);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (624, '2022-02-05', 384.91);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (807, '2022-01-09', 521.43);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (149, '2022-01-08', 912.76);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (579, '2022-01-03', 290.20);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (540, '2021-12-29', 853.59);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (420, '2021-12-24', 743.98);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (909, '2021-12-08', 42.77);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (597, '2021-12-05', 417.51);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (505, '2021-11-28', 42.13);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (618, '2021-11-23', 204.47);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (136, '2021-11-22', 597.54);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (840, '2021-11-21', 425.33);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (68, '2021-10-13', 344.07);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (154, '2021-10-08', 878.86);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (693, '2021-09-29', 494.54);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (539, '2021-09-15', 715.55);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (637, '2021-09-10', 225.71);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (636, '2021-09-08', 310.30);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (559, '2021-09-06', 12.50);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (765, '2021-09-02', 770.29);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (551, '2021-08-22', 616.21);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (23, '2021-08-18', 398.82);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (576, '2021-08-11', 666.51);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (62, '2021-08-06', 294.03);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (222, '2021-06-25', 250.46);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (494, '2021-06-06', 568.68);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (208, '2021-05-26', 405.59);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (652, '2021-05-22', 306.61);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (987, '2021-05-08', 596.77);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (80, '2021-05-05', 923.04);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (795, '2021-04-17', 431.74);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (988, '2021-04-14', 697.09);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (735, '2021-04-10', 895.41);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (114, '2021-03-29', 238.62);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (227, '2021-01-23', 23.77);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (710, '2021-01-08', 996.28);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (670, '2020-12-19', 458.98);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (513, '2020-12-15', 312.46);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (877, '2020-12-12', 526.51);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (96, '2020-11-29', 266.58);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (957, '2020-11-21', 230.02);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (160, '2020-11-17', 558.75);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (647, '2020-11-11', 594.13);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (188, '2020-10-18', 746.40);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (318, '2020-10-11', 746.74);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (782, '2020-10-01', 440.94);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (731, '2020-09-30', 771.76);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (162, '2020-09-21', 395.73);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (549, '2020-09-11', 400.03);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (793, '2020-09-04', 305.18);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (989, '2020-08-29', 193.76);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (619, '2020-08-12', 346.03);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (798, '2020-08-02', 648.24);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (238, '2020-07-28', 605.23);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (885, '2020-07-24', 561.68);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (137, '2020-07-07', 437.38);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (958, '2020-06-25', 579.50);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (174, '2020-06-23', 303.40);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (690, '2020-06-22', 601.18);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (479, '2020-06-14', 11.43);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (605, '2020-06-11', 221.37);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (734, '2020-06-08', 173.68);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (948, '2020-05-29', 300.87);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (336, '2020-05-14', 410.94);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (334, '2020-04-29', 599.95);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (207, '2020-04-27', 84.11);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (418, '2020-04-24', 495.09);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (649, '2020-04-08', 458.17);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (233, '2020-04-08', 937.63);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (126, '2020-04-07', 323.94);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (230, '2020-04-03', 12.26);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (9, '2020-03-25', 999.44);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (913, '2020-03-18', 923.82);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (932, '2020-03-02', 147.94);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (758, '2020-02-25', 513.06);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (690, '2020-02-18', 592.87);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (732, '2020-02-16', 677.54);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (840, '2020-02-08', 146.01);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (544, '2020-02-06', 370.97);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (251, '2020-02-03', 107.10);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (362, '2020-01-19', 174.64);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (413, '2020-01-18', 47.00);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (804, '2020-01-16', 173.28);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (280, '2019-12-31', 308.72);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (575, '2019-12-27', 234.63);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (107, '2019-12-11', 416.94);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (216, '2019-11-10', 658.29);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (506, '2019-10-31', 265.59);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (341, '2019-10-26', 469.13);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (31, '2019-10-26', 554.82);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (399, '2019-10-25', 673.81);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (722, '2019-10-21', 760.44);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (408, '2019-10-08', 183.20);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (828, '2019-09-27', 858.38);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (905, '2019-09-23', 67.23);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (859, '2019-09-11', 969.74);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (969, '2019-09-10', 980.91);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (926, '2019-09-06', 713.41);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (337, '2019-08-25', 774.03);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (492, '2019-08-23', 244.52);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (620, '2019-08-18', 596.12);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (716, '2019-07-12', 944.37);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (608, '2019-07-11', 740.02);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (666, '2019-07-11', 867.93);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (723, '2019-07-08', 157.14);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (784, '2019-07-05', 245.70);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (89, '2019-06-28', 496.40);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (257, '2019-06-27', 703.10);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (736, '2019-06-25', 935.38);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (270, '2019-06-19', 206.78);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (623, '2019-06-09', 536.59);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (569, '2019-06-01', 330.41);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (815, '2019-05-31', 322.21);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (885, '2019-05-27', 739.23);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (30, '2019-05-23', 818.15);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (162, '2019-05-09', 620.64);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (865, '2019-04-30', 635.14);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (477, '2019-04-09', 674.49);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (786, '2019-03-26', 722.10);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (615, '2019-03-09', 446.62);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (332, '2019-03-03', 350.84);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (520, '2019-03-02', 703.06);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (306, '2019-02-23', 199.57);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (354, '2019-02-11', 552.78);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (998, '2019-01-16', 79.52);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (949, '2019-01-15', 525.69);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (626, '2019-01-04', 189.42);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (206, '2018-12-24', 578.37);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (996, '2018-12-22', 51.37);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (136, '2018-12-21', 230.00);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (956, '2018-12-17', 368.97);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (578, '2018-12-11', 136.84);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (84, '2018-12-06', 909.97);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (430, '2018-12-01', 699.83);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (213, '2018-11-15', 944.26);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (372, '2018-11-14', 378.57);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (466, '2018-11-10', 931.63);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (432, '2018-11-08', 453.10);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (373, '2018-11-06', 423.72);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (248, '2018-11-05', 385.60);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (867, '2018-10-30', 101.19);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (971, '2018-10-23', 517.19);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (606, '2018-10-19', 56.57);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (752, '2018-10-15', 4.06);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (105, '2018-10-01', 721.51);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (205, '2018-09-24', 562.74);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (109, '2018-09-18', 678.31);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (863, '2018-09-06', 418.98);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (277, '2018-09-01', 159.31);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (222, '2018-08-08', 66.55);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (939, '2018-07-31', 587.32);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (677, '2018-07-27', 991.55);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (888, '2018-07-19', 313.63);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (412, '2018-07-13', 515.77);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (152, '2018-07-02', 407.22);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (268, '2018-05-25', 278.85);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (790, '2018-05-22', 532.26);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (497, '2018-05-16', 185.23);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (914, '2018-05-09', 227.70);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (962, '2018-04-27', 725.26);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (556, '2018-04-12', 597.99);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (60, '2018-03-03', 737.45);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (757, '2018-03-02', 191.49);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (438, '2018-02-28', 15.54);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (409, '2018-01-30', 248.17);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (963, '2018-01-30', 739.40);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (207, '2018-01-28', 186.08);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (269, '2018-01-23', 617.76);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (871, '2018-01-10', 811.14);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (941, '2018-01-04', 95.76);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (485, '2017-12-29', 635.54);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (392, '2017-12-28', 155.29);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (968, '2017-12-24', 939.20);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (94, '2017-12-02', 280.07);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (675, '2017-11-24', 373.66);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (781, '2017-11-21', 307.81);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (367, '2017-10-26', 866.17);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (88, '2017-10-12', 151.53);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (293, '2017-10-09', 990.80);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (847, '2017-10-04', 928.77);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (97, '2017-10-01', 422.39);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (947, '2017-09-03', 84.94);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (924, '2017-08-28', 906.46);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (944, '2017-08-11', 248.80);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (951, '2017-08-10', 932.24);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (546, '2017-08-01', 570.66);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (619, '2017-07-08', 868.53);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (688, '2017-06-12', 491.72);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (129, '2017-05-31', 580.79);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (189, '2017-05-28', 392.86);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (854, '2017-05-26', 923.37);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (581, '2017-05-10', 57.32);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (321, '2017-05-10', 513.83);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (894, '2017-05-03', 972.26);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (746, '2017-04-01', 374.00);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (122, '2017-03-24', 352.48);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (673, '2017-03-14', 772.20);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (622, '2017-03-11', 446.30);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (679, '2017-03-06', 182.92);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (183, '2017-03-03', 111.82);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (406, '2017-02-24', 747.90);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (570, '2017-02-19', 495.93);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (37, '2017-02-16', 893.57);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (77, '2017-02-16', 966.65);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (134, '2017-02-12', 243.49);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (896, '2017-02-06', 122.82);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (868, '2017-02-06', 749.09);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (895, '2017-01-28', 343.17);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (533, '2017-01-24', 602.59);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (918, '2017-01-19', 520.98);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (654, '2017-01-17', 509.98);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (210, '2017-01-12', 399.54);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (802, '2017-01-11', 398.01);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (256, '2016-12-28', 362.66);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (815, '2016-12-21', 759.17);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (975, '2016-12-16', 680.53);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (745, '2016-12-11', 216.93);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (643, '2016-11-24', 74.48);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (442, '2016-11-12', 942.81);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (130, '2016-11-11', 323.64);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (248, '2016-11-10', 37.27);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (340, '2016-11-03', 858.82);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (239, '2016-10-29', 55.92);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (306, '2016-10-25', 982.92);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (272, '2016-10-18', 967.49);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (196, '2016-10-13', 713.05);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (800, '2016-09-28', 701.73);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (130, '2016-09-26', 531.20);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (865, '2016-09-18', 829.81);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (414, '2016-08-26', 136.92);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (507, '2016-08-24', 829.77);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (870, '2016-08-15', 249.74);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (575, '2016-08-12', 815.92);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (980, '2016-07-22', 150.15);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (336, '2016-05-27', 641.91);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (334, '2016-05-21', 804.18);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (282, '2016-05-13', 63.51);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (336, '2016-05-06', 109.86);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (304, '2016-04-30', 561.80);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (914, '2016-03-27', 236.77);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (867, '2016-03-23', 743.52);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (660, '2016-03-05', 579.90);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (907, '2016-02-26', 651.72);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (523, '2016-02-21', 315.86);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (394, '2016-02-20', 578.04);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (607, '2016-02-01', 909.57);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (850, '2016-01-15', 844.85);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (780, '2016-01-12', 474.59);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (201, '2016-01-10', 405.25);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (847, '2016-01-05', 696.17);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (937, '2015-12-30', 474.47);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (15, '2015-12-24', 608.39);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (539, '2015-12-21', 418.71);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (146, '2015-12-18', 813.51);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (583, '2015-12-13', 599.95);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (388, '2015-11-13', 793.83);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (814, '2015-11-13', 388.45);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (178, '2015-11-10', 366.98);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (279, '2015-11-10', 421.64);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (635, '2015-10-16', 449.29);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (921, '2015-10-10', 517.34);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (438, '2015-10-06', 361.10);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (415, '2015-10-06', 964.79);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (386, '2015-09-23', 172.58);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (563, '2015-09-14', 73.47);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (146, '2015-09-11', 49.16);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (358, '2015-09-10', 735.50);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (614, '2015-09-04', 766.21);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (72, '2015-08-19', 456.33);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (545, '2015-08-14', 3.83);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (210, '2015-08-07', 575.21);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (915, '2015-08-06', 816.49);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (291, '2015-08-03', 492.62);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (197, '2015-07-17', 321.83);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (111, '2015-07-13', 697.08);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (905, '2015-07-06', 379.48);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (955, '2015-07-04', 9.93);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (783, '2015-06-18', 328.46);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (144, '2015-05-26', 964.42);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (877, '2015-05-09', 777.48);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (802, '2015-04-19', 889.32);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (22, '2015-04-04', 362.29);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (51, '2015-03-17', 514.64);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (196, '2015-03-02', 514.76);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (705, '2015-02-26', 156.53);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (707, '2015-02-14', 0.99);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (789, '2015-02-05', 222.25);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (146, '2015-01-26', 685.91);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (301, '2015-01-09', 494.71);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (924, '2014-12-30', 295.30);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (193, '2014-12-25', 683.58);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (917, '2014-12-25', 317.26);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (160, '2014-12-17', 949.88);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (367, '2014-12-13', 640.65);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (602, '2014-12-12', 615.01);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (237, '2014-11-20', 977.08);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (882, '2014-11-04', 496.83);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (34, '2014-11-01', 610.14);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (129, '2014-10-24', 906.19);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (293, '2014-10-24', 776.65);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (143, '2014-10-24', 343.10);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (30, '2014-10-09', 872.32);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (299, '2014-10-06', 423.91);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (215, '2014-09-14', 302.29);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (717, '2014-09-06', 350.20);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (7, '2014-09-01', 693.49);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (960, '2014-08-22', 153.51);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (985, '2014-08-16', 165.54);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (965, '2014-08-07', 679.67);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (467, '2014-08-04', 180.14);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (666, '2014-07-27', 418.24);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (981, '2014-07-08', 205.25);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (784, '2014-07-07', 772.56);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (649, '2014-07-03', 40.76);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (43, '2014-07-03', 626.08);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (829, '2014-06-28', 99.15);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (967, '2014-06-26', 768.48);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (226, '2014-06-19', 226.94);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (119, '2014-06-14', 545.06);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (118, '2014-06-01', 872.09);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (584, '2014-05-28', 584.97);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (897, '2014-05-16', 494.10);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (72, '2014-04-30', 231.84);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (918, '2014-04-26', 30.30);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (158, '2014-04-25', 449.79);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (142, '2014-04-14', 679.14);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (744, '2014-04-03', 729.32);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (906, '2014-03-25', 605.22);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (904, '2014-03-19', 424.09);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (88, '2014-03-17', 10.21);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (16, '2014-03-16', 153.82);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (92, '2014-03-14', 787.17);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (465, '2014-03-05', 63.16);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (305, '2014-03-04', 259.69);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (725, '2014-02-12', 441.89);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (573, '2014-02-10', 75.40);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (788, '2014-02-02', 423.41);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (929, '2014-01-29', 348.83);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (807, '2013-12-29', 471.81);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (606, '2013-12-24', 131.80);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (44, '2013-12-11', 363.29);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (618, '2013-12-03', 865.55);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (670, '2013-12-01', 388.14);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (669, '2013-11-27', 306.39);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (313, '2013-11-12', 903.41);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (792, '2013-10-22', 254.24);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (395, '2013-10-16', 573.09);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (447, '2013-10-01', 220.01);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (233, '2013-09-04', 769.63);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (394, '2013-08-22', 850.02);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (853, '2013-08-17', 512.18);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (655, '2013-08-10', 129.81);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (25, '2013-08-05', 869.49);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (420, '2013-08-04', 928.05);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (441, '2013-07-19', 803.62);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (617, '2013-07-15', 289.74);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (65, '2013-07-11', 339.35);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (675, '2013-06-15', 871.38);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (588, '2013-06-10', 73.77);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (750, '2013-06-01', 98.73);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (168, '2013-05-30', 562.33);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (476, '2013-05-30', 93.09);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (7, '2013-05-16', 891.24);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (866, '2013-05-10', 105.43);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (581, '2013-05-10', 205.70);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (685, '2013-05-10', 548.09);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (28, '2013-05-04', 876.85);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (620, '2013-04-25', 912.53);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (563, '2013-04-21', 539.56);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (231, '2013-04-19', 644.99);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (497, '2013-04-18', 746.60);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (202, '2013-04-09', 99.35);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (440, '2013-03-25', 138.81);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (490, '2013-03-17', 21.50);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (458, '2013-03-01', 703.63);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (951, '2013-02-20', 910.65);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (652, '2013-02-19', 768.86);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (365, '2013-02-13', 554.39);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (469, '2013-01-30', 444.62);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (201, '2013-01-18', 881.48);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (324, '2013-01-10', 799.64);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (414, '2012-11-29', 61.41);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (350, '2012-11-22', 688.62);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (147, '2012-11-13', 468.81);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (564, '2012-11-06', 116.40);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (664, '2012-10-24', 786.10);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (230, '2012-10-24', 709.52);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (868, '2012-10-09', 109.19);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (700, '2012-10-08', 672.79);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (308, '2012-10-06', 487.24);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (382, '2012-09-26', 856.86);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (773, '2012-09-25', 654.52);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (890, '2012-09-21', 270.09);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (877, '2012-09-11', 879.86);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (593, '2012-09-10', 618.24);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (559, '2012-08-26', 101.77);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (250, '2012-08-14', 658.91);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (751, '2012-08-13', 909.46);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (978, '2012-08-10', 746.32);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (272, '2012-08-08', 819.51);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (958, '2012-07-21', 391.24);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (410, '2012-07-21', 930.29);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (71, '2012-06-28', 229.70);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (197, '2012-06-19', 451.47);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (26, '2012-06-14', 524.53);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (842, '2012-06-06', 508.32);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (279, '2012-05-17', 829.45);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (83, '2012-05-08', 817.48);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (875, '2012-05-01', 705.75);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (384, '2012-04-08', 242.62);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (992, '2012-03-25', 254.63);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (866, '2012-03-06', 814.78);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (612, '2012-02-27', 245.07);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (45, '2012-02-24', 426.69);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (845, '2012-02-16', 718.29);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (24, '2012-01-30', 137.20);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (577, '2012-01-13', 387.83);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (161, '2012-01-12', 308.91);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (995, '2012-01-01', 897.54);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (33, '2011-12-25', 179.78);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (822, '2011-12-02', 180.26);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (150, '2011-11-15', 284.28);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (980, '2011-11-11', 44.61);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (898, '2011-11-04', 855.50);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (406, '2011-11-03', 291.49);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (552, '2011-10-16', 209.06);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (960, '2011-10-15', 0.27);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (800, '2011-09-30', 91.42);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (646, '2011-08-27', 704.86);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (529, '2011-08-20', 712.68);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (212, '2011-07-26', 123.86);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (367, '2011-07-25', 312.40);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (824, '2011-07-23', 21.26);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (555, '2011-07-21', 342.49);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (76, '2011-07-19', 934.33);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (553, '2011-07-05', 680.21);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (93, '2011-06-26', 477.40);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (803, '2011-06-23', 752.40);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (667, '2011-06-21', 952.54);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (5, '2011-06-19', 76.96);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (259, '2011-06-14', 750.01);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (237, '2011-06-13', 99.74);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (182, '2011-06-09', 85.46);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (258, '2011-06-05', 406.20);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (413, '2011-05-28', 626.54);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (412, '2011-05-22', 377.72);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (672, '2011-05-10', 887.09);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (659, '2011-04-26', 487.41);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (696, '2011-04-19', 381.37);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (166, '2011-04-18', 701.36);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (172, '2011-04-13', 849.23);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (545, '2011-03-15', 591.05);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (971, '2011-03-10', 96.99);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (19, '2011-03-04', 612.74);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (219, '2011-03-01', 646.48);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (57, '2011-02-25', 214.68);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (774, '2011-02-08', 537.50);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (731, '2011-02-05', 56.35);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (857, '2011-02-02', 857.35);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (158, '2011-01-22', 913.24);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (258, '2011-01-22', 927.88);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (832, '2011-01-01', 635.69);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (754, '2010-12-28', 668.63);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (618, '2010-12-10', 606.84);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (84, '2010-12-09', 344.81);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (73, '2010-12-07', 486.70);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (543, '2010-11-26', 448.90);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (187, '2010-11-06', 918.48);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (510, '2010-09-13', 396.18);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (170, '2010-09-05', 582.87);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (462, '2010-08-09', 131.66);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (628, '2010-08-04', 600.57);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (26, '2010-08-03', 225.46);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (509, '2010-07-26', 87.60);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (682, '2010-07-26', 31.04);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (895, '2010-07-24', 821.19);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (219, '2010-07-23', 11.28);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (771, '2010-07-20', 950.74);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (718, '2010-07-18', 459.85);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (768, '2010-07-15', 879.98);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (462, '2010-07-13', 551.29);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (753, '2010-07-07', 824.86);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (189, '2010-07-01', 687.92);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (696, '2010-06-25', 395.41);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (191, '2010-06-24', 936.69);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (876, '2010-06-22', 175.13);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (821, '2010-06-21', 499.62);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (146, '2010-06-18', 383.73);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (767, '2010-06-14', 897.88);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (548, '2010-06-06', 441.83);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (292, '2010-05-26', 907.84);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (869, '2010-04-16', 479.50);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (678, '2010-04-14', 731.51);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (253, '2010-04-08', 137.70);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (744, '2010-04-04', 854.69);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (440, '2010-03-21', 190.51);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (678, '2010-03-13', 942.56);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (380, '2010-03-07', 538.14);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (485, '2010-03-07', 137.79);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (13, '2010-02-17', 796.74);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (719, '2010-02-05', 792.24);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (810, '2010-01-29', 505.74);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (643, '2010-01-26', 706.68);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (206, '2010-01-20', 175.25);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (230, '2009-12-31', 891.79);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (159, '2009-12-31', 248.94);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (256, '2009-12-19', 108.39);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (582, '2009-12-10', 969.99);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (654, '2009-11-20', 655.25);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (472, '2009-11-17', 606.53);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (124, '2009-11-07', 893.22);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (276, '2009-10-28', 365.09);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (274, '2009-09-11', 685.43);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (190, '2009-09-04', 278.07);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (618, '2009-08-31', 532.48);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (678, '2009-08-17', 67.59);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (320, '2009-08-16', 889.78);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (882, '2009-08-09', 295.20);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (358, '2009-08-05', 655.69);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (278, '2009-07-14', 870.38);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (770, '2009-07-01', 472.81);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (919, '2009-06-23', 557.70);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (571, '2009-06-09', 235.49);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (269, '2009-06-04', 574.69);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (774, '2009-05-22', 317.49);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (335, '2009-05-11', 84.15);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (978, '2009-05-08', 484.86);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (171, '2009-03-22', 811.57);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (403, '2009-03-19', 77.70);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (952, '2009-03-06', 674.52);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (74, '2009-02-26', 454.69);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (894, '2009-02-12', 902.67);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (532, '2009-02-11', 791.41);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (486, '2009-02-08', 269.45);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (277, '2009-02-07', 809.82);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (650, '2009-01-30', 588.09);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (94, '2009-01-25', 698.10);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (415, '2009-01-20', 198.11);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (850, '2009-01-19', 567.64);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (579, '2009-01-11', 538.17);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (823, '2009-01-05', 444.12);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (420, '2008-12-29', 928.37);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (570, '2008-12-11', 356.68);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (637, '2008-11-30', 271.26);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (532, '2008-11-25', 770.17);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (444, '2008-11-24', 74.92);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (430, '2008-11-20', 250.89);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (638, '2008-11-20', 698.46);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (779, '2008-11-12', 635.88);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (148, '2008-11-08', 237.88);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (630, '2008-10-31', 674.99);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (646, '2008-10-28', 988.01);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (885, '2008-10-25', 794.88);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (456, '2008-10-20', 660.65);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (241, '2008-10-10', 731.47);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (961, '2008-10-10', 109.17);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (301, '2008-10-07', 683.26);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (976, '2008-10-06', 860.99);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (221, '2008-09-18', 303.10);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (980, '2008-08-28', 184.95);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (798, '2008-08-12', 476.93);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (568, '2008-08-06', 849.68);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (790, '2008-08-01', 171.28);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (55, '2008-08-01', 115.24);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (568, '2008-07-16', 845.04);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (613, '2008-06-23', 608.71);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (665, '2008-06-22', 259.73);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (636, '2008-06-17', 215.52);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (853, '2008-06-15', 838.58);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (817, '2008-06-13', 678.93);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (660, '2008-06-10', 103.69);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (483, '2008-06-08', 124.18);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (937, '2008-06-05', 627.37);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (499, '2008-05-19', 511.56);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (51, '2008-05-18', 19.01);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (941, '2008-05-15', 240.54);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (778, '2008-05-08', 979.92);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (388, '2008-04-30', 640.25);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (380, '2008-04-28', 194.26);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (861, '2008-04-16', 520.39);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (473, '2008-04-15', 493.51);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (337, '2008-04-11', 863.03);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (471, '2008-04-08', 711.90);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (80, '2008-04-07', 611.10);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (443, '2008-04-02', 575.68);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (161, '2008-03-13', 142.52);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (328, '2008-02-18', 884.39);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (355, '2008-02-15', 309.98);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (71, '2008-02-12', 502.30);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (175, '2008-01-08', 575.18);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (647, '2007-12-31', 267.58);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (628, '2007-12-29', 294.77);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (529, '2007-12-22', 821.66);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (371, '2007-12-05', 613.12);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (298, '2007-11-29', 170.74);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (836, '2007-11-28', 493.48);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (793, '2007-11-13', 785.48);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (707, '2007-11-10', 217.29);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (991, '2007-11-02', 275.57);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (165, '2007-10-28', 457.89);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (6, '2007-10-11', 57.68);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (280, '2007-10-10', 283.22);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (157, '2007-09-30', 943.02);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (451, '2007-09-24', 310.44);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (426, '2007-09-23', 208.70);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (142, '2007-08-27', 377.51);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (113, '2007-08-09', 620.55);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (929, '2007-08-06', 474.63);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (43, '2007-07-05', 784.14);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (436, '2007-06-17', 233.43);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (175, '2007-05-28', 569.18);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (573, '2007-05-26', 360.07);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (522, '2007-05-24', 25.53);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (743, '2007-05-24', 843.33);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (801, '2007-05-21', 888.83);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (596, '2007-05-13', 460.30);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (890, '2007-04-19', 399.59);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (913, '2007-04-09', 800.85);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (178, '2007-04-07', 224.14);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (441, '2007-04-06', 526.29);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (696, '2007-04-04', 793.68);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (658, '2007-03-30', 67.43);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (695, '2007-03-21', 4.28);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (538, '2007-03-14', 422.54);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (585, '2007-03-11', 68.58);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (472, '2007-03-04', 33.91);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (67, '2007-03-01', 237.76);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (852, '2007-02-26', 353.76);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (500, '2007-02-21', 206.07);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (942, '2007-02-20', 292.50);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (586, '2007-02-13', 393.39);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (587, '2007-02-04', 643.97);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (284, '2007-01-31', 18.60);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (245, '2007-01-18', 879.92);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (800, '2007-01-18', 24.98);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (657, '2007-01-17', 265.87);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (463, '2007-01-12', 410.63);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (332, '2007-01-12', 532.98);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (596, '2006-12-30', 713.75);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (796, '2006-12-29', 269.09);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (415, '2006-12-19', 93.54);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (233, '2006-12-18', 508.78);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (932, '2006-11-26', 313.34);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (461, '2006-11-26', 949.27);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (335, '2006-11-19', 35.02);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (571, '2006-11-17', 232.16);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (630, '2006-11-12', 425.05);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (148, '2006-11-07', 487.77);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (565, '2006-10-10', 7.60);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (66, '2006-09-12', 308.36);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (212, '2006-09-03', 748.54);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (535, '2006-08-28', 40.69);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (875, '2006-07-21', 752.47);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (921, '2006-07-14', 498.16);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (575, '2006-07-11', 143.16);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (623, '2006-05-20', 694.44);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (239, '2006-05-16', 618.25);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (959, '2006-05-16', 630.36);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (17, '2006-05-12', 325.98);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (78, '2006-05-11', 921.88);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (389, '2006-05-08', 225.74);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (566, '2006-05-02', 458.04);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (130, '2006-04-26', 86.11);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (596, '2006-04-26', 129.49);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (949, '2006-04-14', 275.34);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (833, '2006-04-07', 435.39);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (101, '2006-04-06', 926.96);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (590, '2006-03-17', 167.15);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (977, '2006-03-03', 856.27);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (789, '2006-03-01', 100.69);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (153, '2006-02-27', 730.26);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (835, '2006-01-24', 187.64);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (640, '2005-12-29', 887.22);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (920, '2005-12-24', 542.82);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (537, '2005-12-10', 803.24);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (265, '2005-11-29', 129.16);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (718, '2005-11-21', 32.30);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (737, '2005-11-17', 260.16);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (169, '2005-10-25', 157.27);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (263, '2005-08-25', 831.67);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (464, '2005-08-25', 87.67);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (987, '2005-08-22', 975.38);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (809, '2005-08-20', 734.14);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (276, '2005-08-20', 330.80);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (969, '2005-08-04', 111.68);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (842, '2005-08-02', 6.24);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (262, '2005-07-31', 754.30);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (751, '2005-07-28', 773.24);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (762, '2005-07-25', 943.45);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (69, '2005-07-22', 762.41);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (813, '2005-07-04', 188.82);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (874, '2005-06-17', 609.89);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (679, '2005-06-13', 166.21);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (321, '2005-05-28', 659.93);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (311, '2005-05-25', 82.79);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (791, '2005-05-14', 285.94);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (11, '2005-05-09', 6.99);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (584, '2005-05-05', 311.91);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (538, '2005-04-29', 95.42);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (18, '2005-04-19', 324.28);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (312, '2005-04-17', 887.14);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (178, '2005-04-04', 648.65);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (630, '2005-03-16', 980.45);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (288, '2005-03-12', 841.67);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (120, '2005-03-09', 269.01);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (402, '2005-03-02', 973.54);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (423, '2005-02-21', 15.78);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (570, '2005-02-01', 498.69);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (881, '2005-01-25', 404.13);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (555, '2005-01-24', 359.25);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (241, '2005-01-23', 363.97);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (56, '2005-01-06', 954.23);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (807, '2005-01-01', 162.84);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (208, '2004-12-31', 697.62);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (747, '2004-12-14', 915.14);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (537, '2004-12-12', 644.47);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (444, '2004-12-11', 106.67);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (856, '2004-12-09', 330.36);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (176, '2004-12-07', 156.89);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (185, '2004-11-26', 567.68);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (646, '2004-11-19', 579.89);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (446, '2004-11-17', 305.10);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (914, '2004-11-09', 103.29);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (949, '2004-10-19', 602.92);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (289, '2004-10-18', 253.49);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (302, '2004-10-02', 864.25);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (905, '2004-09-26', 508.35);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (678, '2004-09-26', 119.45);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (249, '2004-09-24', 985.87);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (777, '2004-09-14', 95.54);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (304, '2004-09-10', 325.60);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (786, '2004-09-09', 846.60);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (833, '2004-09-05', 769.38);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (114, '2004-09-05', 91.22);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (244, '2004-09-01', 403.98);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (345, '2004-08-28', 803.95);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (920, '2004-08-26', 190.05);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (42, '2004-08-14', 363.19);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (471, '2004-07-31', 886.27);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (744, '2004-07-25', 504.15);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (283, '2004-07-21', 310.65);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (213, '2004-07-12', 751.02);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (393, '2004-06-28', 960.36);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (597, '2004-06-20', 949.71);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (515, '2004-06-07', 466.42);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (26, '2004-05-31', 347.95);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (297, '2004-05-24', 936.22);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (992, '2004-05-18', 790.83);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (825, '2004-04-22', 77.29);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (56, '2004-04-18', 947.39);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (791, '2004-04-16', 37.81);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (117, '2004-02-19', 78.81);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (969, '2004-02-18', 635.92);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (927, '2004-02-16', 596.97);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (482, '2004-02-06', 539.55);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (912, '2004-02-02', 978.21);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (219, '2004-01-22', 280.30);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (702, '2004-01-04', 107.14);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (698, '2004-01-02', 586.74);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (354, '2003-12-24', 506.39);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (669, '2003-12-18', 916.27);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (844, '2003-12-15', 831.08);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (565, '2003-12-12', 590.17);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (58, '2003-12-11', 828.54);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (681, '2003-11-28', 221.03);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (132, '2003-11-03', 459.44);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (348, '2003-10-31', 133.92);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (425, '2003-10-31', 828.95);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (162, '2003-10-29', 703.99);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (610, '2003-10-11', 735.22);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (309, '2003-09-26', 4.90);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (469, '2003-09-20', 314.83);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (904, '2003-09-19', 247.18);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (346, '2003-08-23', 737.19);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (27, '2003-08-08', 843.15);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (724, '2003-08-07', 237.73);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (60, '2003-08-06', 794.48);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (979, '2003-07-24', 779.43);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (439, '2003-07-15', 252.60);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (734, '2003-07-09', 930.54);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (671, '2003-07-05', 335.89);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (391, '2003-06-23', 821.54);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (841, '2003-06-11', 821.69);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (48, '2003-06-09', 472.73);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (261, '2003-06-07', 29.23);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (154, '2003-06-06', 118.09);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (118, '2003-06-03', 939.58);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (364, '2003-05-27', 500.08);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (289, '2003-05-07', 167.83);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (871, '2003-04-13', 94.32);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (555, '2003-04-03', 488.43);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (492, '2003-04-02', 640.08);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (641, '2003-03-25', 784.55);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (177, '2003-03-09', 92.05);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (890, '2003-02-25', 587.13);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (856, '2003-02-20', 818.28);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (545, '2003-02-18', 569.51);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (493, '2003-02-12', 666.28);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (191, '2003-02-08', 910.77);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (414, '2003-02-06', 92.15);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (322, '2003-01-18', 253.00);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (822, '2003-01-15', 371.97);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (256, '2003-01-09', 168.72);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (138, '2003-01-03', 633.00);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (840, '2002-12-28', 416.05);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (474, '2002-12-21', 639.61);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (186, '2002-12-12', 235.80);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (677, '2002-12-10', 313.46);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (102, '2002-12-03', 979.21);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (259, '2002-11-24', 393.43);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (821, '2002-11-20', 543.35);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (384, '2002-11-04', 517.00);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (804, '2002-10-20', 67.39);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (173, '2002-10-20', 854.15);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (383, '2002-10-18', 505.14);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (533, '2002-10-06', 85.44);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (323, '2002-09-27', 687.28);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (281, '2002-09-22', 54.53);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (791, '2002-09-20', 666.64);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (390, '2002-09-12', 42.52);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (221, '2002-07-19', 893.30);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (717, '2002-06-21', 671.62);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (490, '2002-06-14', 105.47);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (169, '2002-05-26', 855.47);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (318, '2002-05-22', 527.73);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (120, '2002-05-14', 353.24);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (691, '2002-04-28', 438.26);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (617, '2002-04-26', 417.95);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (551, '2002-04-08', 466.57);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (953, '2002-04-03', 744.65);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (906, '2002-03-30', 250.24);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (163, '2002-03-20', 263.11);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (638, '2002-02-24', 628.80);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (486, '2002-02-12', 881.38);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (808, '2002-01-22', 540.94);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (634, '2002-01-10', 478.65);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (958, '2002-01-10', 555.73);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (672, '2002-01-03', 797.65);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (588, '2001-12-29', 417.42);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (478, '2001-12-24', 149.61);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (786, '2001-12-17', 290.27);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (690, '2001-12-15', 302.33);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (788, '2001-12-13', 654.44);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (912, '2001-12-06', 755.70);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (280, '2001-12-05', 51.37);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (34, '2001-11-30', 460.18);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (94, '2001-11-20', 101.97);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (163, '2001-10-13', 714.38);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (727, '2001-10-13', 716.89);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (263, '2001-10-04', 177.89);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (682, '2001-09-22', 360.08);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (395, '2001-09-18', 479.15);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (1, '2001-09-12', 261.42);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (79, '2001-09-08', 428.33);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (420, '2001-08-24', 438.51);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (655, '2001-08-17', 406.75);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (326, '2001-08-16', 859.00);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (441, '2001-08-14', 312.13);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (330, '2001-08-02', 240.44);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (585, '2001-07-06', 860.51);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (11, '2001-06-06', 400.78);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (485, '2001-05-23', 137.91);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (223, '2001-05-04', 614.28);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (855, '2001-04-27', 698.22);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (752, '2001-04-12', 948.76);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (743, '2001-04-11', 67.04);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (65, '2001-04-06', 63.00);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (962, '2001-03-31', 502.59);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (417, '2001-03-17', 786.68);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (532, '2001-03-02', 32.92);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (36, '2001-02-28', 656.74);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (725, '2001-02-06', 151.25);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (998, '2001-02-02', 663.12);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (739, '2001-01-12', 664.14);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (464, '2001-01-11', 557.72);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (256, '2001-01-10', 572.86);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (284, '2000-12-16', 524.88);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (206, '2000-11-29', 784.18);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (244, '2000-11-18', 561.58);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (159, '2000-10-25', 563.56);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (541, '2000-10-20', 937.26);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (590, '2000-10-17', 429.70);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (765, '2000-10-14', 303.18);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (307, '2000-10-12', 203.48);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (569, '2000-10-11', 621.31);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (793, '2000-10-04', 853.94);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (652, '2000-09-16', 645.91);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (42, '2000-09-01', 238.16);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (714, '2000-08-23', 914.05);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (88, '2000-08-14', 180.11);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (621, '2000-07-21', 911.81);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (484, '2000-07-19', 436.12);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (957, '2000-06-25', 45.60);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (514, '2000-06-21', 972.86);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (494, '2000-06-15', 841.64);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (531, '2000-06-15', 694.83);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (527, '2000-06-11', 691.92);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (971, '2000-06-11', 729.57);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (411, '2000-06-05', 62.37);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (762, '2000-05-29', 970.77);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (845, '2000-05-03', 334.98);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (50, '2000-04-30', 666.02);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (446, '2000-04-20', 124.24);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (326, '2000-03-25', 963.83);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (803, '2000-03-24', 188.40);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (752, '2000-03-23', 889.77);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (412, '2000-03-20', 707.47);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (656, '2000-03-12', 83.23);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (193, '2000-03-06', 355.15);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (829, '2000-03-03', 95.03);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (203, '2000-02-25', 856.64);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (194, '2000-02-25', 260.79);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (884, '2000-01-29', 126.67);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (429, '2000-01-27', 749.53);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (98, '2000-01-11', 193.95);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (672, '2000-01-11', 658.07);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (740, '2000-01-10', 987.43);
INSERT INTO `xd_course`.`sales_data` (`product_id`, `sale_date`, `sale_amount`) VALUES (625, '2000-01-09', 423.61);
 

实际sql

SELECT
    s1.month,
    s1.current_month_sales,
    COALESCE(s2.current_month_sales, 0) AS prev_month_sales,
    ((s1.current_month_sales-COALESCE(s2.current_month_sales, 0))/s1.current_month_sales)as '环比增长率'
FROM
(
  SELECT
        DATE_FORMAT(sale_date, '%Y-%m') AS month,
        SUM(sale_amount) AS current_month_sales
  FROM
        sales_data
  GROUP BY
        DATE_FORMAT(sale_date, '%Y-%m')
) AS s1
LEFT JOIN
(
  SELECT
        DATE_FORMAT(sale_date, '%Y-%m') AS month,
        SUM(sale_amount) AS current_month_sales
  FROM
        sales_data
  GROUP BY
        DATE_FORMAT(sale_date, '%Y-%m')
) AS s2
ON DATE_FORMAT(DATE_SUB(concat(s1.month,'-01'), INTERVAL 1 MONTH), '%Y-%m') = s2.month;

查询结果集

weixin_sjt
关注
  • 7
    点赞
  • 踩
  • 8
    收藏
    觉得还不错? 一键收藏
  • 1
    评论
专栏目录
评论 1
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值