有哪些网站做明星周边,明起3天洛阳市开展区域核酸检测,建设厅网站查询电工证件,电子商务网站建设和管理postgresql-窗口函数 简介窗口函数的定义分区选项#xff08;PARTITION BY#xff09;排序选项#xff08;ORDER BY#xff09;窗口选项#xff08;frame_clause#xff09; 聚合窗口函数排名窗口函数演示了 CUME_DIST 和 NTILE 函数 取值窗口函数 简介
常见的聚合函数PARTITION BY排序选项ORDER BY窗口选项frame_clause 聚合窗口函数排名窗口函数演示了 CUME_DIST 和 NTILE 函数 取值窗口函数 简介
常见的聚合函数包括 AVG、COUNT、MAX、MIN、SUM 以及 STRING_AGG。聚合函数的作用是针对一组数据行进行运算并且返回一条汇总结果 除了聚合函数之外SQL 还定义了许多专门用于数据分析的窗口函数Window Function。 不过窗口函数不是将一组数据汇总为单个结果而是针对每一行数据基于和它相关的一组数 据计算出一个结果。下图演示了聚合函数和窗口函数的区别 以下示例分别将 AVG、COUNT、SUM 作为聚合函数和窗口函数计算员工的平均月薪、 人数总和以及月薪总和 聚合函数通常也可以作为窗口函数区别在于后者包含了 OVER 关键字空括号表示将所 有数据作为整体进行分析所以得到的数值和聚合函数一样。显然窗口函数为每一个员工都返 回了一个结果。
窗口函数的定义
语法
window_function ( expression, ... ) OVER (PARTITION BY ...ORDER BY ...frame_clause
)其中 window_function 是窗口函数的名称expression 是函数参数有些函数不需要参数 OVER 子句包含三个选项分区PARTITION BY、排序ORDER BY以及窗口大小 frame_clause。
分区选项PARTITION BY
PARTITION BY 选项用于定义分区作用类似于 GROUP BY 的分组。如果指定了分区选项 窗口函数将会分别针对每个分区单独进行分析如果省略分区选项所有的数据作为一个整体进 行分析
--按照部门进行分组分析每个部门的平均月薪
select
e.first_name ,
e.last_name ,
e.department_id ,
e.salary ,
avg(e.salary) over(partition by e.department_id)
from employees e
order by e.department_id ;部门 10 只有一个员工平均月薪就是她自己的月薪 4400部门 20 有两个员工平均月薪 等于 (6000 13000)/2 9500其他数据依次类推。
排序选项ORDER BY
ORDER BY 选项用于指定分区内的排序方式通常用于数据的排名分析
--计算每个员工在部门内的入职顺序
select
e.first_name ,
e.last_name ,
e.department_id,
e.hire_date,
rank() over (partition by e.department_id order by e.hire_date)
from employees e;其中PARTITION BY 选项表示按照部门进行分区ORDER BY 选项指定在部门内按照入职先后进行排序RANK 函数用于计算名次 ORDER BY 子句同样支持 NULLS FIRST 和 NULLS LAST 选项用于指定空值的排序顺 序。默认为 NULLS LAST
窗口选项frame_clause
frame_clause 选项用于在当前分区内指定一个计算窗口。指定了窗口之后分析函数不再基 于分区进行计算而是基于窗口内的数据进行计算
示例数据
CREATE TABLE sales_monthly(product VARCHAR(20), ym VARCHAR(10), amount NUMERIC(10, 2));INSERT INTO sales_monthly (product,ym,amount) VALUES (苹果,201801,10159.00);
INSERT INTO sales_monthly (product,ym,amount) VALUES (苹果,201802,10211.00);
INSERT INTO sales_monthly (product,ym,amount) VALUES (苹果,201803,10247.00);
INSERT INTO sales_monthly (product,ym,amount) VALUES (苹果,201804,10376.00);
INSERT INTO sales_monthly (product,ym,amount) VALUES (苹果,201805,10400.00);
INSERT INTO sales_monthly (product,ym,amount) VALUES (苹果,201806,10565.00);
INSERT INTO sales_monthly (product,ym,amount) VALUES (苹果,201807,10613.00);
INSERT INTO sales_monthly (product,ym,amount) VALUES (苹果,201808,10696.00);
INSERT INTO sales_monthly (product,ym,amount) VALUES (苹果,201809,10751.00);
INSERT INTO sales_monthly (product,ym,amount) VALUES (苹果,201810,10842.00);
INSERT INTO sales_monthly (product,ym,amount) VALUES (苹果,201811,10900.00);
INSERT INTO sales_monthly (product,ym,amount) VALUES (苹果,201812,10972.00);
INSERT INTO sales_monthly (product,ym,amount) VALUES (苹果,201901,11155.00);
INSERT INTO sales_monthly (product,ym,amount) VALUES (苹果,201902,11202.00);
INSERT INTO sales_monthly (product,ym,amount) VALUES (苹果,201903,11260.00);
INSERT INTO sales_monthly (product,ym,amount) VALUES (苹果,201904,11341.00);
INSERT INTO sales_monthly (product,ym,amount) VALUES (苹果,201905,11459.00);
INSERT INTO sales_monthly (product,ym,amount) VALUES (苹果,201906,11560.00);
INSERT INTO sales_monthly (product,ym,amount) VALUES (香蕉,201801,10138.00);
INSERT INTO sales_monthly (product,ym,amount) VALUES (香蕉,201802,10194.00);
INSERT INTO sales_monthly (product,ym,amount) VALUES (香蕉,201803,10328.00);
INSERT INTO sales_monthly (product,ym,amount) VALUES (香蕉,201804,10322.00);
INSERT INTO sales_monthly (product,ym,amount) VALUES (香蕉,201805,10481.00);
INSERT INTO sales_monthly (product,ym,amount) VALUES (香蕉,201806,10502.00);
INSERT INTO sales_monthly (product,ym,amount) VALUES (香蕉,201807,10589.00);
INSERT INTO sales_monthly (product,ym,amount) VALUES (香蕉,201808,10681.00);
INSERT INTO sales_monthly (product,ym,amount) VALUES (香蕉,201809,10798.00);
INSERT INTO sales_monthly (product,ym,amount) VALUES (香蕉,201810,10829.00);
INSERT INTO sales_monthly (product,ym,amount) VALUES (香蕉,201811,10913.00);
INSERT INTO sales_monthly (product,ym,amount) VALUES (香蕉,201812,11056.00);
INSERT INTO sales_monthly (product,ym,amount) VALUES (香蕉,201901,11161.00);
INSERT INTO sales_monthly (product,ym,amount) VALUES (香蕉,201902,11173.00);
INSERT INTO sales_monthly (product,ym,amount) VALUES (香蕉,201903,11288.00);
INSERT INTO sales_monthly (product,ym,amount) VALUES (香蕉,201904,11408.00);
INSERT INTO sales_monthly (product,ym,amount) VALUES (香蕉,201905,11469.00);
INSERT INTO sales_monthly (product,ym,amount) VALUES (香蕉,201906,11528.00);
INSERT INTO sales_monthly (product,ym,amount) VALUES (桔子,201801,10154.00);
INSERT INTO sales_monthly (product,ym,amount) VALUES (桔子,201802,10183.00);
INSERT INTO sales_monthly (product,ym,amount) VALUES (桔子,201803,10245.00);
INSERT INTO sales_monthly (product,ym,amount) VALUES (桔子,201804,10325.00);
INSERT INTO sales_monthly (product,ym,amount) VALUES (桔子,201805,10465.00);
INSERT INTO sales_monthly (product,ym,amount) VALUES (桔子,201806,10505.00);
INSERT INTO sales_monthly (product,ym,amount) VALUES (桔子,201807,10578.00);
INSERT INTO sales_monthly (product,ym,amount) VALUES (桔子,201808,10680.00);
INSERT INTO sales_monthly (product,ym,amount) VALUES (桔子,201809,10788.00);
INSERT INTO sales_monthly (product,ym,amount) VALUES (桔子,201810,10838.00);
INSERT INTO sales_monthly (product,ym,amount) VALUES (桔子,201811,10942.00);
INSERT INTO sales_monthly (product,ym,amount) VALUES (桔子,201812,10988.00);
INSERT INTO sales_monthly (product,ym,amount) VALUES (桔子,201901,11099.00);
INSERT INTO sales_monthly (product,ym,amount) VALUES (桔子,201902,11181.00);
INSERT INTO sales_monthly (product,ym,amount) VALUES (桔子,201903,11302.00);
INSERT INTO sales_monthly (product,ym,amount) VALUES (桔子,201904,11327.00);
INSERT INTO sales_monthly (product,ym,amount) VALUES (桔子,201905,11423.00);
INSERT INTO sales_monthly (product,ym,amount) VALUES (桔子,201906,11524.00);-- 计算每个产品当当前月份的累计销量
SELECT product AS 产品, ym 年月, amount 销量,SUM(amount) OVER (PARTITION BY product ORDER BY ym ROWS BETWEEN UNBOUNDED
PRECEDING AND CURRENT ROW)FROM sales_monthly
ORDER BY product, ym;其中PARTITION BY 选项表示按照产品进行分区ORDER BY 选项表示按照日期进行排 序窗口子句 ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW 指定窗口从 当前分区的第一行开始到当前行结束因此 SUM 函数计算的是产品累计到当前月份为止的销 量合计。
具体来说窗口大小的常用选项如下
{ ROWS | RANGE } frame_start
{ ROWS | RANGE } BETWEEN frame_start AND frame_end其中ROWS 表示以行为单位计算窗口的偏移量RANGE 表示以数值例如 30 分钟为 单位计算窗口的偏移量。其中frame_start 用于定义窗口的起始位置可以指定以下内容之一
UNBOUNDED PRECEDING窗口从分区的第一行开始默认值N PRECEDING窗口从当前行之前的第 N 行或者数值开始CURRENT ROW窗口从当前行开始。 frame_end 用于定义窗口的结束位置可以指定以下内容之一CURRENT ROW窗口到当前行结束默认值N FOLLOWING窗口到当前行之后的第 N 行或者数值结束UNBOUNDED FOLLOWING窗口到分区的最后一行结束 CURRENT ROW 表示当前正在处理的行其他的行可以使用相对当前行的位置表示。需要 注意窗口的大小不会超出当前分区的范围
PostgreSQL 还提供了更多复杂的窗口选项可以参考官网
常见的窗口函数可以分为以下几类聚合窗口函数、排名窗口函数以及取值窗口函数。
聚合窗口函数
常用的聚合函数例如 AVG、SUM、COUNT 等也可以作为窗口函数使用
-- create table
CREATE TABLE sales_data(saledate DATE, product VARCHAR(20), channel VARCHAR(20), amount NUMERIC(10, 2));-- insert dataINSERT 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);-- 使用 AVG 函数计算移动平均值
select saledate, amount, avg(amount) over (order by saledate rows between 1
preceding and 1 following)from sales_data
where product 桔子 and channel 淘宝;该语句返回了“桔子”在“淘宝”上的销量以及每一天和它前后一天共 3 天的平均销量。
排名窗口函数
排名窗口函数用于对数据进行分组排名。常见的排名窗口函数包括
ROW_NUMBER为分区中的每行数据分配一个序列号序列号从 1 开始分配RANK计算每行数据在其分区中的名次如果存在名次相同的数据后续的排名将会 产生跳跃DENSE_RANK计算每行数据在其分区中的名次即使存在名次相同的数据后续的 排名也是连续的值PERCENT_RANK以百分比的形式显示每行数据在其分区中的名次如果存在名次相 同的数据后续的排名将会产生跳跃CUME_DIST计算每行数据在其分区内的累积分布也就是该行数据及其之前的数据 的比率取值范围大于 0 并且小于等于 1NTILE将分区内的数据分为 N 等份为每行数据计算其所在的位置 排名窗口函数不支持动态的窗口大小frame_clause而是以当前分区作为分析的窗口。
--按照部门为单位计算员工的月薪排名
SELECT d.department_name 部门名称, concat(e.first_name, , , e.last_name)
姓名, e.salary 月薪,ROW_NUMBER() OVER (PARTITION BY e.department_id ORDER BY e.salary DESC)
AS row_number,RANK() OVER (PARTITION BY e.department_id ORDER BY e.salary DESC) AS
rank,DENSE_RANK() OVER (PARTITION BY e.department_id ORDER BY e.salary DESC)
AS dense_rank,PERCENT_RANK() OVER (PARTITION BY e.department_id ORDER BY e.salary DESC)
AS percent_rankFROM employees eJOIN departments d ON (e.department_id d.department_id)
WHERE d.department_name in (IT, Purchasing)
/*** order by 1,4等于* order by d.department_name,* ROW_NUMBER() OVER (PARTITION BY e.department_id ORDER BY e.salary DESC)* AS row_number*/
ORDER BY 1, 4;ROW_NUMBER 函数为每个员工分配了一个连续的数字编号可以看作是一种排名。IT 部 门的“Valli,Pataballa”和“David,Austin”的月薪相同但是编号不同
RANK 函数为每个员工指定了一个名次IT 部门的“Valli,Pataballa”和“David,Austin”的名次 都是 3而且在他们之后的“Diana,Lorentz”的名次为 5产生了跳跃
DENSE_RANK 函数为每个员工指定了一个名次IT 部门的“Valli,Pataballa”和“David,Austin” 的名次都是 3在他们之后的“Diana,Lorentz”的名次为 4名次是连续值
PERCENT_RANK 函数按照百分比指定名次取值位于 0 到 1 之间。其中“Diana,Lorentz”的 百分比排名为 1也产生了跳跃
4 个窗口函数的 OVER 子句完全相同此时可以采用一种更简单的写法
SELECT d.department_name 部门名称, concat(e.first_name, , , e.last_name)
姓名, e.salary 月薪,ROW_NUMBER() OVER w AS row_number,RANK() OVER w AS rank,DENSE_RANK() OVER w AS dense_rank,PERCENT_RANK() OVER w AS percent_rankFROM employees eJOIN departments d ON (e.department_id d.department_id)
WHERE d.department_name in (IT, Purchasing)
WINDOW w AS (PARTITION BY e.department_id ORDER BY e.salary DESC)
ORDER BY 1, 4;其中WINDOW 定义了一个窗口变量 w然后在窗口函数的 OVER 子句中使用了该变量 这样可以简化函数的输入
窗口函数在 GROUP BY 分组、聚合函数以及 HAVING 过滤之后运行。如果多个窗口函 数拥有相同的 PARTITION BY 和 ORDER BY 选项它们会在遍历数据时一起进行计算也就是 说它们读取输入数据的顺序完全一致
演示了 CUME_DIST 和 NTILE 函数
SELECT concat(first_name, , , last_name) 姓名, hire_date AS 入职日期,CUME_DIST() OVER (ORDER BY hire_date) AS 累积占比,NTILE(100) OVER (ORDER BY hire_date) AS 相对位置FROM employees;其中CUME_DIST 函数显示 2001-01-13 以及之前入职的员工大概有 0.9%1/107 NTILE(100)函数表明前 1%入职的员工有“Lex,De Haan”和“Hermann,Baer”由于员工总数为 107 所以不是完全准确。
取值窗口函数
取值窗口函数用于返回指定位置上的数据。常见的取值窗口函数包括
FIRST_VALUE返回窗口内第一行的数据LAST_VALUE返回窗口内最后一行的数据NTH_VALUE返回窗口内第 N 行的数据LAG返回分区中当前行之前的第 N 行的数据LEAD返回分区中当前行之后第 N 行的数据 其中LAG 和 LEAD 函数不支持动态的窗口大小frame_clause而是以当前分区作为分 析的窗口
/**
* 使用 FIRST_VALUE、LAST_VALUE 以及 NTH 函数分别获取每个部门内部月薪
* 最高、月薪最低以及月薪第三高的员工
*/SELECT department_id, first_name, last_name, salary,FIRST_VALUE(salary) OVER w,LAST_VALUE(salary) OVER w,NTH_VALUE(salary, 3) OVER wFROM employees
WINDOW w AS (PARTITION BY department_id ORDER BY salary desc ROWS BETWEEN
UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING)
ORDER BY department_id, salary DESC;以上三个函数的默认窗口是从当前分区的第一行到当前行所以我们在 OVER 子句中将窗 口设置为整个分区。
LAG 和 LEAD 函数同样用于计算销量数据的环比/同比增长。例如以下语句统计不同产品 每个月的环比增长率
WITH sales_monthly AS (SELECT product, to_char(saledate,YYYYMM) ym, sum(amount) sum_amountFROM sales_dataGROUP BY product, to_char(saledate,YYYYMM)
)
SELECT product AS 产品, ym 年月, sum_amount 销量,(sum_amount - LAG(sum_amount, 1) OVER (PARTITION BY product ORDER BY
ym))/LAG(sum_amount, 1) OVER (PARTITION BY product ORDER BY ym) * 100 AS
环比增长率%FROM sales_monthly
ORDER BY product, ym;首先创建一个通用表表达式 sales_monthly得到了不同产品每个月的销量汇总 LAG(sum_amount, 1)表示获取上一期的销量当前月份的销量减去上个月的销量再除以上个月 的销量就是环比增长率
