當前位置：首頁 > news >正文

網(wǎng)站建設頁面設計南寧百度seo軟件

news 2025/7/4 14:32:19

網(wǎng)站建設頁面設計,南寧百度seo軟件,用php做動態(tài)網(wǎng)站嗎,網(wǎng)站下要加個備案號怎么做postgresql-窗口函數(shù) 簡介窗口函數(shù)的定義分區(qū)選項（PARTITION BY）排序選項（ORDER BY）窗口選項（frame_clause） 聚合窗口函數(shù)排名窗口函數(shù)演示了 CUME_DIST 和 NTILE 函數(shù) 取值窗口函數(shù) 簡介常見的聚合函數(shù)&…

postgresql-窗口函數(shù)

簡介
窗口函數(shù)的定義
- 分區(qū)選項（PARTITION BY）
- 排序選項（ORDER BY）
- 窗口選項（frame_clause）
聚合窗口函數(shù)
排名窗口函數(shù)
- 演示了 CUME_DIST 和 NTILE 函數(shù)
取值窗口函數(shù)

簡介

常見的聚合函數(shù)，包括 AVG、COUNT、MAX、MIN、SUM 以及
STRING_AGG。聚合函數(shù)的作用是針對一組數(shù)據(jù)行進行運算，并且返回一條匯總結果
除了聚合函數(shù)之外，SQL 還定義了許多專門用于數(shù)據(jù)分析的窗口函數(shù)（Window Function）。
不過，窗口函數(shù)不是將一組數(shù)據(jù)匯總為單個結果，而是針對每一行數(shù)據(jù)，基于和它相關的一組數(shù)
據(jù)計算出一個結果。下圖演示了聚合函數(shù)和窗口函數(shù)的區(qū)別：
在這里插入圖片描述
以下示例分別將 AVG、COUNT、SUM 作為聚合函數(shù)和窗口函數(shù)，計算員工的平均月薪、
人數(shù)總和以及月薪總和：

聚合函數(shù)通常也可以作為窗口函數(shù)，區(qū)別在于后者包含了 OVER 關鍵字；空括號表示將所
有數(shù)據(jù)作為整體進行分析，所以得到的數(shù)值和聚合函數(shù)一樣。顯然，窗口函數(shù)為每一個員工都返
回了一個結果。
在這里插入圖片描述

窗口函數(shù)的定義

語法

window_function ( expression, ... ) OVER (PARTITION BY ...ORDER BY ...frame_clause
)

其中 window_function 是窗口函數(shù)的名稱；expression 是函數(shù)參數(shù)，有些函數(shù)不需要參數(shù)；
OVER 子句包含三個選項：分區(qū)（PARTITION BY）、排序（ORDER BY）以及窗口大小
（frame_clause）。

分區(qū)選項（PARTITION BY）

PARTITION BY 選項用于定義分區(qū)，作用類似于 GROUP BY 的分組。如果指定了分區(qū)選項，
窗口函數(shù)將會分別針對每個分區(qū)單獨進行分析；如果省略分區(qū)選項，所有的數(shù)據(jù)作為一個整體進
行分析

--按照部門進行分組，分析每個部門的平均月薪：
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；其他數(shù)據(jù)依次類推。

排序選項（ORDER BY）

ORDER BY 選項用于指定分區(qū)內(nèi)的排序方式，通常用于數(shù)據(jù)的排名分析

--計算每個員工在部門內(nèi)的入職順序
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 選項表示按照部門進行分區(qū)；ORDER BY 選項指定在部門內(nèi)按照入職先后進行排序；RANK 函數(shù)用于計算名次
ORDER BY 子句同樣支持 NULLS FIRST 和 NULLS LAST 選項，用于指定空值的排序順
序。默認為 NULLS LAST

窗口選項（frame_clause）

frame_clause 選項用于在當前分區(qū)內(nèi)指定一個計算窗口。指定了窗口之后，分析函數(shù)不再基
于分區(qū)進行計算，而是基于窗口內(nèi)的數(shù)據(jù)進行計算

示例數(shù)據(jù)

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);

-- 計算每個產(chǎn)品當當前月份的累計銷量
SELECT product AS "產(chǎn)品", 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 選項表示按照產(chǎn)品進行分區(qū)；ORDER BY 選項表示按照日期進行排
序；窗口子句 ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW 指定窗口從
當前分區(qū)的第一行開始到當前行結束；因此 SUM 函數(shù)計算的是產(chǎn)品累計到當前月份為止的銷
量合計。

具體來說，窗口大小的常用選項如下：

{ ROWS | RANGE } frame_start
{ ROWS | RANGE } BETWEEN frame_start AND frame_end

其中，ROWS 表示以行為單位計算窗口的偏移量，RANGE 表示以數(shù)值（例如 30 分鐘）為
單位計算窗口的偏移量。其中，frame_start 用于定義窗口的起始位置，可以指定以下內(nèi)容之一：

UNBOUNDED PRECEDING，窗口從分區(qū)的第一行開始，默認值
N PRECEDING，窗口從當前行之前的第 N 行或者數(shù)值開始
CURRENT ROW，窗口從當前行開始。
frame_end 用于定義窗口的結束位置，可以指定以下內(nèi)容之一：
CURRENT ROW，窗口到當前行結束，默認值
N FOLLOWING，窗口到當前行之后的第 N 行或者數(shù)值結束；
UNBOUNDED FOLLOWING，窗口到分區(qū)的最后一行結束

CURRENT ROW 表示當前正在處理的行，其他的行可以使用相對當前行的位置表示。需要
注意，窗口的大小不會超出當前分區(qū)的范圍

