This is an automated email from the ASF dual-hosted git repository.
doebele pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/empire-db.git
The following commit(s) were added to refs/heads/master by this push:
new fc7b248 EMPIREDB-362 GenerateExample updated
fc7b248 is described below
commit fc7b248808e06b38105c55c63607c33b14b54a22
Author: Rainer Döbele <[email protected]>
AuthorDate: Thu Feb 24 16:32:00 2022 +0100
EMPIREDB-362 GenerateExample updated
---
.../empire-db-example-codegen/generate-config.xml | 10 +-
.../empire-db-example-codegen/pom.xml | 6 +
.../src/main/java/.gitignore | 1 +
.../src/main/java/GenerateExample.java | 28 +
.../src/main/java/org/apache/empire/db/.gitignore | 1 +
.../src/test/resources/hsqldb/sample.properties | 5 +
.../src/test/resources/hsqldb/sample.script | 1040 ++++++++++++++++++++
7 files changed, 1087 insertions(+), 4 deletions(-)
diff --git a/empire-db-examples/empire-db-example-codegen/generate-config.xml
b/empire-db-examples/empire-db-example-codegen/generate-config.xml
index 66fbf02..241e6a4 100644
--- a/empire-db-examples/empire-db-example-codegen/generate-config.xml
+++ b/empire-db-examples/empire-db-example-codegen/generate-config.xml
@@ -33,7 +33,10 @@
<timestampColumn>UPDATE_TIMESTAMP</timestampColumn>
<!-- generation options -->
+ <!--
<targetFolder>target/generated-sources/java</targetFolder>
+ -->
+ <targetFolder>src/main/java</targetFolder>
<packageName>org.apache.empire.db.example</packageName>
<dbClassName>MyDatabase</dbClassName>
<nestTables>false</nestTables>
@@ -61,16 +64,15 @@
<log4j:configuration xmlns:log4j="http://jakarta.apache.org/log4j/";>
- <appender name="console"
class="org.apache.log4j.ConsoleAppender">
- <!-- layout class="org.apache.log4j.TTCCLayout"/ -->
+ <!-- Console -->
+ <appender name="default"
class="org.apache.log4j.ConsoleAppender">
<layout class="org.apache.log4j.PatternLayout">
- <!-- param name="ConversionPattern"
value="NSB(%c) %-5p %m at %l%n"/ -->
<param name="ConversionPattern" value="%-5p
[%d{yyyy/MM/dd HH:mm}]: %m at %l %n"/>
</layout>
</appender>
<!-- File output -->
- <appender name="default" class="org.apache.log4j.FileAppender">
+ <appender name="logfile" class="org.apache.log4j.FileAppender">
<param name="file" value="target/codegen.log" />
<param name="append" value="false" />
<param name="threshold" value="debug" />
diff --git a/empire-db-examples/empire-db-example-codegen/pom.xml
b/empire-db-examples/empire-db-example-codegen/pom.xml
index 515db60..8643d11 100644
--- a/empire-db-examples/empire-db-example-codegen/pom.xml
+++ b/empire-db-examples/empire-db-example-codegen/pom.xml
@@ -26,11 +26,17 @@
<description>Example showing the use of the empire-db codegen maven
plugin</description>
<dependencies>
+
<dependency>
<groupId>org.apache.empire-db</groupId>
<artifactId>empire-db</artifactId>
</dependency>
+ <dependency>
+ <groupId>org.apache.empire-db</groupId>
+ <artifactId>empire-db-codegen</artifactId>
+ </dependency>
+
<dependency>
<groupId>org.hsqldb</groupId>
<artifactId>hsqldb</artifactId>
diff --git
a/empire-db-examples/empire-db-example-codegen/src/main/java/.gitignore
b/empire-db-examples/empire-db-example-codegen/src/main/java/.gitignore
new file mode 100644
index 0000000..cf1db2e
--- /dev/null
+++ b/empire-db-examples/empire-db-example-codegen/src/main/java/.gitignore
@@ -0,0 +1 @@
+/org/
diff --git
a/empire-db-examples/empire-db-example-codegen/src/main/java/GenerateExample.java
b/empire-db-examples/empire-db-example-codegen/src/main/java/GenerateExample.java
new file mode 100644
index 0000000..0df5f5e
--- /dev/null
+++
b/empire-db-examples/empire-db-example-codegen/src/main/java/GenerateExample.java
@@ -0,0 +1,28 @@
+import org.apache.empire.db.codegen.CodeGenConfig;
+import org.apache.empire.db.codegen.CodeGenerator;
+import org.slf4j.Logger;
+import org.slf4j.LoggerFactory;
+
+/**
+ * GenerateExample
+ * Simple wrapper to call the CodeGenerator
+ * see generate-config.xml for details
+ * @author doebele
+ */
+public final class GenerateExample
+{
+ private static final Logger log =
LoggerFactory.getLogger(GenerateExample.class);
+
+ public static void main(String[] args)
+ {
+ CodeGenConfig config = new CodeGenConfig();
+ config.init("generate-config.xml");
+
+ log.info("Creating code for {}", config.getJdbcURL());
+
+ CodeGenerator app = new CodeGenerator();
+ app.generate(config);
+
+ log.info("Code generation complete. File are located in {}",
config.getTargetFolder());
+ }
+}
diff --git
a/empire-db-examples/empire-db-example-codegen/src/main/java/org/apache/empire/db/.gitignore
b/empire-db-examples/empire-db-example-codegen/src/main/java/org/apache/empire/db/.gitignore
new file mode 100644
index 0000000..3bde5c3
--- /dev/null
+++
b/empire-db-examples/empire-db-example-codegen/src/main/java/org/apache/empire/db/.gitignore
@@ -0,0 +1 @@
+/example/
diff --git
a/empire-db-examples/empire-db-example-codegen/src/test/resources/hsqldb/sample.properties
b/empire-db-examples/empire-db-example-codegen/src/test/resources/hsqldb/sample.properties
new file mode 100644
index 0000000..82e6fb3
--- /dev/null
+++
b/empire-db-examples/empire-db-example-codegen/src/test/resources/hsqldb/sample.properties
@@ -0,0 +1,5 @@
+#HSQL Database Engine 2.6.0
+#Thu Feb 24 16:12:54 CET 2022
+version=2.6.0
+modified=no
+tx_timestamp=1736
diff --git
a/empire-db-examples/empire-db-example-codegen/src/test/resources/hsqldb/sample.script
b/empire-db-examples/empire-db-example-codegen/src/test/resources/hsqldb/sample.script
new file mode 100644
index 0000000..12d6a11
--- /dev/null
+++
b/empire-db-examples/empire-db-example-codegen/src/test/resources/hsqldb/sample.script
@@ -0,0 +1,1040 @@
+SET DATABASE UNIQUE NAME HSQLDB7F2ADD5240
+SET DATABASE GC 0
+SET DATABASE DEFAULT RESULT MEMORY ROWS 0
+SET DATABASE EVENT LOG LEVEL 0
+SET DATABASE TRANSACTION CONTROL LOCKS
+SET DATABASE DEFAULT ISOLATION LEVEL READ COMMITTED
+SET DATABASE TRANSACTION ROLLBACK ON CONFLICT TRUE
+SET DATABASE TEXT TABLE DEFAULTS ''
+SET DATABASE SQL NAMES FALSE
+SET DATABASE SQL REFERENCES FALSE
+SET DATABASE SQL SIZE TRUE
+SET DATABASE SQL TYPES FALSE
+SET DATABASE SQL TDC DELETE TRUE
+SET DATABASE SQL TDC UPDATE TRUE
+SET DATABASE SQL CONCAT NULLS TRUE
+SET DATABASE SQL UNIQUE NULLS TRUE
+SET DATABASE SQL CONVERT TRUNCATE TRUE
+SET DATABASE SQL AVG SCALE 0
+SET DATABASE SQL DOUBLE NAN TRUE
+SET FILES WRITE DELAY 500 MILLIS
+SET FILES BACKUP INCREMENT TRUE
+SET FILES CACHE SIZE 10000
+SET FILES CACHE ROWS 50000
+SET FILES SCALE 32
+SET FILES LOB SCALE 32
+SET FILES DEFRAG 0
+SET FILES NIO TRUE
+SET FILES NIO SIZE 256
+SET FILES LOG TRUE
+SET FILES LOG SIZE 50
+SET FILES CHECK 1736
+SET DATABASE COLLATION "SQL_TEXT" PAD SPACE
+CREATE USER SA PASSWORD DIGEST 'd41d8cd98f00b204e9800998ecf8427e'
+ALTER USER SA SET LOCAL TRUE
+CREATE SCHEMA PUBLIC AUTHORIZATION DBA
+CREATE SEQUENCE PUBLIC.MODEL_ID_SEQUENCE AS INTEGER START WITH 1
+CREATE SEQUENCE PUBLIC.DEALER_ID_SEQUENCE AS INTEGER START WITH 1
+CREATE MEMORY TABLE PUBLIC.BRAND(WMI VARCHAR(3) NOT NULL PRIMARY KEY,NAME
VARCHAR(80) NOT NULL,COUNTRY VARCHAR(40),UPDATE_TIMESTAMP TIMESTAMP NOT NULL)
+CREATE MEMORY TABLE PUBLIC.MODEL(ID INTEGER NOT NULL PRIMARY KEY,NAME
VARCHAR(20) NOT NULL,CONFIGURATION VARCHAR(40) NOT NULL,WMI VARCHAR(3) NOT
NULL,TRIM VARCHAR(20) NOT NULL,ENGINE_TYPE CHARACTER(1) NOT NULL,ENGINE_POWER
DECIMAL(4) NOT NULL,BASE_PRICE DECIMAL(8,2),UPDATE_TIMESTAMP TIMESTAMP NOT
NULL,CONSTRAINT MODEL_WMI FOREIGN KEY(WMI) REFERENCES PUBLIC.BRAND(WMI))
+CREATE MEMORY TABLE PUBLIC.DEALER(ID INTEGER NOT NULL PRIMARY KEY,COMPANY_NAME
VARCHAR(40) NOT NULL,ADDRESS VARCHAR(40),CITY VARCHAR(20) NOT NULL,COUNTRY
VARCHAR(40) NOT NULL,YEAR_FOUNDED DECIMAL(4),UPDATE_TIMESTAMP TIMESTAMP NOT
NULL)
+CREATE MEMORY TABLE PUBLIC.DEALER_BRANDS(DEALER_ID INTEGER NOT NULL,WMI
VARCHAR(3) NOT NULL,DEALERSHIP_TYPE CHARACTER(1) NOT NULL,YEAR_BEGIN
DECIMAL(4),PRIMARY KEY(DEALER_ID,WMI),CONSTRAINT DEALER_BRANDS_DEALER_FK
FOREIGN KEY(DEALER_ID) REFERENCES PUBLIC.DEALER(ID) ON DELETE
CASCADE,CONSTRAINT DEALER_BRANDS_WMI FOREIGN KEY(WMI) REFERENCES
PUBLIC.BRAND(WMI))
+CREATE MEMORY TABLE PUBLIC.SALES(MODEL_ID INTEGER NOT NULL,DEALER_ID INTEGER
NOT NULL,YEAR DECIMAL(4) NOT NULL,MONTH DECIMAL(2) NOT NULL,CAR_COLOR
VARCHAR(20),PRICE DECIMAL(8,2) NOT NULL,CONSTRAINT SALES_MODEL_FK FOREIGN
KEY(MODEL_ID) REFERENCES PUBLIC.MODEL(ID),CONSTRAINT SALES_DEALER_FK FOREIGN
KEY(DEALER_ID) REFERENCES PUBLIC.DEALER(ID) ON DELETE CASCADE)
+CREATE VIEW PUBLIC.DEALER_SALES_VIEW
(DEALER_NAME,DEALER_COUNTRY,BRAND_SOLD,DEALERSHIP_TYPE,SALE_YEAR,SALE_COUNT,TURNOVER)
AS (SELECT
T3.COMPANY_NAME,T3.COUNTRY,T1.NAME,T4.DEALERSHIP_TYPE,T5.YEAR,COUNT(*),SUM(T5.PRICE)AS
TURNOVER FROM PUBLIC.DEALER T3 INNER JOIN PUBLIC.SALES T5 ON
T5.DEALER_ID=T3.ID INNER JOIN PUBLIC.MODEL T2 ON T2.ID=T5.MODEL_ID INNER JOIN
PUBLIC.BRAND T1 ON T1.WMI=T2.WMI LEFT JOIN PUBLIC.DEALER_BRANDS T4 ON
T4.DEALER_ID=T3.ID AND T4.WMI=T2.WMI AND T4.DEALERSHIP_TYPE<>' [...]
+ALTER SEQUENCE SYSTEM_LOBS.LOB_ID RESTART WITH 1
+ALTER SEQUENCE PUBLIC.MODEL_ID_SEQUENCE RESTART WITH 15
+ALTER SEQUENCE PUBLIC.DEALER_ID_SEQUENCE RESTART WITH 6
+SET DATABASE DEFAULT INITIAL SCHEMA PUBLIC
+GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.CARDINAL_NUMBER TO PUBLIC
+GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.YES_OR_NO TO PUBLIC
+GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.CHARACTER_DATA TO PUBLIC
+GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.SQL_IDENTIFIER TO PUBLIC
+GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.TIME_STAMP TO PUBLIC
+GRANT DBA TO SA
+SET SCHEMA SYSTEM_LOBS
+INSERT INTO BLOCKS VALUES(0,2147483647,0)
+SET SCHEMA PUBLIC
+INSERT INTO BRAND VALUES('1F','Ford','USA','2022-02-24 09:33:42.180000')
+INSERT INTO BRAND VALUES('5YJ','Tesla','USA','2022-02-24 09:33:42.180000')
+INSERT INTO BRAND VALUES('JT','Toyota','Japan','2022-02-24 09:33:42.190000')
+INSERT INTO BRAND VALUES('WVW','Volkswagen','Germany','2022-02-24
09:33:42.140000')
+INSERT INTO MODEL VALUES(1,'Golf','Golf Style 1,5 l
TSI','WVW','Style','P',130,30970.00,'2022-02-24 09:33:42.240000')
+INSERT INTO MODEL VALUES(2,'Golf','Golf R-Line 2,0 l TSI
4MOTION','WVW','R-Line','P',190,38650.00,'2022-02-24 09:33:42.260000')
+INSERT INTO MODEL VALUES(3,'Tiguan','Tiguan Life 1,5 l
TSI','WVW','Life','P',150,32545.00,'2022-02-24 09:33:42.260000')
+INSERT INTO MODEL VALUES(4,'Tiguan','Tiguan Elegance 2,0 l TDI
SCR','WVW','Elegance','D',150,40845.00,'2022-02-24 09:33:42.270000')
+INSERT INTO MODEL VALUES(5,'Tiguan','Tiguan R-Line 1,4 l
eHybrid','WVW','R-Line','H',150,48090.00,'2022-02-24 09:33:42.280000')
+INSERT INTO MODEL VALUES(6,'Model 3','Model 3 LR','5YJ','Long
Range','E',261,45940.00,'2022-02-24 09:33:42.290000')
+INSERT INTO MODEL VALUES(7,'Model 3','Model 3
Performance','5YJ','Performance','E',487,53940.00,'2022-02-24 09:33:42.300000')
+INSERT INTO MODEL VALUES(8,'Model Y','Model Y LR','5YJ','Long
Range','E',345,53940.00,'2022-02-24 09:33:42.310000')
+INSERT INTO MODEL VALUES(9,'Model Y','Model Y
Performance','5YJ','Performance','E',450,58940.00,'2022-02-24 09:33:42.310000')
+INSERT INTO MODEL VALUES(10,'Model S','Model S
Plaid','5YJ','Plaid','E',1020,0.00,'2022-02-24 09:33:42.320000')
+INSERT INTO MODEL VALUES(11,'Mustang','Mustang GT 5,0 l Ti-VCT
V8','1F','GT','P',449,54300.00,'2022-02-24 09:33:42.330000')
+INSERT INTO MODEL VALUES(12,'Mustang','Mustang Mach1 5,0 l Ti-VCT
V8','1F','Mach1','P',460,62800.00,'2022-02-24 09:33:42.330000')
+INSERT INTO MODEL VALUES(13,'Prius','Prius Hybrid
1,8-l-VVT-i','JT','Basis','H',122,38000.00,'2022-02-24 09:33:42.340000')
+INSERT INTO MODEL VALUES(14,'Supra','GR Supra Pure 2,0 l Twin-Scroll
Turbo','JT','Pure','P',258,49290.00,'2022-02-24 09:33:42.360000')
+INSERT INTO DEALER VALUES(1,'Autozentrum
Schmitz',NULL,'Munich','Germany',NULL,'2022-02-24 09:33:42.370000')
+INSERT INTO DEALER VALUES(2,'Beadles Volkswagen',NULL,'Dartford','United
Kingdom',NULL,'2022-02-24 09:33:42.380000')
+INSERT INTO DEALER VALUES(3,'Auto Nation',NULL,'Los
Angeles','USA',NULL,'2022-02-24 09:33:42.390000')
+INSERT INTO DEALER VALUES(4,'Vauban Motors
Argenteuil',NULL,'Paris','France',NULL,'2022-02-24 09:33:42.390000')
+INSERT INTO DEALER VALUES(5,'Autorigoldi
S.p.A.',NULL,'Milan','Italy',NULL,'2022-02-24 09:33:42.400000')
+INSERT INTO DEALER_BRANDS VALUES(1,'5YJ','B',NULL)
+INSERT INTO DEALER_BRANDS VALUES(1,'WVW','U',NULL)
+INSERT INTO DEALER_BRANDS VALUES(2,'1F','I',NULL)
+INSERT INTO DEALER_BRANDS VALUES(2,'WVW','B',NULL)
+INSERT INTO DEALER_BRANDS VALUES(3,'1F','B',NULL)
+INSERT INTO DEALER_BRANDS VALUES(3,'5YJ','I',NULL)
+INSERT INTO DEALER_BRANDS VALUES(4,'JT','B',NULL)
+INSERT INTO DEALER_BRANDS VALUES(5,'JT','G',NULL)
+INSERT INTO DEALER_BRANDS VALUES(5,'WVW','B',NULL)
+INSERT INTO SALES VALUES(1,4,2020,9,NULL,31048.65)
+INSERT INTO SALES VALUES(1,5,2021,12,NULL,30944.84)
+INSERT INTO SALES VALUES(1,5,2019,6,NULL,30943.90)
+INSERT INTO SALES VALUES(1,4,2021,8,NULL,31011.04)
+INSERT INTO SALES VALUES(1,4,2020,4,NULL,30883.80)
+INSERT INTO SALES VALUES(1,4,2021,7,NULL,30917.17)
+INSERT INTO SALES VALUES(1,3,2019,10,NULL,30998.01)
+INSERT INTO SALES VALUES(1,4,2020,11,NULL,30943.48)
+INSERT INTO SALES VALUES(1,3,2020,9,NULL,30954.69)
+INSERT INTO SALES VALUES(1,1,2020,3,NULL,31009.42)
+INSERT INTO SALES VALUES(1,3,2020,8,NULL,30946.52)
+INSERT INTO SALES VALUES(1,3,2021,2,NULL,31020.28)
+INSERT INTO SALES VALUES(1,5,2020,9,NULL,30883.94)
+INSERT INTO SALES VALUES(1,3,2019,2,NULL,30899.54)
+INSERT INTO SALES VALUES(1,5,2021,11,NULL,30965.26)
+INSERT INTO SALES VALUES(1,5,2020,6,NULL,30901.43)
+INSERT INTO SALES VALUES(1,5,2019,9,NULL,31042.95)
+INSERT INTO SALES VALUES(1,2,2020,7,NULL,31048.48)
+INSERT INTO SALES VALUES(1,5,2020,2,NULL,31055.86)
+INSERT INTO SALES VALUES(1,5,2019,12,NULL,30988.21)
+INSERT INTO SALES VALUES(1,1,2019,5,NULL,31046.73)
+INSERT INTO SALES VALUES(1,4,2019,2,NULL,31013.89)
+INSERT INTO SALES VALUES(1,5,2020,2,NULL,30934.66)
+INSERT INTO SALES VALUES(1,5,2020,8,NULL,31043.57)
+INSERT INTO SALES VALUES(1,1,2019,12,NULL,31061.94)
+INSERT INTO SALES VALUES(1,2,2019,1,NULL,31002.14)
+INSERT INTO SALES VALUES(2,4,2021,7,NULL,38635.28)
+INSERT INTO SALES VALUES(2,5,2019,2,NULL,38702.13)
+INSERT INTO SALES VALUES(2,4,2019,10,NULL,38658.23)
+INSERT INTO SALES VALUES(2,1,2019,6,NULL,38630.52)
+INSERT INTO SALES VALUES(2,4,2019,7,NULL,38564.56)
+INSERT INTO SALES VALUES(2,5,2019,6,NULL,38573.29)
+INSERT INTO SALES VALUES(2,4,2020,2,NULL,38701.10)
+INSERT INTO SALES VALUES(2,3,2020,2,NULL,38614.68)
+INSERT INTO SALES VALUES(2,2,2019,10,NULL,38621.49)
+INSERT INTO SALES VALUES(2,3,2021,7,NULL,38711.79)
+INSERT INTO SALES VALUES(2,5,2019,6,NULL,38622.50)
+INSERT INTO SALES VALUES(2,1,2021,6,NULL,38628.50)
+INSERT INTO SALES VALUES(2,3,2019,6,NULL,38681.93)
+INSERT INTO SALES VALUES(2,3,2019,10,NULL,38639.96)
+INSERT INTO SALES VALUES(2,2,2021,11,NULL,38648.68)
+INSERT INTO SALES VALUES(2,3,2019,5,NULL,38683.52)
+INSERT INTO SALES VALUES(2,3,2021,5,NULL,38585.95)
+INSERT INTO SALES VALUES(2,5,2020,7,NULL,38681.81)
+INSERT INTO SALES VALUES(2,1,2020,6,NULL,38618.15)
+INSERT INTO SALES VALUES(2,1,2020,3,NULL,38613.75)
+INSERT INTO SALES VALUES(2,2,2021,7,NULL,38682.49)
+INSERT INTO SALES VALUES(2,3,2019,4,NULL,38559.40)
+INSERT INTO SALES VALUES(2,4,2019,8,NULL,38635.97)
+INSERT INTO SALES VALUES(2,5,2021,2,NULL,38594.24)
+INSERT INTO SALES VALUES(2,2,2020,7,NULL,38618.47)
+INSERT INTO SALES VALUES(2,2,2019,7,NULL,38658.79)
+INSERT INTO SALES VALUES(2,4,2021,4,NULL,38622.80)
+INSERT INTO SALES VALUES(2,1,2021,4,NULL,38579.32)
+INSERT INTO SALES VALUES(2,3,2019,7,NULL,38672.53)
+INSERT INTO SALES VALUES(2,3,2019,1,NULL,38665.45)
+INSERT INTO SALES VALUES(2,1,2021,9,NULL,38658.27)
+INSERT INTO SALES VALUES(2,3,2020,11,NULL,38560.31)
+INSERT INTO SALES VALUES(2,4,2019,6,NULL,38733.26)
+INSERT INTO SALES VALUES(2,4,2021,6,NULL,38669.28)
+INSERT INTO SALES VALUES(2,2,2019,5,NULL,38619.03)
+INSERT INTO SALES VALUES(2,5,2021,7,NULL,38742.77)
+INSERT INTO SALES VALUES(2,2,2019,4,NULL,38621.93)
+INSERT INTO SALES VALUES(2,5,2021,11,NULL,38639.14)
+INSERT INTO SALES VALUES(2,3,2019,6,NULL,38611.26)
+INSERT INTO SALES VALUES(2,5,2019,2,NULL,38743.28)
+INSERT INTO SALES VALUES(2,1,2021,3,NULL,38659.82)
+INSERT INTO SALES VALUES(2,3,2019,5,NULL,38566.85)
+INSERT INTO SALES VALUES(2,5,2020,4,NULL,38697.71)
+INSERT INTO SALES VALUES(3,2,2020,10,NULL,32639.41)
+INSERT INTO SALES VALUES(3,2,2019,2,NULL,32451.29)
+INSERT INTO SALES VALUES(3,2,2020,2,NULL,32638.27)
+INSERT INTO SALES VALUES(3,4,2020,5,NULL,32616.53)
+INSERT INTO SALES VALUES(3,3,2020,6,NULL,32506.82)
+INSERT INTO SALES VALUES(3,1,2020,9,NULL,32459.22)
+INSERT INTO SALES VALUES(3,5,2020,11,NULL,32578.34)
+INSERT INTO SALES VALUES(3,5,2020,4,NULL,32507.32)
+INSERT INTO SALES VALUES(3,5,2020,7,NULL,32620.67)
+INSERT INTO SALES VALUES(3,2,2020,12,NULL,32522.11)
+INSERT INTO SALES VALUES(3,2,2019,11,NULL,32547.75)
+INSERT INTO SALES VALUES(3,2,2020,4,NULL,32633.88)
+INSERT INTO SALES VALUES(3,2,2020,10,NULL,32624.88)
+INSERT INTO SALES VALUES(3,3,2020,12,NULL,32468.58)
+INSERT INTO SALES VALUES(3,5,2021,4,NULL,32574.84)
+INSERT INTO SALES VALUES(3,1,2020,2,NULL,32497.63)
+INSERT INTO SALES VALUES(3,1,2019,7,NULL,32641.80)
+INSERT INTO SALES VALUES(3,5,2019,1,NULL,32492.69)
+INSERT INTO SALES VALUES(3,4,2020,6,NULL,32520.09)
+INSERT INTO SALES VALUES(3,2,2020,1,NULL,32617.68)
+INSERT INTO SALES VALUES(3,2,2020,7,NULL,32504.84)
+INSERT INTO SALES VALUES(3,2,2021,12,NULL,32539.83)
+INSERT INTO SALES VALUES(3,2,2020,10,NULL,32471.58)
+INSERT INTO SALES VALUES(3,3,2020,11,NULL,32592.05)
+INSERT INTO SALES VALUES(3,3,2019,11,NULL,32541.77)
+INSERT INTO SALES VALUES(3,1,2020,11,NULL,32468.39)
+INSERT INTO SALES VALUES(3,3,2021,5,NULL,32541.27)
+INSERT INTO SALES VALUES(3,2,2020,12,NULL,32584.80)
+INSERT INTO SALES VALUES(3,2,2021,3,NULL,32608.90)
+INSERT INTO SALES VALUES(3,3,2020,3,NULL,32487.21)
+INSERT INTO SALES VALUES(3,4,2020,8,NULL,32561.98)
+INSERT INTO SALES VALUES(3,3,2019,5,NULL,32538.83)
+INSERT INTO SALES VALUES(3,5,2020,1,NULL,32475.97)
+INSERT INTO SALES VALUES(3,4,2021,1,NULL,32568.86)
+INSERT INTO SALES VALUES(3,5,2021,12,NULL,32585.24)
+INSERT INTO SALES VALUES(3,3,2019,8,NULL,32614.54)
+INSERT INTO SALES VALUES(3,3,2019,3,NULL,32461.89)
+INSERT INTO SALES VALUES(3,1,2019,4,NULL,32538.61)
+INSERT INTO SALES VALUES(3,3,2021,1,NULL,32479.86)
+INSERT INTO SALES VALUES(3,5,2020,4,NULL,32554.21)
+INSERT INTO SALES VALUES(3,4,2021,7,NULL,32621.15)
+INSERT INTO SALES VALUES(3,2,2021,8,NULL,32539.25)
+INSERT INTO SALES VALUES(3,4,2021,7,NULL,32531.31)
+INSERT INTO SALES VALUES(3,1,2020,10,NULL,32472.23)
+INSERT INTO SALES VALUES(3,4,2020,10,NULL,32581.17)
+INSERT INTO SALES VALUES(3,4,2019,5,NULL,32571.68)
+INSERT INTO SALES VALUES(3,1,2021,12,NULL,32541.87)
+INSERT INTO SALES VALUES(3,5,2020,2,NULL,32571.04)
+INSERT INTO SALES VALUES(3,1,2021,8,NULL,32530.25)
+INSERT INTO SALES VALUES(3,5,2019,1,NULL,32611.25)
+INSERT INTO SALES VALUES(3,1,2019,8,NULL,32531.54)
+INSERT INTO SALES VALUES(3,2,2020,6,NULL,32482.89)
+INSERT INTO SALES VALUES(3,1,2020,11,NULL,32456.48)
+INSERT INTO SALES VALUES(3,1,2021,11,NULL,32599.96)
+INSERT INTO SALES VALUES(3,1,2019,4,NULL,32539.82)
+INSERT INTO SALES VALUES(3,1,2019,7,NULL,32537.40)
+INSERT INTO SALES VALUES(3,5,2021,1,NULL,32537.30)
+INSERT INTO SALES VALUES(3,2,2019,7,NULL,32614.30)
+INSERT INTO SALES VALUES(3,2,2021,7,NULL,32628.12)
+INSERT INTO SALES VALUES(3,1,2019,2,NULL,32454.84)
+INSERT INTO SALES VALUES(3,1,2020,6,NULL,32579.88)
+INSERT INTO SALES VALUES(3,5,2021,4,NULL,32509.04)
+INSERT INTO SALES VALUES(3,4,2021,10,NULL,32583.10)
+INSERT INTO SALES VALUES(3,1,2021,1,NULL,32565.27)
+INSERT INTO SALES VALUES(3,2,2020,11,NULL,32612.31)
+INSERT INTO SALES VALUES(3,4,2020,4,NULL,32536.67)
+INSERT INTO SALES VALUES(3,4,2019,6,NULL,32620.72)
+INSERT INTO SALES VALUES(3,5,2019,9,NULL,32453.37)
+INSERT INTO SALES VALUES(3,3,2021,5,NULL,32525.55)
+INSERT INTO SALES VALUES(3,4,2019,9,NULL,32642.68)
+INSERT INTO SALES VALUES(3,2,2021,9,NULL,32591.05)
+INSERT INTO SALES VALUES(3,4,2019,5,NULL,32529.15)
+INSERT INTO SALES VALUES(3,4,2019,7,NULL,32466.15)
+INSERT INTO SALES VALUES(4,4,2019,6,NULL,40763.79)
+INSERT INTO SALES VALUES(4,5,2020,9,NULL,40884.11)
+INSERT INTO SALES VALUES(4,5,2019,11,NULL,40860.95)
+INSERT INTO SALES VALUES(4,2,2019,3,NULL,40817.18)
+INSERT INTO SALES VALUES(4,5,2021,12,NULL,40891.48)
+INSERT INTO SALES VALUES(4,2,2021,12,NULL,40746.39)
+INSERT INTO SALES VALUES(4,2,2021,5,NULL,40897.18)
+INSERT INTO SALES VALUES(4,4,2019,4,NULL,40883.23)
+INSERT INTO SALES VALUES(4,1,2019,10,NULL,40895.94)
+INSERT INTO SALES VALUES(4,5,2020,12,NULL,40775.91)
+INSERT INTO SALES VALUES(4,1,2019,2,NULL,40897.03)
+INSERT INTO SALES VALUES(4,1,2019,11,NULL,40766.01)
+INSERT INTO SALES VALUES(4,2,2020,5,NULL,40783.72)
+INSERT INTO SALES VALUES(4,2,2021,6,NULL,40937.82)
+INSERT INTO SALES VALUES(4,3,2020,5,NULL,40826.46)
+INSERT INTO SALES VALUES(4,5,2019,12,NULL,40748.72)
+INSERT INTO SALES VALUES(4,2,2019,2,NULL,40839.93)
+INSERT INTO SALES VALUES(4,2,2020,7,NULL,40778.71)
+INSERT INTO SALES VALUES(4,5,2019,7,NULL,40847.22)
+INSERT INTO SALES VALUES(4,5,2019,7,NULL,40887.56)
+INSERT INTO SALES VALUES(4,2,2020,10,NULL,40764.41)
+INSERT INTO SALES VALUES(4,5,2021,3,NULL,40917.69)
+INSERT INTO SALES VALUES(4,5,2020,9,NULL,40868.94)
+INSERT INTO SALES VALUES(4,2,2021,5,NULL,40931.24)
+INSERT INTO SALES VALUES(4,1,2020,8,NULL,40864.85)
+INSERT INTO SALES VALUES(4,4,2020,12,NULL,40819.41)
+INSERT INTO SALES VALUES(4,5,2019,6,NULL,40808.37)
+INSERT INTO SALES VALUES(4,1,2021,8,NULL,40772.56)
+INSERT INTO SALES VALUES(4,1,2020,7,NULL,40807.03)
+INSERT INTO SALES VALUES(4,3,2019,8,NULL,40749.15)
+INSERT INTO SALES VALUES(4,4,2019,1,NULL,40855.58)
+INSERT INTO SALES VALUES(4,1,2019,3,NULL,40932.01)
+INSERT INTO SALES VALUES(4,3,2021,1,NULL,40822.04)
+INSERT INTO SALES VALUES(4,3,2020,12,NULL,40809.96)
+INSERT INTO SALES VALUES(4,3,2019,3,NULL,40847.18)
+INSERT INTO SALES VALUES(4,5,2021,10,NULL,40773.39)
+INSERT INTO SALES VALUES(4,5,2020,6,NULL,40870.55)
+INSERT INTO SALES VALUES(5,3,2020,2,NULL,48137.91)
+INSERT INTO SALES VALUES(5,4,2019,7,NULL,48025.67)
+INSERT INTO SALES VALUES(5,2,2019,1,NULL,48080.38)
+INSERT INTO SALES VALUES(5,4,2021,8,NULL,48090.53)
+INSERT INTO SALES VALUES(5,2,2019,11,NULL,48027.04)
+INSERT INTO SALES VALUES(5,4,2019,6,NULL,48037.20)
+INSERT INTO SALES VALUES(5,1,2021,3,NULL,48013.61)
+INSERT INTO SALES VALUES(5,2,2020,6,NULL,48100.31)
+INSERT INTO SALES VALUES(5,4,2021,7,NULL,48180.11)
+INSERT INTO SALES VALUES(5,5,2020,3,NULL,48024.41)
+INSERT INTO SALES VALUES(5,2,2021,10,NULL,48181.08)
+INSERT INTO SALES VALUES(5,5,2020,5,NULL,48026.09)
+INSERT INTO SALES VALUES(5,1,2021,11,NULL,48110.78)
+INSERT INTO SALES VALUES(5,3,2019,11,NULL,47999.76)
+INSERT INTO SALES VALUES(5,2,2020,11,NULL,48013.04)
+INSERT INTO SALES VALUES(5,2,2020,12,NULL,48061.37)
+INSERT INTO SALES VALUES(5,5,2019,6,NULL,48095.14)
+INSERT INTO SALES VALUES(5,4,2021,5,NULL,48174.89)
+INSERT INTO SALES VALUES(5,4,2021,8,NULL,48015.44)
+INSERT INTO SALES VALUES(5,3,2021,3,NULL,48055.90)
+INSERT INTO SALES VALUES(5,5,2020,10,NULL,48064.11)
+INSERT INTO SALES VALUES(5,2,2020,7,NULL,47996.90)
+INSERT INTO SALES VALUES(5,4,2021,10,NULL,48106.56)
+INSERT INTO SALES VALUES(5,2,2019,12,NULL,48108.77)
+INSERT INTO SALES VALUES(5,1,2020,6,NULL,48009.19)
+INSERT INTO SALES VALUES(5,3,2021,5,NULL,48123.09)
+INSERT INTO SALES VALUES(5,3,2021,6,NULL,48116.82)
+INSERT INTO SALES VALUES(5,1,2021,6,NULL,48149.66)
+INSERT INTO SALES VALUES(5,2,2019,4,NULL,48001.46)
+INSERT INTO SALES VALUES(5,1,2021,5,NULL,48033.86)
+INSERT INTO SALES VALUES(5,4,2021,1,NULL,48151.94)
+INSERT INTO SALES VALUES(5,3,2020,8,NULL,48008.43)
+INSERT INTO SALES VALUES(5,2,2020,1,NULL,48123.85)
+INSERT INTO SALES VALUES(5,3,2019,7,NULL,48183.96)
+INSERT INTO SALES VALUES(5,4,2020,4,NULL,48119.40)
+INSERT INTO SALES VALUES(5,3,2020,12,NULL,48073.02)
+INSERT INTO SALES VALUES(5,1,2020,1,NULL,48016.70)
+INSERT INTO SALES VALUES(5,3,2021,3,NULL,47991.99)
+INSERT INTO SALES VALUES(5,3,2019,5,NULL,48118.05)
+INSERT INTO SALES VALUES(5,2,2021,3,NULL,48035.58)
+INSERT INTO SALES VALUES(5,3,2019,1,NULL,48136.62)
+INSERT INTO SALES VALUES(5,2,2020,12,NULL,48168.18)
+INSERT INTO SALES VALUES(5,4,2020,9,NULL,47991.21)
+INSERT INTO SALES VALUES(5,1,2019,7,NULL,48026.89)
+INSERT INTO SALES VALUES(5,4,2021,12,NULL,48028.59)
+INSERT INTO SALES VALUES(5,2,2019,8,NULL,48080.48)
+INSERT INTO SALES VALUES(5,4,2020,10,NULL,48142.84)
+INSERT INTO SALES VALUES(5,1,2021,12,NULL,48039.09)
+INSERT INTO SALES VALUES(5,5,2019,4,NULL,48111.39)
+INSERT INTO SALES VALUES(5,4,2021,8,NULL,48058.91)
+INSERT INTO SALES VALUES(5,4,2020,9,NULL,48117.13)
+INSERT INTO SALES VALUES(5,3,2019,8,NULL,48136.65)
+INSERT INTO SALES VALUES(5,5,2021,6,NULL,48076.28)
+INSERT INTO SALES VALUES(5,4,2021,3,NULL,48138.15)
+INSERT INTO SALES VALUES(5,2,2019,3,NULL,48041.35)
+INSERT INTO SALES VALUES(5,1,2020,4,NULL,48155.68)
+INSERT INTO SALES VALUES(5,5,2019,12,NULL,47998.97)
+INSERT INTO SALES VALUES(5,3,2019,10,NULL,48138.54)
+INSERT INTO SALES VALUES(5,5,2021,7,NULL,48031.89)
+INSERT INTO SALES VALUES(5,3,2019,1,NULL,47991.44)
+INSERT INTO SALES VALUES(5,4,2020,2,NULL,48064.86)
+INSERT INTO SALES VALUES(5,2,2021,10,NULL,48185.18)
+INSERT INTO SALES VALUES(5,2,2020,6,NULL,48063.74)
+INSERT INTO SALES VALUES(5,4,2019,5,NULL,48174.21)
+INSERT INTO SALES VALUES(5,2,2020,3,NULL,48007.59)
+INSERT INTO SALES VALUES(5,4,2021,12,NULL,48165.49)
+INSERT INTO SALES VALUES(5,4,2019,6,NULL,48003.08)
+INSERT INTO SALES VALUES(5,1,2019,2,NULL,48033.39)
+INSERT INTO SALES VALUES(5,3,2021,10,NULL,48160.84)
+INSERT INTO SALES VALUES(5,3,2021,5,NULL,48024.90)
+INSERT INTO SALES VALUES(5,2,2019,10,NULL,48103.29)
+INSERT INTO SALES VALUES(5,2,2021,9,NULL,48149.90)
+INSERT INTO SALES VALUES(5,2,2021,4,NULL,48023.43)
+INSERT INTO SALES VALUES(5,5,2019,7,NULL,48000.92)
+INSERT INTO SALES VALUES(5,1,2020,10,NULL,48064.16)
+INSERT INTO SALES VALUES(5,2,2019,2,NULL,47996.89)
+INSERT INTO SALES VALUES(5,3,2020,2,NULL,48037.67)
+INSERT INTO SALES VALUES(5,5,2019,10,NULL,48095.49)
+INSERT INTO SALES VALUES(5,4,2020,2,NULL,48154.40)
+INSERT INTO SALES VALUES(5,3,2019,3,NULL,48068.64)
+INSERT INTO SALES VALUES(5,1,2019,1,NULL,48081.08)
+INSERT INTO SALES VALUES(5,3,2020,1,NULL,48085.53)
+INSERT INTO SALES VALUES(5,4,2020,4,NULL,48097.47)
+INSERT INTO SALES VALUES(5,5,2019,8,NULL,47997.86)
+INSERT INTO SALES VALUES(5,5,2020,9,NULL,48171.24)
+INSERT INTO SALES VALUES(5,1,2021,12,NULL,48171.83)
+INSERT INTO SALES VALUES(5,5,2021,10,NULL,48020.60)
+INSERT INTO SALES VALUES(5,4,2019,4,NULL,48161.19)
+INSERT INTO SALES VALUES(5,1,2020,9,NULL,48084.09)
+INSERT INTO SALES VALUES(5,4,2020,1,NULL,48166.25)
+INSERT INTO SALES VALUES(5,2,2021,6,NULL,48167.23)
+INSERT INTO SALES VALUES(5,5,2019,8,NULL,48073.00)
+INSERT INTO SALES VALUES(5,5,2021,1,NULL,48185.38)
+INSERT INTO SALES VALUES(5,3,2020,4,NULL,48117.15)
+INSERT INTO SALES VALUES(5,1,2019,2,NULL,48072.56)
+INSERT INTO SALES VALUES(5,3,2019,8,NULL,48067.49)
+INSERT INTO SALES VALUES(5,3,2019,7,NULL,48175.47)
+INSERT INTO SALES VALUES(5,1,2019,1,NULL,48073.10)
+INSERT INTO SALES VALUES(5,3,2020,11,NULL,48102.56)
+INSERT INTO SALES VALUES(5,3,2020,6,NULL,48169.04)
+INSERT INTO SALES VALUES(5,4,2019,11,NULL,48047.39)
+INSERT INTO SALES VALUES(5,1,2021,4,NULL,48084.89)
+INSERT INTO SALES VALUES(5,4,2019,10,NULL,48056.09)
+INSERT INTO SALES VALUES(5,2,2021,7,NULL,48050.87)
+INSERT INTO SALES VALUES(5,1,2021,1,NULL,48158.18)
+INSERT INTO SALES VALUES(5,5,2021,12,NULL,48145.85)
+INSERT INTO SALES VALUES(6,4,2021,9,NULL,45902.66)
+INSERT INTO SALES VALUES(6,2,2019,12,NULL,45930.58)
+INSERT INTO SALES VALUES(6,1,2021,8,NULL,45972.09)
+INSERT INTO SALES VALUES(6,5,2020,11,NULL,45990.85)
+INSERT INTO SALES VALUES(6,5,2019,10,NULL,45884.28)
+INSERT INTO SALES VALUES(6,2,2019,5,NULL,45857.31)
+INSERT INTO SALES VALUES(6,2,2021,11,NULL,45919.42)
+INSERT INTO SALES VALUES(6,3,2020,8,NULL,45860.85)
+INSERT INTO SALES VALUES(6,2,2019,11,NULL,45978.19)
+INSERT INTO SALES VALUES(6,4,2020,4,NULL,45940.14)
+INSERT INTO SALES VALUES(6,3,2021,3,NULL,45910.90)
+INSERT INTO SALES VALUES(6,1,2019,8,NULL,45981.62)
+INSERT INTO SALES VALUES(6,2,2020,6,NULL,45899.76)
+INSERT INTO SALES VALUES(6,2,2020,4,NULL,46031.62)
+INSERT INTO SALES VALUES(6,1,2019,12,NULL,45844.88)
+INSERT INTO SALES VALUES(6,5,2019,2,NULL,45956.50)
+INSERT INTO SALES VALUES(6,1,2021,8,NULL,45954.90)
+INSERT INTO SALES VALUES(6,3,2020,6,NULL,45976.49)
+INSERT INTO SALES VALUES(6,3,2019,4,NULL,45993.00)
+INSERT INTO SALES VALUES(6,2,2019,4,NULL,45949.07)
+INSERT INTO SALES VALUES(6,5,2020,4,NULL,45879.12)
+INSERT INTO SALES VALUES(6,3,2019,10,NULL,45927.64)
+INSERT INTO SALES VALUES(6,1,2019,2,NULL,45999.06)
+INSERT INTO SALES VALUES(6,5,2021,11,NULL,45971.30)
+INSERT INTO SALES VALUES(6,3,2020,7,NULL,46021.32)
+INSERT INTO SALES VALUES(6,4,2020,10,NULL,46031.50)
+INSERT INTO SALES VALUES(6,3,2020,6,NULL,45872.51)
+INSERT INTO SALES VALUES(6,2,2020,7,NULL,45991.30)
+INSERT INTO SALES VALUES(6,3,2021,1,NULL,45971.96)
+INSERT INTO SALES VALUES(6,1,2020,3,NULL,45983.09)
+INSERT INTO SALES VALUES(6,1,2020,8,NULL,45876.47)
+INSERT INTO SALES VALUES(6,1,2021,3,NULL,45960.54)
+INSERT INTO SALES VALUES(6,5,2021,6,NULL,45935.85)
+INSERT INTO SALES VALUES(6,4,2020,10,NULL,45950.49)
+INSERT INTO SALES VALUES(6,4,2021,8,NULL,46010.18)
+INSERT INTO SALES VALUES(6,5,2021,5,NULL,45860.67)
+INSERT INTO SALES VALUES(6,5,2021,2,NULL,45949.41)
+INSERT INTO SALES VALUES(6,5,2021,6,NULL,45968.93)
+INSERT INTO SALES VALUES(6,2,2021,3,NULL,45986.16)
+INSERT INTO SALES VALUES(6,3,2021,4,NULL,45869.83)
+INSERT INTO SALES VALUES(6,1,2021,8,NULL,45842.54)
+INSERT INTO SALES VALUES(6,3,2021,5,NULL,45904.34)
+INSERT INTO SALES VALUES(6,2,2020,3,NULL,46001.69)
+INSERT INTO SALES VALUES(6,3,2021,5,NULL,45948.45)
+INSERT INTO SALES VALUES(6,3,2019,5,NULL,45844.92)
+INSERT INTO SALES VALUES(6,3,2021,11,NULL,45886.47)
+INSERT INTO SALES VALUES(6,1,2020,11,NULL,46005.03)
+INSERT INTO SALES VALUES(6,1,2019,11,NULL,45944.70)
+INSERT INTO SALES VALUES(6,4,2021,8,NULL,45936.94)
+INSERT INTO SALES VALUES(6,5,2021,7,NULL,45911.53)
+INSERT INTO SALES VALUES(6,2,2020,9,NULL,45956.00)
+INSERT INTO SALES VALUES(6,1,2021,8,NULL,45919.34)
+INSERT INTO SALES VALUES(6,3,2021,10,NULL,45845.10)
+INSERT INTO SALES VALUES(6,4,2021,8,NULL,45914.38)
+INSERT INTO SALES VALUES(6,3,2019,8,NULL,45981.17)
+INSERT INTO SALES VALUES(6,3,2021,5,NULL,45990.17)
+INSERT INTO SALES VALUES(6,4,2021,1,NULL,45981.93)
+INSERT INTO SALES VALUES(6,2,2019,7,NULL,46010.23)
+INSERT INTO SALES VALUES(6,4,2021,9,NULL,45923.62)
+INSERT INTO SALES VALUES(6,2,2020,12,NULL,45996.04)
+INSERT INTO SALES VALUES(6,4,2020,7,NULL,46030.54)
+INSERT INTO SALES VALUES(6,2,2020,8,NULL,46005.85)
+INSERT INTO SALES VALUES(6,5,2019,7,NULL,45987.14)
+INSERT INTO SALES VALUES(6,5,2019,7,NULL,45880.29)
+INSERT INTO SALES VALUES(6,5,2021,12,NULL,45873.53)
+INSERT INTO SALES VALUES(6,1,2021,12,NULL,45880.38)
+INSERT INTO SALES VALUES(6,4,2019,10,NULL,45975.01)
+INSERT INTO SALES VALUES(6,3,2021,11,NULL,45893.85)
+INSERT INTO SALES VALUES(6,3,2021,4,NULL,45966.63)
+INSERT INTO SALES VALUES(6,2,2020,8,NULL,45935.58)
+INSERT INTO SALES VALUES(6,5,2020,3,NULL,46023.33)
+INSERT INTO SALES VALUES(6,2,2021,5,NULL,45917.75)
+INSERT INTO SALES VALUES(6,4,2019,1,NULL,45856.69)
+INSERT INTO SALES VALUES(6,3,2019,12,NULL,45915.72)
+INSERT INTO SALES VALUES(6,5,2020,9,NULL,45928.83)
+INSERT INTO SALES VALUES(6,3,2019,12,NULL,46005.24)
+INSERT INTO SALES VALUES(6,3,2021,8,NULL,45944.36)
+INSERT INTO SALES VALUES(6,2,2020,1,NULL,45996.88)
+INSERT INTO SALES VALUES(6,2,2019,3,NULL,45971.26)
+INSERT INTO SALES VALUES(6,2,2021,5,NULL,45843.41)
+INSERT INTO SALES VALUES(6,1,2019,6,NULL,45991.17)
+INSERT INTO SALES VALUES(6,4,2019,4,NULL,45945.90)
+INSERT INTO SALES VALUES(6,3,2020,4,NULL,45930.28)
+INSERT INTO SALES VALUES(6,2,2019,2,NULL,46034.37)
+INSERT INTO SALES VALUES(7,2,2019,2,NULL,53877.82)
+INSERT INTO SALES VALUES(7,5,2021,7,NULL,54013.67)
+INSERT INTO SALES VALUES(7,4,2019,10,NULL,53941.93)
+INSERT INTO SALES VALUES(7,5,2021,4,NULL,53873.91)
+INSERT INTO SALES VALUES(7,5,2020,2,NULL,53895.29)
+INSERT INTO SALES VALUES(7,4,2019,11,NULL,54004.85)
+INSERT INTO SALES VALUES(7,2,2019,3,NULL,53960.70)
+INSERT INTO SALES VALUES(7,2,2019,3,NULL,54017.18)
+INSERT INTO SALES VALUES(7,4,2019,11,NULL,53857.70)
+INSERT INTO SALES VALUES(7,2,2021,11,NULL,53907.11)
+INSERT INTO SALES VALUES(7,1,2021,10,NULL,53941.57)
+INSERT INTO SALES VALUES(7,2,2021,5,NULL,53905.00)
+INSERT INTO SALES VALUES(7,1,2019,8,NULL,53888.11)
+INSERT INTO SALES VALUES(7,3,2020,8,NULL,53929.29)
+INSERT INTO SALES VALUES(7,3,2019,5,NULL,53856.21)
+INSERT INTO SALES VALUES(7,2,2020,9,NULL,54003.09)
+INSERT INTO SALES VALUES(7,2,2020,9,NULL,53910.08)
+INSERT INTO SALES VALUES(7,4,2020,5,NULL,53840.22)
+INSERT INTO SALES VALUES(7,5,2019,6,NULL,53933.38)
+INSERT INTO SALES VALUES(7,2,2021,6,NULL,53857.86)
+INSERT INTO SALES VALUES(7,2,2019,4,NULL,53917.16)
+INSERT INTO SALES VALUES(7,2,2020,10,NULL,53922.80)
+INSERT INTO SALES VALUES(7,5,2021,5,NULL,53953.70)
+INSERT INTO SALES VALUES(7,5,2021,2,NULL,53988.34)
+INSERT INTO SALES VALUES(7,3,2021,9,NULL,53918.18)
+INSERT INTO SALES VALUES(7,5,2020,11,NULL,54028.83)
+INSERT INTO SALES VALUES(7,3,2021,6,NULL,53870.39)
+INSERT INTO SALES VALUES(7,5,2019,5,NULL,53928.93)
+INSERT INTO SALES VALUES(7,5,2021,1,NULL,53858.29)
+INSERT INTO SALES VALUES(8,3,2019,12,NULL,54039.05)
+INSERT INTO SALES VALUES(8,1,2020,1,NULL,53952.78)
+INSERT INTO SALES VALUES(8,4,2019,5,NULL,53891.71)
+INSERT INTO SALES VALUES(8,1,2019,11,NULL,53902.32)
+INSERT INTO SALES VALUES(8,5,2021,10,NULL,53917.13)
+INSERT INTO SALES VALUES(8,1,2020,2,NULL,53911.44)
+INSERT INTO SALES VALUES(8,3,2019,8,NULL,53878.93)
+INSERT INTO SALES VALUES(8,1,2019,9,NULL,53890.59)
+INSERT INTO SALES VALUES(8,1,2019,5,NULL,53999.32)
+INSERT INTO SALES VALUES(8,2,2020,3,NULL,53958.04)
+INSERT INTO SALES VALUES(8,4,2019,4,NULL,54029.87)
+INSERT INTO SALES VALUES(8,3,2021,3,NULL,53986.56)
+INSERT INTO SALES VALUES(8,5,2019,8,NULL,53914.89)
+INSERT INTO SALES VALUES(8,3,2020,6,NULL,53880.63)
+INSERT INTO SALES VALUES(8,4,2019,3,NULL,54035.83)
+INSERT INTO SALES VALUES(8,2,2019,12,NULL,53997.58)
+INSERT INTO SALES VALUES(8,5,2019,11,NULL,53874.96)
+INSERT INTO SALES VALUES(8,1,2019,8,NULL,53975.86)
+INSERT INTO SALES VALUES(8,3,2021,11,NULL,53986.48)
+INSERT INTO SALES VALUES(8,1,2021,12,NULL,53883.63)
+INSERT INTO SALES VALUES(8,5,2019,5,NULL,54013.56)
+INSERT INTO SALES VALUES(8,5,2019,12,NULL,53851.21)
+INSERT INTO SALES VALUES(8,3,2019,3,NULL,53939.40)
+INSERT INTO SALES VALUES(8,3,2019,1,NULL,54000.41)
+INSERT INTO SALES VALUES(8,5,2021,4,NULL,54010.66)
+INSERT INTO SALES VALUES(8,4,2021,2,NULL,53934.16)
+INSERT INTO SALES VALUES(8,3,2020,9,NULL,54021.64)
+INSERT INTO SALES VALUES(8,5,2020,4,NULL,53899.64)
+INSERT INTO SALES VALUES(8,3,2019,1,NULL,53897.25)
+INSERT INTO SALES VALUES(8,4,2020,11,NULL,53988.36)
+INSERT INTO SALES VALUES(8,2,2020,10,NULL,53963.33)
+INSERT INTO SALES VALUES(8,3,2019,4,NULL,53986.20)
+INSERT INTO SALES VALUES(8,5,2019,5,NULL,53942.43)
+INSERT INTO SALES VALUES(8,2,2019,8,NULL,53936.95)
+INSERT INTO SALES VALUES(8,2,2019,5,NULL,53963.32)
+INSERT INTO SALES VALUES(8,4,2019,8,NULL,53932.46)
+INSERT INTO SALES VALUES(8,2,2019,6,NULL,53922.64)
+INSERT INTO SALES VALUES(8,1,2021,6,NULL,53892.78)
+INSERT INTO SALES VALUES(8,2,2020,1,NULL,53986.82)
+INSERT INTO SALES VALUES(8,4,2019,12,NULL,53949.53)
+INSERT INTO SALES VALUES(8,1,2019,8,NULL,53872.73)
+INSERT INTO SALES VALUES(8,5,2020,9,NULL,53895.76)
+INSERT INTO SALES VALUES(8,3,2020,6,NULL,53995.11)
+INSERT INTO SALES VALUES(8,1,2021,5,NULL,54015.63)
+INSERT INTO SALES VALUES(8,1,2020,6,NULL,54019.27)
+INSERT INTO SALES VALUES(8,5,2020,12,NULL,53857.17)
+INSERT INTO SALES VALUES(8,1,2019,10,NULL,54007.24)
+INSERT INTO SALES VALUES(8,4,2021,5,NULL,53961.40)
+INSERT INTO SALES VALUES(8,2,2021,7,NULL,53995.70)
+INSERT INTO SALES VALUES(8,3,2021,10,NULL,54011.07)
+INSERT INTO SALES VALUES(8,2,2019,4,NULL,53893.84)
+INSERT INTO SALES VALUES(8,1,2021,7,NULL,53912.34)
+INSERT INTO SALES VALUES(8,3,2019,11,NULL,54039.67)
+INSERT INTO SALES VALUES(8,5,2020,2,NULL,53972.66)
+INSERT INTO SALES VALUES(8,4,2019,3,NULL,54002.84)
+INSERT INTO SALES VALUES(8,2,2021,11,NULL,53988.17)
+INSERT INTO SALES VALUES(8,5,2020,12,NULL,53872.33)
+INSERT INTO SALES VALUES(8,3,2021,8,NULL,53903.76)
+INSERT INTO SALES VALUES(8,2,2020,9,NULL,53917.35)
+INSERT INTO SALES VALUES(8,5,2021,7,NULL,53959.34)
+INSERT INTO SALES VALUES(8,5,2019,1,NULL,53959.62)
+INSERT INTO SALES VALUES(8,3,2021,2,NULL,53885.26)
+INSERT INTO SALES VALUES(8,4,2019,12,NULL,53845.45)
+INSERT INTO SALES VALUES(8,2,2021,10,NULL,53960.48)
+INSERT INTO SALES VALUES(8,1,2019,6,NULL,53855.69)
+INSERT INTO SALES VALUES(8,3,2020,11,NULL,53996.58)
+INSERT INTO SALES VALUES(8,1,2021,9,NULL,53942.13)
+INSERT INTO SALES VALUES(8,3,2019,8,NULL,53960.92)
+INSERT INTO SALES VALUES(8,3,2020,7,NULL,53928.27)
+INSERT INTO SALES VALUES(8,1,2020,2,NULL,54002.28)
+INSERT INTO SALES VALUES(8,2,2020,4,NULL,53863.15)
+INSERT INTO SALES VALUES(8,1,2019,1,NULL,53892.24)
+INSERT INTO SALES VALUES(8,1,2019,5,NULL,53966.10)
+INSERT INTO SALES VALUES(8,2,2020,9,NULL,53945.55)
+INSERT INTO SALES VALUES(8,1,2021,11,NULL,53851.04)
+INSERT INTO SALES VALUES(8,3,2019,2,NULL,53932.84)
+INSERT INTO SALES VALUES(8,2,2020,3,NULL,53968.39)
+INSERT INTO SALES VALUES(8,3,2021,5,NULL,53948.84)
+INSERT INTO SALES VALUES(8,3,2019,11,NULL,53853.01)
+INSERT INTO SALES VALUES(8,1,2020,5,NULL,53849.55)
+INSERT INTO SALES VALUES(8,5,2020,10,NULL,54016.32)
+INSERT INTO SALES VALUES(8,3,2019,9,NULL,53921.45)
+INSERT INTO SALES VALUES(8,3,2019,3,NULL,53971.02)
+INSERT INTO SALES VALUES(8,5,2020,3,NULL,53896.26)
+INSERT INTO SALES VALUES(8,3,2019,3,NULL,53926.55)
+INSERT INTO SALES VALUES(8,5,2020,4,NULL,53874.24)
+INSERT INTO SALES VALUES(8,3,2019,2,NULL,53943.75)
+INSERT INTO SALES VALUES(8,5,2020,4,NULL,53969.62)
+INSERT INTO SALES VALUES(8,4,2021,11,NULL,53986.77)
+INSERT INTO SALES VALUES(8,3,2020,12,NULL,53941.24)
+INSERT INTO SALES VALUES(8,3,2020,1,NULL,53960.74)
+INSERT INTO SALES VALUES(8,2,2019,8,NULL,53921.71)
+INSERT INTO SALES VALUES(8,5,2020,9,NULL,53873.30)
+INSERT INTO SALES VALUES(8,5,2021,3,NULL,54008.45)
+INSERT INTO SALES VALUES(9,5,2021,5,NULL,58930.46)
+INSERT INTO SALES VALUES(9,5,2019,6,NULL,58944.96)
+INSERT INTO SALES VALUES(9,5,2020,1,NULL,58951.79)
+INSERT INTO SALES VALUES(9,2,2019,1,NULL,58881.05)
+INSERT INTO SALES VALUES(9,3,2021,7,NULL,58939.30)
+INSERT INTO SALES VALUES(9,5,2019,11,NULL,58857.79)
+INSERT INTO SALES VALUES(9,4,2019,7,NULL,58850.60)
+INSERT INTO SALES VALUES(9,5,2021,2,NULL,58900.11)
+INSERT INTO SALES VALUES(9,5,2020,6,NULL,58931.32)
+INSERT INTO SALES VALUES(9,3,2019,2,NULL,58936.46)
+INSERT INTO SALES VALUES(9,4,2019,1,NULL,58967.99)
+INSERT INTO SALES VALUES(9,3,2021,7,NULL,58930.67)
+INSERT INTO SALES VALUES(9,3,2019,5,NULL,58872.41)
+INSERT INTO SALES VALUES(9,3,2019,4,NULL,58998.72)
+INSERT INTO SALES VALUES(9,1,2019,3,NULL,58917.05)
+INSERT INTO SALES VALUES(9,3,2019,5,NULL,58855.08)
+INSERT INTO SALES VALUES(9,3,2019,10,NULL,58990.88)
+INSERT INTO SALES VALUES(9,2,2020,7,NULL,58983.03)
+INSERT INTO SALES VALUES(9,4,2021,11,NULL,58895.37)
+INSERT INTO SALES VALUES(9,1,2020,3,NULL,58973.60)
+INSERT INTO SALES VALUES(9,1,2019,7,NULL,58949.98)
+INSERT INTO SALES VALUES(9,3,2021,6,NULL,58927.55)
+INSERT INTO SALES VALUES(9,5,2019,5,NULL,59026.76)
+INSERT INTO SALES VALUES(9,5,2020,2,NULL,58865.01)
+INSERT INTO SALES VALUES(9,3,2019,11,NULL,58983.69)
+INSERT INTO SALES VALUES(9,5,2020,8,NULL,58937.33)
+INSERT INTO SALES VALUES(9,2,2021,8,NULL,58916.11)
+INSERT INTO SALES VALUES(9,2,2020,9,NULL,58885.50)
+INSERT INTO SALES VALUES(9,1,2019,5,NULL,58895.85)
+INSERT INTO SALES VALUES(9,3,2021,1,NULL,59039.91)
+INSERT INTO SALES VALUES(9,3,2021,11,NULL,58917.68)
+INSERT INTO SALES VALUES(9,2,2021,11,NULL,59005.80)
+INSERT INTO SALES VALUES(9,4,2020,12,NULL,59022.45)
+INSERT INTO SALES VALUES(9,3,2020,3,NULL,59029.05)
+INSERT INTO SALES VALUES(9,1,2019,2,NULL,59016.56)
+INSERT INTO SALES VALUES(9,1,2020,9,NULL,58886.68)
+INSERT INTO SALES VALUES(9,2,2020,9,NULL,58857.30)
+INSERT INTO SALES VALUES(9,3,2019,7,NULL,58996.86)
+INSERT INTO SALES VALUES(9,3,2019,5,NULL,59023.47)
+INSERT INTO SALES VALUES(9,5,2020,5,NULL,58892.62)
+INSERT INTO SALES VALUES(9,3,2020,4,NULL,58840.97)
+INSERT INTO SALES VALUES(9,3,2020,12,NULL,58854.15)
+INSERT INTO SALES VALUES(9,5,2019,11,NULL,58982.80)
+INSERT INTO SALES VALUES(9,1,2020,9,NULL,58943.86)
+INSERT INTO SALES VALUES(9,4,2021,1,NULL,59012.97)
+INSERT INTO SALES VALUES(9,2,2021,5,NULL,58939.09)
+INSERT INTO SALES VALUES(9,2,2019,12,NULL,58893.98)
+INSERT INTO SALES VALUES(9,3,2020,8,NULL,58906.68)
+INSERT INTO SALES VALUES(10,2,2021,12,NULL,-91.67)
+INSERT INTO SALES VALUES(10,2,2021,11,NULL,-65.62)
+INSERT INTO SALES VALUES(10,1,2019,1,NULL,-22.77)
+INSERT INTO SALES VALUES(10,1,2020,11,NULL,47.91)
+INSERT INTO SALES VALUES(10,4,2020,12,NULL,96.68)
+INSERT INTO SALES VALUES(10,5,2021,7,NULL,-81.47)
+INSERT INTO SALES VALUES(10,4,2021,2,NULL,83.41)
+INSERT INTO SALES VALUES(10,3,2020,2,NULL,97.28)
+INSERT INTO SALES VALUES(10,3,2019,4,NULL,-85.91)
+INSERT INTO SALES VALUES(10,3,2020,10,NULL,39.47)
+INSERT INTO SALES VALUES(10,2,2021,9,NULL,-6.41)
+INSERT INTO SALES VALUES(10,5,2019,9,NULL,33.74)
+INSERT INTO SALES VALUES(10,5,2020,9,NULL,-23.73)
+INSERT INTO SALES VALUES(10,5,2020,9,NULL,-96.72)
+INSERT INTO SALES VALUES(10,4,2021,9,NULL,91.03)
+INSERT INTO SALES VALUES(10,2,2020,9,NULL,54.99)
+INSERT INTO SALES VALUES(10,2,2020,3,NULL,-28.95)
+INSERT INTO SALES VALUES(10,5,2020,8,NULL,-97.60)
+INSERT INTO SALES VALUES(10,2,2020,12,NULL,38.87)
+INSERT INTO SALES VALUES(10,3,2019,7,NULL,-61.89)
+INSERT INTO SALES VALUES(10,2,2020,2,NULL,-52.41)
+INSERT INTO SALES VALUES(10,4,2020,9,NULL,-18.47)
+INSERT INTO SALES VALUES(10,2,2021,8,NULL,29.10)
+INSERT INTO SALES VALUES(10,3,2021,9,NULL,-22.28)
+INSERT INTO SALES VALUES(10,5,2021,9,NULL,-50.00)
+INSERT INTO SALES VALUES(10,5,2020,12,NULL,-26.92)
+INSERT INTO SALES VALUES(10,5,2019,8,NULL,25.99)
+INSERT INTO SALES VALUES(10,4,2020,3,NULL,-56.30)
+INSERT INTO SALES VALUES(10,2,2021,4,NULL,95.63)
+INSERT INTO SALES VALUES(10,1,2021,8,NULL,2.16)
+INSERT INTO SALES VALUES(10,3,2021,12,NULL,-95.90)
+INSERT INTO SALES VALUES(10,1,2020,8,NULL,-41.53)
+INSERT INTO SALES VALUES(10,2,2019,7,NULL,-2.18)
+INSERT INTO SALES VALUES(10,3,2021,12,NULL,61.10)
+INSERT INTO SALES VALUES(10,2,2020,12,NULL,-19.23)
+INSERT INTO SALES VALUES(10,2,2019,3,NULL,-6.27)
+INSERT INTO SALES VALUES(10,3,2019,2,NULL,33.15)
+INSERT INTO SALES VALUES(10,3,2019,12,NULL,53.52)
+INSERT INTO SALES VALUES(10,1,2020,9,NULL,43.24)
+INSERT INTO SALES VALUES(10,4,2021,5,NULL,86.82)
+INSERT INTO SALES VALUES(10,3,2020,4,NULL,-46.68)
+INSERT INTO SALES VALUES(10,1,2020,6,NULL,7.88)
+INSERT INTO SALES VALUES(10,2,2020,5,NULL,-29.80)
+INSERT INTO SALES VALUES(10,2,2020,10,NULL,-23.46)
+INSERT INTO SALES VALUES(10,5,2020,4,NULL,-58.54)
+INSERT INTO SALES VALUES(10,4,2019,4,NULL,-39.41)
+INSERT INTO SALES VALUES(10,4,2021,3,NULL,47.89)
+INSERT INTO SALES VALUES(10,2,2019,9,NULL,58.53)
+INSERT INTO SALES VALUES(10,4,2019,12,NULL,13.05)
+INSERT INTO SALES VALUES(10,1,2019,9,NULL,8.68)
+INSERT INTO SALES VALUES(10,1,2019,3,NULL,80.79)
+INSERT INTO SALES VALUES(10,4,2020,3,NULL,-39.81)
+INSERT INTO SALES VALUES(10,3,2020,1,NULL,61.31)
+INSERT INTO SALES VALUES(10,3,2020,2,NULL,31.96)
+INSERT INTO SALES VALUES(10,3,2020,2,NULL,-3.21)
+INSERT INTO SALES VALUES(10,3,2019,11,NULL,35.09)
+INSERT INTO SALES VALUES(10,2,2021,12,NULL,47.16)
+INSERT INTO SALES VALUES(10,4,2021,6,NULL,-15.29)
+INSERT INTO SALES VALUES(10,4,2019,7,NULL,46.90)
+INSERT INTO SALES VALUES(10,4,2019,6,NULL,76.97)
+INSERT INTO SALES VALUES(10,2,2020,10,NULL,33.67)
+INSERT INTO SALES VALUES(10,4,2019,11,NULL,56.95)
+INSERT INTO SALES VALUES(10,2,2021,8,NULL,99.47)
+INSERT INTO SALES VALUES(10,1,2021,6,NULL,-46.75)
+INSERT INTO SALES VALUES(10,2,2021,6,NULL,-34.87)
+INSERT INTO SALES VALUES(10,2,2021,1,NULL,5.17)
+INSERT INTO SALES VALUES(10,2,2021,8,NULL,-70.98)
+INSERT INTO SALES VALUES(10,3,2021,9,NULL,58.04)
+INSERT INTO SALES VALUES(10,1,2021,12,NULL,90.54)
+INSERT INTO SALES VALUES(10,1,2020,5,NULL,-47.32)
+INSERT INTO SALES VALUES(10,3,2021,6,NULL,-0.51)
+INSERT INTO SALES VALUES(10,5,2021,12,NULL,84.69)
+INSERT INTO SALES VALUES(10,2,2019,4,NULL,-68.30)
+INSERT INTO SALES VALUES(10,1,2019,10,NULL,-40.64)
+INSERT INTO SALES VALUES(10,1,2019,1,NULL,42.13)
+INSERT INTO SALES VALUES(10,2,2021,6,NULL,17.93)
+INSERT INTO SALES VALUES(10,1,2019,3,NULL,95.81)
+INSERT INTO SALES VALUES(10,5,2020,2,NULL,61.11)
+INSERT INTO SALES VALUES(10,3,2019,12,NULL,-72.19)
+INSERT INTO SALES VALUES(10,2,2020,1,NULL,45.48)
+INSERT INTO SALES VALUES(10,5,2021,5,NULL,32.61)
+INSERT INTO SALES VALUES(10,3,2020,9,NULL,78.69)
+INSERT INTO SALES VALUES(10,3,2019,9,NULL,-66.00)
+INSERT INTO SALES VALUES(10,2,2021,9,NULL,89.18)
+INSERT INTO SALES VALUES(10,2,2019,5,NULL,36.04)
+INSERT INTO SALES VALUES(10,1,2021,6,NULL,96.16)
+INSERT INTO SALES VALUES(10,4,2019,5,NULL,-93.90)
+INSERT INTO SALES VALUES(10,2,2021,1,NULL,55.73)
+INSERT INTO SALES VALUES(10,1,2020,12,NULL,-9.55)
+INSERT INTO SALES VALUES(10,2,2021,7,NULL,-91.18)
+INSERT INTO SALES VALUES(10,3,2021,11,NULL,13.51)
+INSERT INTO SALES VALUES(10,5,2021,11,NULL,-93.14)
+INSERT INTO SALES VALUES(10,2,2019,4,NULL,-38.69)
+INSERT INTO SALES VALUES(10,3,2021,6,NULL,-59.27)
+INSERT INTO SALES VALUES(10,1,2019,7,NULL,0.05)
+INSERT INTO SALES VALUES(10,1,2021,3,NULL,49.11)
+INSERT INTO SALES VALUES(10,2,2020,2,NULL,-69.51)
+INSERT INTO SALES VALUES(10,3,2020,1,NULL,-68.32)
+INSERT INTO SALES VALUES(11,2,2019,8,NULL,54302.29)
+INSERT INTO SALES VALUES(11,1,2021,3,NULL,54358.45)
+INSERT INTO SALES VALUES(11,3,2019,5,NULL,54357.88)
+INSERT INTO SALES VALUES(11,4,2019,12,NULL,54301.89)
+INSERT INTO SALES VALUES(11,5,2021,8,NULL,54335.51)
+INSERT INTO SALES VALUES(11,3,2019,8,NULL,54279.62)
+INSERT INTO SALES VALUES(11,5,2019,6,NULL,54382.27)
+INSERT INTO SALES VALUES(11,1,2019,9,NULL,54250.15)
+INSERT INTO SALES VALUES(11,2,2021,6,NULL,54330.69)
+INSERT INTO SALES VALUES(11,4,2020,12,NULL,54380.97)
+INSERT INTO SALES VALUES(11,2,2020,11,NULL,54281.98)
+INSERT INTO SALES VALUES(11,5,2020,5,NULL,54334.66)
+INSERT INTO SALES VALUES(11,1,2021,12,NULL,54209.26)
+INSERT INTO SALES VALUES(11,1,2021,12,NULL,54209.75)
+INSERT INTO SALES VALUES(11,5,2021,7,NULL,54262.75)
+INSERT INTO SALES VALUES(11,2,2021,9,NULL,54243.21)
+INSERT INTO SALES VALUES(11,2,2020,5,NULL,54308.93)
+INSERT INTO SALES VALUES(11,2,2020,1,NULL,54231.82)
+INSERT INTO SALES VALUES(11,4,2020,10,NULL,54285.75)
+INSERT INTO SALES VALUES(11,2,2020,9,NULL,54279.26)
+INSERT INTO SALES VALUES(11,2,2019,7,NULL,54205.91)
+INSERT INTO SALES VALUES(11,1,2021,11,NULL,54326.00)
+INSERT INTO SALES VALUES(11,1,2019,8,NULL,54290.18)
+INSERT INTO SALES VALUES(11,3,2019,12,NULL,54369.15)
+INSERT INTO SALES VALUES(11,2,2019,1,NULL,54362.91)
+INSERT INTO SALES VALUES(11,5,2019,11,NULL,54329.09)
+INSERT INTO SALES VALUES(11,4,2020,8,NULL,54291.65)
+INSERT INTO SALES VALUES(11,3,2019,8,NULL,54370.06)
+INSERT INTO SALES VALUES(11,2,2019,5,NULL,54302.95)
+INSERT INTO SALES VALUES(11,1,2020,9,NULL,54331.75)
+INSERT INTO SALES VALUES(12,1,2020,4,NULL,62702.65)
+INSERT INTO SALES VALUES(12,2,2020,11,NULL,62726.08)
+INSERT INTO SALES VALUES(12,4,2021,1,NULL,62836.66)
+INSERT INTO SALES VALUES(12,5,2019,2,NULL,62821.35)
+INSERT INTO SALES VALUES(12,5,2020,4,NULL,62738.17)
+INSERT INTO SALES VALUES(12,5,2020,9,NULL,62721.42)
+INSERT INTO SALES VALUES(12,3,2020,3,NULL,62793.51)
+INSERT INTO SALES VALUES(12,5,2021,12,NULL,62833.67)
+INSERT INTO SALES VALUES(12,2,2019,11,NULL,62745.36)
+INSERT INTO SALES VALUES(12,5,2020,4,NULL,62863.38)
+INSERT INTO SALES VALUES(12,1,2021,8,NULL,62746.45)
+INSERT INTO SALES VALUES(12,3,2020,6,NULL,62711.88)
+INSERT INTO SALES VALUES(12,5,2020,8,NULL,62786.81)
+INSERT INTO SALES VALUES(12,4,2019,8,NULL,62773.67)
+INSERT INTO SALES VALUES(12,2,2019,10,NULL,62857.78)
+INSERT INTO SALES VALUES(12,1,2019,5,NULL,62820.76)
+INSERT INTO SALES VALUES(12,5,2021,4,NULL,62866.23)
+INSERT INTO SALES VALUES(12,5,2019,11,NULL,62712.50)
+INSERT INTO SALES VALUES(12,5,2021,12,NULL,62762.12)
+INSERT INTO SALES VALUES(12,4,2021,2,NULL,62819.19)
+INSERT INTO SALES VALUES(12,5,2020,9,NULL,62792.69)
+INSERT INTO SALES VALUES(12,2,2020,10,NULL,62897.76)
+INSERT INTO SALES VALUES(12,5,2021,11,NULL,62846.71)
+INSERT INTO SALES VALUES(12,3,2021,2,NULL,62807.79)
+INSERT INTO SALES VALUES(12,1,2019,4,NULL,62701.88)
+INSERT INTO SALES VALUES(12,5,2020,10,NULL,62706.19)
+INSERT INTO SALES VALUES(12,3,2021,7,NULL,62838.75)
+INSERT INTO SALES VALUES(12,4,2019,5,NULL,62808.68)
+INSERT INTO SALES VALUES(12,5,2019,4,NULL,62734.50)
+INSERT INTO SALES VALUES(12,5,2021,4,NULL,62856.61)
+INSERT INTO SALES VALUES(12,5,2019,9,NULL,62799.70)
+INSERT INTO SALES VALUES(12,4,2021,3,NULL,62877.12)
+INSERT INTO SALES VALUES(12,3,2021,6,NULL,62771.56)
+INSERT INTO SALES VALUES(12,4,2019,5,NULL,62875.14)
+INSERT INTO SALES VALUES(12,3,2021,2,NULL,62826.68)
+INSERT INTO SALES VALUES(12,5,2020,2,NULL,62745.33)
+INSERT INTO SALES VALUES(12,3,2021,6,NULL,62726.82)
+INSERT INTO SALES VALUES(12,1,2021,10,NULL,62742.46)
+INSERT INTO SALES VALUES(12,4,2021,12,NULL,62760.84)
+INSERT INTO SALES VALUES(12,5,2021,10,NULL,62898.24)
+INSERT INTO SALES VALUES(12,5,2019,2,NULL,62896.15)
+INSERT INTO SALES VALUES(12,4,2019,7,NULL,62823.14)
+INSERT INTO SALES VALUES(12,4,2019,12,NULL,62802.85)
+INSERT INTO SALES VALUES(12,1,2019,6,NULL,62781.32)
+INSERT INTO SALES VALUES(12,5,2020,9,NULL,62864.04)
+INSERT INTO SALES VALUES(12,1,2020,7,NULL,62776.97)
+INSERT INTO SALES VALUES(12,5,2020,6,NULL,62735.33)
+INSERT INTO SALES VALUES(12,5,2021,2,NULL,62840.44)
+INSERT INTO SALES VALUES(12,5,2021,7,NULL,62867.06)
+INSERT INTO SALES VALUES(12,3,2021,1,NULL,62752.31)
+INSERT INTO SALES VALUES(12,2,2021,4,NULL,62852.35)
+INSERT INTO SALES VALUES(12,3,2020,4,NULL,62893.75)
+INSERT INTO SALES VALUES(12,4,2019,12,NULL,62714.35)
+INSERT INTO SALES VALUES(12,4,2019,6,NULL,62761.49)
+INSERT INTO SALES VALUES(12,5,2021,9,NULL,62895.96)
+INSERT INTO SALES VALUES(12,5,2020,11,NULL,62735.57)
+INSERT INTO SALES VALUES(12,1,2019,4,NULL,62765.21)
+INSERT INTO SALES VALUES(12,3,2021,3,NULL,62738.26)
+INSERT INTO SALES VALUES(12,1,2019,10,NULL,62899.77)
+INSERT INTO SALES VALUES(12,2,2021,5,NULL,62872.36)
+INSERT INTO SALES VALUES(12,3,2019,12,NULL,62863.64)
+INSERT INTO SALES VALUES(12,3,2021,9,NULL,62777.21)
+INSERT INTO SALES VALUES(12,1,2021,4,NULL,62839.52)
+INSERT INTO SALES VALUES(12,3,2019,1,NULL,62890.67)
+INSERT INTO SALES VALUES(12,3,2019,6,NULL,62729.96)
+INSERT INTO SALES VALUES(12,4,2021,9,NULL,62855.31)
+INSERT INTO SALES VALUES(12,1,2021,11,NULL,62790.72)
+INSERT INTO SALES VALUES(12,3,2020,2,NULL,62757.18)
+INSERT INTO SALES VALUES(12,4,2020,3,NULL,62709.47)
+INSERT INTO SALES VALUES(12,3,2019,7,NULL,62735.37)
+INSERT INTO SALES VALUES(12,3,2019,6,NULL,62893.29)
+INSERT INTO SALES VALUES(12,2,2020,12,NULL,62750.69)
+INSERT INTO SALES VALUES(12,4,2021,8,NULL,62778.07)
+INSERT INTO SALES VALUES(12,4,2021,3,NULL,62751.66)
+INSERT INTO SALES VALUES(12,2,2019,8,NULL,62823.24)
+INSERT INTO SALES VALUES(12,1,2020,5,NULL,62726.24)
+INSERT INTO SALES VALUES(12,5,2021,9,NULL,62705.01)
+INSERT INTO SALES VALUES(12,5,2019,12,NULL,62777.45)
+INSERT INTO SALES VALUES(12,4,2021,6,NULL,62871.43)
+INSERT INTO SALES VALUES(12,5,2020,4,NULL,62811.19)
+INSERT INTO SALES VALUES(12,4,2021,3,NULL,62872.60)
+INSERT INTO SALES VALUES(12,1,2020,12,NULL,62874.62)
+INSERT INTO SALES VALUES(12,3,2021,4,NULL,62729.25)
+INSERT INTO SALES VALUES(12,3,2019,10,NULL,62833.31)
+INSERT INTO SALES VALUES(12,2,2021,12,NULL,62852.98)
+INSERT INTO SALES VALUES(12,3,2020,4,NULL,62725.36)
+INSERT INTO SALES VALUES(12,3,2021,4,NULL,62881.47)
+INSERT INTO SALES VALUES(12,3,2021,4,NULL,62781.02)
+INSERT INTO SALES VALUES(12,3,2020,3,NULL,62841.92)
+INSERT INTO SALES VALUES(12,2,2020,4,NULL,62745.79)
+INSERT INTO SALES VALUES(12,4,2020,3,NULL,62705.99)
+INSERT INTO SALES VALUES(12,5,2019,11,NULL,62795.52)
+INSERT INTO SALES VALUES(12,1,2020,11,NULL,62849.61)
+INSERT INTO SALES VALUES(12,5,2020,1,NULL,62781.68)
+INSERT INTO SALES VALUES(12,4,2019,9,NULL,62780.74)
+INSERT INTO SALES VALUES(12,3,2019,4,NULL,62795.05)
+INSERT INTO SALES VALUES(12,4,2020,4,NULL,62748.60)
+INSERT INTO SALES VALUES(12,4,2020,2,NULL,62886.22)
+INSERT INTO SALES VALUES(12,3,2019,6,NULL,62897.49)
+INSERT INTO SALES VALUES(12,3,2020,2,NULL,62831.11)
+INSERT INTO SALES VALUES(12,1,2020,1,NULL,62878.58)
+INSERT INTO SALES VALUES(12,4,2019,7,NULL,62879.77)
+INSERT INTO SALES VALUES(12,1,2019,9,NULL,62882.81)
+INSERT INTO SALES VALUES(12,5,2021,6,NULL,62876.81)
+INSERT INTO SALES VALUES(12,4,2020,4,NULL,62708.39)
+INSERT INTO SALES VALUES(12,3,2021,1,NULL,62791.67)
+INSERT INTO SALES VALUES(12,3,2020,3,NULL,62725.98)
+INSERT INTO SALES VALUES(12,3,2020,5,NULL,62747.11)
+INSERT INTO SALES VALUES(12,2,2019,8,NULL,62854.94)
+INSERT INTO SALES VALUES(12,1,2019,10,NULL,62884.06)
+INSERT INTO SALES VALUES(12,3,2019,7,NULL,62713.95)
+INSERT INTO SALES VALUES(12,5,2020,11,NULL,62851.24)
+INSERT INTO SALES VALUES(12,2,2021,5,NULL,62759.17)
+INSERT INTO SALES VALUES(12,4,2019,1,NULL,62757.76)
+INSERT INTO SALES VALUES(12,2,2020,1,NULL,62873.35)
+INSERT INTO SALES VALUES(12,4,2019,6,NULL,62877.03)
+INSERT INTO SALES VALUES(12,4,2019,2,NULL,62719.09)
+INSERT INTO SALES VALUES(12,5,2019,11,NULL,62840.17)
+INSERT INTO SALES VALUES(13,2,2021,8,NULL,37964.27)
+INSERT INTO SALES VALUES(13,5,2021,1,NULL,37994.85)
+INSERT INTO SALES VALUES(13,3,2019,5,NULL,37996.97)
+INSERT INTO SALES VALUES(13,1,2019,4,NULL,37919.36)
+INSERT INTO SALES VALUES(13,3,2019,1,NULL,38083.37)
+INSERT INTO SALES VALUES(13,4,2019,11,NULL,37912.99)
+INSERT INTO SALES VALUES(13,4,2021,5,NULL,38076.04)
+INSERT INTO SALES VALUES(13,5,2019,11,NULL,38099.33)
+INSERT INTO SALES VALUES(13,5,2020,8,NULL,37957.90)
+INSERT INTO SALES VALUES(13,3,2020,7,NULL,37932.52)
+INSERT INTO SALES VALUES(13,2,2021,10,NULL,37979.98)
+INSERT INTO SALES VALUES(13,1,2020,4,NULL,37966.82)
+INSERT INTO SALES VALUES(13,1,2020,6,NULL,37980.20)
+INSERT INTO SALES VALUES(13,3,2019,2,NULL,37948.26)
+INSERT INTO SALES VALUES(13,1,2021,1,NULL,37977.73)
+INSERT INTO SALES VALUES(13,2,2020,3,NULL,37947.89)
+INSERT INTO SALES VALUES(13,4,2021,2,NULL,37987.58)
+INSERT INTO SALES VALUES(13,4,2020,5,NULL,37906.24)
+INSERT INTO SALES VALUES(13,5,2021,1,NULL,38049.72)
+INSERT INTO SALES VALUES(13,1,2020,1,NULL,38008.36)
+INSERT INTO SALES VALUES(13,2,2020,4,NULL,37917.48)
+INSERT INTO SALES VALUES(13,5,2019,11,NULL,37959.13)
+INSERT INTO SALES VALUES(13,1,2020,6,NULL,38099.64)
+INSERT INTO SALES VALUES(13,2,2019,9,NULL,38078.30)
+INSERT INTO SALES VALUES(13,1,2019,10,NULL,38000.82)
+INSERT INTO SALES VALUES(13,4,2019,3,NULL,37984.77)
+INSERT INTO SALES VALUES(13,2,2019,4,NULL,37954.54)
+INSERT INTO SALES VALUES(13,1,2019,3,NULL,38089.74)
+INSERT INTO SALES VALUES(13,4,2020,3,NULL,37993.77)
+INSERT INTO SALES VALUES(13,3,2019,3,NULL,37968.10)
+INSERT INTO SALES VALUES(13,2,2021,7,NULL,38053.13)
+INSERT INTO SALES VALUES(13,1,2019,9,NULL,37927.75)
+INSERT INTO SALES VALUES(13,5,2021,2,NULL,37947.67)
+INSERT INTO SALES VALUES(13,2,2019,5,NULL,37946.31)
+INSERT INTO SALES VALUES(13,5,2020,9,NULL,37922.39)
+INSERT INTO SALES VALUES(13,1,2019,1,NULL,37994.72)
+INSERT INTO SALES VALUES(13,3,2019,6,NULL,38017.33)
+INSERT INTO SALES VALUES(13,5,2021,1,NULL,38017.32)
+INSERT INTO SALES VALUES(13,4,2020,5,NULL,37942.51)
+INSERT INTO SALES VALUES(13,4,2021,7,NULL,38087.94)
+INSERT INTO SALES VALUES(13,1,2019,7,NULL,38007.52)
+INSERT INTO SALES VALUES(13,1,2021,1,NULL,37911.48)
+INSERT INTO SALES VALUES(13,5,2021,4,NULL,37900.02)
+INSERT INTO SALES VALUES(13,3,2019,7,NULL,38090.53)
+INSERT INTO SALES VALUES(13,4,2019,5,NULL,37957.86)
+INSERT INTO SALES VALUES(13,4,2020,4,NULL,38026.62)
+INSERT INTO SALES VALUES(13,5,2021,5,NULL,38029.30)
+INSERT INTO SALES VALUES(13,2,2021,1,NULL,37975.55)
+INSERT INTO SALES VALUES(13,1,2019,12,NULL,38065.85)
+INSERT INTO SALES VALUES(13,2,2021,2,NULL,38026.34)
+INSERT INTO SALES VALUES(13,3,2020,3,NULL,38042.27)
+INSERT INTO SALES VALUES(13,2,2020,10,NULL,38023.45)
+INSERT INTO SALES VALUES(13,5,2020,11,NULL,38048.28)
+INSERT INTO SALES VALUES(13,4,2019,5,NULL,37901.56)
+INSERT INTO SALES VALUES(13,2,2020,3,NULL,38046.47)
+INSERT INTO SALES VALUES(13,1,2019,10,NULL,37952.78)
+INSERT INTO SALES VALUES(13,3,2020,10,NULL,38040.94)
+INSERT INTO SALES VALUES(13,4,2019,12,NULL,37995.42)
+INSERT INTO SALES VALUES(13,5,2020,12,NULL,38051.31)
+INSERT INTO SALES VALUES(13,1,2019,10,NULL,38064.23)
+INSERT INTO SALES VALUES(13,2,2019,4,NULL,37936.47)
+INSERT INTO SALES VALUES(13,2,2021,8,NULL,38091.38)
+INSERT INTO SALES VALUES(13,3,2020,7,NULL,37962.71)
+INSERT INTO SALES VALUES(13,2,2021,6,NULL,38097.84)
+INSERT INTO SALES VALUES(13,1,2021,7,NULL,38060.70)
+INSERT INTO SALES VALUES(13,5,2020,5,NULL,38064.67)
+INSERT INTO SALES VALUES(13,5,2019,12,NULL,37965.92)
+INSERT INTO SALES VALUES(13,5,2020,11,NULL,37903.66)
+INSERT INTO SALES VALUES(13,1,2021,10,NULL,38087.04)
+INSERT INTO SALES VALUES(13,5,2019,11,NULL,37997.01)
+INSERT INTO SALES VALUES(13,3,2020,7,NULL,37996.70)
+INSERT INTO SALES VALUES(13,5,2021,10,NULL,38025.48)
+INSERT INTO SALES VALUES(13,2,2019,8,NULL,38089.38)
+INSERT INTO SALES VALUES(13,4,2020,9,NULL,38054.54)
+INSERT INTO SALES VALUES(13,2,2019,6,NULL,38000.73)
+INSERT INTO SALES VALUES(13,1,2019,6,NULL,38098.06)
+INSERT INTO SALES VALUES(13,4,2020,10,NULL,38033.07)
+INSERT INTO SALES VALUES(13,5,2020,10,NULL,38029.13)
+INSERT INTO SALES VALUES(13,4,2020,2,NULL,38081.34)
+INSERT INTO SALES VALUES(13,3,2019,1,NULL,37957.46)
+INSERT INTO SALES VALUES(13,5,2021,6,NULL,38004.34)
+INSERT INTO SALES VALUES(13,2,2019,8,NULL,38042.92)
+INSERT INTO SALES VALUES(13,2,2021,8,NULL,38035.49)
+INSERT INTO SALES VALUES(13,4,2021,11,NULL,37964.78)
+INSERT INTO SALES VALUES(13,5,2019,4,NULL,38077.89)
+INSERT INTO SALES VALUES(13,4,2021,2,NULL,37916.14)
+INSERT INTO SALES VALUES(13,2,2019,10,NULL,37978.03)
+INSERT INTO SALES VALUES(13,4,2019,4,NULL,38043.10)
+INSERT INTO SALES VALUES(13,4,2020,6,NULL,37922.81)
+INSERT INTO SALES VALUES(14,4,2020,12,NULL,49307.62)
+INSERT INTO SALES VALUES(14,1,2021,4,NULL,49332.78)
+INSERT INTO SALES VALUES(14,1,2019,2,NULL,49286.68)
+INSERT INTO SALES VALUES(14,4,2019,9,NULL,49210.99)
+INSERT INTO SALES VALUES(14,5,2020,10,NULL,49339.14)
+INSERT INTO SALES VALUES(14,5,2020,9,NULL,49381.71)
+INSERT INTO SALES VALUES(14,4,2020,2,NULL,49369.84)
+INSERT INTO SALES VALUES(14,5,2021,5,NULL,49203.39)
+INSERT INTO SALES VALUES(14,4,2020,10,NULL,49264.55)
+INSERT INTO SALES VALUES(14,2,2020,9,NULL,49278.36)
+INSERT INTO SALES VALUES(14,3,2020,1,NULL,49228.21)
+INSERT INTO SALES VALUES(14,4,2021,12,NULL,49367.44)
+INSERT INTO SALES VALUES(14,4,2021,4,NULL,49207.46)
+INSERT INTO SALES VALUES(14,2,2021,8,NULL,49208.13)
+INSERT INTO SALES VALUES(14,3,2021,5,NULL,49348.29)
+INSERT INTO SALES VALUES(14,2,2020,3,NULL,49211.85)
+INSERT INTO SALES VALUES(14,4,2021,6,NULL,49289.49)
+INSERT INTO SALES VALUES(14,2,2020,6,NULL,49266.32)
+INSERT INTO SALES VALUES(14,4,2020,6,NULL,49342.74)
+INSERT INTO SALES VALUES(14,2,2019,2,NULL,49318.58)
+INSERT INTO SALES VALUES(14,1,2019,8,NULL,49260.12)
+INSERT INTO SALES VALUES(14,2,2021,5,NULL,49264.68)
+INSERT INTO SALES VALUES(14,2,2021,4,NULL,49339.84)
+INSERT INTO SALES VALUES(14,2,2019,2,NULL,49321.63)
+INSERT INTO SALES VALUES(14,2,2020,6,NULL,49270.93)
+INSERT INTO SALES VALUES(14,4,2019,9,NULL,49307.49)
+INSERT INTO SALES VALUES(14,3,2019,12,NULL,49367.66)
+INSERT INTO SALES VALUES(14,3,2021,5,NULL,49305.38)
+INSERT INTO SALES VALUES(14,3,2021,3,NULL,49294.54)
+INSERT INTO SALES VALUES(14,4,2020,1,NULL,49237.14)
+INSERT INTO SALES VALUES(14,1,2021,2,NULL,49232.63)
+INSERT INTO SALES VALUES(14,2,2019,11,NULL,49322.49)
+INSERT INTO SALES VALUES(14,4,2020,11,NULL,49287.94)
+INSERT INTO SALES VALUES(14,5,2021,1,NULL,49249.35)
+INSERT INTO SALES VALUES(14,4,2020,12,NULL,49192.70)
+INSERT INTO SALES VALUES(14,3,2020,9,NULL,49331.30)
+INSERT INTO SALES VALUES(14,2,2021,8,NULL,49200.39)
+INSERT INTO SALES VALUES(14,3,2020,5,NULL,49377.75)
+INSERT INTO SALES VALUES(14,1,2021,7,NULL,49325.04)
+INSERT INTO SALES VALUES(14,2,2020,3,NULL,49252.76)
+INSERT INTO SALES VALUES(14,1,2019,4,NULL,49325.94)
+INSERT INTO SALES VALUES(14,1,2021,1,NULL,49348.16)
+INSERT INTO SALES VALUES(14,5,2021,1,NULL,49288.22)
+INSERT INTO SALES VALUES(14,3,2021,7,NULL,49246.90)
+INSERT INTO SALES VALUES(14,4,2020,2,NULL,49300.34)
+INSERT INTO SALES VALUES(14,1,2020,2,NULL,49302.28)
+INSERT INTO SALES VALUES(14,3,2020,11,NULL,49379.00)
+INSERT INTO SALES VALUES(14,1,2020,3,NULL,49308.86)
+INSERT INTO SALES VALUES(14,2,2020,11,NULL,49242.58)
+INSERT INTO SALES VALUES(14,1,2020,12,NULL,49290.97)
+INSERT INTO SALES VALUES(14,1,2020,10,NULL,49383.55)
+INSERT INTO SALES VALUES(14,3,2020,6,NULL,49284.38)
+INSERT INTO SALES VALUES(14,3,2020,11,NULL,49340.93)
+INSERT INTO SALES VALUES(14,4,2021,2,NULL,49237.08)
+INSERT INTO SALES VALUES(14,4,2020,3,NULL,49323.32)
+INSERT INTO SALES VALUES(14,1,2020,8,NULL,49204.91)
+INSERT INTO SALES VALUES(14,5,2019,4,NULL,49383.51)
+INSERT INTO SALES VALUES(14,2,2020,10,NULL,49267.74)
+INSERT INTO SALES VALUES(14,3,2021,5,NULL,49195.31)
+INSERT INTO SALES VALUES(14,4,2021,4,NULL,49242.16)
+INSERT INTO SALES VALUES(14,1,2021,6,NULL,49333.39)
+INSERT INTO SALES VALUES(14,5,2021,9,NULL,49316.23)
+INSERT INTO SALES VALUES(14,1,2020,1,NULL,49207.00)
+INSERT INTO SALES VALUES(14,3,2020,7,NULL,49382.27)
+INSERT INTO SALES VALUES(14,1,2021,4,NULL,49248.23)
+INSERT INTO SALES VALUES(14,2,2019,4,NULL,49293.37)
+INSERT INTO SALES VALUES(14,1,2021,4,NULL,49205.72)
+INSERT INTO SALES VALUES(14,5,2020,4,NULL,49319.43)
+INSERT INTO SALES VALUES(14,2,2020,6,NULL,49244.45)
+INSERT INTO SALES VALUES(14,1,2021,2,NULL,49328.48)
+INSERT INTO SALES VALUES(14,2,2019,3,NULL,49202.57)
+INSERT INTO SALES VALUES(14,3,2021,1,NULL,49269.12)
+INSERT INTO SALES VALUES(14,4,2020,1,NULL,49205.90)
+INSERT INTO SALES VALUES(14,2,2021,8,NULL,49379.80)
+INSERT INTO SALES VALUES(14,5,2020,8,NULL,49290.93)
+INSERT INTO SALES VALUES(14,4,2019,5,NULL,49200.77)
+INSERT INTO SALES VALUES(14,5,2019,1,NULL,49337.14)
