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