[BugFix] Fix tablet scheduler exception (#52925) #256
GitHub Actions / SQL-Tester Report (Release ubuntu)
failed
Nov 25, 2024 in 0s
845 tests run, 844 passed, 0 skipped, 1 failed.
Annotations
Check failure on line 1 in TestSQLCases
github-actions / SQL-Tester Report (Release ubuntu)
TestSQLCases.test_basic_window_function
TimedOutException: exceed the process-timeout limit!
Raw output
[Stacktrace]:
Traceback (most recent call last):
File "/home/runner/_work/starrocks/starrocks/test/lib/sql_annotation.py", line 43, in wrapper
res = func(*args, **kwargs)
File "/home/runner/_work/starrocks/starrocks/test/test_sql_cases.py", line 370, in test_sql_basic
actual_res, actual_res_log, var, order = self.execute_single_statement(sql, sql_id, record_mode)
File "/home/runner/_work/starrocks/starrocks/test/lib/sr_sql_lib.py", line 1273, in execute_single_statement
actual_res = self.execute_sql(statement, conn=conn)
File "/home/runner/_work/starrocks/starrocks/test/lib/sr_sql_lib.py", line 742, in execute_sql
cursor.execute(sql)
File "/root/.pyenv/versions/3.8.19/lib/python3.8/site-packages/pymysql/cursors.py", line 153, in execute
result = self._query(query)
File "/root/.pyenv/versions/3.8.19/lib/python3.8/site-packages/pymysql/cursors.py", line 322, in _query
conn.query(q)
File "/root/.pyenv/versions/3.8.19/lib/python3.8/site-packages/pymysql/connections.py", line 563, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/root/.pyenv/versions/3.8.19/lib/python3.8/site-packages/pymysql/connections.py", line 825, in _read_query_result
result.read()
File "/root/.pyenv/versions/3.8.19/lib/python3.8/site-packages/pymysql/connections.py", line 1199, in read
first_packet = self.connection._read_packet()
File "/root/.pyenv/versions/3.8.19/lib/python3.8/site-packages/pymysql/connections.py", line 744, in _read_packet
packet_header = self._read_bytes(4)
File "/root/.pyenv/versions/3.8.19/lib/python3.8/site-packages/pymysql/connections.py", line 782, in _read_bytes
data = self._rfile.read(num_bytes)
File "/root/.pyenv/versions/3.8.19/lib/python3.8/socket.py", line 669, in readinto
return self._sock.recv_into(b)
File "/root/.pyenv/versions/3.8.19/lib/python3.8/site-packages/nose/plugins/multiprocess.py", line 204, in signalhandler
raise TimedOutException()
nose.plugins.multiprocess.TimedOutException: 'Timed Out'
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/root/.pyenv/versions/3.8.19/lib/python3.8/unittest/case.py", line 60, in testPartExecutor
yield
File "/root/.pyenv/versions/3.8.19/lib/python3.8/unittest/case.py", line 676, in run
self._callTestMethod(testMethod)
File "/root/.pyenv/versions/3.8.19/lib/python3.8/unittest/case.py", line 633, in _callTestMethod
method()
File "/root/.pyenv/versions/3.8.19/lib/python3.8/site-packages/nose/case.py", line 170, in runTest
self.test(*self.arg)
File "/root/.pyenv/versions/3.8.19/lib/python3.8/site-packages/parameterized/parameterized.py", line 620, in standalone_func
return func(*(a + p.args), **p.kwargs, **kw)
File "/home/runner/_work/starrocks/starrocks/test/lib/sql_annotation.py", line 46, in wrapper
raise AssertionError("TimedOutException: exceed the process-timeout limit!")
AssertionError: TimedOutException: exceed the process-timeout limit!
[Standard Output]:
?[1;32m------------------------------------------------------------ ?[0m
?[1;32m[case name]: test_basic_window_function ?[0m
?[1;32m[case file]: sql/test_window_function/R/test_basic_window_function ?[0m
?[1;32m------------------------------------------------------------ ?[0m
[SQL]: CREATE DATABASE test_db_a3036606e58a4ab1a37085fecdd4ba25;
[SQL]: USE test_db_a3036606e58a4ab1a37085fecdd4ba25;
→ case db: ['test_db_a3036606e58a4ab1a37085fecdd4ba25']
→ case resource: []
CREATE TABLE `t0` (
`v1` int(11) NULL,
`v2` int(11) NULL,
`v3` int(11) NOT NULL,
`v4` int(11) NULL
) ENGINE=OLAP
DUPLICATE KEY(`v1`)
DISTRIBUTED BY HASH(`v1`) BUCKETS 10
PROPERTIES (
"replication_num" = "1"
);
INSERT INTO `t0` (v1, v2, v3, v4) values
(1, 1, 1, NULL),
(1, 1, 2, NULL),
(1, NULL, 3, NULL),
(1, NULL, 4, NULL),
(1, 2, 5, NULL),
(1, 2, 6, NULL),
(1, NULL, 7, NULL),
(1, NULL, 8, NULL),
(2, 3, 9, NULL),
(2, 3, 10, NULL),
(2, NULL, 11, NULL),
(2, NULL, 12, NULL),
(2, 4, 13, NULL),
(2, 4, 14, NULL),
(2, NULL, 15, NULL),
(2, NULL, 16, NULL),
(NULL, 3, 17, NULL),
(NULL, 3, 18, NULL),
(NULL, NULL, 19, NULL),
(NULL, NULL, 20, NULL),
(NULL, 4, 21, NULL),
(NULL, 4, 22, NULL),
(NULL, NULL, 23, NULL),
(NULL, NULL, 24, NULL);
INSERT INTO `t0` SELECT * FROM `t0`;
INSERT INTO `t0` SELECT * FROM `t0`;
INSERT INTO `t0` SELECT * FROM `t0`;
INSERT INTO `t0` SELECT * FROM `t0`;
INSERT INTO `t0` SELECT * FROM `t0`;
INSERT INTO `t0` SELECT * FROM `t0`;
INSERT INTO `t0` SELECT * FROM `t0`;
INSERT INTO `t0` SELECT * FROM `t0`;
INSERT INTO `t0` SELECT * FROM `t0`;
INSERT INTO `t0` SELECT * FROM `t0`;
INSERT INTO `t0` SELECT * FROM `t0`;
INSERT INTO `t0` SELECT * FROM `t0`;
INSERT INTO `t0` (v1, v2, v3, v4) values
(1, 1111, 1111, NULL),
(1, 1111, 2222, NULL),
(1, NULL, 3333, NULL),
(1, NULL, 4444, NULL),
(1, 2222, 5555, NULL),
(1, 2222, 6666, NULL),
(1, NULL, 7777, NULL),
(1, NULL, 8888, NULL),
(101, 101, 101, NULL),
(101, 101, 102, NULL),
(101, NULL, 103, NULL),
(101, NULL, 104, NULL),
(101, 102, 105, NULL),
(101, 102, 106, NULL),
(101, NULL, 107, NULL),
(101, NULL, 108, NULL),
(102, 103, 109, NULL),
(102, 103, 110, NULL),
(102, NULL, 111, NULL),
(102, NULL, 112, NULL),
(102, 104, 113, NULL),
(102, 104, 114, NULL),
(102, NULL, 115, NULL),
(102, NULL, 116, NULL),
(NULL, 103, 117, NULL),
(NULL, 103, 118, NULL),
(NULL, NULL, 119, NULL),
(NULL, NULL, 120, NULL),
(NULL, 104, 121, NULL),
(NULL, 104, 122, NULL),
(NULL, NULL, 123, NULL),
(NULL, NULL, 124, NULL);
CREATE TABLE `t1` (
`v1` decimal64(18,5) NULL,
`v2` decimal64(18,5) NULL,
`v3` decimal64(18,5) NOT NULL,
`v4` decimal64(18,5) NULL,
`v5` decimal64(18,5) NOT NULL,
`v6` decimal64(18,5) NOT NULL,
`v7` decimal64(18,5) NOT NULL,
`v8` decimal64(18,5) NOT NULL,
`v9` decimal64(18,5) NOT NULL
) ENGINE=OLAP
DUPLICATE KEY(`v1`)
DISTRIBUTED BY HASH(`v1`) BUCKETS 10
PROPERTIES (
"replication_num" = "1"
);
INSERT INTO `t1` (v1, v2, v3, v4, v5, v6, v7, v8, v9)
SELECT v1, v2, v3, v4, v5, v6,
mod(v5, 128) as v7,
mod(v6, 32) as v8,
1 as v9
FROM (
SELECT v1, v2, v3, v4,
row_number() OVER (ORDER BY v1, v2, v3, v4) as v5,
row_number() OVER (PARTITION BY v1 ORDER BY v2, v3, v4) as v6
FROM `t0`
) tmp;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v2) OVER(ORDER BY v5 ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v2) OVER(ORDER BY v5 ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v2) OVER(ORDER BY v5 ROWS BETWEEN UNBOUNDED PRECEDING AND 10 PRECEDING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v2) OVER(ORDER BY v5 ROWS BETWEEN UNBOUNDED PRECEDING AND 10 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v2) OVER(ORDER BY v5 ROWS BETWEEN 10 PRECEDING AND 5 PRECEDING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v2) OVER(ORDER BY v5 ROWS BETWEEN 5 PRECEDING AND 5 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v2) OVER(ORDER BY v5 ROWS BETWEEN 5 FOLLOWING AND 10 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v2) OVER(ORDER BY v5 ROWS BETWEEN 5 PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v2) OVER(ORDER BY v5 ROWS BETWEEN CURRENT ROW AND 5 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v2) OVER(ORDER BY v5 ROWS BETWEEN 15000 PRECEDING AND 5000 PRECEDING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v2) OVER(ORDER BY v5 ROWS BETWEEN 5000 PRECEDING AND 5000 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v2) OVER(ORDER BY v5 ROWS BETWEEN 5000 FOLLOWING AND 15000 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v2) OVER(ORDER BY v5 ROWS BETWEEN 10000 PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v2) OVER(ORDER BY v5 ROWS BETWEEN CURRENT ROW AND 10000 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v2) OVER(ORDER BY v4 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v2) OVER(ORDER BY v5 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v2) OVER(ORDER BY v6 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v2) OVER(ORDER BY v7 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v2) OVER(ORDER BY v8 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v2) OVER(ORDER BY v9 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v2) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v2) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v2) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN UNBOUNDED PRECEDING AND 10 PRECEDING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v2) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN UNBOUNDED PRECEDING AND 10 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v2) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN 10 PRECEDING AND 5 PRECEDING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v2) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN 5 PRECEDING AND 5 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v2) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN 5 FOLLOWING AND 10 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v2) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN 5 PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v2) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN CURRENT ROW AND 5 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v2) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN 15000 PRECEDING AND 5000 PRECEDING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v2) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN 5000 PRECEDING AND 5000 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v2) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN 5000 FOLLOWING AND 15000 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v2) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN 10000 PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v2) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN CURRENT ROW AND 10000 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v2) OVER(PARTITION BY v1 ORDER BY v4 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v2) OVER(PARTITION BY v1 ORDER BY v5 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v2) OVER(PARTITION BY v1 ORDER BY v6 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v2) OVER(PARTITION BY v1 ORDER BY v7 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v2) OVER(PARTITION BY v1 ORDER BY v8 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v2) OVER(PARTITION BY v1 ORDER BY v9 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v3) OVER(ORDER BY v5 ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v3) OVER(ORDER BY v5 ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v3) OVER(ORDER BY v5 ROWS BETWEEN UNBOUNDED PRECEDING AND 10 PRECEDING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v3) OVER(ORDER BY v5 ROWS BETWEEN UNBOUNDED PRECEDING AND 10 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v3) OVER(ORDER BY v5 ROWS BETWEEN 10 PRECEDING AND 5 PRECEDING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v3) OVER(ORDER BY v5 ROWS BETWEEN 5 PRECEDING AND 5 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v3) OVER(ORDER BY v5 ROWS BETWEEN 5 FOLLOWING AND 10 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v3) OVER(ORDER BY v5 ROWS BETWEEN 5 PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v3) OVER(ORDER BY v5 ROWS BETWEEN CURRENT ROW AND 5 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v3) OVER(ORDER BY v5 ROWS BETWEEN 15000 PRECEDING AND 5000 PRECEDING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v3) OVER(ORDER BY v5 ROWS BETWEEN 5000 PRECEDING AND 5000 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v3) OVER(ORDER BY v5 ROWS BETWEEN 5000 FOLLOWING AND 15000 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v3) OVER(ORDER BY v5 ROWS BETWEEN 10000 PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v3) OVER(ORDER BY v5 ROWS BETWEEN CURRENT ROW AND 10000 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v3) OVER(ORDER BY v4 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v3) OVER(ORDER BY v5 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v3) OVER(ORDER BY v6 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v3) OVER(ORDER BY v7 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v3) OVER(ORDER BY v8 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v3) OVER(ORDER BY v9 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v3) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v3) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v3) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN UNBOUNDED PRECEDING AND 10 PRECEDING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v3) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN UNBOUNDED PRECEDING AND 10 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v3) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN 10 PRECEDING AND 5 PRECEDING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v3) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN 5 PRECEDING AND 5 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v3) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN 5 FOLLOWING AND 10 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v3) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN 5 PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v3) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN CURRENT ROW AND 5 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v3) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN 15000 PRECEDING AND 5000 PRECEDING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v3) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN 5000 PRECEDING AND 5000 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v3) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN 5000 FOLLOWING AND 15000 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v3) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN 10000 PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v3) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN CURRENT ROW AND 10000 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v3) OVER(PARTITION BY v1 ORDER BY v4 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v3) OVER(PARTITION BY v1 ORDER BY v5 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v3) OVER(PARTITION BY v1 ORDER BY v6 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v3) OVER(PARTITION BY v1 ORDER BY v7 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v3) OVER(PARTITION BY v1 ORDER BY v8 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v3) OVER(PARTITION BY v1 ORDER BY v9 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v4) OVER(ORDER BY v5 ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v4) OVER(ORDER BY v5 ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v4) OVER(ORDER BY v5 ROWS BETWEEN UNBOUNDED PRECEDING AND 10 PRECEDING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v4) OVER(ORDER BY v5 ROWS BETWEEN UNBOUNDED PRECEDING AND 10 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v4) OVER(ORDER BY v5 ROWS BETWEEN 10 PRECEDING AND 5 PRECEDING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v4) OVER(ORDER BY v5 ROWS BETWEEN 5 PRECEDING AND 5 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v4) OVER(ORDER BY v5 ROWS BETWEEN 5 FOLLOWING AND 10 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v4) OVER(ORDER BY v5 ROWS BETWEEN 5 PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v4) OVER(ORDER BY v5 ROWS BETWEEN CURRENT ROW AND 5 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v4) OVER(ORDER BY v5 ROWS BETWEEN 15000 PRECEDING AND 5000 PRECEDING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v4) OVER(ORDER BY v5 ROWS BETWEEN 5000 PRECEDING AND 5000 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v4) OVER(ORDER BY v5 ROWS BETWEEN 5000 FOLLOWING AND 15000 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v4) OVER(ORDER BY v5 ROWS BETWEEN 10000 PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v4) OVER(ORDER BY v5 ROWS BETWEEN CURRENT ROW AND 10000 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v4) OVER(ORDER BY v4 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v4) OVER(ORDER BY v5 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v4) OVER(ORDER BY v6 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v4) OVER(ORDER BY v7 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v4) OVER(ORDER BY v8 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v4) OVER(ORDER BY v9 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v4) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v4) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v4) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN UNBOUNDED PRECEDING AND 10 PRECEDING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v4) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN UNBOUNDED PRECEDING AND 10 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v4) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN 10 PRECEDING AND 5 PRECEDING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v4) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN 5 PRECEDING AND 5 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v4) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN 5 FOLLOWING AND 10 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v4) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN 5 PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v4) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN CURRENT ROW AND 5 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v4) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN 15000 PRECEDING AND 5000 PRECEDING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v4) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN 5000 PRECEDING AND 5000 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v4) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN 5000 FOLLOWING AND 15000 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v4) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN 10000 PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v4) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN CURRENT ROW AND 10000 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v4) OVER(PARTITION BY v1 ORDER BY v4 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v4) OVER(PARTITION BY v1 ORDER BY v5 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v4) OVER(PARTITION BY v1 ORDER BY v6 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v4) OVER(PARTITION BY v1 ORDER BY v7 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v4) OVER(PARTITION BY v1 ORDER BY v8 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT COUNT(v4) OVER(PARTITION BY v1 ORDER BY v9 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v2) OVER(ORDER BY v5 ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v2) OVER(ORDER BY v5 ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v2) OVER(ORDER BY v5 ROWS BETWEEN UNBOUNDED PRECEDING AND 10 PRECEDING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v2) OVER(ORDER BY v5 ROWS BETWEEN UNBOUNDED PRECEDING AND 10 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v2) OVER(ORDER BY v5 ROWS BETWEEN 10 PRECEDING AND 5 PRECEDING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v2) OVER(ORDER BY v5 ROWS BETWEEN 5 PRECEDING AND 5 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v2) OVER(ORDER BY v5 ROWS BETWEEN 5 FOLLOWING AND 10 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v2) OVER(ORDER BY v5 ROWS BETWEEN 5 PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v2) OVER(ORDER BY v5 ROWS BETWEEN CURRENT ROW AND 5 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v2) OVER(ORDER BY v5 ROWS BETWEEN 15000 PRECEDING AND 5000 PRECEDING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v2) OVER(ORDER BY v5 ROWS BETWEEN 5000 PRECEDING AND 5000 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v2) OVER(ORDER BY v5 ROWS BETWEEN 5000 FOLLOWING AND 15000 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v2) OVER(ORDER BY v5 ROWS BETWEEN 10000 PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v2) OVER(ORDER BY v5 ROWS BETWEEN CURRENT ROW AND 10000 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v2) OVER(ORDER BY v4 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v2) OVER(ORDER BY v5 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v2) OVER(ORDER BY v6 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v2) OVER(ORDER BY v7 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v2) OVER(ORDER BY v8 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v2) OVER(ORDER BY v9 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v2) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v2) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v2) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN UNBOUNDED PRECEDING AND 10 PRECEDING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v2) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN UNBOUNDED PRECEDING AND 10 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v2) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN 10 PRECEDING AND 5 PRECEDING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v2) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN 5 PRECEDING AND 5 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v2) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN 5 FOLLOWING AND 10 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v2) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN 5 PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v2) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN CURRENT ROW AND 5 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v2) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN 15000 PRECEDING AND 5000 PRECEDING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v2) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN 5000 PRECEDING AND 5000 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v2) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN 5000 FOLLOWING AND 15000 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v2) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN 10000 PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v2) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN CURRENT ROW AND 10000 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v2) OVER(PARTITION BY v1 ORDER BY v4 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v2) OVER(PARTITION BY v1 ORDER BY v5 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v2) OVER(PARTITION BY v1 ORDER BY v6 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v2) OVER(PARTITION BY v1 ORDER BY v7 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v2) OVER(PARTITION BY v1 ORDER BY v8 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v2) OVER(PARTITION BY v1 ORDER BY v9 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v3) OVER(ORDER BY v5 ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v3) OVER(ORDER BY v5 ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v3) OVER(ORDER BY v5 ROWS BETWEEN UNBOUNDED PRECEDING AND 10 PRECEDING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v3) OVER(ORDER BY v5 ROWS BETWEEN UNBOUNDED PRECEDING AND 10 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v3) OVER(ORDER BY v5 ROWS BETWEEN 10 PRECEDING AND 5 PRECEDING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v3) OVER(ORDER BY v5 ROWS BETWEEN 5 PRECEDING AND 5 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v3) OVER(ORDER BY v5 ROWS BETWEEN 5 FOLLOWING AND 10 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v3) OVER(ORDER BY v5 ROWS BETWEEN 5 PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v3) OVER(ORDER BY v5 ROWS BETWEEN CURRENT ROW AND 5 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v3) OVER(ORDER BY v5 ROWS BETWEEN 15000 PRECEDING AND 5000 PRECEDING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v3) OVER(ORDER BY v5 ROWS BETWEEN 5000 PRECEDING AND 5000 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v3) OVER(ORDER BY v5 ROWS BETWEEN 5000 FOLLOWING AND 15000 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v3) OVER(ORDER BY v5 ROWS BETWEEN 10000 PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v3) OVER(ORDER BY v5 ROWS BETWEEN CURRENT ROW AND 10000 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v3) OVER(ORDER BY v4 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v3) OVER(ORDER BY v5 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v3) OVER(ORDER BY v6 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v3) OVER(ORDER BY v7 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v3) OVER(ORDER BY v8 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v3) OVER(ORDER BY v9 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v3) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v3) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v3) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN UNBOUNDED PRECEDING AND 10 PRECEDING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v3) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN UNBOUNDED PRECEDING AND 10 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v3) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN 10 PRECEDING AND 5 PRECEDING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v3) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN 5 PRECEDING AND 5 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v3) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN 5 FOLLOWING AND 10 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v3) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN 5 PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v3) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN CURRENT ROW AND 5 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v3) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN 15000 PRECEDING AND 5000 PRECEDING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v3) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN 5000 PRECEDING AND 5000 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v3) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN 5000 FOLLOWING AND 15000 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v3) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN 10000 PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v3) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN CURRENT ROW AND 10000 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v3) OVER(PARTITION BY v1 ORDER BY v4 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v3) OVER(PARTITION BY v1 ORDER BY v5 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v3) OVER(PARTITION BY v1 ORDER BY v6 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v3) OVER(PARTITION BY v1 ORDER BY v7 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v3) OVER(PARTITION BY v1 ORDER BY v8 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v3) OVER(PARTITION BY v1 ORDER BY v9 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v4) OVER(ORDER BY v5 ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v4) OVER(ORDER BY v5 ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v4) OVER(ORDER BY v5 ROWS BETWEEN UNBOUNDED PRECEDING AND 10 PRECEDING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v4) OVER(ORDER BY v5 ROWS BETWEEN UNBOUNDED PRECEDING AND 10 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v4) OVER(ORDER BY v5 ROWS BETWEEN 10 PRECEDING AND 5 PRECEDING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v4) OVER(ORDER BY v5 ROWS BETWEEN 5 PRECEDING AND 5 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v4) OVER(ORDER BY v5 ROWS BETWEEN 5 FOLLOWING AND 10 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v4) OVER(ORDER BY v5 ROWS BETWEEN 5 PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v4) OVER(ORDER BY v5 ROWS BETWEEN CURRENT ROW AND 5 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v4) OVER(ORDER BY v5 ROWS BETWEEN 15000 PRECEDING AND 5000 PRECEDING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v4) OVER(ORDER BY v5 ROWS BETWEEN 5000 PRECEDING AND 5000 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v4) OVER(ORDER BY v5 ROWS BETWEEN 5000 FOLLOWING AND 15000 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v4) OVER(ORDER BY v5 ROWS BETWEEN 10000 PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v4) OVER(ORDER BY v5 ROWS BETWEEN CURRENT ROW AND 10000 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v4) OVER(ORDER BY v4 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v4) OVER(ORDER BY v5 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v4) OVER(ORDER BY v6 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v4) OVER(ORDER BY v7 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v4) OVER(ORDER BY v8 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v4) OVER(ORDER BY v9 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v4) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v4) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v4) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN UNBOUNDED PRECEDING AND 10 PRECEDING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v4) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN UNBOUNDED PRECEDING AND 10 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v4) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN 10 PRECEDING AND 5 PRECEDING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v4) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN 5 PRECEDING AND 5 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v4) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN 5 FOLLOWING AND 10 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v4) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN 5 PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v4) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN CURRENT ROW AND 5 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v4) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN 15000 PRECEDING AND 5000 PRECEDING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v4) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN 5000 PRECEDING AND 5000 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v4) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN 5000 FOLLOWING AND 15000 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v4) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN 10000 PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v4) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN CURRENT ROW AND 10000 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v4) OVER(PARTITION BY v1 ORDER BY v4 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v4) OVER(PARTITION BY v1 ORDER BY v5 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v4) OVER(PARTITION BY v1 ORDER BY v6 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v4) OVER(PARTITION BY v1 ORDER BY v7 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v4) OVER(PARTITION BY v1 ORDER BY v8 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT SUM(v4) OVER(PARTITION BY v1 ORDER BY v9 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v2) OVER(ORDER BY v5 ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v2) OVER(ORDER BY v5 ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v2) OVER(ORDER BY v5 ROWS BETWEEN UNBOUNDED PRECEDING AND 10 PRECEDING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v2) OVER(ORDER BY v5 ROWS BETWEEN UNBOUNDED PRECEDING AND 10 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v2) OVER(ORDER BY v5 ROWS BETWEEN 10 PRECEDING AND 5 PRECEDING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v2) OVER(ORDER BY v5 ROWS BETWEEN 5 PRECEDING AND 5 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v2) OVER(ORDER BY v5 ROWS BETWEEN 5 FOLLOWING AND 10 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v2) OVER(ORDER BY v5 ROWS BETWEEN 5 PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v2) OVER(ORDER BY v5 ROWS BETWEEN CURRENT ROW AND 5 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v2) OVER(ORDER BY v5 ROWS BETWEEN 15000 PRECEDING AND 5000 PRECEDING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v2) OVER(ORDER BY v5 ROWS BETWEEN 5000 PRECEDING AND 5000 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v2) OVER(ORDER BY v5 ROWS BETWEEN 5000 FOLLOWING AND 15000 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v2) OVER(ORDER BY v5 ROWS BETWEEN 10000 PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v2) OVER(ORDER BY v5 ROWS BETWEEN CURRENT ROW AND 10000 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v2) OVER(ORDER BY v4 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v2) OVER(ORDER BY v5 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v2) OVER(ORDER BY v6 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v2) OVER(ORDER BY v7 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v2) OVER(ORDER BY v8 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v2) OVER(ORDER BY v9 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v2) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v2) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v2) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN UNBOUNDED PRECEDING AND 10 PRECEDING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v2) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN UNBOUNDED PRECEDING AND 10 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v2) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN 10 PRECEDING AND 5 PRECEDING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v2) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN 5 PRECEDING AND 5 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v2) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN 5 FOLLOWING AND 10 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v2) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN 5 PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v2) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN CURRENT ROW AND 5 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v2) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN 15000 PRECEDING AND 5000 PRECEDING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v2) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN 5000 PRECEDING AND 5000 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v2) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN 5000 FOLLOWING AND 15000 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v2) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN 10000 PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v2) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN CURRENT ROW AND 10000 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v2) OVER(PARTITION BY v1 ORDER BY v4 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v2) OVER(PARTITION BY v1 ORDER BY v5 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v2) OVER(PARTITION BY v1 ORDER BY v6 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v2) OVER(PARTITION BY v1 ORDER BY v7 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v2) OVER(PARTITION BY v1 ORDER BY v8 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v2) OVER(PARTITION BY v1 ORDER BY v9 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v3) OVER(ORDER BY v5 ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v3) OVER(ORDER BY v5 ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v3) OVER(ORDER BY v5 ROWS BETWEEN UNBOUNDED PRECEDING AND 10 PRECEDING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v3) OVER(ORDER BY v5 ROWS BETWEEN UNBOUNDED PRECEDING AND 10 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v3) OVER(ORDER BY v5 ROWS BETWEEN 10 PRECEDING AND 5 PRECEDING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v3) OVER(ORDER BY v5 ROWS BETWEEN 5 PRECEDING AND 5 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v3) OVER(ORDER BY v5 ROWS BETWEEN 5 FOLLOWING AND 10 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v3) OVER(ORDER BY v5 ROWS BETWEEN 5 PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v3) OVER(ORDER BY v5 ROWS BETWEEN CURRENT ROW AND 5 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v3) OVER(ORDER BY v5 ROWS BETWEEN 15000 PRECEDING AND 5000 PRECEDING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v3) OVER(ORDER BY v5 ROWS BETWEEN 5000 PRECEDING AND 5000 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v3) OVER(ORDER BY v5 ROWS BETWEEN 5000 FOLLOWING AND 15000 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v3) OVER(ORDER BY v5 ROWS BETWEEN 10000 PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v3) OVER(ORDER BY v5 ROWS BETWEEN CURRENT ROW AND 10000 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v3) OVER(ORDER BY v4 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v3) OVER(ORDER BY v5 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v3) OVER(ORDER BY v6 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v3) OVER(ORDER BY v7 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v3) OVER(ORDER BY v8 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v3) OVER(ORDER BY v9 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v3) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v3) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v3) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN UNBOUNDED PRECEDING AND 10 PRECEDING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v3) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN UNBOUNDED PRECEDING AND 10 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v3) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN 10 PRECEDING AND 5 PRECEDING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v3) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN 5 PRECEDING AND 5 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v3) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN 5 FOLLOWING AND 10 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v3) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN 5 PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v3) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN CURRENT ROW AND 5 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v3) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN 15000 PRECEDING AND 5000 PRECEDING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v3) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN 5000 PRECEDING AND 5000 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v3) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN 5000 FOLLOWING AND 15000 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v3) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN 10000 PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v3) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN CURRENT ROW AND 10000 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v3) OVER(PARTITION BY v1 ORDER BY v4 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v3) OVER(PARTITION BY v1 ORDER BY v5 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v3) OVER(PARTITION BY v1 ORDER BY v6 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v3) OVER(PARTITION BY v1 ORDER BY v7 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v3) OVER(PARTITION BY v1 ORDER BY v8 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v3) OVER(PARTITION BY v1 ORDER BY v9 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v4) OVER(ORDER BY v5 ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v4) OVER(ORDER BY v5 ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v4) OVER(ORDER BY v5 ROWS BETWEEN UNBOUNDED PRECEDING AND 10 PRECEDING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v4) OVER(ORDER BY v5 ROWS BETWEEN UNBOUNDED PRECEDING AND 10 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v4) OVER(ORDER BY v5 ROWS BETWEEN 10 PRECEDING AND 5 PRECEDING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v4) OVER(ORDER BY v5 ROWS BETWEEN 5 PRECEDING AND 5 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v4) OVER(ORDER BY v5 ROWS BETWEEN 5 FOLLOWING AND 10 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v4) OVER(ORDER BY v5 ROWS BETWEEN 5 PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v4) OVER(ORDER BY v5 ROWS BETWEEN CURRENT ROW AND 5 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v4) OVER(ORDER BY v5 ROWS BETWEEN 15000 PRECEDING AND 5000 PRECEDING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v4) OVER(ORDER BY v5 ROWS BETWEEN 5000 PRECEDING AND 5000 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v4) OVER(ORDER BY v5 ROWS BETWEEN 5000 FOLLOWING AND 15000 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v4) OVER(ORDER BY v5 ROWS BETWEEN 10000 PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v4) OVER(ORDER BY v5 ROWS BETWEEN CURRENT ROW AND 10000 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v4) OVER(ORDER BY v4 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v4) OVER(ORDER BY v5 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v4) OVER(ORDER BY v6 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v4) OVER(ORDER BY v7 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v4) OVER(ORDER BY v8 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v4) OVER(ORDER BY v9 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v4) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v4) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v4) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN UNBOUNDED PRECEDING AND 10 PRECEDING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v4) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN UNBOUNDED PRECEDING AND 10 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v4) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN 10 PRECEDING AND 5 PRECEDING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v4) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN 5 PRECEDING AND 5 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v4) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN 5 FOLLOWING AND 10 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v4) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN 5 PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v4) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN CURRENT ROW AND 5 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v4) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN 15000 PRECEDING AND 5000 PRECEDING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v4) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN 5000 PRECEDING AND 5000 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v4) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN 5000 FOLLOWING AND 15000 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v4) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN 10000 PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v4) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN CURRENT ROW AND 10000 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v4) OVER(PARTITION BY v1 ORDER BY v4 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v4) OVER(PARTITION BY v1 ORDER BY v5 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v4) OVER(PARTITION BY v1 ORDER BY v6 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v4) OVER(PARTITION BY v1 ORDER BY v7 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v4) OVER(PARTITION BY v1 ORDER BY v8 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT AVG(v4) OVER(PARTITION BY v1 ORDER BY v9 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT MIN(v2) OVER(ORDER BY v5 ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT MIN(v2) OVER(ORDER BY v5 ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT MIN(v2) OVER(ORDER BY v5 ROWS BETWEEN UNBOUNDED PRECEDING AND 10 PRECEDING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT MIN(v2) OVER(ORDER BY v5 ROWS BETWEEN UNBOUNDED PRECEDING AND 10 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT MIN(v2) OVER(ORDER BY v5 ROWS BETWEEN 10 PRECEDING AND 5 PRECEDING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT MIN(v2) OVER(ORDER BY v5 ROWS BETWEEN 5 PRECEDING AND 5 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT MIN(v2) OVER(ORDER BY v5 ROWS BETWEEN 5 FOLLOWING AND 10 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT MIN(v2) OVER(ORDER BY v5 ROWS BETWEEN 5 PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT MIN(v2) OVER(ORDER BY v5 ROWS BETWEEN CURRENT ROW AND 5 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT MIN(v2) OVER(ORDER BY v4 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT MIN(v2) OVER(ORDER BY v5 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT MIN(v2) OVER(ORDER BY v6 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT MIN(v2) OVER(ORDER BY v7 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT MIN(v2) OVER(ORDER BY v8 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT MIN(v2) OVER(ORDER BY v9 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT MIN(v2) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT MIN(v2) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT MIN(v2) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN UNBOUNDED PRECEDING AND 10 PRECEDING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT MIN(v2) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN UNBOUNDED PRECEDING AND 10 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT MIN(v2) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN 10 PRECEDING AND 5 PRECEDING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT MIN(v2) OVER(PARTITION BY v1 ORDER BY v5 ROWS BETWEEN 5 PRECEDING AND 5 FOLLOWING) AS wv FROM t1) a;
SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT M
Loading