You've already forked mariadb-columnstore-engine
mirror of
https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
synced 2025-10-31 18:30:33 +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>
36 lines
992 B
Plaintext
36 lines
992 B
Plaintext
USE tpch1;
|
|
select p_brand, sum(l_quantity) tot_qty,
|
|
avg(l_quantity) avg_qty, count(*)
|
|
from part, lineitem
|
|
where l_shipdate between '1996-04-01' and '1996-04-14'
|
|
and p_size = 5
|
|
and p_partkey = l_partkey
|
|
group by p_brand
|
|
order by 1;
|
|
p_brand tot_qty avg_qty count(*)
|
|
Brand#11 732.00 25.241379 29
|
|
Brand#12 986.00 28.171429 35
|
|
Brand#13 814.00 25.437500 32
|
|
Brand#14 704.00 26.074074 27
|
|
Brand#15 580.00 23.200000 25
|
|
Brand#21 664.00 25.538462 26
|
|
Brand#22 518.00 22.521739 23
|
|
Brand#23 964.00 28.352941 34
|
|
Brand#24 460.00 20.000000 23
|
|
Brand#25 632.00 25.280000 25
|
|
Brand#31 674.00 28.083333 24
|
|
Brand#32 653.00 25.115385 26
|
|
Brand#33 710.00 25.357143 28
|
|
Brand#34 414.00 23.000000 18
|
|
Brand#35 516.00 19.846154 26
|
|
Brand#41 797.00 29.518519 27
|
|
Brand#42 1003.00 30.393939 33
|
|
Brand#43 823.00 23.514286 35
|
|
Brand#44 1026.00 27.729730 37
|
|
Brand#45 435.00 21.750000 20
|
|
Brand#51 739.00 25.482759 29
|
|
Brand#52 880.00 28.387097 31
|
|
Brand#53 837.00 24.617647 34
|
|
Brand#54 1126.00 30.432432 37
|
|
Brand#55 525.00 21.000000 25
|