You've already forked mariadb-columnstore-engine
mirror of
https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
synced 2025-07-29 08:21:15 +03:00
4c9d6e39ac
* Restructured test suites and added autopilot and extended suites * Updated autopilot with correct branch - develop * Moved setup test case to a 'setup' directory, for consistency * Fixed a path issue * Updated some tests cases to keep up with development Co-authored-by: root <root@rocky8.localdomain>
26 lines
728 B
Plaintext
26 lines
728 B
Plaintext
USE tpch1;
|
|
select
|
|
l_returnflag,
|
|
l_linestatus,
|
|
sum(l_quantity) as sum_qty,
|
|
sum(l_extendedprice) as sum_base_price,
|
|
avg(l_quantity) as avg_qty,
|
|
avg(l_extendedprice) as avg_price,
|
|
avg(l_discount) as avg_disc,
|
|
count(*) as count_order
|
|
from
|
|
lineitem
|
|
where
|
|
l_shipdate <= date '1998-09-26'
|
|
|
|
group by l_returnflag,
|
|
l_linestatus
|
|
order by
|
|
l_returnflag,
|
|
l_linestatus;
|
|
l_returnflag l_linestatus sum_qty sum_base_price avg_qty avg_price avg_disc count_order
|
|
A F 37734107.00 56586554400.73 25.522006 38273.129735 0.049985 1478493
|
|
N F 991417.00 1487504710.38 25.516472 38284.467761 0.050093 38854
|
|
N O 75466970.00 113184426461.43 25.501612 38247.000969 0.049997 2959302
|
|
R F 37719753.00 56568041380.90 25.505794 38250.854626 0.050009 1478870
|