SQL

SQL：使用 CASE 和 GROUP BY 实现数据透视

统计不同产品、不同渠道销售情况

创建表

  • 需求：
    • 需要根据 employee、attendance、calendar 三张表，统计员工的出勤情况；
    • 创建销售数据表sales_data ``` – saledate表示销售日期，product表示产品名称，channel表示销售渠道，amount表示销售金额

CREATE TABLE sales_data(saledate DATE, product VARCHAR(20), channel VARCHAR(20), amount NUMERIC(10, 2));


# 写入测试数据

```aidl
INSERT INTO sales_data VALUES ('2019-01-01','桔子','淘宝',1864.00);
INSERT INTO sales_data VALUES ('2019-01-01','桔子','京东',1329.00);
INSERT INTO sales_data VALUES ('2019-01-01','桔子','店面',1736.00);
INSERT INTO sales_data VALUES ('2019-01-01','香蕉','淘宝',1573.00);
INSERT INTO sales_data VALUES ('2019-01-01','香蕉','京东',1364.00);
INSERT INTO sales_data VALUES ('2019-01-01','香蕉','店面',1178.00);
INSERT INTO sales_data VALUES ('2019-01-01','苹果','淘宝',511.00);
INSERT INTO sales_data VALUES ('2019-01-01','苹果','京东',568.00);
INSERT INTO sales_data VALUES ('2019-01-01','苹果','店面',847.00);
INSERT INTO sales_data VALUES ('2019-01-02','桔子','淘宝',1923.00);
INSERT INTO sales_data VALUES ('2019-01-02','桔子','京东',775.00);
INSERT INTO sales_data VALUES ('2019-01-02','桔子','店面',599.00);
INSERT INTO sales_data VALUES ('2019-01-02','香蕉','淘宝',1612.00);
INSERT INTO sales_data VALUES ('2019-01-02','香蕉','京东',1057.00);
INSERT INTO sales_data VALUES ('2019-01-02','香蕉','店面',1580.00);
INSERT INTO sales_data VALUES ('2019-01-02','苹果','淘宝',1345.00);
INSERT INTO sales_data VALUES ('2019-01-02','苹果','京东',564.00);
INSERT INTO sales_data VALUES ('2019-01-02','苹果','店面',1953.00);
INSERT INTO sales_data VALUES ('2019-01-03','桔子','淘宝',729.00);
INSERT INTO sales_data VALUES ('2019-01-03','桔子','京东',1758.00);
INSERT INTO sales_data VALUES ('2019-01-03','桔子','店面',918.00);
INSERT INTO sales_data VALUES ('2019-01-03','香蕉','淘宝',1879.00);
INSERT INTO sales_data VALUES ('2019-01-03','香蕉','京东',1142.00);
INSERT INTO sales_data VALUES ('2019-01-03','香蕉','店面',731.00);
INSERT INTO sales_data VALUES ('2019-01-03','苹果','淘宝',1329.00);
INSERT INTO sales_data VALUES ('2019-01-03','苹果','京东',1315.00);
INSERT INTO sales_data VALUES ('2019-01-03','苹果','店面',1956.00);
INSERT INTO sales_data VALUES ('2019-01-04','桔子','淘宝',547.00);
INSERT INTO sales_data VALUES ('2019-01-04','桔子','京东',1462.00);
INSERT INTO sales_data VALUES ('2019-01-04','桔子','店面',1418.00);
INSERT INTO sales_data VALUES ('2019-01-04','香蕉','淘宝',1205.00);
INSERT INTO sales_data VALUES ('2019-01-04','香蕉','京东',1326.00);
INSERT INTO sales_data VALUES ('2019-01-04','香蕉','店面',746.00);
INSERT INTO sales_data VALUES ('2019-01-04','苹果','淘宝',940.00);
INSERT INTO sales_data VALUES ('2019-01-04','苹果','京东',898.00);
INSERT INTO sales_data VALUES ('2019-01-04','苹果','店面',1610.00);
INSERT INTO sales_data VALUES ('2019-01-05','桔子','淘宝',1624.00);
INSERT INTO sales_data VALUES ('2019-01-05','桔子','京东',915.00);
INSERT INTO sales_data VALUES ('2019-01-05','桔子','店面',1683.00);
INSERT INTO sales_data VALUES ('2019-01-05','香蕉','淘宝',1970.00);
INSERT INTO sales_data VALUES ('2019-01-05','香蕉','京东',833.00);
INSERT INTO sales_data VALUES ('2019-01-05','香蕉','店面',1954.00);
INSERT INTO sales_data VALUES ('2019-01-05','苹果','淘宝',565.00);
INSERT INTO sales_data VALUES ('2019-01-05','苹果','京东',1940.00);
INSERT INTO sales_data VALUES ('2019-01-05','苹果','店面',1006.00);
INSERT INTO sales_data VALUES ('2019-01-06','桔子','淘宝',1645.00);
INSERT INTO sales_data VALUES ('2019-01-06','桔子','京东',1285.00);
INSERT INTO sales_data VALUES ('2019-01-06','桔子','店面',1069.00);
INSERT INTO sales_data VALUES ('2019-01-06','香蕉','淘宝',1593.00);
INSERT INTO sales_data VALUES ('2019-01-06','香蕉','京东',1504.00);
INSERT INTO sales_data VALUES ('2019-01-06','香蕉','店面',817.00);
INSERT INTO sales_data VALUES ('2019-01-06','苹果','淘宝',2000.00);
INSERT INTO sales_data VALUES ('2019-01-06','苹果','京东',1373.00);
INSERT INTO sales_data VALUES ('2019-01-06','苹果','店面',1450.00);
INSERT INTO sales_data VALUES ('2019-01-07','桔子','淘宝',727.00);
INSERT INTO sales_data VALUES ('2019-01-07','桔子','京东',698.00);
INSERT INTO sales_data VALUES ('2019-01-07','桔子','店面',759.00);
INSERT INTO sales_data VALUES ('2019-01-07','香蕉','淘宝',673.00);
INSERT INTO sales_data VALUES ('2019-01-07','香蕉','京东',729.00);
INSERT INTO sales_data VALUES ('2019-01-07','香蕉','店面',1706.00);
INSERT INTO sales_data VALUES ('2019-01-07','苹果','淘宝',1575.00);
INSERT INTO sales_data VALUES ('2019-01-07','苹果','京东',1419.00);
INSERT INTO sales_data VALUES ('2019-01-07','苹果','店面',1017.00);
INSERT INTO sales_data VALUES ('2019-01-08','桔子','淘宝',1811.00);
INSERT INTO sales_data VALUES ('2019-01-08','桔子','京东',1849.00);
INSERT INTO sales_data VALUES ('2019-01-08','桔子','店面',1405.00);
INSERT INTO sales_data VALUES ('2019-01-08','香蕉','淘宝',1406.00);
INSERT INTO sales_data VALUES ('2019-01-08','香蕉','京东',1453.00);
INSERT INTO sales_data VALUES ('2019-01-08','香蕉','店面',1800.00);
INSERT INTO sales_data VALUES ('2019-01-08','苹果','淘宝',1070.00);
INSERT INTO sales_data VALUES ('2019-01-08','苹果','京东',1403.00);
INSERT INTO sales_data VALUES ('2019-01-08','苹果','店面',613.00);
INSERT INTO sales_data VALUES ('2019-01-09','桔子','淘宝',1009.00);
INSERT INTO sales_data VALUES ('2019-01-09','桔子','京东',1453.00);
INSERT INTO sales_data VALUES ('2019-01-09','桔子','店面',2038.00);
INSERT INTO sales_data VALUES ('2019-01-09','香蕉','淘宝',1495.00);
INSERT INTO sales_data VALUES ('2019-01-09','香蕉','京东',1073.00);
INSERT INTO sales_data VALUES ('2019-01-09','香蕉','店面',1298.00);
INSERT INTO sales_data VALUES ('2019-01-09','苹果','淘宝',2039.00);
INSERT INTO sales_data VALUES ('2019-01-09','苹果','京东',641.00);
INSERT INTO sales_data VALUES ('2019-01-09','苹果','店面',777.00);
INSERT INTO sales_data VALUES ('2019-01-10','桔子','淘宝',836.00);
INSERT INTO sales_data VALUES ('2019-01-10','桔子','京东',621.00);
INSERT INTO sales_data VALUES ('2019-01-10','桔子','店面',1630.00);
INSERT INTO sales_data VALUES ('2019-01-10','香蕉','淘宝',1761.00);
INSERT INTO sales_data VALUES ('2019-01-10','香蕉','京东',818.00);
INSERT INTO sales_data VALUES ('2019-01-10','香蕉','店面',1797.00);
INSERT INTO sales_data VALUES ('2019-01-10','苹果','淘宝',1990.00);
INSERT INTO sales_data VALUES ('2019-01-10','苹果','京东',960.00);
INSERT INTO sales_data VALUES ('2019-01-10','苹果','店面',1997.00);
INSERT INTO sales_data VALUES ('2019-01-11','桔子','淘宝',1671.00);
INSERT INTO sales_data VALUES ('2019-01-11','桔子','京东',2010.00);
INSERT INTO sales_data VALUES ('2019-01-11','桔子','店面',1391.00);
INSERT INTO sales_data VALUES ('2019-01-11','香蕉','淘宝',658.00);
INSERT INTO sales_data VALUES ('2019-01-11','香蕉','京东',1786.00);
INSERT INTO sales_data VALUES ('2019-01-11','香蕉','店面',1205.00);
INSERT INTO sales_data VALUES ('2019-01-11','苹果','淘宝',1528.00);
INSERT INTO sales_data VALUES ('2019-01-11','苹果','京东',1158.00);
INSERT INTO sales_data VALUES ('2019-01-11','苹果','店面',623.00);
INSERT INTO sales_data VALUES ('2019-01-12','桔子','淘宝',1299.00);
INSERT INTO sales_data VALUES ('2019-01-12','桔子','京东',1698.00);
INSERT INTO sales_data VALUES ('2019-01-12','桔子','店面',1497.00);
INSERT INTO sales_data VALUES ('2019-01-12','香蕉','淘宝',1377.00);
INSERT INTO sales_data VALUES ('2019-01-12','香蕉','京东',667.00);
INSERT INTO sales_data VALUES ('2019-01-12','香蕉','店面',910.00);
INSERT INTO sales_data VALUES ('2019-01-12','苹果','淘宝',1374.00);
INSERT INTO sales_data VALUES ('2019-01-12','苹果','京东',1621.00);
INSERT INTO sales_data VALUES ('2019-01-12','苹果','店面',1443.00);
INSERT INTO sales_data VALUES ('2019-01-13','桔子','淘宝',637.00);
INSERT INTO sales_data VALUES ('2019-01-13','桔子','京东',1625.00);
INSERT INTO sales_data VALUES ('2019-01-13','桔子','店面',1548.00);
INSERT INTO sales_data VALUES ('2019-01-13','香蕉','淘宝',873.00);
INSERT INTO sales_data VALUES ('2019-01-13','香蕉','京东',1916.00);
INSERT INTO sales_data VALUES ('2019-01-13','香蕉','店面',1624.00);
INSERT INTO sales_data VALUES ('2019-01-13','苹果','淘宝',1958.00);
INSERT INTO sales_data VALUES ('2019-01-13','苹果','京东',1632.00);
INSERT INTO sales_data VALUES ('2019-01-13','苹果','店面',1897.00);
INSERT INTO sales_data VALUES ('2019-01-14','桔子','淘宝',1715.00);
INSERT INTO sales_data VALUES ('2019-01-14','桔子','京东',1582.00);
INSERT INTO sales_data VALUES ('2019-01-14','桔子','店面',817.00);
INSERT INTO sales_data VALUES ('2019-01-14','香蕉','淘宝',1667.00);
INSERT INTO sales_data VALUES ('2019-01-14','香蕉','京东',1203.00);
INSERT INTO sales_data VALUES ('2019-01-14','香蕉','店面',777.00);
INSERT INTO sales_data VALUES ('2019-01-14','苹果','淘宝',1008.00);
INSERT INTO sales_data VALUES ('2019-01-14','苹果','京东',1311.00);
INSERT INTO sales_data VALUES ('2019-01-14','苹果','店面',2013.00);
INSERT INTO sales_data VALUES ('2019-01-15','桔子','淘宝',1668.00);
INSERT INTO sales_data VALUES ('2019-01-15','桔子','京东',794.00);
INSERT INTO sales_data VALUES ('2019-01-15','桔子','店面',1126.00);
INSERT INTO sales_data VALUES ('2019-01-15','香蕉','淘宝',1741.00);
INSERT INTO sales_data VALUES ('2019-01-15','香蕉','京东',1538.00);
INSERT INTO sales_data VALUES ('2019-01-15','香蕉','店面',768.00);
INSERT INTO sales_data VALUES ('2019-01-15','苹果','淘宝',1183.00);
INSERT INTO sales_data VALUES ('2019-01-15','苹果','京东',859.00);
INSERT INTO sales_data VALUES ('2019-01-15','苹果','店面',880.00);
INSERT INTO sales_data VALUES ('2019-01-16','桔子','淘宝',1543.00);
INSERT INTO sales_data VALUES ('2019-01-16','桔子','京东',1684.00);
INSERT INTO sales_data VALUES ('2019-01-16','桔子','店面',1951.00);
INSERT INTO sales_data VALUES ('2019-01-16','香蕉','淘宝',930.00);
INSERT INTO sales_data VALUES ('2019-01-16','香蕉','京东',1760.00);
INSERT INTO sales_data VALUES ('2019-01-16','香蕉','店面',1517.00);
INSERT INTO sales_data VALUES ('2019-01-16','苹果','淘宝',1918.00);
INSERT INTO sales_data VALUES ('2019-01-16','苹果','京东',2073.00);
INSERT INTO sales_data VALUES ('2019-01-16','苹果','店面',1373.00);
INSERT INTO sales_data VALUES ('2019-01-17','桔子','淘宝',1487.00);
INSERT INTO sales_data VALUES ('2019-01-17','桔子','京东',1976.00);
INSERT INTO sales_data VALUES ('2019-01-17','桔子','店面',950.00);
INSERT INTO sales_data VALUES ('2019-01-17','香蕉','淘宝',1324.00);
INSERT INTO sales_data VALUES ('2019-01-17','香蕉','京东',1627.00);
INSERT INTO sales_data VALUES ('2019-01-17','香蕉','店面',1967.00);
INSERT INTO sales_data VALUES ('2019-01-17','苹果','淘宝',1576.00);
INSERT INTO sales_data VALUES ('2019-01-17','苹果','京东',1229.00);
INSERT INTO sales_data VALUES ('2019-01-17','苹果','店面',1105.00);
INSERT INTO sales_data VALUES ('2019-01-18','桔子','淘宝',1792.00);
INSERT INTO sales_data VALUES ('2019-01-18','桔子','京东',1676.00);
INSERT INTO sales_data VALUES ('2019-01-18','桔子','店面',1856.00);
INSERT INTO sales_data VALUES ('2019-01-18','香蕉','淘宝',1740.00);
INSERT INTO sales_data VALUES ('2019-01-18','香蕉','京东',1274.00);
INSERT INTO sales_data VALUES ('2019-01-18','香蕉','店面',2080.00);
INSERT INTO sales_data VALUES ('2019-01-18','苹果','淘宝',796.00);
INSERT INTO sales_data VALUES ('2019-01-18','苹果','京东',946.00);
INSERT INTO sales_data VALUES ('2019-01-18','苹果','店面',1548.00);
INSERT INTO sales_data VALUES ('2019-01-19','桔子','淘宝',1000.00);
INSERT INTO sales_data VALUES ('2019-01-19','桔子','京东',1563.00);
INSERT INTO sales_data VALUES ('2019-01-19','桔子','店面',1843.00);
INSERT INTO sales_data VALUES ('2019-01-19','香蕉','淘宝',1310.00);
INSERT INTO sales_data VALUES ('2019-01-19','香蕉','京东',1031.00);
INSERT INTO sales_data VALUES ('2019-01-19','香蕉','店面',1451.00);
INSERT INTO sales_data VALUES ('2019-01-19','苹果','淘宝',1186.00);
INSERT INTO sales_data VALUES ('2019-01-19','苹果','京东',1386.00);
INSERT INTO sales_data VALUES ('2019-01-19','苹果','店面',1137.00);
INSERT INTO sales_data VALUES ('2019-01-20','桔子','淘宝',633.00);
INSERT INTO sales_data VALUES ('2019-01-20','桔子','京东',1235.00);
INSERT INTO sales_data VALUES ('2019-01-20','桔子','店面',1140.00);
INSERT INTO sales_data VALUES ('2019-01-20','香蕉','淘宝',1431.00);
INSERT INTO sales_data VALUES ('2019-01-20','香蕉','京东',642.00);
INSERT INTO sales_data VALUES ('2019-01-20','香蕉','店面',1036.00);
INSERT INTO sales_data VALUES ('2019-01-20','苹果','淘宝',1801.00);
INSERT INTO sales_data VALUES ('2019-01-20','苹果','京东',1386.00);
INSERT INTO sales_data VALUES ('2019-01-20','苹果','店面',2083.00);
INSERT INTO sales_data VALUES ('2019-01-21','桔子','淘宝',1694.00);
INSERT INTO sales_data VALUES ('2019-01-21','桔子','京东',887.00);
INSERT INTO sales_data VALUES ('2019-01-21','桔子','店面',1236.00);
INSERT INTO sales_data VALUES ('2019-01-21','香蕉','淘宝',719.00);
INSERT INTO sales_data VALUES ('2019-01-21','香蕉','京东',2094.00);
INSERT INTO sales_data VALUES ('2019-01-21','香蕉','店面',828.00);
INSERT INTO sales_data VALUES ('2019-01-21','苹果','淘宝',1990.00);
INSERT INTO sales_data VALUES ('2019-01-21','苹果','京东',1749.00);
INSERT INTO sales_data VALUES ('2019-01-21','苹果','店面',1517.00);
INSERT INTO sales_data VALUES ('2019-01-22','桔子','淘宝',1990.00);
INSERT INTO sales_data VALUES ('2019-01-22','桔子','京东',1965.00);
INSERT INTO sales_data VALUES ('2019-01-22','桔子','店面',1883.00);
INSERT INTO sales_data VALUES ('2019-01-22','香蕉','淘宝',1454.00);
INSERT INTO sales_data VALUES ('2019-01-22','香蕉','京东',875.00);
INSERT INTO sales_data VALUES ('2019-01-22','香蕉','店面',1356.00);
INSERT INTO sales_data VALUES ('2019-01-22','苹果','淘宝',1207.00);
INSERT INTO sales_data VALUES ('2019-01-22','苹果','京东',1595.00);
INSERT INTO sales_data VALUES ('2019-01-22','苹果','店面',1797.00);
INSERT INTO sales_data VALUES ('2019-01-23','桔子','淘宝',2073.00);
INSERT INTO sales_data VALUES ('2019-01-23','桔子','京东',696.00);
INSERT INTO sales_data VALUES ('2019-01-23','桔子','店面',1099.00);
INSERT INTO sales_data VALUES ('2019-01-23','香蕉','淘宝',1120.00);
INSERT INTO sales_data VALUES ('2019-01-23','香蕉','京东',733.00);
INSERT INTO sales_data VALUES ('2019-01-23','香蕉','店面',1739.00);
INSERT INTO sales_data VALUES ('2019-01-23','苹果','淘宝',1665.00);
INSERT INTO sales_data VALUES ('2019-01-23','苹果','京东',1569.00);
INSERT INTO sales_data VALUES ('2019-01-23','苹果','店面',1786.00);
INSERT INTO sales_data VALUES ('2019-01-24','桔子','淘宝',2111.00);
INSERT INTO sales_data VALUES ('2019-01-24','桔子','京东',1280.00);
INSERT INTO sales_data VALUES ('2019-01-24','桔子','店面',1082.00);
INSERT INTO sales_data VALUES ('2019-01-24','香蕉','淘宝',2099.00);
INSERT INTO sales_data VALUES ('2019-01-24','香蕉','京东',874.00);
INSERT INTO sales_data VALUES ('2019-01-24','香蕉','店面',1369.00);
INSERT INTO sales_data VALUES ('2019-01-24','苹果','淘宝',1235.00);
INSERT INTO sales_data VALUES ('2019-01-24','苹果','京东',993.00);
INSERT INTO sales_data VALUES ('2019-01-24','苹果','店面',1363.00);
INSERT INTO sales_data VALUES ('2019-01-25','桔子','淘宝',1468.00);
INSERT INTO sales_data VALUES ('2019-01-25','桔子','京东',888.00);
INSERT INTO sales_data VALUES ('2019-01-25','桔子','店面',1017.00);
INSERT INTO sales_data VALUES ('2019-01-25','香蕉','淘宝',885.00);
INSERT INTO sales_data VALUES ('2019-01-25','香蕉','京东',773.00);
INSERT INTO sales_data VALUES ('2019-01-25','香蕉','店面',878.00);
INSERT INTO sales_data VALUES ('2019-01-25','苹果','淘宝',662.00);
INSERT INTO sales_data VALUES ('2019-01-25','苹果','京东',1622.00);
INSERT INTO sales_data VALUES ('2019-01-25','苹果','店面',1148.00);
INSERT INTO sales_data VALUES ('2019-01-26','桔子','淘宝',1418.00);
INSERT INTO sales_data VALUES ('2019-01-26','桔子','京东',729.00);
INSERT INTO sales_data VALUES ('2019-01-26','桔子','店面',643.00);
INSERT INTO sales_data VALUES ('2019-01-26','香蕉','淘宝',1111.00);
INSERT INTO sales_data VALUES ('2019-01-26','香蕉','京东',692.00);
INSERT INTO sales_data VALUES ('2019-01-26','香蕉','店面',728.00);
INSERT INTO sales_data VALUES ('2019-01-26','苹果','淘宝',1600.00);
INSERT INTO sales_data VALUES ('2019-01-26','苹果','京东',1202.00);
INSERT INTO sales_data VALUES ('2019-01-26','苹果','店面',851.00);
INSERT INTO sales_data VALUES ('2019-01-27','桔子','淘宝',1233.00);
INSERT INTO sales_data VALUES ('2019-01-27','桔子','京东',761.00);
INSERT INTO sales_data VALUES ('2019-01-27','桔子','店面',1816.00);
INSERT INTO sales_data VALUES ('2019-01-27','香蕉','淘宝',909.00);
INSERT INTO sales_data VALUES ('2019-01-27','香蕉','京东',757.00);
INSERT INTO sales_data VALUES ('2019-01-27','香蕉','店面',981.00);
INSERT INTO sales_data VALUES ('2019-01-27','苹果','淘宝',1376.00);
INSERT INTO sales_data VALUES ('2019-01-27','苹果','京东',741.00);
INSERT INTO sales_data VALUES ('2019-01-27','苹果','店面',1240.00);
INSERT INTO sales_data VALUES ('2019-01-28','桔子','淘宝',635.00);
INSERT INTO sales_data VALUES ('2019-01-28','桔子','京东',1366.00);
INSERT INTO sales_data VALUES ('2019-01-28','桔子','店面',1623.00);
INSERT INTO sales_data VALUES ('2019-01-28','香蕉','淘宝',1383.00);
INSERT INTO sales_data VALUES ('2019-01-28','香蕉','京东',713.00);
INSERT INTO sales_data VALUES ('2019-01-28','香蕉','店面',1891.00);
INSERT INTO sales_data VALUES ('2019-01-28','苹果','淘宝',1781.00);
INSERT INTO sales_data VALUES ('2019-01-28','苹果','京东',978.00);
INSERT INTO sales_data VALUES ('2019-01-28','苹果','店面',2044.00);
INSERT INTO sales_data VALUES ('2019-01-29','桔子','淘宝',2044.00);
INSERT INTO sales_data VALUES ('2019-01-29','桔子','京东',1026.00);
INSERT INTO sales_data VALUES ('2019-01-29','桔子','店面',1551.00);
INSERT INTO sales_data VALUES ('2019-01-29','香蕉','淘宝',1071.00);
INSERT INTO sales_data VALUES ('2019-01-29','香蕉','京东',1819.00);
INSERT INTO sales_data VALUES ('2019-01-29','香蕉','店面',1655.00);
INSERT INTO sales_data VALUES ('2019-01-29','苹果','淘宝',1089.00);
INSERT INTO sales_data VALUES ('2019-01-29','苹果','京东',805.00);
INSERT INTO sales_data VALUES ('2019-01-29','苹果','店面',1722.00);
INSERT INTO sales_data VALUES ('2019-01-30','桔子','淘宝',1197.00);
INSERT INTO sales_data VALUES ('2019-01-30','桔子','京东',1785.00);
INSERT INTO sales_data VALUES ('2019-01-30','桔子','店面',804.00);
INSERT INTO sales_data VALUES ('2019-01-30','香蕉','淘宝',1424.00);
INSERT INTO sales_data VALUES ('2019-01-30','香蕉','京东',888.00);
INSERT INTO sales_data VALUES ('2019-01-30','香蕉','店面',935.00);
INSERT INTO sales_data VALUES ('2019-01-30','苹果','淘宝',1109.00);
INSERT INTO sales_data VALUES ('2019-01-30','苹果','京东',1167.00);
INSERT INTO sales_data VALUES ('2019-01-30','苹果','店面',1062.00);
INSERT INTO sales_data VALUES ('2019-01-31','桔子','淘宝',1465.00);
INSERT INTO sales_data VALUES ('2019-01-31','桔子','京东',1918.00);
INSERT INTO sales_data VALUES ('2019-01-31','桔子','店面',1178.00);
INSERT INTO sales_data VALUES ('2019-01-31','香蕉','淘宝',2075.00);
INSERT INTO sales_data VALUES ('2019-01-31','香蕉','京东',1918.00);
INSERT INTO sales_data VALUES ('2019-01-31','香蕉','店面',1908.00);
INSERT INTO sales_data VALUES ('2019-01-31','苹果','淘宝',1563.00);
INSERT INTO sales_data VALUES ('2019-01-31','苹果','京东',1166.00);
INSERT INTO sales_data VALUES ('2019-01-31','苹果','店面',1987.00);
INSERT INTO sales_data VALUES ('2019-02-01','桔子','淘宝',1324.00);
INSERT INTO sales_data VALUES ('2019-02-01','桔子','京东',817.00);
INSERT INTO sales_data VALUES ('2019-02-01','桔子','店面',835.00);
INSERT INTO sales_data VALUES ('2019-02-01','香蕉','淘宝',1233.00);
INSERT INTO sales_data VALUES ('2019-02-01','香蕉','京东',721.00);
INSERT INTO sales_data VALUES ('2019-02-01','香蕉','店面',1221.00);
INSERT INTO sales_data VALUES ('2019-02-01','苹果','淘宝',2145.00);
INSERT INTO sales_data VALUES ('2019-02-01','苹果','京东',1152.00);
INSERT INTO sales_data VALUES ('2019-02-01','苹果','店面',900.00);
INSERT INTO sales_data VALUES ('2019-02-02','桔子','淘宝',1665.00);
INSERT INTO sales_data VALUES ('2019-02-02','桔子','京东',1606.00);
INSERT INTO sales_data VALUES ('2019-02-02','桔子','店面',1070.00);
INSERT INTO sales_data VALUES ('2019-02-02','香蕉','淘宝',1247.00);
INSERT INTO sales_data VALUES ('2019-02-02','香蕉','京东',2158.00);
INSERT INTO sales_data VALUES ('2019-02-02','香蕉','店面',709.00);
INSERT INTO sales_data VALUES ('2019-02-02','苹果','淘宝',1406.00);
INSERT INTO sales_data VALUES ('2019-02-02','苹果','京东',1437.00);
INSERT INTO sales_data VALUES ('2019-02-02','苹果','店面',952.00);
INSERT INTO sales_data VALUES ('2019-02-03','桔子','淘宝',1701.00);
INSERT INTO sales_data VALUES ('2019-02-03','桔子','京东',1906.00);
INSERT INTO sales_data VALUES ('2019-02-03','桔子','店面',1479.00);
INSERT INTO sales_data VALUES ('2019-02-03','香蕉','淘宝',2118.00);
INSERT INTO sales_data VALUES ('2019-02-03','香蕉','京东',1221.00);
INSERT INTO sales_data VALUES ('2019-02-03','香蕉','店面',1247.00);
INSERT INTO sales_data VALUES ('2019-02-03','苹果','淘宝',1146.00);
INSERT INTO sales_data VALUES ('2019-02-03','苹果','京东',1146.00);
INSERT INTO sales_data VALUES ('2019-02-03','苹果','店面',1015.00);
INSERT INTO sales_data VALUES ('2019-02-04','桔子','淘宝',909.00);
INSERT INTO sales_data VALUES ('2019-02-04','桔子','京东',2065.00);
INSERT INTO sales_data VALUES ('2019-02-04','桔子','店面',1536.00);
INSERT INTO sales_data VALUES ('2019-02-04','香蕉','淘宝',746.00);
INSERT INTO sales_data VALUES ('2019-02-04','香蕉','京东',1234.00);
INSERT INTO sales_data VALUES ('2019-02-04','香蕉','店面',1698.00);
INSERT INTO sales_data VALUES ('2019-02-04','苹果','淘宝',926.00);
INSERT INTO sales_data VALUES ('2019-02-04','苹果','京东',1812.00);
INSERT INTO sales_data VALUES ('2019-02-04','苹果','店面',1764.00);
INSERT INTO sales_data VALUES ('2019-02-05','桔子','淘宝',1497.00);
INSERT INTO sales_data VALUES ('2019-02-05','桔子','京东',1806.00);
INSERT INTO sales_data VALUES ('2019-02-05','桔子','店面',766.00);
INSERT INTO sales_data VALUES ('2019-02-05','香蕉','淘宝',1741.00);
INSERT INTO sales_data VALUES ('2019-02-05','香蕉','京东',1311.00);
INSERT INTO sales_data VALUES ('2019-02-05','香蕉','店面',1712.00);
INSERT INTO sales_data VALUES ('2019-02-05','苹果','淘宝',2151.00);
INSERT INTO sales_data VALUES ('2019-02-05','苹果','京东',1898.00);
INSERT INTO sales_data VALUES ('2019-02-05','苹果','店面',1710.00);
INSERT INTO sales_data VALUES ('2019-02-06','桔子','淘宝',705.00);
INSERT INTO sales_data VALUES ('2019-02-06','桔子','京东',1149.00);
INSERT INTO sales_data VALUES ('2019-02-06','桔子','店面',992.00);
INSERT INTO sales_data VALUES ('2019-02-06','香蕉','淘宝',997.00);
INSERT INTO sales_data VALUES ('2019-02-06','香蕉','京东',685.00);
INSERT INTO sales_data VALUES ('2019-02-06','香蕉','店面',732.00);
INSERT INTO sales_data VALUES ('2019-02-06','苹果','淘宝',1811.00);
INSERT INTO sales_data VALUES ('2019-02-06','苹果','京东',2138.00);
INSERT INTO sales_data VALUES ('2019-02-06','苹果','店面',1288.00);
INSERT INTO sales_data VALUES ('2019-02-07','桔子','淘宝',898.00);
INSERT INTO sales_data VALUES ('2019-02-07','桔子','京东',1124.00);
INSERT INTO sales_data VALUES ('2019-02-07','桔子','店面',1775.00);
INSERT INTO sales_data VALUES ('2019-02-07','香蕉','淘宝',1248.00);
INSERT INTO sales_data VALUES ('2019-02-07','香蕉','京东',1363.00);
INSERT INTO sales_data VALUES ('2019-02-07','香蕉','店面',1669.00);
INSERT INTO sales_data VALUES ('2019-02-07','苹果','淘宝',2114.00);
INSERT INTO sales_data VALUES ('2019-02-07','苹果','京东',1439.00);
INSERT INTO sales_data VALUES ('2019-02-07','苹果','店面',733.00);
INSERT INTO sales_data VALUES ('2019-02-08','桔子','淘宝',1648.00);
INSERT INTO sales_data VALUES ('2019-02-08','桔子','京东',1700.00);
INSERT INTO sales_data VALUES ('2019-02-08','桔子','店面',1880.00);
INSERT INTO sales_data VALUES ('2019-02-08','香蕉','淘宝',1241.00);
INSERT INTO sales_data VALUES ('2019-02-08','香蕉','京东',1022.00);
INSERT INTO sales_data VALUES ('2019-02-08','香蕉','店面',1511.00);
INSERT INTO sales_data VALUES ('2019-02-08','苹果','淘宝',1332.00);
INSERT INTO sales_data VALUES ('2019-02-08','苹果','京东',2088.00);
INSERT INTO sales_data VALUES ('2019-02-08','苹果','店面',2147.00);
INSERT INTO sales_data VALUES ('2019-02-09','桔子','淘宝',874.00);
INSERT INTO sales_data VALUES ('2019-02-09','桔子','京东',2069.00);
INSERT INTO sales_data VALUES ('2019-02-09','桔子','店面',1876.00);
INSERT INTO sales_data VALUES ('2019-02-09','香蕉','淘宝',1909.00);
INSERT INTO sales_data VALUES ('2019-02-09','香蕉','京东',2094.00);
INSERT INTO sales_data VALUES ('2019-02-09','香蕉','店面',845.00);
INSERT INTO sales_data VALUES ('2019-02-09','苹果','淘宝',721.00);
INSERT INTO sales_data VALUES ('2019-02-09','苹果','京东',912.00);
INSERT INTO sales_data VALUES ('2019-02-09','苹果','店面',850.00);
INSERT INTO sales_data VALUES ('2019-02-10','桔子','淘宝',778.00);
INSERT INTO sales_data VALUES ('2019-02-10','桔子','京东',2048.00);
INSERT INTO sales_data VALUES ('2019-02-10','桔子','店面',813.00);
INSERT INTO sales_data VALUES ('2019-02-10','香蕉','淘宝',1386.00);
INSERT INTO sales_data VALUES ('2019-02-10','香蕉','京东',761.00);
INSERT INTO sales_data VALUES ('2019-02-10','香蕉','店面',1252.00);
INSERT INTO sales_data VALUES ('2019-02-10','苹果','淘宝',976.00);
INSERT INTO sales_data VALUES ('2019-02-10','苹果','京东',1324.00);
INSERT INTO sales_data VALUES ('2019-02-10','苹果','店面',1930.00);
INSERT INTO sales_data VALUES ('2019-02-11','桔子','淘宝',1965.00);
INSERT INTO sales_data VALUES ('2019-02-11','桔子','京东',1258.00);
INSERT INTO sales_data VALUES ('2019-02-11','桔子','店面',1189.00);
INSERT INTO sales_data VALUES ('2019-02-11','香蕉','淘宝',2013.00);
INSERT INTO sales_data VALUES ('2019-02-11','香蕉','京东',716.00);
INSERT INTO sales_data VALUES ('2019-02-11','香蕉','店面',2199.00);
INSERT INTO sales_data VALUES ('2019-02-11','苹果','淘宝',1703.00);
INSERT INTO sales_data VALUES ('2019-02-11','苹果','京东',1267.00);
INSERT INTO sales_data VALUES ('2019-02-11','苹果','店面',1031.00);
INSERT INTO sales_data VALUES ('2019-02-12','桔子','淘宝',1029.00);
INSERT INTO sales_data VALUES ('2019-02-12','桔子','京东',1914.00);
INSERT INTO sales_data VALUES ('2019-02-12','桔子','店面',934.00);
INSERT INTO sales_data VALUES ('2019-02-12','香蕉','淘宝',986.00);
INSERT INTO sales_data VALUES ('2019-02-12','香蕉','京东',2093.00);
INSERT INTO sales_data VALUES ('2019-02-12','香蕉','店面',808.00);
INSERT INTO sales_data VALUES ('2019-02-12','苹果','淘宝',2167.00);
INSERT INTO sales_data VALUES ('2019-02-12','苹果','京东',1807.00);
INSERT INTO sales_data VALUES ('2019-02-12','苹果','店面',2207.00);
INSERT INTO sales_data VALUES ('2019-02-13','桔子','淘宝',822.00);
INSERT INTO sales_data VALUES ('2019-02-13','桔子','京东',1838.00);
INSERT INTO sales_data VALUES ('2019-02-13','桔子','店面',929.00);
INSERT INTO sales_data VALUES ('2019-02-13','香蕉','淘宝',977.00);
INSERT INTO sales_data VALUES ('2019-02-13','香蕉','京东',1916.00);
INSERT INTO sales_data VALUES ('2019-02-13','香蕉','店面',777.00);
INSERT INTO sales_data VALUES ('2019-02-13','苹果','淘宝',1091.00);
INSERT INTO sales_data VALUES ('2019-02-13','苹果','京东',1102.00);
INSERT INTO sales_data VALUES ('2019-02-13','苹果','店面',837.00);
INSERT INTO sales_data VALUES ('2019-02-14','桔子','淘宝',1648.00);
INSERT INTO sales_data VALUES ('2019-02-14','桔子','京东',1383.00);
INSERT INTO sales_data VALUES ('2019-02-14','桔子','店面',1466.00);
INSERT INTO sales_data VALUES ('2019-02-14','香蕉','淘宝',1378.00);
INSERT INTO sales_data VALUES ('2019-02-14','香蕉','京东',1144.00);
INSERT INTO sales_data VALUES ('2019-02-14','香蕉','店面',2019.00);
INSERT INTO sales_data VALUES ('2019-02-14','苹果','淘宝',1862.00);
INSERT INTO sales_data VALUES ('2019-02-14','苹果','京东',952.00);
INSERT INTO sales_data VALUES ('2019-02-14','苹果','店面',2029.00);
INSERT INTO sales_data VALUES ('2019-02-15','桔子','淘宝',1861.00);
INSERT INTO sales_data VALUES ('2019-02-15','桔子','京东',1955.00);
INSERT INTO sales_data VALUES ('2019-02-15','桔子','店面',1096.00);
INSERT INTO sales_data VALUES ('2019-02-15','香蕉','淘宝',2187.00);
INSERT INTO sales_data VALUES ('2019-02-15','香蕉','京东',774.00);
INSERT INTO sales_data VALUES ('2019-02-15','香蕉','店面',800.00);
INSERT INTO sales_data VALUES ('2019-02-15','苹果','淘宝',911.00);
INSERT INTO sales_data VALUES ('2019-02-15','苹果','京东',1050.00);
INSERT INTO sales_data VALUES ('2019-02-15','苹果','店面',2184.00);
INSERT INTO sales_data VALUES ('2019-02-16','桔子','淘宝',1013.00);
INSERT INTO sales_data VALUES ('2019-02-16','桔子','京东',1012.00);
INSERT INTO sales_data VALUES ('2019-02-16','桔子','店面',1786.00);
INSERT INTO sales_data VALUES ('2019-02-16','香蕉','淘宝',1010.00);
INSERT INTO sales_data VALUES ('2019-02-16','香蕉','京东',1119.00);
INSERT INTO sales_data VALUES ('2019-02-16','香蕉','店面',1408.00);
INSERT INTO sales_data VALUES ('2019-02-16','苹果','淘宝',1224.00);
INSERT INTO sales_data VALUES ('2019-02-16','苹果','京东',1382.00);
INSERT INTO sales_data VALUES ('2019-02-16','苹果','店面',1109.00);
INSERT INTO sales_data VALUES ('2019-02-17','桔子','淘宝',1290.00);
INSERT INTO sales_data VALUES ('2019-02-17','桔子','京东',1762.00);
INSERT INTO sales_data VALUES ('2019-02-17','桔子','店面',1501.00);
INSERT INTO sales_data VALUES ('2019-02-17','香蕉','淘宝',1413.00);
INSERT INTO sales_data VALUES ('2019-02-17','香蕉','京东',1190.00);
INSERT INTO sales_data VALUES ('2019-02-17','香蕉','店面',2165.00);
INSERT INTO sales_data VALUES ('2019-02-17','苹果','淘宝',2159.00);
INSERT INTO sales_data VALUES ('2019-02-17','苹果','京东',1848.00);
INSERT INTO sales_data VALUES ('2019-02-17','苹果','店面',1088.00);
INSERT INTO sales_data VALUES ('2019-02-18','桔子','淘宝',1963.00);
INSERT INTO sales_data VALUES ('2019-02-18','桔子','京东',1496.00);
INSERT INTO sales_data VALUES ('2019-02-18','桔子','店面',1325.00);
INSERT INTO sales_data VALUES ('2019-02-18','香蕉','淘宝',1772.00);
INSERT INTO sales_data VALUES ('2019-02-18','香蕉','京东',1132.00);
INSERT INTO sales_data VALUES ('2019-02-18','香蕉','店面',1055.00);
INSERT INTO sales_data VALUES ('2019-02-18','苹果','淘宝',2143.00);
INSERT INTO sales_data VALUES ('2019-02-18','苹果','京东',1094.00);
INSERT INTO sales_data VALUES ('2019-02-18','苹果','店面',1104.00);
INSERT INTO sales_data VALUES ('2019-02-19','桔子','淘宝',2224.00);
INSERT INTO sales_data VALUES ('2019-02-19','桔子','京东',1285.00);
INSERT INTO sales_data VALUES ('2019-02-19','桔子','店面',1434.00);
INSERT INTO sales_data VALUES ('2019-02-19','香蕉','淘宝',2182.00);
INSERT INTO sales_data VALUES ('2019-02-19','香蕉','京东',1568.00);
INSERT INTO sales_data VALUES ('2019-02-19','香蕉','店面',1716.00);
INSERT INTO sales_data VALUES ('2019-02-19','苹果','淘宝',1738.00);
INSERT INTO sales_data VALUES ('2019-02-19','苹果','京东',1848.00);
INSERT INTO sales_data VALUES ('2019-02-19','苹果','店面',2106.00);
INSERT INTO sales_data VALUES ('2019-02-20','桔子','淘宝',921.00);
INSERT INTO sales_data VALUES ('2019-02-20','桔子','京东',847.00);
INSERT INTO sales_data VALUES ('2019-02-20','桔子','店面',1262.00);
INSERT INTO sales_data VALUES ('2019-02-20','香蕉','淘宝',1300.00);
INSERT INTO sales_data VALUES ('2019-02-20','香蕉','京东',1402.00);
INSERT INTO sales_data VALUES ('2019-02-20','香蕉','店面',789.00);
INSERT INTO sales_data VALUES ('2019-02-20','苹果','淘宝',2067.00);
INSERT INTO sales_data VALUES ('2019-02-20','苹果','京东',2080.00);
INSERT INTO sales_data VALUES ('2019-02-20','苹果','店面',1244.00);
INSERT INTO sales_data VALUES ('2019-02-21','桔子','淘宝',2002.00);
INSERT INTO sales_data VALUES ('2019-02-21','桔子','京东',2009.00);
INSERT INTO sales_data VALUES ('2019-02-21','桔子','店面',863.00);
INSERT INTO sales_data VALUES ('2019-02-21','香蕉','淘宝',855.00);
INSERT INTO sales_data VALUES ('2019-02-21','香蕉','京东',1731.00);
INSERT INTO sales_data VALUES ('2019-02-21','香蕉','店面',1618.00);
INSERT INTO sales_data VALUES ('2019-02-21','苹果','淘宝',1440.00);
INSERT INTO sales_data VALUES ('2019-02-21','苹果','京东',1263.00);
INSERT INTO sales_data VALUES ('2019-02-21','苹果','店面',2010.00);
INSERT INTO sales_data VALUES ('2019-02-22','桔子','淘宝',1761.00);
INSERT INTO sales_data VALUES ('2019-02-22','桔子','京东',1171.00);
INSERT INTO sales_data VALUES ('2019-02-22','桔子','店面',869.00);
INSERT INTO sales_data VALUES ('2019-02-22','香蕉','淘宝',2125.00);
INSERT INTO sales_data VALUES ('2019-02-22','香蕉','京东',1150.00);
INSERT INTO sales_data VALUES ('2019-02-22','香蕉','店面',1409.00);
INSERT INTO sales_data VALUES ('2019-02-22','苹果','淘宝',1314.00);
INSERT INTO sales_data VALUES ('2019-02-22','苹果','京东',1087.00);
INSERT INTO sales_data VALUES ('2019-02-22','苹果','店面',2232.00);
INSERT INTO sales_data VALUES ('2019-02-23','桔子','淘宝',790.00);
INSERT INTO sales_data VALUES ('2019-02-23','桔子','京东',2085.00);
INSERT INTO sales_data VALUES ('2019-02-23','桔子','店面',1840.00);
INSERT INTO sales_data VALUES ('2019-02-23','香蕉','淘宝',2151.00);
INSERT INTO sales_data VALUES ('2019-02-23','香蕉','京东',2257.00);
INSERT INTO sales_data VALUES ('2019-02-23','香蕉','店面',1937.00);
INSERT INTO sales_data VALUES ('2019-02-23','苹果','淘宝',1163.00);
INSERT INTO sales_data VALUES ('2019-02-23','苹果','京东',1307.00);
INSERT INTO sales_data VALUES ('2019-02-23','苹果','店面',1089.00);
INSERT INTO sales_data VALUES ('2019-02-24','桔子','淘宝',1208.00);
INSERT INTO sales_data VALUES ('2019-02-24','桔子','京东',1129.00);
INSERT INTO sales_data VALUES ('2019-02-24','桔子','店面',924.00);
INSERT INTO sales_data VALUES ('2019-02-24','香蕉','淘宝',1702.00);
INSERT INTO sales_data VALUES ('2019-02-24','香蕉','京东',875.00);
INSERT INTO sales_data VALUES ('2019-02-24','香蕉','店面',2178.00);
INSERT INTO sales_data VALUES ('2019-02-24','苹果','淘宝',1810.00);
INSERT INTO sales_data VALUES ('2019-02-24','苹果','京东',975.00);
INSERT INTO sales_data VALUES ('2019-02-24','苹果','店面',1655.00);
INSERT INTO sales_data VALUES ('2019-02-25','桔子','淘宝',1178.00);
INSERT INTO sales_data VALUES ('2019-02-25','桔子','京东',1666.00);
INSERT INTO sales_data VALUES ('2019-02-25','桔子','店面',2168.00);
INSERT INTO sales_data VALUES ('2019-02-25','香蕉','淘宝',933.00);
INSERT INTO sales_data VALUES ('2019-02-25','香蕉','京东',1166.00);
INSERT INTO sales_data VALUES ('2019-02-25','香蕉','店面',1079.00);
INSERT INTO sales_data VALUES ('2019-02-25','苹果','淘宝',1042.00);
INSERT INTO sales_data VALUES ('2019-02-25','苹果','京东',1031.00);
INSERT INTO sales_data VALUES ('2019-02-25','苹果','店面',1469.00);
INSERT INTO sales_data VALUES ('2019-02-26','桔子','淘宝',1695.00);
INSERT INTO sales_data VALUES ('2019-02-26','桔子','京东',1590.00);
INSERT INTO sales_data VALUES ('2019-02-26','桔子','店面',1802.00);
INSERT INTO sales_data VALUES ('2019-02-26','香蕉','淘宝',1667.00);
INSERT INTO sales_data VALUES ('2019-02-26','香蕉','京东',1615.00);
INSERT INTO sales_data VALUES ('2019-02-26','香蕉','店面',1622.00);
INSERT INTO sales_data VALUES ('2019-02-26','苹果','淘宝',1242.00);
INSERT INTO sales_data VALUES ('2019-02-26','苹果','京东',1501.00);
INSERT INTO sales_data VALUES ('2019-02-26','苹果','店面',1614.00);
INSERT INTO sales_data VALUES ('2019-02-27','桔子','淘宝',919.00);
INSERT INTO sales_data VALUES ('2019-02-27','桔子','京东',1904.00);
INSERT INTO sales_data VALUES ('2019-02-27','桔子','店面',2161.00);
INSERT INTO sales_data VALUES ('2019-02-27','香蕉','淘宝',1243.00);
INSERT INTO sales_data VALUES ('2019-02-27','香蕉','京东',842.00);
INSERT INTO sales_data VALUES ('2019-02-27','香蕉','店面',1019.00);
INSERT INTO sales_data VALUES ('2019-02-27','苹果','淘宝',1397.00);
INSERT INTO sales_data VALUES ('2019-02-27','苹果','京东',1774.00);
INSERT INTO sales_data VALUES ('2019-02-27','苹果','店面',1125.00);
INSERT INTO sales_data VALUES ('2019-02-28','桔子','淘宝',1310.00);
INSERT INTO sales_data VALUES ('2019-02-28','桔子','京东',1319.00);
INSERT INTO sales_data VALUES ('2019-02-28','桔子','店面',1335.00);
INSERT INTO sales_data VALUES ('2019-02-28','香蕉','淘宝',2195.00);
INSERT INTO sales_data VALUES ('2019-02-28','香蕉','京东',1721.00);
INSERT INTO sales_data VALUES ('2019-02-28','香蕉','店面',2226.00);
INSERT INTO sales_data VALUES ('2019-02-28','苹果','淘宝',2088.00);
INSERT INTO sales_data VALUES ('2019-02-28','苹果','京东',1879.00);
INSERT INTO sales_data VALUES ('2019-02-28','苹果','店面',1117.00);
INSERT INTO sales_data VALUES ('2019-03-01','桔子','淘宝',897.00);
INSERT INTO sales_data VALUES ('2019-03-01','桔子','京东',2151.00);
INSERT INTO sales_data VALUES ('2019-03-01','桔子','店面',1378.00);
INSERT INTO sales_data VALUES ('2019-03-01','香蕉','淘宝',1591.00);
INSERT INTO sales_data VALUES ('2019-03-01','香蕉','京东',1566.00);
INSERT INTO sales_data VALUES ('2019-03-01','香蕉','店面',2187.00);
INSERT INTO sales_data VALUES ('2019-03-01','苹果','淘宝',1113.00);
INSERT INTO sales_data VALUES ('2019-03-01','苹果','京东',953.00);
INSERT INTO sales_data VALUES ('2019-03-01','苹果','店面',1522.00);
INSERT INTO sales_data VALUES ('2019-03-02','桔子','淘宝',1960.00);
INSERT INTO sales_data VALUES ('2019-03-02','桔子','京东',1420.00);
INSERT INTO sales_data VALUES ('2019-03-02','桔子','店面',2248.00);
INSERT INTO sales_data VALUES ('2019-03-02','香蕉','淘宝',1294.00);
INSERT INTO sales_data VALUES ('2019-03-02','香蕉','京东',1554.00);
INSERT INTO sales_data VALUES ('2019-03-02','香蕉','店面',1868.00);
INSERT INTO sales_data VALUES ('2019-03-02','苹果','淘宝',1169.00);
INSERT INTO sales_data VALUES ('2019-03-02','苹果','京东',2012.00);
INSERT INTO sales_data VALUES ('2019-03-02','苹果','店面',1924.00);
INSERT INTO sales_data VALUES ('2019-03-03','桔子','淘宝',1409.00);
INSERT INTO sales_data VALUES ('2019-03-03','桔子','京东',1129.00);
INSERT INTO sales_data VALUES ('2019-03-03','桔子','店面',1418.00);
INSERT INTO sales_data VALUES ('2019-03-03','香蕉','淘宝',1748.00);
INSERT INTO sales_data VALUES ('2019-03-03','香蕉','京东',1649.00);
INSERT INTO sales_data VALUES ('2019-03-03','香蕉','店面',1947.00);
INSERT INTO sales_data VALUES ('2019-03-03','苹果','淘宝',2294.00);
INSERT INTO sales_data VALUES ('2019-03-03','苹果','京东',1554.00);
INSERT INTO sales_data VALUES ('2019-03-03','苹果','店面',1378.00);
INSERT INTO sales_data VALUES ('2019-03-04','桔子','淘宝',2234.00);
INSERT INTO sales_data VALUES ('2019-03-04','桔子','京东',1357.00);
INSERT INTO sales_data VALUES ('2019-03-04','桔子','店面',972.00);
INSERT INTO sales_data VALUES ('2019-03-04','香蕉','淘宝',1061.00);
INSERT INTO sales_data VALUES ('2019-03-04','香蕉','京东',1459.00);
INSERT INTO sales_data VALUES ('2019-03-04','香蕉','店面',828.00);
INSERT INTO sales_data VALUES ('2019-03-04','苹果','淘宝',1644.00);
INSERT INTO sales_data VALUES ('2019-03-04','苹果','京东',2255.00);
INSERT INTO sales_data VALUES ('2019-03-04','苹果','店面',1599.00);
INSERT INTO sales_data VALUES ('2019-03-05','桔子','淘宝',1542.00);
INSERT INTO sales_data VALUES ('2019-03-05','桔子','京东',1078.00);
INSERT INTO sales_data VALUES ('2019-03-05','桔子','店面',1762.00);
INSERT INTO sales_data VALUES ('2019-03-05','香蕉','淘宝',2269.00);
INSERT INTO sales_data VALUES ('2019-03-05','香蕉','京东',2238.00);
INSERT INTO sales_data VALUES ('2019-03-05','香蕉','店面',882.00);
INSERT INTO sales_data VALUES ('2019-03-05','苹果','淘宝',2217.00);
INSERT INTO sales_data VALUES ('2019-03-05','苹果','京东',1232.00);
INSERT INTO sales_data VALUES ('2019-03-05','苹果','店面',1636.00);
INSERT INTO sales_data VALUES ('2019-03-06','桔子','淘宝',1790.00);
INSERT INTO sales_data VALUES ('2019-03-06','桔子','京东',1606.00);
INSERT INTO sales_data VALUES ('2019-03-06','桔子','店面',1352.00);
INSERT INTO sales_data VALUES ('2019-03-06','香蕉','淘宝',1414.00);
INSERT INTO sales_data VALUES ('2019-03-06','香蕉','京东',2210.00);
INSERT INTO sales_data VALUES ('2019-03-06','香蕉','店面',1676.00);
INSERT INTO sales_data VALUES ('2019-03-06','苹果','淘宝',2028.00);
INSERT INTO sales_data VALUES ('2019-03-06','苹果','京东',1653.00);
INSERT INTO sales_data VALUES ('2019-03-06','苹果','店面',1020.00);
INSERT INTO sales_data VALUES ('2019-03-07','桔子','淘宝',1675.00);
INSERT INTO sales_data VALUES ('2019-03-07','桔子','京东',1647.00);
INSERT INTO sales_data VALUES ('2019-03-07','桔子','店面',1775.00);
INSERT INTO sales_data VALUES ('2019-03-07','香蕉','淘宝',2248.00);
INSERT INTO sales_data VALUES ('2019-03-07','香蕉','京东',1571.00);
INSERT INTO sales_data VALUES ('2019-03-07','香蕉','店面',2321.00);
INSERT INTO sales_data VALUES ('2019-03-07','苹果','淘宝',910.00);
INSERT INTO sales_data VALUES ('2019-03-07','苹果','京东',1822.00);
INSERT INTO sales_data VALUES ('2019-03-07','苹果','店面',1470.00);
INSERT INTO sales_data VALUES ('2019-03-08','桔子','淘宝',933.00);
INSERT INTO sales_data VALUES ('2019-03-08','桔子','京东',1161.00);
INSERT INTO sales_data VALUES ('2019-03-08','桔子','店面',1420.00);
INSERT INTO sales_data VALUES ('2019-03-08','香蕉','淘宝',1722.00);
INSERT INTO sales_data VALUES ('2019-03-08','香蕉','京东',1888.00);
INSERT INTO sales_data VALUES ('2019-03-08','香蕉','店面',1683.00);
INSERT INTO sales_data VALUES ('2019-03-08','苹果','淘宝',1169.00);
INSERT INTO sales_data VALUES ('2019-03-08','苹果','京东',1842.00);
INSERT INTO sales_data VALUES ('2019-03-08','苹果','店面',1606.00);
INSERT INTO sales_data VALUES ('2019-03-09','桔子','淘宝',1241.00);
INSERT INTO sales_data VALUES ('2019-03-09','桔子','京东',1749.00);
INSERT INTO sales_data VALUES ('2019-03-09','桔子','店面',2028.00);
INSERT INTO sales_data VALUES ('2019-03-09','香蕉','淘宝',2061.00);
INSERT INTO sales_data VALUES ('2019-03-09','香蕉','京东',1219.00);
INSERT INTO sales_data VALUES ('2019-03-09','香蕉','店面',1314.00);
INSERT INTO sales_data VALUES ('2019-03-09','苹果','淘宝',1094.00);
INSERT INTO sales_data VALUES ('2019-03-09','苹果','京东',1813.00);
INSERT INTO sales_data VALUES ('2019-03-09','苹果','店面',1203.00);
INSERT INTO sales_data VALUES ('2019-03-10','桔子','淘宝',1955.00);
INSERT INTO sales_data VALUES ('2019-03-10','桔子','京东',1526.00);
INSERT INTO sales_data VALUES ('2019-03-10','桔子','店面',2041.00);
INSERT INTO sales_data VALUES ('2019-03-10','香蕉','淘宝',2155.00);
INSERT INTO sales_data VALUES ('2019-03-10','香蕉','京东',875.00);
INSERT INTO sales_data VALUES ('2019-03-10','香蕉','店面',1363.00);
INSERT INTO sales_data VALUES ('2019-03-10','苹果','淘宝',1605.00);
INSERT INTO sales_data VALUES ('2019-03-10','苹果','京东',2298.00);
INSERT INTO sales_data VALUES ('2019-03-10','苹果','店面',2109.00);
INSERT INTO sales_data VALUES ('2019-03-11','桔子','淘宝',1606.00);
INSERT INTO sales_data VALUES ('2019-03-11','桔子','京东',888.00);
INSERT INTO sales_data VALUES ('2019-03-11','桔子','店面',1611.00);
INSERT INTO sales_data VALUES ('2019-03-11','香蕉','淘宝',2251.00);
INSERT INTO sales_data VALUES ('2019-03-11','香蕉','京东',991.00);
INSERT INTO sales_data VALUES ('2019-03-11','香蕉','店面',1942.00);
INSERT INTO sales_data VALUES ('2019-03-11','苹果','淘宝',1341.00);
INSERT INTO sales_data VALUES ('2019-03-11','苹果','京东',1883.00);
INSERT INTO sales_data VALUES ('2019-03-11','苹果','店面',1500.00);
INSERT INTO sales_data VALUES ('2019-03-12','桔子','淘宝',2199.00);
INSERT INTO sales_data VALUES ('2019-03-12','桔子','京东',2226.00);
INSERT INTO sales_data VALUES ('2019-03-12','桔子','店面',1017.00);
INSERT INTO sales_data VALUES ('2019-03-12','香蕉','淘宝',1476.00);
INSERT INTO sales_data VALUES ('2019-03-12','香蕉','京东',1132.00);
INSERT INTO sales_data VALUES ('2019-03-12','香蕉','店面',1931.00);
INSERT INTO sales_data VALUES ('2019-03-12','苹果','淘宝',1168.00);
INSERT INTO sales_data VALUES ('2019-03-12','苹果','京东',858.00);
INSERT INTO sales_data VALUES ('2019-03-12','苹果','店面',2314.00);
INSERT INTO sales_data VALUES ('2019-03-13','桔子','淘宝',1652.00);
INSERT INTO sales_data VALUES ('2019-03-13','桔子','京东',1122.00);
INSERT INTO sales_data VALUES ('2019-03-13','桔子','店面',1797.00);
INSERT INTO sales_data VALUES ('2019-03-13','香蕉','淘宝',2020.00);
INSERT INTO sales_data VALUES ('2019-03-13','香蕉','京东',2237.00);
INSERT INTO sales_data VALUES ('2019-03-13','香蕉','店面',983.00);
INSERT INTO sales_data VALUES ('2019-03-13','苹果','淘宝',1721.00);
INSERT INTO sales_data VALUES ('2019-03-13','苹果','京东',2053.00);
INSERT INTO sales_data VALUES ('2019-03-13','苹果','店面',1018.00);
INSERT INTO sales_data VALUES ('2019-03-14','桔子','淘宝',2249.00);
INSERT INTO sales_data VALUES ('2019-03-14','桔子','京东',1323.00);
INSERT INTO sales_data VALUES ('2019-03-14','桔子','店面',982.00);
INSERT INTO sales_data VALUES ('2019-03-14','香蕉','淘宝',2018.00);
INSERT INTO sales_data VALUES ('2019-03-14','香蕉','京东',2084.00);
INSERT INTO sales_data VALUES ('2019-03-14','香蕉','店面',1025.00);
INSERT INTO sales_data VALUES ('2019-03-14','苹果','淘宝',1284.00);
INSERT INTO sales_data VALUES ('2019-03-14','苹果','京东',1990.00);
INSERT INTO sales_data VALUES ('2019-03-14','苹果','店面',1171.00);
INSERT INTO sales_data VALUES ('2019-03-15','桔子','淘宝',886.00);
INSERT INTO sales_data VALUES ('2019-03-15','桔子','京东',992.00);
INSERT INTO sales_data VALUES ('2019-03-15','桔子','店面',2214.00);
INSERT INTO sales_data VALUES ('2019-03-15','香蕉','淘宝',1541.00);
INSERT INTO sales_data VALUES ('2019-03-15','香蕉','京东',2341.00);
INSERT INTO sales_data VALUES ('2019-03-15','香蕉','店面',2090.00);
INSERT INTO sales_data VALUES ('2019-03-15','苹果','淘宝',1708.00);
INSERT INTO sales_data VALUES ('2019-03-15','苹果','京东',1467.00);
INSERT INTO sales_data VALUES ('2019-03-15','苹果','店面',872.00);
INSERT INTO sales_data VALUES ('2019-03-16','桔子','淘宝',1293.00);
INSERT INTO sales_data VALUES ('2019-03-16','桔子','京东',1790.00);
INSERT INTO sales_data VALUES ('2019-03-16','桔子','店面',885.00);
INSERT INTO sales_data VALUES ('2019-03-16','香蕉','淘宝',1258.00);
INSERT INTO sales_data VALUES ('2019-03-16','香蕉','京东',1087.00);
INSERT INTO sales_data VALUES ('2019-03-16','香蕉','店面',1153.00);
INSERT INTO sales_data VALUES ('2019-03-16','苹果','淘宝',2200.00);
INSERT INTO sales_data VALUES ('2019-03-16','苹果','京东',2252.00);
INSERT INTO sales_data VALUES ('2019-03-16','苹果','店面',1035.00);
INSERT INTO sales_data VALUES ('2019-03-17','桔子','淘宝',2333.00);
INSERT INTO sales_data VALUES ('2019-03-17','桔子','京东',1624.00);
INSERT INTO sales_data VALUES ('2019-03-17','桔子','店面',2238.00);
INSERT INTO sales_data VALUES ('2019-03-17','香蕉','淘宝',996.00);
INSERT INTO sales_data VALUES ('2019-03-17','香蕉','京东',1513.00);
INSERT INTO sales_data VALUES ('2019-03-17','香蕉','店面',1200.00);
INSERT INTO sales_data VALUES ('2019-03-17','苹果','淘宝',1118.00);
INSERT INTO sales_data VALUES ('2019-03-17','苹果','京东',1171.00);
INSERT INTO sales_data VALUES ('2019-03-17','苹果','店面',924.00);
INSERT INTO sales_data VALUES ('2019-03-18','桔子','淘宝',1288.00);
INSERT INTO sales_data VALUES ('2019-03-18','桔子','京东',1600.00);
INSERT INTO sales_data VALUES ('2019-03-18','桔子','店面',2059.00);
INSERT INTO sales_data VALUES ('2019-03-18','香蕉','淘宝',1599.00);
INSERT INTO sales_data VALUES ('2019-03-18','香蕉','京东',1622.00);
INSERT INTO sales_data VALUES ('2019-03-18','香蕉','店面',2186.00);
INSERT INTO sales_data VALUES ('2019-03-18','苹果','淘宝',1448.00);
INSERT INTO sales_data VALUES ('2019-03-18','苹果','京东',2298.00);
INSERT INTO sales_data VALUES ('2019-03-18','苹果','店面',2162.00);
INSERT INTO sales_data VALUES ('2019-03-19','桔子','淘宝',1178.00);
INSERT INTO sales_data VALUES ('2019-03-19','桔子','京东',1646.00);
INSERT INTO sales_data VALUES ('2019-03-19','桔子','店面',1268.00);
INSERT INTO sales_data VALUES ('2019-03-19','香蕉','淘宝',1185.00);
INSERT INTO sales_data VALUES ('2019-03-19','香蕉','京东',2069.00);
INSERT INTO sales_data VALUES ('2019-03-19','香蕉','店面',2188.00);
INSERT INTO sales_data VALUES ('2019-03-19','苹果','淘宝',1200.00);
INSERT INTO sales_data VALUES ('2019-03-19','苹果','京东',957.00);
INSERT INTO sales_data VALUES ('2019-03-19','苹果','店面',905.00);
INSERT INTO sales_data VALUES ('2019-03-20','桔子','淘宝',1488.00);
INSERT INTO sales_data VALUES ('2019-03-20','桔子','京东',2292.00);
INSERT INTO sales_data VALUES ('2019-03-20','桔子','店面',2292.00);
INSERT INTO sales_data VALUES ('2019-03-20','香蕉','淘宝',1653.00);
INSERT INTO sales_data VALUES ('2019-03-20','香蕉','京东',2250.00);
INSERT INTO sales_data VALUES ('2019-03-20','香蕉','店面',1540.00);
INSERT INTO sales_data VALUES ('2019-03-20','苹果','淘宝',1516.00);
INSERT INTO sales_data VALUES ('2019-03-20','苹果','京东',2371.00);
INSERT INTO sales_data VALUES ('2019-03-20','苹果','店面',2178.00);
INSERT INTO sales_data VALUES ('2019-03-21','桔子','淘宝',1846.00);
INSERT INTO sales_data VALUES ('2019-03-21','桔子','京东',1119.00);
INSERT INTO sales_data VALUES ('2019-03-21','桔子','店面',980.00);
INSERT INTO sales_data VALUES ('2019-03-21','香蕉','淘宝',1895.00);
INSERT INTO sales_data VALUES ('2019-03-21','香蕉','京东',1527.00);
INSERT INTO sales_data VALUES ('2019-03-21','香蕉','店面',1700.00);
INSERT INTO sales_data VALUES ('2019-03-21','苹果','淘宝',1574.00);
INSERT INTO sales_data VALUES ('2019-03-21','苹果','京东',2246.00);
INSERT INTO sales_data VALUES ('2019-03-21','苹果','店面',942.00);
INSERT INTO sales_data VALUES ('2019-03-22','桔子','淘宝',1384.00);
INSERT INTO sales_data VALUES ('2019-03-22','桔子','京东',1319.00);
INSERT INTO sales_data VALUES ('2019-03-22','桔子','店面',2365.00);
INSERT INTO sales_data VALUES ('2019-03-22','香蕉','淘宝',1166.00);
INSERT INTO sales_data VALUES ('2019-03-22','香蕉','京东',1612.00);
INSERT INTO sales_data VALUES ('2019-03-22','香蕉','店面',1626.00);
INSERT INTO sales_data VALUES ('2019-03-22','苹果','淘宝',1549.00);
INSERT INTO sales_data VALUES ('2019-03-22','苹果','京东',1912.00);
INSERT INTO sales_data VALUES ('2019-03-22','苹果','店面',1311.00);
INSERT INTO sales_data VALUES ('2019-03-23','桔子','淘宝',1357.00);
INSERT INTO sales_data VALUES ('2019-03-23','桔子','京东',2232.00);
INSERT INTO sales_data VALUES ('2019-03-23','桔子','店面',1388.00);
INSERT INTO sales_data VALUES ('2019-03-23','香蕉','淘宝',1377.00);
INSERT INTO sales_data VALUES ('2019-03-23','香蕉','京东',1330.00);
INSERT INTO sales_data VALUES ('2019-03-23','香蕉','店面',1290.00);
INSERT INTO sales_data VALUES ('2019-03-23','苹果','淘宝',1279.00);
INSERT INTO sales_data VALUES ('2019-03-23','苹果','京东',2093.00);
INSERT INTO sales_data VALUES ('2019-03-23','苹果','店面',1150.00);
INSERT INTO sales_data VALUES ('2019-03-24','桔子','淘宝',1935.00);
INSERT INTO sales_data VALUES ('2019-03-24','桔子','京东',1224.00);
INSERT INTO sales_data VALUES ('2019-03-24','桔子','店面',1136.00);
INSERT INTO sales_data VALUES ('2019-03-24','香蕉','淘宝',1723.00);
INSERT INTO sales_data VALUES ('2019-03-24','香蕉','京东',2174.00);
INSERT INTO sales_data VALUES ('2019-03-24','香蕉','店面',1360.00);
INSERT INTO sales_data VALUES ('2019-03-24','苹果','淘宝',1808.00);
INSERT INTO sales_data VALUES ('2019-03-24','苹果','京东',1674.00);
INSERT INTO sales_data VALUES ('2019-03-24','苹果','店面',1992.00);
INSERT INTO sales_data VALUES ('2019-03-25','桔子','淘宝',1118.00);
INSERT INTO sales_data VALUES ('2019-03-25','桔子','京东',2358.00);
INSERT INTO sales_data VALUES ('2019-03-25','桔子','店面',1848.00);
INSERT INTO sales_data VALUES ('2019-03-25','香蕉','淘宝',1165.00);
INSERT INTO sales_data VALUES ('2019-03-25','香蕉','京东',1342.00);
INSERT INTO sales_data VALUES ('2019-03-25','香蕉','店面',2266.00);
INSERT INTO sales_data VALUES ('2019-03-25','苹果','淘宝',1130.00);
INSERT INTO sales_data VALUES ('2019-03-25','苹果','京东',1608.00);
INSERT INTO sales_data VALUES ('2019-03-25','苹果','店面',1478.00);
INSERT INTO sales_data VALUES ('2019-03-26','桔子','淘宝',1862.00);
INSERT INTO sales_data VALUES ('2019-03-26','桔子','京东',2262.00);
INSERT INTO sales_data VALUES ('2019-03-26','桔子','店面',995.00);
INSERT INTO sales_data VALUES ('2019-03-26','香蕉','淘宝',2273.00);
INSERT INTO sales_data VALUES ('2019-03-26','香蕉','京东',1214.00);
INSERT INTO sales_data VALUES ('2019-03-26','香蕉','店面',2322.00);
INSERT INTO sales_data VALUES ('2019-03-26','苹果','淘宝',1256.00);
INSERT INTO sales_data VALUES ('2019-03-26','苹果','京东',1687.00);
INSERT INTO sales_data VALUES ('2019-03-26','苹果','店面',1247.00);
INSERT INTO sales_data VALUES ('2019-03-27','桔子','淘宝',1646.00);
INSERT INTO sales_data VALUES ('2019-03-27','桔子','京东',2066.00);
INSERT INTO sales_data VALUES ('2019-03-27','桔子','店面',940.00);
INSERT INTO sales_data VALUES ('2019-03-27','香蕉','淘宝',1891.00);
INSERT INTO sales_data VALUES ('2019-03-27','香蕉','京东',1590.00);
INSERT INTO sales_data VALUES ('2019-03-27','香蕉','店面',1254.00);
INSERT INTO sales_data VALUES ('2019-03-27','苹果','淘宝',2117.00);
INSERT INTO sales_data VALUES ('2019-03-27','苹果','京东',2403.00);
INSERT INTO sales_data VALUES ('2019-03-27','苹果','店面',1018.00);
INSERT INTO sales_data VALUES ('2019-03-28','桔子','淘宝',1072.00);
INSERT INTO sales_data VALUES ('2019-03-28','桔子','京东',1806.00);
INSERT INTO sales_data VALUES ('2019-03-28','桔子','店面',1787.00);
INSERT INTO sales_data VALUES ('2019-03-28','香蕉','淘宝',2154.00);
INSERT INTO sales_data VALUES ('2019-03-28','香蕉','京东',2009.00);
INSERT INTO sales_data VALUES ('2019-03-28','香蕉','店面',1730.00);
INSERT INTO sales_data VALUES ('2019-03-28','苹果','淘宝',1586.00);
INSERT INTO sales_data VALUES ('2019-03-28','苹果','京东',2259.00);
INSERT INTO sales_data VALUES ('2019-03-28','苹果','店面',2157.00);
INSERT INTO sales_data VALUES ('2019-03-29','桔子','淘宝',1443.00);
INSERT INTO sales_data VALUES ('2019-03-29','桔子','京东',979.00);
INSERT INTO sales_data VALUES ('2019-03-29','桔子','店面',1355.00);
INSERT INTO sales_data VALUES ('2019-03-29','香蕉','淘宝',2006.00);
INSERT INTO sales_data VALUES ('2019-03-29','香蕉','京东',1921.00);
INSERT INTO sales_data VALUES ('2019-03-29','香蕉','店面',1197.00);
INSERT INTO sales_data VALUES ('2019-03-29','苹果','淘宝',2081.00);
INSERT INTO sales_data VALUES ('2019-03-29','苹果','京东',1773.00);
INSERT INTO sales_data VALUES ('2019-03-29','苹果','店面',1492.00);
INSERT INTO sales_data VALUES ('2019-03-30','桔子','淘宝',1987.00);
INSERT INTO sales_data VALUES ('2019-03-30','桔子','京东',2114.00);
INSERT INTO sales_data VALUES ('2019-03-30','桔子','店面',2263.00);
INSERT INTO sales_data VALUES ('2019-03-30','香蕉','淘宝',2314.00);
INSERT INTO sales_data VALUES ('2019-03-30','香蕉','京东',1335.00);
INSERT INTO sales_data VALUES ('2019-03-30','香蕉','店面',1904.00);
INSERT INTO sales_data VALUES ('2019-03-30','苹果','淘宝',2329.00);
INSERT INTO sales_data VALUES ('2019-03-30','苹果','京东',2300.00);
INSERT INTO sales_data VALUES ('2019-03-30','苹果','店面',1069.00);
INSERT INTO sales_data VALUES ('2019-03-31','桔子','淘宝',1163.00);
INSERT INTO sales_data VALUES ('2019-03-31','桔子','京东',1997.00);
INSERT INTO sales_data VALUES ('2019-03-31','桔子','店面',1052.00);
INSERT INTO sales_data VALUES ('2019-03-31','香蕉','淘宝',1256.00);
INSERT INTO sales_data VALUES ('2019-03-31','香蕉','京东',2139.00);
INSERT INTO sales_data VALUES ('2019-03-31','香蕉','店面',1928.00);
INSERT INTO sales_data VALUES ('2019-03-31','苹果','淘宝',2113.00);
INSERT INTO sales_data VALUES ('2019-03-31','苹果','京东',1863.00);
INSERT INTO sales_data VALUES ('2019-03-31','苹果','店面',1507.00);
INSERT INTO sales_data VALUES ('2019-04-01','桔子','淘宝',1418.00);
INSERT INTO sales_data VALUES ('2019-04-01','桔子','京东',1024.00);
INSERT INTO sales_data VALUES ('2019-04-01','桔子','店面',1341.00);
INSERT INTO sales_data VALUES ('2019-04-01','香蕉','淘宝',1145.00);
INSERT INTO sales_data VALUES ('2019-04-01','香蕉','京东',1532.00);
INSERT INTO sales_data VALUES ('2019-04-01','香蕉','店面',1385.00);
INSERT INTO sales_data VALUES ('2019-04-01','苹果','淘宝',1565.00);
INSERT INTO sales_data VALUES ('2019-04-01','苹果','京东',1103.00);
INSERT INTO sales_data VALUES ('2019-04-01','苹果','店面',2371.00);
INSERT INTO sales_data VALUES ('2019-04-02','桔子','淘宝',1832.00);
INSERT INTO sales_data VALUES ('2019-04-02','桔子','京东',2253.00);
INSERT INTO sales_data VALUES ('2019-04-02','桔子','店面',1714.00);
INSERT INTO sales_data VALUES ('2019-04-02','香蕉','淘宝',2389.00);
INSERT INTO sales_data VALUES ('2019-04-02','香蕉','京东',1801.00);
INSERT INTO sales_data VALUES ('2019-04-02','香蕉','店面',1388.00);
INSERT INTO sales_data VALUES ('2019-04-02','苹果','淘宝',2212.00);
INSERT INTO sales_data VALUES ('2019-04-02','苹果','京东',1675.00);
INSERT INTO sales_data VALUES ('2019-04-02','苹果','店面',1783.00);
INSERT INTO sales_data VALUES ('2019-04-03','桔子','淘宝',1681.00);
INSERT INTO sales_data VALUES ('2019-04-03','桔子','京东',1570.00);
INSERT INTO sales_data VALUES ('2019-04-03','桔子','店面',1648.00);
INSERT INTO sales_data VALUES ('2019-04-03','香蕉','淘宝',1810.00);
INSERT INTO sales_data VALUES ('2019-04-03','香蕉','京东',1787.00);
INSERT INTO sales_data VALUES ('2019-04-03','香蕉','店面',1200.00);
INSERT INTO sales_data VALUES ('2019-04-03','苹果','淘宝',1917.00);
INSERT INTO sales_data VALUES ('2019-04-03','苹果','京东',2098.00);
INSERT INTO sales_data VALUES ('2019-04-03','苹果','店面',2394.00);
INSERT INTO sales_data VALUES ('2019-04-04','桔子','淘宝',1406.00);
INSERT INTO sales_data VALUES ('2019-04-04','桔子','京东',1771.00);
INSERT INTO sales_data VALUES ('2019-04-04','桔子','店面',1816.00);
INSERT INTO sales_data VALUES ('2019-04-04','香蕉','淘宝',1968.00);
INSERT INTO sales_data VALUES ('2019-04-04','香蕉','京东',2239.00);
INSERT INTO sales_data VALUES ('2019-04-04','香蕉','店面',1890.00);
INSERT INTO sales_data VALUES ('2019-04-04','苹果','淘宝',2359.00);
INSERT INTO sales_data VALUES ('2019-04-04','苹果','京东',2434.00);
INSERT INTO sales_data VALUES ('2019-04-04','苹果','店面',972.00);
INSERT INTO sales_data VALUES ('2019-04-05','桔子','淘宝',1299.00);
INSERT INTO sales_data VALUES ('2019-04-05','桔子','京东',1554.00);
INSERT INTO sales_data VALUES ('2019-04-05','桔子','店面',1130.00);
INSERT INTO sales_data VALUES ('2019-04-05','香蕉','淘宝',1220.00);
INSERT INTO sales_data VALUES ('2019-04-05','香蕉','京东',2432.00);
INSERT INTO sales_data VALUES ('2019-04-05','香蕉','店面',2428.00);
INSERT INTO sales_data VALUES ('2019-04-05','苹果','淘宝',1979.00);
INSERT INTO sales_data VALUES ('2019-04-05','苹果','京东',2366.00);
INSERT INTO sales_data VALUES ('2019-04-05','苹果','店面',1774.00);
INSERT INTO sales_data VALUES ('2019-04-06','桔子','淘宝',2417.00);
INSERT INTO sales_data VALUES ('2019-04-06','桔子','京东',2128.00);
INSERT INTO sales_data VALUES ('2019-04-06','桔子','店面',1000.00);
INSERT INTO sales_data VALUES ('2019-04-06','香蕉','淘宝',1744.00);
INSERT INTO sales_data VALUES ('2019-04-06','香蕉','京东',1349.00);
INSERT INTO sales_data VALUES ('2019-04-06','香蕉','店面',1609.00);
INSERT INTO sales_data VALUES ('2019-04-06','苹果','淘宝',2432.00);
INSERT INTO sales_data VALUES ('2019-04-06','苹果','京东',2199.00);
INSERT INTO sales_data VALUES ('2019-04-06','苹果','店面',2437.00);
INSERT INTO sales_data VALUES ('2019-04-07','桔子','淘宝',1177.00);
INSERT INTO sales_data VALUES ('2019-04-07','桔子','京东',1662.00);
INSERT INTO sales_data VALUES ('2019-04-07','桔子','店面',2080.00);
INSERT INTO sales_data VALUES ('2019-04-07','香蕉','淘宝',1111.00);
INSERT INTO sales_data VALUES ('2019-04-07','香蕉','京东',2102.00);
INSERT INTO sales_data VALUES ('2019-04-07','香蕉','店面',1386.00);
INSERT INTO sales_data VALUES ('2019-04-07','苹果','淘宝',1962.00);
INSERT INTO sales_data VALUES ('2019-04-07','苹果','京东',1605.00);
INSERT INTO sales_data VALUES ('2019-04-07','苹果','店面',1160.00);
INSERT INTO sales_data VALUES ('2019-04-08','桔子','淘宝',1392.00);
INSERT INTO sales_data VALUES ('2019-04-08','桔子','京东',1504.00);
INSERT INTO sales_data VALUES ('2019-04-08','桔子','店面',1134.00);
INSERT INTO sales_data VALUES ('2019-04-08','香蕉','淘宝',1399.00);
INSERT INTO sales_data VALUES ('2019-04-08','香蕉','京东',1832.00);
INSERT INTO sales_data VALUES ('2019-04-08','香蕉','店面',1718.00);
INSERT INTO sales_data VALUES ('2019-04-08','苹果','淘宝',1559.00);
INSERT INTO sales_data VALUES ('2019-04-08','苹果','京东',2082.00);
INSERT INTO sales_data VALUES ('2019-04-08','苹果','店面',1680.00);
INSERT INTO sales_data VALUES ('2019-04-09','桔子','淘宝',1522.00);
INSERT INTO sales_data VALUES ('2019-04-09','桔子','京东',1596.00);
INSERT INTO sales_data VALUES ('2019-04-09','桔子','店面',1581.00);
INSERT INTO sales_data VALUES ('2019-04-09','香蕉','淘宝',2326.00);
INSERT INTO sales_data VALUES ('2019-04-09','香蕉','京东',1537.00);
INSERT INTO sales_data VALUES ('2019-04-09','香蕉','店面',1234.00);
INSERT INTO sales_data VALUES ('2019-04-09','苹果','淘宝',2351.00);
INSERT INTO sales_data VALUES ('2019-04-09','苹果','京东',2307.00);
INSERT INTO sales_data VALUES ('2019-04-09','苹果','店面',1608.00);
INSERT INTO sales_data VALUES ('2019-04-10','桔子','淘宝',1490.00);
INSERT INTO sales_data VALUES ('2019-04-10','桔子','京东',2269.00);
INSERT INTO sales_data VALUES ('2019-04-10','桔子','店面',1337.00);
INSERT INTO sales_data VALUES ('2019-04-10','香蕉','淘宝',1451.00);
INSERT INTO sales_data VALUES ('2019-04-10','香蕉','京东',2466.00);
INSERT INTO sales_data VALUES ('2019-04-10','香蕉','店面',2019.00);
INSERT INTO sales_data VALUES ('2019-04-10','苹果','淘宝',1051.00);
INSERT INTO sales_data VALUES ('2019-04-10','苹果','京东',1096.00);
INSERT INTO sales_data VALUES ('2019-04-10','苹果','店面',1642.00);
INSERT INTO sales_data VALUES ('2019-04-11','桔子','淘宝',1462.00);
INSERT INTO sales_data VALUES ('2019-04-11','桔子','京东',2083.00);
INSERT INTO sales_data VALUES ('2019-04-11','桔子','店面',2272.00);
INSERT INTO sales_data VALUES ('2019-04-11','香蕉','淘宝',1642.00);
INSERT INTO sales_data VALUES ('2019-04-11','香蕉','京东',2490.00);
INSERT INTO sales_data VALUES ('2019-04-11','香蕉','店面',1290.00);
INSERT INTO sales_data VALUES ('2019-04-11','苹果','淘宝',1792.00);
INSERT INTO sales_data VALUES ('2019-04-11','苹果','京东',1404.00);
INSERT INTO sales_data VALUES ('2019-04-11','苹果','店面',2138.00);
INSERT INTO sales_data VALUES ('2019-04-12','桔子','淘宝',1030.00);
INSERT INTO sales_data VALUES ('2019-04-12','桔子','京东',1983.00);
INSERT INTO sales_data VALUES ('2019-04-12','桔子','店面',1740.00);
INSERT INTO sales_data VALUES ('2019-04-12','香蕉','淘宝',1725.00);
INSERT INTO sales_data VALUES ('2019-04-12','香蕉','京东',1015.00);
INSERT INTO sales_data VALUES ('2019-04-12','香蕉','店面',2346.00);
INSERT INTO sales_data VALUES ('2019-04-12','苹果','淘宝',2316.00);
INSERT INTO sales_data VALUES ('2019-04-12','苹果','京东',2351.00);
INSERT INTO sales_data VALUES ('2019-04-12','苹果','店面',1393.00);
INSERT INTO sales_data VALUES ('2019-04-13','桔子','淘宝',1065.00);
INSERT INTO sales_data VALUES ('2019-04-13','桔子','京东',2216.00);
INSERT INTO sales_data VALUES ('2019-04-13','桔子','店面',1215.00);
INSERT INTO sales_data VALUES ('2019-04-13','香蕉','淘宝',1683.00);
INSERT INTO sales_data VALUES ('2019-04-13','香蕉','京东',1211.00);
INSERT INTO sales_data VALUES ('2019-04-13','香蕉','店面',2489.00);
INSERT INTO sales_data VALUES ('2019-04-13','苹果','淘宝',2025.00);
INSERT INTO sales_data VALUES ('2019-04-13','苹果','京东',1667.00);
INSERT INTO sales_data VALUES ('2019-04-13','苹果','店面',2460.00);
INSERT INTO sales_data VALUES ('2019-04-14','桔子','淘宝',1555.00);
INSERT INTO sales_data VALUES ('2019-04-14','桔子','京东',1728.00);
INSERT INTO sales_data VALUES ('2019-04-14','桔子','店面',1066.00);
INSERT INTO sales_data VALUES ('2019-04-14','香蕉','淘宝',2201.00);
INSERT INTO sales_data VALUES ('2019-04-14','香蕉','京东',2191.00);
INSERT INTO sales_data VALUES ('2019-04-14','香蕉','店面',2149.00);
INSERT INTO sales_data VALUES ('2019-04-14','苹果','淘宝',1973.00);
INSERT INTO sales_data VALUES ('2019-04-14','苹果','京东',1333.00);
INSERT INTO sales_data VALUES ('2019-04-14','苹果','店面',2140.00);
INSERT INTO sales_data VALUES ('2019-04-15','桔子','淘宝',2268.00);
INSERT INTO sales_data VALUES ('2019-04-15','桔子','京东',2130.00);
INSERT INTO sales_data VALUES ('2019-04-15','桔子','店面',1048.00);
INSERT INTO sales_data VALUES ('2019-04-15','香蕉','淘宝',1906.00);
INSERT INTO sales_data VALUES ('2019-04-15','香蕉','京东',2155.00);
INSERT INTO sales_data VALUES ('2019-04-15','香蕉','店面',2026.00);
INSERT INTO sales_data VALUES ('2019-04-15','苹果','淘宝',1141.00);
INSERT INTO sales_data VALUES ('2019-04-15','苹果','京东',1375.00);
INSERT INTO sales_data VALUES ('2019-04-15','苹果','店面',2036.00);
INSERT INTO sales_data VALUES ('2019-04-16','桔子','淘宝',2486.00);
INSERT INTO sales_data VALUES ('2019-04-16','桔子','京东',1191.00);
INSERT INTO sales_data VALUES ('2019-04-16','桔子','店面',1886.00);
INSERT INTO sales_data VALUES ('2019-04-16','香蕉','淘宝',1374.00);
INSERT INTO sales_data VALUES ('2019-04-16','香蕉','京东',1246.00);
INSERT INTO sales_data VALUES ('2019-04-16','香蕉','店面',1593.00);
INSERT INTO sales_data VALUES ('2019-04-16','苹果','淘宝',1579.00);
INSERT INTO sales_data VALUES ('2019-04-16','苹果','京东',1919.00);
INSERT INTO sales_data VALUES ('2019-04-16','苹果','店面',1794.00);
INSERT INTO sales_data VALUES ('2019-04-17','桔子','淘宝',1563.00);
INSERT INTO sales_data VALUES ('2019-04-17','桔子','京东',1439.00);
INSERT INTO sales_data VALUES ('2019-04-17','桔子','店面',2456.00);
INSERT INTO sales_data VALUES ('2019-04-17','香蕉','淘宝',1513.00);
INSERT INTO sales_data VALUES ('2019-04-17','香蕉','京东',1978.00);
INSERT INTO sales_data VALUES ('2019-04-17','香蕉','店面',1669.00);
INSERT INTO sales_data VALUES ('2019-04-17','苹果','淘宝',1564.00);
INSERT INTO sales_data VALUES ('2019-04-17','苹果','京东',1665.00);
INSERT INTO sales_data VALUES ('2019-04-17','苹果','店面',1345.00);
INSERT INTO sales_data VALUES ('2019-04-18','桔子','淘宝',1204.00);
INSERT INTO sales_data VALUES ('2019-04-18','桔子','京东',1127.00);
INSERT INTO sales_data VALUES ('2019-04-18','桔子','店面',1668.00);
INSERT INTO sales_data VALUES ('2019-04-18','香蕉','淘宝',2328.00);
INSERT INTO sales_data VALUES ('2019-04-18','香蕉','京东',2376.00);
INSERT INTO sales_data VALUES ('2019-04-18','香蕉','店面',1278.00);
INSERT INTO sales_data VALUES ('2019-04-18','苹果','淘宝',2357.00);
INSERT INTO sales_data VALUES ('2019-04-18','苹果','京东',1762.00);
INSERT INTO sales_data VALUES ('2019-04-18','苹果','店面',2413.00);
INSERT INTO sales_data VALUES ('2019-04-19','桔子','淘宝',1868.00);
INSERT INTO sales_data VALUES ('2019-04-19','桔子','京东',1888.00);
INSERT INTO sales_data VALUES ('2019-04-19','桔子','店面',1272.00);
INSERT INTO sales_data VALUES ('2019-04-19','香蕉','淘宝',1384.00);
INSERT INTO sales_data VALUES ('2019-04-19','香蕉','京东',1849.00);
INSERT INTO sales_data VALUES ('2019-04-19','香蕉','店面',1438.00);
INSERT INTO sales_data VALUES ('2019-04-19','苹果','淘宝',2245.00);
INSERT INTO sales_data VALUES ('2019-04-19','苹果','京东',2198.00);
INSERT INTO sales_data VALUES ('2019-04-19','苹果','店面',1659.00);
INSERT INTO sales_data VALUES ('2019-04-20','桔子','淘宝',1317.00);
INSERT INTO sales_data VALUES ('2019-04-20','桔子','京东',1258.00);
INSERT INTO sales_data VALUES ('2019-04-20','桔子','店面',1057.00);
INSERT INTO sales_data VALUES ('2019-04-20','香蕉','淘宝',2086.00);
INSERT INTO sales_data VALUES ('2019-04-20','香蕉','京东',1791.00);
INSERT INTO sales_data VALUES ('2019-04-20','香蕉','店面',1466.00);
INSERT INTO sales_data VALUES ('2019-04-20','苹果','淘宝',2012.00);
INSERT INTO sales_data VALUES ('2019-04-20','苹果','京东',2274.00);
INSERT INTO sales_data VALUES ('2019-04-20','苹果','店面',2415.00);
INSERT INTO sales_data VALUES ('2019-04-21','桔子','淘宝',1156.00);
INSERT INTO sales_data VALUES ('2019-04-21','桔子','京东',1313.00);
INSERT INTO sales_data VALUES ('2019-04-21','桔子','店面',1554.00);
INSERT INTO sales_data VALUES ('2019-04-21','香蕉','淘宝',1471.00);
INSERT INTO sales_data VALUES ('2019-04-21','香蕉','京东',1482.00);
INSERT INTO sales_data VALUES ('2019-04-21','香蕉','店面',1647.00);
INSERT INTO sales_data VALUES ('2019-04-21','苹果','淘宝',2104.00);
INSERT INTO sales_data VALUES ('2019-04-21','苹果','京东',1276.00);
INSERT INTO sales_data VALUES ('2019-04-21','苹果','店面',1487.00);
INSERT INTO sales_data VALUES ('2019-04-22','桔子','淘宝',2352.00);
INSERT INTO sales_data VALUES ('2019-04-22','桔子','京东',1102.00);
INSERT INTO sales_data VALUES ('2019-04-22','桔子','店面',2219.00);
INSERT INTO sales_data VALUES ('2019-04-22','香蕉','淘宝',2230.00);
INSERT INTO sales_data VALUES ('2019-04-22','香蕉','京东',1930.00);
INSERT INTO sales_data VALUES ('2019-04-22','香蕉','店面',1567.00);
INSERT INTO sales_data VALUES ('2019-04-22','苹果','淘宝',2462.00);
INSERT INTO sales_data VALUES ('2019-04-22','苹果','京东',2274.00);
INSERT INTO sales_data VALUES ('2019-04-22','苹果','店面',2376.00);
INSERT INTO sales_data VALUES ('2019-04-23','桔子','淘宝',1365.00);
INSERT INTO sales_data VALUES ('2019-04-23','桔子','京东',1983.00);
INSERT INTO sales_data VALUES ('2019-04-23','桔子','店面',2039.00);
INSERT INTO sales_data VALUES ('2019-04-23','香蕉','淘宝',1984.00);
INSERT INTO sales_data VALUES ('2019-04-23','香蕉','京东',2256.00);
INSERT INTO sales_data VALUES ('2019-04-23','香蕉','店面',2252.00);
INSERT INTO sales_data VALUES ('2019-04-23','苹果','淘宝',1997.00);
INSERT INTO sales_data VALUES ('2019-04-23','苹果','京东',1797.00);
INSERT INTO sales_data VALUES ('2019-04-23','苹果','店面',1498.00);
INSERT INTO sales_data VALUES ('2019-04-24','桔子','淘宝',2423.00);
INSERT INTO sales_data VALUES ('2019-04-24','桔子','京东',1269.00);
INSERT INTO sales_data VALUES ('2019-04-24','桔子','店面',1232.00);
INSERT INTO sales_data VALUES ('2019-04-24','香蕉','淘宝',2293.00);
INSERT INTO sales_data VALUES ('2019-04-24','香蕉','京东',1375.00);
INSERT INTO sales_data VALUES ('2019-04-24','香蕉','店面',1495.00);
INSERT INTO sales_data VALUES ('2019-04-24','苹果','淘宝',1297.00);
INSERT INTO sales_data VALUES ('2019-04-24','苹果','京东',1796.00);
INSERT INTO sales_data VALUES ('2019-04-24','苹果','店面',1927.00);
INSERT INTO sales_data VALUES ('2019-04-25','桔子','淘宝',1899.00);
INSERT INTO sales_data VALUES ('2019-04-25','桔子','京东',1356.00);
INSERT INTO sales_data VALUES ('2019-04-25','桔子','店面',2158.00);
INSERT INTO sales_data VALUES ('2019-04-25','香蕉','淘宝',2336.00);
INSERT INTO sales_data VALUES ('2019-04-25','香蕉','京东',1153.00);
INSERT INTO sales_data VALUES ('2019-04-25','香蕉','店面',2205.00);
INSERT INTO sales_data VALUES ('2019-04-25','苹果','淘宝',2000.00);
INSERT INTO sales_data VALUES ('2019-04-25','苹果','京东',2327.00);
INSERT INTO sales_data VALUES ('2019-04-25','苹果','店面',1580.00);
INSERT INTO sales_data VALUES ('2019-04-26','桔子','淘宝',2517.00);
INSERT INTO sales_data VALUES ('2019-04-26','桔子','京东',2239.00);
INSERT INTO sales_data VALUES ('2019-04-26','桔子','店面',1304.00);
INSERT INTO sales_data VALUES ('2019-04-26','香蕉','淘宝',2338.00);
INSERT INTO sales_data VALUES ('2019-04-26','香蕉','京东',2545.00);
INSERT INTO sales_data VALUES ('2019-04-26','香蕉','店面',2228.00);
INSERT INTO sales_data VALUES ('2019-04-26','苹果','淘宝',1817.00);
INSERT INTO sales_data VALUES ('2019-04-26','苹果','京东',1969.00);
INSERT INTO sales_data VALUES ('2019-04-26','苹果','店面',1923.00);
INSERT INTO sales_data VALUES ('2019-04-27','桔子','淘宝',1514.00);
INSERT INTO sales_data VALUES ('2019-04-27','桔子','京东',1411.00);
INSERT INTO sales_data VALUES ('2019-04-27','桔子','店面',1165.00);
INSERT INTO sales_data VALUES ('2019-04-27','香蕉','淘宝',1952.00);
INSERT INTO sales_data VALUES ('2019-04-27','香蕉','京东',1268.00);
INSERT INTO sales_data VALUES ('2019-04-27','香蕉','店面',1369.00);
INSERT INTO sales_data VALUES ('2019-04-27','苹果','淘宝',2119.00);
INSERT INTO sales_data VALUES ('2019-04-27','苹果','京东',2496.00);
INSERT INTO sales_data VALUES ('2019-04-27','苹果','店面',1679.00);
INSERT INTO sales_data VALUES ('2019-04-28','桔子','淘宝',2554.00);
INSERT INTO sales_data VALUES ('2019-04-28','桔子','京东',1233.00);
INSERT INTO sales_data VALUES ('2019-04-28','桔子','店面',2416.00);
INSERT INTO sales_data VALUES ('2019-04-28','香蕉','淘宝',1917.00);
INSERT INTO sales_data VALUES ('2019-04-28','香蕉','京东',2061.00);
INSERT INTO sales_data VALUES ('2019-04-28','香蕉','店面',1201.00);
INSERT INTO sales_data VALUES ('2019-04-28','苹果','淘宝',1505.00);
INSERT INTO sales_data VALUES ('2019-04-28','苹果','京东',1827.00);
INSERT INTO sales_data VALUES ('2019-04-28','苹果','店面',1284.00);
INSERT INTO sales_data VALUES ('2019-04-29','桔子','淘宝',1145.00);
INSERT INTO sales_data VALUES ('2019-04-29','桔子','京东',1262.00);
INSERT INTO sales_data VALUES ('2019-04-29','桔子','店面',2546.00);
INSERT INTO sales_data VALUES ('2019-04-29','香蕉','淘宝',1655.00);
INSERT INTO sales_data VALUES ('2019-04-29','香蕉','京东',1204.00);
INSERT INTO sales_data VALUES ('2019-04-29','香蕉','店面',2210.00);
INSERT INTO sales_data VALUES ('2019-04-29','苹果','淘宝',1884.00);
INSERT INTO sales_data VALUES ('2019-04-29','苹果','京东',2467.00);
INSERT INTO sales_data VALUES ('2019-04-29','苹果','店面',2180.00);
INSERT INTO sales_data VALUES ('2019-04-30','桔子','淘宝',1542.00);
INSERT INTO sales_data VALUES ('2019-04-30','桔子','京东',1714.00);
INSERT INTO sales_data VALUES ('2019-04-30','桔子','店面',1579.00);
INSERT INTO sales_data VALUES ('2019-04-30','香蕉','淘宝',2390.00);
INSERT INTO sales_data VALUES ('2019-04-30','香蕉','京东',2148.00);
INSERT INTO sales_data VALUES ('2019-04-30','香蕉','店面',1910.00);
INSERT INTO sales_data VALUES ('2019-04-30','苹果','淘宝',2476.00);
INSERT INTO sales_data VALUES ('2019-04-30','苹果','京东',1520.00);
INSERT INTO sales_data VALUES ('2019-04-30','苹果','店面',2098.00);
INSERT INTO sales_data VALUES ('2019-05-01','桔子','淘宝',1270.00);
INSERT INTO sales_data VALUES ('2019-05-01','桔子','京东',2564.00);
INSERT INTO sales_data VALUES ('2019-05-01','桔子','店面',2019.00);
INSERT INTO sales_data VALUES ('2019-05-01','香蕉','淘宝',1870.00);
INSERT INTO sales_data VALUES ('2019-05-01','香蕉','京东',2533.00);
INSERT INTO sales_data VALUES ('2019-05-01','香蕉','店面',2167.00);
INSERT INTO sales_data VALUES ('2019-05-01','苹果','淘宝',1700.00);
INSERT INTO sales_data VALUES ('2019-05-01','苹果','京东',1865.00);
INSERT INTO sales_data VALUES ('2019-05-01','苹果','店面',1643.00);
INSERT INTO sales_data VALUES ('2019-05-02','桔子','淘宝',1822.00);
INSERT INTO sales_data VALUES ('2019-05-02','桔子','京东',2290.00);
INSERT INTO sales_data VALUES ('2019-05-02','桔子','店面',2391.00);
INSERT INTO sales_data VALUES ('2019-05-02','香蕉','淘宝',2021.00);
INSERT INTO sales_data VALUES ('2019-05-02','香蕉','京东',2345.00);
INSERT INTO sales_data VALUES ('2019-05-02','香蕉','店面',2563.00);
INSERT INTO sales_data VALUES ('2019-05-02','苹果','淘宝',1977.00);
INSERT INTO sales_data VALUES ('2019-05-02','苹果','京东',1410.00);
INSERT INTO sales_data VALUES ('2019-05-02','苹果','店面',1177.00);
INSERT INTO sales_data VALUES ('2019-05-03','桔子','淘宝',1602.00);
INSERT INTO sales_data VALUES ('2019-05-03','桔子','京东',2209.00);
INSERT INTO sales_data VALUES ('2019-05-03','桔子','店面',2559.00);
INSERT INTO sales_data VALUES ('2019-05-03','香蕉','淘宝',1192.00);
INSERT INTO sales_data VALUES ('2019-05-03','香蕉','京东',1156.00);
INSERT INTO sales_data VALUES ('2019-05-03','香蕉','店面',1678.00);
INSERT INTO sales_data VALUES ('2019-05-03','苹果','淘宝',1677.00);
INSERT INTO sales_data VALUES ('2019-05-03','苹果','京东',2452.00);
INSERT INTO sales_data VALUES ('2019-05-03','苹果','店面',1231.00);
INSERT INTO sales_data VALUES ('2019-05-04','桔子','淘宝',2496.00);
INSERT INTO sales_data VALUES ('2019-05-04','桔子','京东',2337.00);
INSERT INTO sales_data VALUES ('2019-05-04','桔子','店面',1661.00);
INSERT INTO sales_data VALUES ('2019-05-04','香蕉','淘宝',1999.00);
INSERT INTO sales_data VALUES ('2019-05-04','香蕉','京东',2508.00);
INSERT INTO sales_data VALUES ('2019-05-04','香蕉','店面',1626.00);
INSERT INTO sales_data VALUES ('2019-05-04','苹果','淘宝',1418.00);
INSERT INTO sales_data VALUES ('2019-05-04','苹果','京东',1777.00);
INSERT INTO sales_data VALUES ('2019-05-04','苹果','店面',1559.00);
INSERT INTO sales_data VALUES ('2019-05-05','桔子','淘宝',2490.00);
INSERT INTO sales_data VALUES ('2019-05-05','桔子','京东',2382.00);
INSERT INTO sales_data VALUES ('2019-05-05','桔子','店面',2329.00);
INSERT INTO sales_data VALUES ('2019-05-05','香蕉','淘宝',1533.00);
INSERT INTO sales_data VALUES ('2019-05-05','香蕉','京东',1599.00);
INSERT INTO sales_data VALUES ('2019-05-05','香蕉','店面',2014.00);
INSERT INTO sales_data VALUES ('2019-05-05','苹果','淘宝',1319.00);
INSERT INTO sales_data VALUES ('2019-05-05','苹果','京东',2515.00);
INSERT INTO sales_data VALUES ('2019-05-05','苹果','店面',1754.00);
INSERT INTO sales_data VALUES ('2019-05-06','桔子','淘宝',1282.00);
INSERT INTO sales_data VALUES ('2019-05-06','桔子','京东',1892.00);
INSERT INTO sales_data VALUES ('2019-05-06','桔子','店面',2064.00);
INSERT INTO sales_data VALUES ('2019-05-06','香蕉','淘宝',1354.00);
INSERT INTO sales_data VALUES ('2019-05-06','香蕉','京东',2384.00);
INSERT INTO sales_data VALUES ('2019-05-06','香蕉','店面',1663.00);
INSERT INTO sales_data VALUES ('2019-05-06','苹果','淘宝',1303.00);
INSERT INTO sales_data VALUES ('2019-05-06','苹果','京东',2467.00);
INSERT INTO sales_data VALUES ('2019-05-06','苹果','店面',1709.00);
INSERT INTO sales_data VALUES ('2019-05-07','桔子','淘宝',1876.00);
INSERT INTO sales_data VALUES ('2019-05-07','桔子','京东',1538.00);
INSERT INTO sales_data VALUES ('2019-05-07','桔子','店面',1556.00);
INSERT INTO sales_data VALUES ('2019-05-07','香蕉','淘宝',1997.00);
INSERT INTO sales_data VALUES ('2019-05-07','香蕉','京东',1419.00);
INSERT INTO sales_data VALUES ('2019-05-07','香蕉','店面',1278.00);
INSERT INTO sales_data VALUES ('2019-05-07','苹果','淘宝',2544.00);
INSERT INTO sales_data VALUES ('2019-05-07','苹果','京东',2303.00);
INSERT INTO sales_data VALUES ('2019-05-07','苹果','店面',1171.00);
INSERT INTO sales_data VALUES ('2019-05-08','桔子','淘宝',1559.00);
INSERT INTO sales_data VALUES ('2019-05-08','桔子','京东',2611.00);
INSERT INTO sales_data VALUES ('2019-05-08','桔子','店面',1838.00);
INSERT INTO sales_data VALUES ('2019-05-08','香蕉','淘宝',2003.00);
INSERT INTO sales_data VALUES ('2019-05-08','香蕉','京东',2481.00);
INSERT INTO sales_data VALUES ('2019-05-08','香蕉','店面',1601.00);
INSERT INTO sales_data VALUES ('2019-05-08','苹果','淘宝',1713.00);
INSERT INTO sales_data VALUES ('2019-05-08','苹果','京东',1395.00);
INSERT INTO sales_data VALUES ('2019-05-08','苹果','店面',2080.00);
INSERT INTO sales_data VALUES ('2019-05-09','桔子','淘宝',2612.00);
INSERT INTO sales_data VALUES ('2019-05-09','桔子','京东',1599.00);
INSERT INTO sales_data VALUES ('2019-05-09','桔子','店面',1980.00);
INSERT INTO sales_data VALUES ('2019-05-09','香蕉','淘宝',1746.00);
INSERT INTO sales_data VALUES ('2019-05-09','香蕉','京东',1756.00);
INSERT INTO sales_data VALUES ('2019-05-09','香蕉','店面',1246.00);
INSERT INTO sales_data VALUES ('2019-05-09','苹果','淘宝',1184.00);
INSERT INTO sales_data VALUES ('2019-05-09','苹果','京东',1984.00);
INSERT INTO sales_data VALUES ('2019-05-09','苹果','店面',2505.00);
INSERT INTO sales_data VALUES ('2019-05-10','桔子','淘宝',1728.00);
INSERT INTO sales_data VALUES ('2019-05-10','桔子','京东',2168.00);
INSERT INTO sales_data VALUES ('2019-05-10','桔子','店面',2352.00);
INSERT INTO sales_data VALUES ('2019-05-10','香蕉','淘宝',2312.00);
INSERT INTO sales_data VALUES ('2019-05-10','香蕉','京东',1414.00);
INSERT INTO sales_data VALUES ('2019-05-10','香蕉','店面',1260.00);
INSERT INTO sales_data VALUES ('2019-05-10','苹果','淘宝',1238.00);
INSERT INTO sales_data VALUES ('2019-05-10','苹果','京东',2281.00);
INSERT INTO sales_data VALUES ('2019-05-10','苹果','店面',1549.00);
INSERT INTO sales_data VALUES ('2019-05-11','桔子','淘宝',1391.00);
INSERT INTO sales_data VALUES ('2019-05-11','桔子','京东',2200.00);
INSERT INTO sales_data VALUES ('2019-05-11','桔子','店面',1227.00);
INSERT INTO sales_data VALUES ('2019-05-11','香蕉','淘宝',1432.00);
INSERT INTO sales_data VALUES ('2019-05-11','香蕉','京东',2624.00);
INSERT INTO sales_data VALUES ('2019-05-11','香蕉','店面',1204.00);
INSERT INTO sales_data VALUES ('2019-05-11','苹果','淘宝',2136.00);
INSERT INTO sales_data VALUES ('2019-05-11','苹果','京东',1992.00);
INSERT INTO sales_data VALUES ('2019-05-11','苹果','店面',2550.00);
INSERT INTO sales_data VALUES ('2019-05-12','桔子','淘宝',2606.00);
INSERT INTO sales_data VALUES ('2019-05-12','桔子','京东',2575.00);
INSERT INTO sales_data VALUES ('2019-05-12','桔子','店面',1315.00);
INSERT INTO sales_data VALUES ('2019-05-12','香蕉','淘宝',2051.00);
INSERT INTO sales_data VALUES ('2019-05-12','香蕉','京东',2547.00);
INSERT INTO sales_data VALUES ('2019-05-12','香蕉','店面',1774.00);
INSERT INTO sales_data VALUES ('2019-05-12','苹果','淘宝',1391.00);
INSERT INTO sales_data VALUES ('2019-05-12','苹果','京东',1652.00);
INSERT INTO sales_data VALUES ('2019-05-12','苹果','店面',2389.00);
INSERT INTO sales_data VALUES ('2019-05-13','桔子','淘宝',1502.00);
INSERT INTO sales_data VALUES ('2019-05-13','桔子','京东',1701.00);
INSERT INTO sales_data VALUES ('2019-05-13','桔子','店面',1739.00);
INSERT INTO sales_data VALUES ('2019-05-13','香蕉','淘宝',1367.00);
INSERT INTO sales_data VALUES ('2019-05-13','香蕉','京东',2284.00);
INSERT INTO sales_data VALUES ('2019-05-13','香蕉','店面',1261.00);
INSERT INTO sales_data VALUES ('2019-05-13','苹果','淘宝',2574.00);
INSERT INTO sales_data VALUES ('2019-05-13','苹果','京东',1951.00);
INSERT INTO sales_data VALUES ('2019-05-13','苹果','店面',1530.00);
INSERT INTO sales_data VALUES ('2019-05-14','桔子','淘宝',1194.00);
INSERT INTO sales_data VALUES ('2019-05-14','桔子','京东',2049.00);
INSERT INTO sales_data VALUES ('2019-05-14','桔子','店面',1171.00);
INSERT INTO sales_data VALUES ('2019-05-14','香蕉','淘宝',1598.00);
INSERT INTO sales_data VALUES ('2019-05-14','香蕉','京东',2290.00);
INSERT INTO sales_data VALUES ('2019-05-14','香蕉','店面',2220.00);
INSERT INTO sales_data VALUES ('2019-05-14','苹果','淘宝',1676.00);
INSERT INTO sales_data VALUES ('2019-05-14','苹果','京东',2573.00);
INSERT INTO sales_data VALUES ('2019-05-14','苹果','店面',2194.00);
INSERT INTO sales_data VALUES ('2019-05-15','桔子','淘宝',1734.00);
INSERT INTO sales_data VALUES ('2019-05-15','桔子','京东',2063.00);
INSERT INTO sales_data VALUES ('2019-05-15','桔子','店面',1541.00);
INSERT INTO sales_data VALUES ('2019-05-15','香蕉','淘宝',1634.00);
INSERT INTO sales_data VALUES ('2019-05-15','香蕉','京东',2014.00);
INSERT INTO sales_data VALUES ('2019-05-15','香蕉','店面',1461.00);
INSERT INTO sales_data VALUES ('2019-05-15','苹果','淘宝',1794.00);
INSERT INTO sales_data VALUES ('2019-05-15','苹果','京东',1411.00);
INSERT INTO sales_data VALUES ('2019-05-15','苹果','店面',1353.00);
INSERT INTO sales_data VALUES ('2019-05-16','桔子','淘宝',2418.00);
INSERT INTO sales_data VALUES ('2019-05-16','桔子','京东',1651.00);
INSERT INTO sales_data VALUES ('2019-05-16','桔子','店面',1855.00);
INSERT INTO sales_data VALUES ('2019-05-16','香蕉','淘宝',2152.00);
INSERT INTO sales_data VALUES ('2019-05-16','香蕉','京东',1994.00);
INSERT INTO sales_data VALUES ('2019-05-16','香蕉','店面',2396.00);
INSERT INTO sales_data VALUES ('2019-05-16','苹果','淘宝',1231.00);
INSERT INTO sales_data VALUES ('2019-05-16','苹果','京东',2201.00);
INSERT INTO sales_data VALUES ('2019-05-16','苹果','店面',2020.00);
INSERT INTO sales_data VALUES ('2019-05-17','桔子','淘宝',1337.00);
INSERT INTO sales_data VALUES ('2019-05-17','桔子','京东',2120.00);
INSERT INTO sales_data VALUES ('2019-05-17','桔子','店面',1316.00);
INSERT INTO sales_data VALUES ('2019-05-17','香蕉','淘宝',1706.00);
INSERT INTO sales_data VALUES ('2019-05-17','香蕉','京东',2150.00);
INSERT INTO sales_data VALUES ('2019-05-17','香蕉','店面',2200.00);
INSERT INTO sales_data VALUES ('2019-05-17','苹果','淘宝',1712.00);
INSERT INTO sales_data VALUES ('2019-05-17','苹果','京东',2583.00);
INSERT INTO sales_data VALUES ('2019-05-17','苹果','店面',1825.00);
INSERT INTO sales_data VALUES ('2019-05-18','桔子','淘宝',1272.00);
INSERT INTO sales_data VALUES ('2019-05-18','桔子','京东',1599.00);
INSERT INTO sales_data VALUES ('2019-05-18','桔子','店面',1738.00);
INSERT INTO sales_data VALUES ('2019-05-18','香蕉','淘宝',2302.00);
INSERT INTO sales_data VALUES ('2019-05-18','香蕉','京东',2163.00);
INSERT INTO sales_data VALUES ('2019-05-18','香蕉','店面',2631.00);
INSERT INTO sales_data VALUES ('2019-05-18','苹果','淘宝',2673.00);
INSERT INTO sales_data VALUES ('2019-05-18','苹果','京东',2627.00);
INSERT INTO sales_data VALUES ('2019-05-18','苹果','店面',1975.00);
INSERT INTO sales_data VALUES ('2019-05-19','桔子','淘宝',1469.00);
INSERT INTO sales_data VALUES ('2019-05-19','桔子','京东',1757.00);
INSERT INTO sales_data VALUES ('2019-05-19','桔子','店面',2221.00);
INSERT INTO sales_data VALUES ('2019-05-19','香蕉','淘宝',1652.00);
INSERT INTO sales_data VALUES ('2019-05-19','香蕉','京东',1500.00);
INSERT INTO sales_data VALUES ('2019-05-19','香蕉','店面',1197.00);
INSERT INTO sales_data VALUES ('2019-05-19','苹果','淘宝',2331.00);
INSERT INTO sales_data VALUES ('2019-05-19','苹果','京东',2477.00);
INSERT INTO sales_data VALUES ('2019-05-19','苹果','店面',2016.00);
INSERT INTO sales_data VALUES ('2019-05-20','桔子','淘宝',2057.00);
INSERT INTO sales_data VALUES ('2019-05-20','桔子','京东',2537.00);
INSERT INTO sales_data VALUES ('2019-05-20','桔子','店面',1547.00);
INSERT INTO sales_data VALUES ('2019-05-20','香蕉','淘宝',1403.00);
INSERT INTO sales_data VALUES ('2019-05-20','香蕉','京东',2694.00);
INSERT INTO sales_data VALUES ('2019-05-20','香蕉','店面',2487.00);
INSERT INTO sales_data VALUES ('2019-05-20','苹果','淘宝',1539.00);
INSERT INTO sales_data VALUES ('2019-05-20','苹果','京东',1720.00);
INSERT INTO sales_data VALUES ('2019-05-20','苹果','店面',1957.00);
INSERT INTO sales_data VALUES ('2019-05-21','桔子','淘宝',2564.00);
INSERT INTO sales_data VALUES ('2019-05-21','桔子','京东',2257.00);
INSERT INTO sales_data VALUES ('2019-05-21','桔子','店面',1865.00);
INSERT INTO sales_data VALUES ('2019-05-21','香蕉','淘宝',1709.00);
INSERT INTO sales_data VALUES ('2019-05-21','香蕉','京东',2345.00);
INSERT INTO sales_data VALUES ('2019-05-21','香蕉','店面',2278.00);
INSERT INTO sales_data VALUES ('2019-05-21','苹果','淘宝',2261.00);
INSERT INTO sales_data VALUES ('2019-05-21','苹果','京东',1961.00);
INSERT INTO sales_data VALUES ('2019-05-21','苹果','店面',1756.00);
INSERT INTO sales_data VALUES ('2019-05-22','桔子','淘宝',2212.00);
INSERT INTO sales_data VALUES ('2019-05-22','桔子','京东',1954.00);
INSERT INTO sales_data VALUES ('2019-05-22','桔子','店面',1703.00);
INSERT INTO sales_data VALUES ('2019-05-22','香蕉','淘宝',1503.00);
INSERT INTO sales_data VALUES ('2019-05-22','香蕉','京东',2233.00);
INSERT INTO sales_data VALUES ('2019-05-22','香蕉','店面',2270.00);
INSERT INTO sales_data VALUES ('2019-05-22','苹果','淘宝',2533.00);
INSERT INTO sales_data VALUES ('2019-05-22','苹果','京东',2695.00);
INSERT INTO sales_data VALUES ('2019-05-22','苹果','店面',2580.00);
INSERT INTO sales_data VALUES ('2019-05-23','桔子','淘宝',2546.00);
INSERT INTO sales_data VALUES ('2019-05-23','桔子','京东',2341.00);
INSERT INTO sales_data VALUES ('2019-05-23','桔子','店面',2371.00);
INSERT INTO sales_data VALUES ('2019-05-23','香蕉','淘宝',1872.00);
INSERT INTO sales_data VALUES ('2019-05-23','香蕉','京东',1703.00);
INSERT INTO sales_data VALUES ('2019-05-23','香蕉','店面',2213.00);
INSERT INTO sales_data VALUES ('2019-05-23','苹果','淘宝',2223.00);
INSERT INTO sales_data VALUES ('2019-05-23','苹果','京东',1911.00);
INSERT INTO sales_data VALUES ('2019-05-23','苹果','店面',2212.00);
INSERT INTO sales_data VALUES ('2019-05-24','桔子','淘宝',2021.00);
INSERT INTO sales_data VALUES ('2019-05-24','桔子','京东',2259.00);
INSERT INTO sales_data VALUES ('2019-05-24','桔子','店面',1242.00);
INSERT INTO sales_data VALUES ('2019-05-24','香蕉','淘宝',1282.00);
INSERT INTO sales_data VALUES ('2019-05-24','香蕉','京东',2123.00);
INSERT INTO sales_data VALUES ('2019-05-24','香蕉','店面',2299.00);
INSERT INTO sales_data VALUES ('2019-05-24','苹果','淘宝',1947.00);
INSERT INTO sales_data VALUES ('2019-05-24','苹果','京东',2632.00);
INSERT INTO sales_data VALUES ('2019-05-24','苹果','店面',1944.00);
INSERT INTO sales_data VALUES ('2019-05-25','桔子','淘宝',1530.00);
INSERT INTO sales_data VALUES ('2019-05-25','桔子','京东',2198.00);
INSERT INTO sales_data VALUES ('2019-05-25','桔子','店面',2710.00);
INSERT INTO sales_data VALUES ('2019-05-25','香蕉','淘宝',2087.00);
INSERT INTO sales_data VALUES ('2019-05-25','香蕉','京东',1706.00);
INSERT INTO sales_data VALUES ('2019-05-25','香蕉','店面',1959.00);
INSERT INTO sales_data VALUES ('2019-05-25','苹果','淘宝',2585.00);
INSERT INTO sales_data VALUES ('2019-05-25','苹果','京东',2003.00);
INSERT INTO sales_data VALUES ('2019-05-25','苹果','店面',1487.00);
INSERT INTO sales_data VALUES ('2019-05-26','桔子','淘宝',2155.00);
INSERT INTO sales_data VALUES ('2019-05-26','桔子','京东',1837.00);
INSERT INTO sales_data VALUES ('2019-05-26','桔子','店面',1482.00);
INSERT INTO sales_data VALUES ('2019-05-26','香蕉','淘宝',2030.00);
INSERT INTO sales_data VALUES ('2019-05-26','香蕉','京东',1672.00);
INSERT INTO sales_data VALUES ('2019-05-26','香蕉','店面',2612.00);
INSERT INTO sales_data VALUES ('2019-05-26','苹果','淘宝',1691.00);
INSERT INTO sales_data VALUES ('2019-05-26','苹果','京东',2334.00);
INSERT INTO sales_data VALUES ('2019-05-26','苹果','店面',1606.00);
INSERT INTO sales_data VALUES ('2019-05-27','桔子','淘宝',2699.00);
INSERT INTO sales_data VALUES ('2019-05-27','桔子','京东',1852.00);
INSERT INTO sales_data VALUES ('2019-05-27','桔子','店面',2311.00);
INSERT INTO sales_data VALUES ('2019-05-27','香蕉','淘宝',2201.00);
INSERT INTO sales_data VALUES ('2019-05-27','香蕉','京东',2658.00);
INSERT INTO sales_data VALUES ('2019-05-27','香蕉','店面',1856.00);
INSERT INTO sales_data VALUES ('2019-05-27','苹果','淘宝',2228.00);
INSERT INTO sales_data VALUES ('2019-05-27','苹果','京东',2725.00);
INSERT INTO sales_data VALUES ('2019-05-27','苹果','店面',1264.00);
INSERT INTO sales_data VALUES ('2019-05-28','桔子','淘宝',1818.00);
INSERT INTO sales_data VALUES ('2019-05-28','桔子','京东',1963.00);
INSERT INTO sales_data VALUES ('2019-05-28','桔子','店面',2686.00);
INSERT INTO sales_data VALUES ('2019-05-28','香蕉','淘宝',2547.00);
INSERT INTO sales_data VALUES ('2019-05-28','香蕉','京东',2273.00);
INSERT INTO sales_data VALUES ('2019-05-28','香蕉','店面',2164.00);
INSERT INTO sales_data VALUES ('2019-05-28','苹果','淘宝',2537.00);
INSERT INTO sales_data VALUES ('2019-05-28','苹果','京东',1640.00);
INSERT INTO sales_data VALUES ('2019-05-28','苹果','店面',2650.00);
INSERT INTO sales_data VALUES ('2019-05-29','桔子','淘宝',1781.00);
INSERT INTO sales_data VALUES ('2019-05-29','桔子','京东',1510.00);
INSERT INTO sales_data VALUES ('2019-05-29','桔子','店面',1938.00);
INSERT INTO sales_data VALUES ('2019-05-29','香蕉','淘宝',2048.00);
INSERT INTO sales_data VALUES ('2019-05-29','香蕉','京东',2440.00);
INSERT INTO sales_data VALUES ('2019-05-29','香蕉','店面',2549.00);
INSERT INTO sales_data VALUES ('2019-05-29','苹果','淘宝',2304.00);
INSERT INTO sales_data VALUES ('2019-05-29','苹果','京东',1745.00);
INSERT INTO sales_data VALUES ('2019-05-29','苹果','店面',1497.00);
INSERT INTO sales_data VALUES ('2019-05-30','桔子','淘宝',2197.00);
INSERT INTO sales_data VALUES ('2019-05-30','桔子','京东',2216.00);
INSERT INTO sales_data VALUES ('2019-05-30','桔子','店面',2610.00);
INSERT INTO sales_data VALUES ('2019-05-30','香蕉','淘宝',2577.00);
INSERT INTO sales_data VALUES ('2019-05-30','香蕉','京东',2185.00);
INSERT INTO sales_data VALUES ('2019-05-30','香蕉','店面',1733.00);
INSERT INTO sales_data VALUES ('2019-05-30','苹果','淘宝',2159.00);
INSERT INTO sales_data VALUES ('2019-05-30','苹果','京东',1657.00);
INSERT INTO sales_data VALUES ('2019-05-30','苹果','店面',1661.00);
INSERT INTO sales_data VALUES ('2019-05-31','桔子','淘宝',1290.00);
INSERT INTO sales_data VALUES ('2019-05-31','桔子','京东',2660.00);
INSERT INTO sales_data VALUES ('2019-05-31','桔子','店面',1661.00);
INSERT INTO sales_data VALUES ('2019-05-31','香蕉','淘宝',1324.00);
INSERT INTO sales_data VALUES ('2019-05-31','香蕉','京东',1743.00);
INSERT INTO sales_data VALUES ('2019-05-31','香蕉','店面',2389.00);
INSERT INTO sales_data VALUES ('2019-05-31','苹果','淘宝',1274.00);
INSERT INTO sales_data VALUES ('2019-05-31','苹果','京东',1554.00);
INSERT INTO sales_data VALUES ('2019-05-31','苹果','店面',1927.00);
INSERT INTO sales_data VALUES ('2019-06-01','桔子','淘宝',2209.00);
INSERT INTO sales_data VALUES ('2019-06-01','桔子','京东',1361.00);
INSERT INTO sales_data VALUES ('2019-06-01','桔子','店面',2336.00);
INSERT INTO sales_data VALUES ('2019-06-01','香蕉','淘宝',2123.00);
INSERT INTO sales_data VALUES ('2019-06-01','香蕉','京东',1902.00);
INSERT INTO sales_data VALUES ('2019-06-01','香蕉','店面',2606.00);
INSERT INTO sales_data VALUES ('2019-06-01','苹果','淘宝',1321.00);
INSERT INTO sales_data VALUES ('2019-06-01','苹果','京东',2710.00);
INSERT INTO sales_data VALUES ('2019-06-01','苹果','店面',2306.00);
INSERT INTO sales_data VALUES ('2019-06-02','桔子','淘宝',2635.00);
INSERT INTO sales_data VALUES ('2019-06-02','桔子','京东',2279.00);
INSERT INTO sales_data VALUES ('2019-06-02','桔子','店面',1316.00);
INSERT INTO sales_data VALUES ('2019-06-02','香蕉','淘宝',1392.00);
INSERT INTO sales_data VALUES ('2019-06-02','香蕉','京东',1731.00);
INSERT INTO sales_data VALUES ('2019-06-02','香蕉','店面',2287.00);
INSERT INTO sales_data VALUES ('2019-06-02','苹果','淘宝',2757.00);
INSERT INTO sales_data VALUES ('2019-06-02','苹果','京东',1563.00);
INSERT INTO sales_data VALUES ('2019-06-02','苹果','店面',1728.00);
INSERT INTO sales_data VALUES ('2019-06-03','桔子','淘宝',1750.00);
INSERT INTO sales_data VALUES ('2019-06-03','桔子','京东',2482.00);
INSERT INTO sales_data VALUES ('2019-06-03','桔子','店面',2144.00);
INSERT INTO sales_data VALUES ('2019-06-03','香蕉','淘宝',2166.00);
INSERT INTO sales_data VALUES ('2019-06-03','香蕉','京东',2522.00);
INSERT INTO sales_data VALUES ('2019-06-03','香蕉','店面',2054.00);
INSERT INTO sales_data VALUES ('2019-06-03','苹果','淘宝',2577.00);
INSERT INTO sales_data VALUES ('2019-06-03','苹果','京东',2596.00);
INSERT INTO sales_data VALUES ('2019-06-03','苹果','店面',2547.00);
INSERT INTO sales_data VALUES ('2019-06-04','桔子','淘宝',2220.00);
INSERT INTO sales_data VALUES ('2019-06-04','桔子','京东',2625.00);
INSERT INTO sales_data VALUES ('2019-06-04','桔子','店面',1357.00);
INSERT INTO sales_data VALUES ('2019-06-04','香蕉','淘宝',1397.00);
INSERT INTO sales_data VALUES ('2019-06-04','香蕉','京东',2079.00);
INSERT INTO sales_data VALUES ('2019-06-04','香蕉','店面',1463.00);
INSERT INTO sales_data VALUES ('2019-06-04','苹果','淘宝',2478.00);
INSERT INTO sales_data VALUES ('2019-06-04','苹果','京东',1447.00);
INSERT INTO sales_data VALUES ('2019-06-04','苹果','店面',2109.00);
INSERT INTO sales_data VALUES ('2019-06-05','桔子','淘宝',2334.00);
INSERT INTO sales_data VALUES ('2019-06-05','桔子','京东',1518.00);
INSERT INTO sales_data VALUES ('2019-06-05','桔子','店面',2069.00);
INSERT INTO sales_data VALUES ('2019-06-05','香蕉','淘宝',1885.00);
INSERT INTO sales_data VALUES ('2019-06-05','香蕉','京东',1393.00);
INSERT INTO sales_data VALUES ('2019-06-05','香蕉','店面',1588.00);
INSERT INTO sales_data VALUES ('2019-06-05','苹果','淘宝',1942.00);
INSERT INTO sales_data VALUES ('2019-06-05','苹果','京东',1525.00);
INSERT INTO sales_data VALUES ('2019-06-05','苹果','店面',2059.00);
INSERT INTO sales_data VALUES ('2019-06-06','桔子','淘宝',1474.00);
INSERT INTO sales_data VALUES ('2019-06-06','桔子','京东',1527.00);
INSERT INTO sales_data VALUES ('2019-06-06','桔子','店面',2367.00);
INSERT INTO sales_data VALUES ('2019-06-06','香蕉','淘宝',1941.00);
INSERT INTO sales_data VALUES ('2019-06-06','香蕉','京东',2012.00);
INSERT INTO sales_data VALUES ('2019-06-06','香蕉','店面',2085.00);
INSERT INTO sales_data VALUES ('2019-06-06','苹果','淘宝',1321.00);
INSERT INTO sales_data VALUES ('2019-06-06','苹果','京东',1413.00);
INSERT INTO sales_data VALUES ('2019-06-06','苹果','店面',1841.00);
INSERT INTO sales_data VALUES ('2019-06-07','桔子','淘宝',2115.00);
INSERT INTO sales_data VALUES ('2019-06-07','桔子','京东',2730.00);
INSERT INTO sales_data VALUES ('2019-06-07','桔子','店面',1677.00);
INSERT INTO sales_data VALUES ('2019-06-07','香蕉','淘宝',1897.00);
INSERT INTO sales_data VALUES ('2019-06-07','香蕉','京东',2180.00);
INSERT INTO sales_data VALUES ('2019-06-07','香蕉','店面',1532.00);
INSERT INTO sales_data VALUES ('2019-06-07','苹果','淘宝',1984.00);
INSERT INTO sales_data VALUES ('2019-06-07','苹果','京东',2307.00);
INSERT INTO sales_data VALUES ('2019-06-07','苹果','店面',2341.00);
INSERT INTO sales_data VALUES ('2019-06-08','桔子','淘宝',2181.00);
INSERT INTO sales_data VALUES ('2019-06-08','桔子','京东',2020.00);
INSERT INTO sales_data VALUES ('2019-06-08','桔子','店面',2523.00);
INSERT INTO sales_data VALUES ('2019-06-08','香蕉','淘宝',1521.00);
INSERT INTO sales_data VALUES ('2019-06-08','香蕉','京东',1579.00);
INSERT INTO sales_data VALUES ('2019-06-08','香蕉','店面',2766.00);
INSERT INTO sales_data VALUES ('2019-06-08','苹果','淘宝',2315.00);
INSERT INTO sales_data VALUES ('2019-06-08','苹果','京东',2190.00);
INSERT INTO sales_data VALUES ('2019-06-08','苹果','店面',1384.00);
INSERT INTO sales_data VALUES ('2019-06-09','桔子','淘宝',2633.00);
INSERT INTO sales_data VALUES ('2019-06-09','桔子','京东',1361.00);
INSERT INTO sales_data VALUES ('2019-06-09','桔子','店面',1639.00);
INSERT INTO sales_data VALUES ('2019-06-09','香蕉','淘宝',1916.00);
INSERT INTO sales_data VALUES ('2019-06-09','香蕉','京东',1555.00);
INSERT INTO sales_data VALUES ('2019-06-09','香蕉','店面',1886.00);
INSERT INTO sales_data VALUES ('2019-06-09','苹果','淘宝',1504.00);
INSERT INTO sales_data VALUES ('2019-06-09','苹果','京东',2217.00);
INSERT INTO sales_data VALUES ('2019-06-09','苹果','店面',2619.00);
INSERT INTO sales_data VALUES ('2019-06-10','桔子','淘宝',2313.00);
INSERT INTO sales_data VALUES ('2019-06-10','桔子','京东',2262.00);
INSERT INTO sales_data VALUES ('2019-06-10','桔子','店面',2757.00);
INSERT INTO sales_data VALUES ('2019-06-10','香蕉','淘宝',1375.00);
INSERT INTO sales_data VALUES ('2019-06-10','香蕉','京东',1592.00);
INSERT INTO sales_data VALUES ('2019-06-10','香蕉','店面',2701.00);
INSERT INTO sales_data VALUES ('2019-06-10','苹果','淘宝',1767.00);
INSERT INTO sales_data VALUES ('2019-06-10','苹果','京东',2204.00);
INSERT INTO sales_data VALUES ('2019-06-10','苹果','店面',2096.00);
INSERT INTO sales_data VALUES ('2019-06-11','桔子','淘宝',2019.00);
INSERT INTO sales_data VALUES ('2019-06-11','桔子','京东',1408.00);
INSERT INTO sales_data VALUES ('2019-06-11','桔子','店面',1623.00);
INSERT INTO sales_data VALUES ('2019-06-11','香蕉','淘宝',1575.00);
INSERT INTO sales_data VALUES ('2019-06-11','香蕉','京东',2299.00);
INSERT INTO sales_data VALUES ('2019-06-11','香蕉','店面',2353.00);
INSERT INTO sales_data VALUES ('2019-06-11','苹果','淘宝',1308.00);
INSERT INTO sales_data VALUES ('2019-06-11','苹果','京东',2530.00);
INSERT INTO sales_data VALUES ('2019-06-11','苹果','店面',2643.00);
INSERT INTO sales_data VALUES ('2019-06-12','桔子','淘宝',2788.00);
INSERT INTO sales_data VALUES ('2019-06-12','桔子','京东',2060.00);
INSERT INTO sales_data VALUES ('2019-06-12','桔子','店面',2048.00);
INSERT INTO sales_data VALUES ('2019-06-12','香蕉','淘宝',1382.00);
INSERT INTO sales_data VALUES ('2019-06-12','香蕉','京东',1897.00);
INSERT INTO sales_data VALUES ('2019-06-12','香蕉','店面',2114.00);
INSERT INTO sales_data VALUES ('2019-06-12','苹果','淘宝',1726.00);
INSERT INTO sales_data VALUES ('2019-06-12','苹果','京东',2519.00);
INSERT INTO sales_data VALUES ('2019-06-12','苹果','店面',2374.00);
INSERT INTO sales_data VALUES ('2019-06-13','桔子','淘宝',2322.00);
INSERT INTO sales_data VALUES ('2019-06-13','桔子','京东',2732.00);
INSERT INTO sales_data VALUES ('2019-06-13','桔子','店面',1801.00);
INSERT INTO sales_data VALUES ('2019-06-13','香蕉','淘宝',2145.00);
INSERT INTO sales_data VALUES ('2019-06-13','香蕉','京东',2246.00);
INSERT INTO sales_data VALUES ('2019-06-13','香蕉','店面',2763.00);
INSERT INTO sales_data VALUES ('2019-06-13','苹果','淘宝',2102.00);
INSERT INTO sales_data VALUES ('2019-06-13','苹果','京东',2320.00);
INSERT INTO sales_data VALUES ('2019-06-13','苹果','店面',1555.00);
INSERT INTO sales_data VALUES ('2019-06-14','桔子','淘宝',2008.00);
INSERT INTO sales_data VALUES ('2019-06-14','桔子','京东',2792.00);
INSERT INTO sales_data VALUES ('2019-06-14','桔子','店面',2465.00);
INSERT INTO sales_data VALUES ('2019-06-14','香蕉','淘宝',2805.00);
INSERT INTO sales_data VALUES ('2019-06-14','香蕉','京东',2006.00);
INSERT INTO sales_data VALUES ('2019-06-14','香蕉','店面',2568.00);
INSERT INTO sales_data VALUES ('2019-06-14','苹果','淘宝',1623.00);
INSERT INTO sales_data VALUES ('2019-06-14','苹果','京东',2276.00);
INSERT INTO sales_data VALUES ('2019-06-14','苹果','店面',2062.00);
INSERT INTO sales_data VALUES ('2019-06-15','桔子','淘宝',2677.00);
INSERT INTO sales_data VALUES ('2019-06-15','桔子','京东',2284.00);
INSERT INTO sales_data VALUES ('2019-06-15','桔子','店面',1793.00);
INSERT INTO sales_data VALUES ('2019-06-15','香蕉','淘宝',2514.00);
INSERT INTO sales_data VALUES ('2019-06-15','香蕉','京东',2262.00);
INSERT INTO sales_data VALUES ('2019-06-15','香蕉','店面',2542.00);
INSERT INTO sales_data VALUES ('2019-06-15','苹果','淘宝',1752.00);
INSERT INTO sales_data VALUES ('2019-06-15','苹果','京东',2334.00);
INSERT INTO sales_data VALUES ('2019-06-15','苹果','店面',1629.00);
INSERT INTO sales_data VALUES ('2019-06-16','桔子','淘宝',2561.00);
INSERT INTO sales_data VALUES ('2019-06-16','桔子','京东',2754.00);
INSERT INTO sales_data VALUES ('2019-06-16','桔子','店面',1343.00);
INSERT INTO sales_data VALUES ('2019-06-16','香蕉','淘宝',2125.00);
INSERT INTO sales_data VALUES ('2019-06-16','香蕉','京东',2261.00);
INSERT INTO sales_data VALUES ('2019-06-16','香蕉','店面',2760.00);
INSERT INTO sales_data VALUES ('2019-06-16','苹果','淘宝',2610.00);
INSERT INTO sales_data VALUES ('2019-06-16','苹果','京东',1592.00);
INSERT INTO sales_data VALUES ('2019-06-16','苹果','店面',2191.00);
INSERT INTO sales_data VALUES ('2019-06-17','桔子','淘宝',2563.00);
INSERT INTO sales_data VALUES ('2019-06-17','桔子','京东',2383.00);
INSERT INTO sales_data VALUES ('2019-06-17','桔子','店面',1701.00);
INSERT INTO sales_data VALUES ('2019-06-17','香蕉','淘宝',2804.00);
INSERT INTO sales_data VALUES ('2019-06-17','香蕉','京东',1572.00);
INSERT INTO sales_data VALUES ('2019-06-17','香蕉','店面',1674.00);
INSERT INTO sales_data VALUES ('2019-06-17','苹果','淘宝',2448.00);
INSERT INTO sales_data VALUES ('2019-06-17','苹果','京东',1557.00);
INSERT INTO sales_data VALUES ('2019-06-17','苹果','店面',2360.00);
INSERT INTO sales_data VALUES ('2019-06-18','桔子','淘宝',2201.00);
INSERT INTO sales_data VALUES ('2019-06-18','桔子','京东',1865.00);
INSERT INTO sales_data VALUES ('2019-06-18','桔子','店面',1821.00);
INSERT INTO sales_data VALUES ('2019-06-18','香蕉','淘宝',1444.00);
INSERT INTO sales_data VALUES ('2019-06-18','香蕉','京东',1716.00);
INSERT INTO sales_data VALUES ('2019-06-18','香蕉','店面',2780.00);
INSERT INTO sales_data VALUES ('2019-06-18','苹果','淘宝',1911.00);
INSERT INTO sales_data VALUES ('2019-06-18','苹果','京东',1405.00);
INSERT INTO sales_data VALUES ('2019-06-18','苹果','店面',2216.00);
INSERT INTO sales_data VALUES ('2019-06-19','桔子','淘宝',1634.00);
INSERT INTO sales_data VALUES ('2019-06-19','桔子','京东',1837.00);
INSERT INTO sales_data VALUES ('2019-06-19','桔子','店面',1730.00);
INSERT INTO sales_data VALUES ('2019-06-19','香蕉','淘宝',1938.00);
INSERT INTO sales_data VALUES ('2019-06-19','香蕉','京东',1568.00);
INSERT INTO sales_data VALUES ('2019-06-19','香蕉','店面',1655.00);
INSERT INTO sales_data VALUES ('2019-06-19','苹果','淘宝',1951.00);
INSERT INTO sales_data VALUES ('2019-06-19','苹果','京东',2363.00);
INSERT INTO sales_data VALUES ('2019-06-19','苹果','店面',2586.00);
INSERT INTO sales_data VALUES ('2019-06-20','桔子','淘宝',1886.00);
INSERT INTO sales_data VALUES ('2019-06-20','桔子','京东',2148.00);
INSERT INTO sales_data VALUES ('2019-06-20','桔子','店面',1352.00);
INSERT INTO sales_data VALUES ('2019-06-20','香蕉','淘宝',2747.00);
INSERT INTO sales_data VALUES ('2019-06-20','香蕉','京东',1876.00);
INSERT INTO sales_data VALUES ('2019-06-20','香蕉','店面',2401.00);
INSERT INTO sales_data VALUES ('2019-06-20','苹果','淘宝',1614.00);
INSERT INTO sales_data VALUES ('2019-06-20','苹果','京东',1845.00);
INSERT INTO sales_data VALUES ('2019-06-20','苹果','店面',2638.00);
INSERT INTO sales_data VALUES ('2019-06-21','桔子','淘宝',1958.00);
INSERT INTO sales_data VALUES ('2019-06-21','桔子','京东',1464.00);
INSERT INTO sales_data VALUES ('2019-06-21','桔子','店面',1364.00);
INSERT INTO sales_data VALUES ('2019-06-21','香蕉','淘宝',1483.00);
INSERT INTO sales_data VALUES ('2019-06-21','香蕉','京东',2325.00);
INSERT INTO sales_data VALUES ('2019-06-21','香蕉','店面',1889.00);
INSERT INTO sales_data VALUES ('2019-06-21','苹果','淘宝',1964.00);
INSERT INTO sales_data VALUES ('2019-06-21','苹果','京东',2429.00);
INSERT INTO sales_data VALUES ('2019-06-21','苹果','店面',2265.00);
INSERT INTO sales_data VALUES ('2019-06-22','桔子','淘宝',1908.00);
INSERT INTO sales_data VALUES ('2019-06-22','桔子','京东',1505.00);
INSERT INTO sales_data VALUES ('2019-06-22','桔子','店面',2336.00);
INSERT INTO sales_data VALUES ('2019-06-22','香蕉','淘宝',2785.00);
INSERT INTO sales_data VALUES ('2019-06-22','香蕉','京东',1794.00);
INSERT INTO sales_data VALUES ('2019-06-22','香蕉','店面',2828.00);
INSERT INTO sales_data VALUES ('2019-06-22','苹果','淘宝',1670.00);
INSERT INTO sales_data VALUES ('2019-06-22','苹果','京东',2387.00);
INSERT INTO sales_data VALUES ('2019-06-22','苹果','店面',1551.00);
INSERT INTO sales_data VALUES ('2019-06-23','桔子','淘宝',1985.00);
INSERT INTO sales_data VALUES ('2019-06-23','桔子','京东',1498.00);
INSERT INTO sales_data VALUES ('2019-06-23','桔子','店面',2573.00);
INSERT INTO sales_data VALUES ('2019-06-23','香蕉','淘宝',1725.00);
INSERT INTO sales_data VALUES ('2019-06-23','香蕉','京东',2034.00);
INSERT INTO sales_data VALUES ('2019-06-23','香蕉','店面',1871.00);
INSERT INTO sales_data VALUES ('2019-06-23','苹果','淘宝',1728.00);
INSERT INTO sales_data VALUES ('2019-06-23','苹果','京东',1932.00);
INSERT INTO sales_data VALUES ('2019-06-23','苹果','店面',2398.00);
INSERT INTO sales_data VALUES ('2019-06-24','桔子','淘宝',2784.00);
INSERT INTO sales_data VALUES ('2019-06-24','桔子','京东',2201.00);
INSERT INTO sales_data VALUES ('2019-06-24','桔子','店面',1398.00);
INSERT INTO sales_data VALUES ('2019-06-24','香蕉','淘宝',2571.00);
INSERT INTO sales_data VALUES ('2019-06-24','香蕉','京东',2803.00);
INSERT INTO sales_data VALUES ('2019-06-24','香蕉','店面',1507.00);
INSERT INTO sales_data VALUES ('2019-06-24','苹果','淘宝',2581.00);
INSERT INTO sales_data VALUES ('2019-06-24','苹果','京东',1431.00);
INSERT INTO sales_data VALUES ('2019-06-24','苹果','店面',2477.00);
INSERT INTO sales_data VALUES ('2019-06-25','桔子','淘宝',1620.00);
INSERT INTO sales_data VALUES ('2019-06-25','桔子','京东',2044.00);
INSERT INTO sales_data VALUES ('2019-06-25','桔子','店面',2055.00);
INSERT INTO sales_data VALUES ('2019-06-25','香蕉','淘宝',2530.00);
INSERT INTO sales_data VALUES ('2019-06-25','香蕉','京东',2593.00);
INSERT INTO sales_data VALUES ('2019-06-25','香蕉','店面',2201.00);
INSERT INTO sales_data VALUES ('2019-06-25','苹果','淘宝',2006.00);
INSERT INTO sales_data VALUES ('2019-06-25','苹果','京东',2517.00);
INSERT INTO sales_data VALUES ('2019-06-25','苹果','店面',2634.00);
INSERT INTO sales_data VALUES ('2019-06-26','桔子','淘宝',1979.00);
INSERT INTO sales_data VALUES ('2019-06-26','桔子','京东',2832.00);
INSERT INTO sales_data VALUES ('2019-06-26','桔子','店面',2166.00);
INSERT INTO sales_data VALUES ('2019-06-26','香蕉','淘宝',2170.00);
INSERT INTO sales_data VALUES ('2019-06-26','香蕉','京东',1952.00);
INSERT INTO sales_data VALUES ('2019-06-26','香蕉','店面',2299.00);
INSERT INTO sales_data VALUES ('2019-06-26','苹果','淘宝',1878.00);
INSERT INTO sales_data VALUES ('2019-06-26','苹果','京东',2312.00);
INSERT INTO sales_data VALUES ('2019-06-26','苹果','店面',1468.00);
INSERT INTO sales_data VALUES ('2019-06-27','桔子','淘宝',2389.00);
INSERT INTO sales_data VALUES ('2019-06-27','桔子','京东',2680.00);
INSERT INTO sales_data VALUES ('2019-06-27','桔子','店面',2040.00);
INSERT INTO sales_data VALUES ('2019-06-27','香蕉','淘宝',1922.00);
INSERT INTO sales_data VALUES ('2019-06-27','香蕉','京东',2594.00);
INSERT INTO sales_data VALUES ('2019-06-27','香蕉','店面',2870.00);
INSERT INTO sales_data VALUES ('2019-06-27','苹果','淘宝',1950.00);
INSERT INTO sales_data VALUES ('2019-06-27','苹果','京东',2296.00);
INSERT INTO sales_data VALUES ('2019-06-27','苹果','店面',2803.00);
INSERT INTO sales_data VALUES ('2019-06-28','桔子','淘宝',2092.00);
INSERT INTO sales_data VALUES ('2019-06-28','桔子','京东',2011.00);
INSERT INTO sales_data VALUES ('2019-06-28','桔子','店面',2869.00);
INSERT INTO sales_data VALUES ('2019-06-28','香蕉','淘宝',1699.00);
INSERT INTO sales_data VALUES ('2019-06-28','香蕉','京东',2256.00);
INSERT INTO sales_data VALUES ('2019-06-28','香蕉','店面',2038.00);
INSERT INTO sales_data VALUES ('2019-06-28','苹果','淘宝',2379.00);
INSERT INTO sales_data VALUES ('2019-06-28','苹果','京东',1911.00);
INSERT INTO sales_data VALUES ('2019-06-28','苹果','店面',1756.00);
INSERT INTO sales_data VALUES ('2019-06-29','桔子','淘宝',1709.00);
INSERT INTO sales_data VALUES ('2019-06-29','桔子','京东',2547.00);
INSERT INTO sales_data VALUES ('2019-06-29','桔子','店面',1403.00);
INSERT INTO sales_data VALUES ('2019-06-29','香蕉','淘宝',1469.00);
INSERT INTO sales_data VALUES ('2019-06-29','香蕉','京东',1646.00);
INSERT INTO sales_data VALUES ('2019-06-29','香蕉','店面',2856.00);
INSERT INTO sales_data VALUES ('2019-06-29','苹果','淘宝',2255.00);
INSERT INTO sales_data VALUES ('2019-06-29','苹果','京东',2436.00);
INSERT INTO sales_data VALUES ('2019-06-29','苹果','店面',1928.00);
INSERT INTO sales_data VALUES ('2019-06-30','桔子','淘宝',1679.00);
INSERT INTO sales_data VALUES ('2019-06-30','桔子','京东',1439.00);
INSERT INTO sales_data VALUES ('2019-06-30','桔子','店面',2865.00);
INSERT INTO sales_data VALUES ('2019-06-30','香蕉','淘宝',1767.00);
INSERT INTO sales_data VALUES ('2019-06-30','香蕉','京东',2443.00);
INSERT INTO sales_data VALUES ('2019-06-30','香蕉','店面',2660.00);
INSERT INTO sales_data VALUES ('2019-06-30','苹果','淘宝',2422.00);
INSERT INTO sales_data VALUES ('2019-06-30','苹果','京东',1481.00);
INSERT INTO sales_data VALUES ('2019-06-30','苹果','店面',2369.00);

