github.com/matrixorigin/matrixone@v1.2.0/test/distributed/cases/benchmark/tpch/03_QUERIES/q1.result (about) 1 use tpch; 2 select 3 l_returnflag, 4 l_linestatus, 5 sum(l_quantity) as sum_qty, 6 sum(l_extendedprice) as sum_base_price, 7 sum(l_extendedprice * (1 - l_discount)) as sum_disc_price, 8 sum(l_extendedprice * (1 - l_discount) * (1 + l_tax)) as sum_charge, 9 avg(l_quantity) as avg_qty, 10 avg(l_extendedprice) as avg_price, 11 avg(l_discount) as avg_disc, 12 count(*) as count_order 13 from 14 lineitem 15 where 16 l_shipdate <= date '1998-12-01' - interval '112' day 17 group by 18 l_returnflag, 19 l_linestatus 20 order by 21 l_returnflag, 22 l_linestatus 23 ; 24 l_returnflag l_linestatus sum_qty sum_base_price sum_disc_price sum_charge avg_qty avg_price avg_disc count_order 25 A F 37474.00 37569624.64 35676192.0970 37101416.222424 25.35 25419.23 0.05 1478 26 N F 1041.00 1041301.07 999060.8980 1036450.802280 27.39 27402.66 0.04 38 27 N O 73962.00 74177309.20 70512214.0527 73308018.638225 25.52 25596.03 0.05 2898 28 R F 36511.00 36570841.24 34738472.8758 36169060.112193 25.06 25100.10 0.05 1457