PostgreSQL 還提供了更多復雜的窗口選項，可以參考官網(wǎng)

常見的窗口函數(shù)可以分為以下幾類：聚合窗口函數(shù)、排名窗口函數(shù)以及取值窗口函數(shù)。

聚合窗口函數(shù)

常用的聚合函數(shù)，例如 AVG、SUM、COUNT 等，也可以作為窗口函數(shù)使用

-- 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 函數(shù)計算移動平均值
select saledate, amount, avg(amount) over (order by saledate rows between 1
preceding and 1 following)from sales_data
where product = '桔子' and channel = '淘寶';

在這里插入圖片描述
該語句返回了“桔子”在“淘寶”上的銷量，以及每一天和它前后一天（共 3 天）的平均銷量。

排名窗口函數(shù)

排名窗口函數(shù)用于對數(shù)據(jù)進行分組排名。常見的排名窗口函數(shù)包括：

ROW_NUMBER，為分區(qū)中的每行數(shù)據(jù)分配一個序列號，序列號從 1 開始分配
RANK，計算每行數(shù)據(jù)在其分區(qū)中的名次；如果存在名次相同的數(shù)據(jù)，后續(xù)的排名將會
產(chǎn)生跳躍
DENSE_RANK，計算每行數(shù)據(jù)在其分區(qū)中的名次；即使存在名次相同的數(shù)據(jù)，后續(xù)的
排名也是連續(xù)的值
PERCENT_RANK，以百分比的形式顯示每行數(shù)據(jù)在其分區(qū)中的名次；如果存在名次相
同的數(shù)據(jù)，后續(xù)的排名將會產(chǎn)生跳躍
CUME_DIST，計算每行數(shù)據(jù)在其分區(qū)內(nèi)的累積分布，也就是該行數(shù)據(jù)及其之前的數(shù)據(jù)
的比率；取值范圍大于 0 并且小于等于 1
NTILE，將分區(qū)內(nèi)的數(shù)據(jù)分為 N 等份，為每行數(shù)據(jù)計算其所在的位置
排名窗口函數(shù)不支持動態(tài)的窗口大小（frame_clause），而是以當前分區(qū)作為分析的窗口。

--按照部門為單位，計算員工的月薪排名：
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_rank"FROM 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 函數(shù)為每個員工分配了一個連續(xù)的數(shù)字編號，可以看作是一種排名。IT 部
門的“Valli,Pataballa”和“David,Austin”的月薪相同，但是編號不同

RANK 函數(shù)為每個員工指定了一個名次，IT 部門的“Valli,Pataballa”和“David,Austin”的名次
都是 3；而且在他們之后的“Diana,Lorentz”的名次為 5，產(chǎn)生了跳躍

DENSE_RANK 函數(shù)為每個員工指定了一個名次，IT 部門的“Valli,Pataballa”和“David,Austin”
的名次都是 3；在他們之后的“Diana,Lorentz”的名次為 4，名次是連續(xù)值

PERCENT_RANK 函數(shù)按照百分比指定名次，取值位于 0 到 1 之間。其中“Diana,Lorentz”的
百分比排名為 1，也產(chǎn)生了跳躍

4 個窗口函數(shù)的 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_rank"FROM 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，然后在窗口函數(shù)的 OVER 子句中使用了該變量；
這樣可以簡化函數(shù)的輸入

窗口函數(shù)在 GROUP BY 分組、聚合函數(shù)以及 HAVING 過濾之后運行。如果多個窗口函
數(shù)擁有相同的 PARTITION BY 和 ORDER BY 選項，它們會在遍歷數(shù)據(jù)時一起進行計算，也就是
說它們讀取輸入數(shù)據(jù)的順序完全一致

演示了 CUME_DIST 和 NTILE 函數(shù)

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 函數(shù)顯示 2001-01-13 以及之前入職的員工大概有 0.9%（1/107）；
NTILE(100)函數(shù)表明前 1%入職的員工有“Lex,De Haan”和“Hermann,Baer”，由于員工總數(shù)為 107，
所以不是完全準確。

取值窗口函數(shù)

取值窗口函數(shù)用于返回指定位置上的數(shù)據(jù)。常見的取值窗口函數(shù)包括：

FIRST_VALUE，返回窗口內(nèi)第一行的數(shù)據(jù)
LAST_VALUE，返回窗口內(nèi)最后一行的數(shù)據(jù)
NTH_VALUE，返回窗口內(nèi)第 N 行的數(shù)據(jù)
LAG，返回分區(qū)中當前行之前的第 N 行的數(shù)據(jù)
LEAD，返回分區(qū)中當前行之后第 N 行的數(shù)據(jù)
其中，LAG 和 LEAD 函數(shù)不支持動態(tài)的窗口大小（frame_clause），而是以當前分區(qū)作為分
析的窗口

/**
* 使用 FIRST_VALUE、LAST_VALUE 以及 NTH 函數(shù)分別獲取每個部門內(nèi)部月薪
* 最高、月薪最低以及月薪第三高的員工
*/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;

在這里插入圖片描述
以上三個函數(shù)的默認窗口是從當前分區(qū)的第一行到當前行，所以我們在 OVER 子句中將窗
口設置為整個分區(qū)。

LAG 和 LEAD 函數(shù)同樣用于計算銷量數(shù)據(jù)的環(huán)比/同比增長。例如，以下語句統(tǒng)計不同產(chǎn)品
每個月的環(huán)比增長率

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 "產(chǎn)品", 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 "
環(huán)比增長率（%）"FROM sales_monthly
ORDER BY product, ym;