SQL

SELECT 
  sd.product AS '产品',
    sd.channel AS '渠道',
    SUM(
    CASE
        EXTRACT(MONTH FROM sd.saledate) 
        WHEN 1 THEN amount 
        END
    )
    AS '1月',
    SUM(
    CASE
        EXTRACT(MONTH FROM sd.saledate) 
        WHEN 1 THEN amount 
        END
    )
    AS '2月',
    SUM(
    CASE
        EXTRACT(MONTH FROM sd.saledate) 
        WHEN 1 THEN amount 
        END
    )
    AS '3月',
    SUM(
    CASE
        EXTRACT(MONTH FROM sd.saledate) 
        WHEN 1 THEN amount 
        END
    )
    AS '4月',
    SUM(
    CASE
        EXTRACT(MONTH FROM sd.saledate) 
        WHEN 1 THEN amount 
        END
    )
    AS '5月',
    SUM(
    CASE
        EXTRACT(MONTH FROM sd.saledate) 
        WHEN 1 THEN amount 
        END
    )
    AS '6月',
    SUM(
    CASE
        EXTRACT(MONTH FROM sd.saledate) 
        WHEN 1 THEN amount 
        END
    )
    AS '7月',
    SUM(
    CASE
        EXTRACT(MONTH FROM sd.saledate) 
        WHEN 1 THEN amount 
        END
    )
    AS '8月',
    SUM(
    CASE
        EXTRACT(MONTH FROM sd.saledate) 
        WHEN 1 THEN amount 
        END
    )
    AS '9月',
    SUM(
    CASE
        EXTRACT(MONTH FROM sd.saledate) 
        WHEN 1 THEN amount 
        END
    )
    AS '10月',
    SUM(
    CASE
        EXTRACT(MONTH FROM sd.saledate) 
        WHEN 1 THEN amount 
        END
    )
    AS '11月',
    SUM(
    CASE
        EXTRACT(MONTH FROM sd.saledate) 
        WHEN 1 THEN amount 
        END
    )
    AS '12月'
FROM
  sales_data sd
GROUP BY
  sd.product,sd.channel;

  • 得到结果

    sql-13

CATALOG
    FEATURED TAGS
    推荐系统 数据结构 用户画像 指标体系 数仓建模 用户运营 SQL 数据埋点 HBase Hive OLAP 数仓运维 BI FineBI Hadoop Spark Tableau 数仓 数据中台 数据治理 数据湖 数据集市 Airflow DataX DolphinScheduler Flume Kafka Maxwell Zookeeper 任务调度 Elasticsearch ETL 数据产品 数据库 MySQL Python Redis JS逆向 安卓逆向 爬虫 HTTP
    FRIENDS