1
0
mirror of https://github.com/mariadb-corporation/mariadb-columnstore-engine.git synced 2025-08-07 03:22:57 +03:00
Files

5 lines
243 B
Plaintext

USE tpch1;
Select o_shippriority, sum(o_totalprice), avg(o_totalprice), count(*) from orders where o_orderkey < 1000000 group by o_shippriority;
o_shippriority sum(o_totalprice) avg(o_totalprice) count(*)
0 37837807526.82 151351.835515 249999