Online Business Sales 2017-2019

Dataset is actual sales from online store between 2017-2019

@kaggle.tylermorse_retail_business_sales_20172019

Table List

2 tables(27.47 KB)

Business Retailsales2

@kaggle.tylermorse_retail_business_sales_20172019.business_retailsales2

8.38 KB
36 rows
9 columns

month Month	year Year	total_orders Total Orders	gross_sales Gross Sales	discounts Discounts	returns Returns	net_sales Net Sales	shipping Shipping	total_sales Total Sales
January	2017	73	8861.5	-129.4	-448.45	8283.65	1088.3	9371.95
February	2017	56	6908.5	-104.7	-416.2	6387.6	892.45	7280.05
March	2017	60	5778.5	-172.2	-1017.2	4589.1	707.43	5296.53
April	2017	70	8814	-281.4		8532.6	1068.3	9600.9
May	2017	54	6677	-185.75	-253.8	6237.45	866.46	7103.91
June	2017	68	9621.5	-234.45	-17.5	9369.55	1204.32	10573.87
July	2017	66	6480	-51.5	-469.2	5959.3	807.36	6766.66
August	2017	55	8025	-258.9	-26	7740.1	843.46	8583.56
September	2017	68	7075	-61.7	-281	6732.3	907.32	7639.62
October	2017	59	5720	-88	-305	5327	695.42	6022.42


CREATE TABLE business_retailsales2 (
  "month" VARCHAR,
  "year" BIGINT,
  "total_orders" BIGINT,
  "gross_sales" DOUBLE,
  "discounts" DOUBLE,
  "returns" DOUBLE,
  "net_sales" DOUBLE,
  "shipping" DOUBLE,
  "total_sales" DOUBLE
);