github.com/matrixorigin/matrixone@v1.2.0/test/distributed/cases/benchmark/tpch/03_QUERIES/q19.result (about) 1 use tpch; 2 select 3 sum(l_extendedprice* (1 - l_discount)) as revenue 4 from 5 lineitem, 6 part 7 where 8 ( 9 p_partkey = l_partkey 10 and p_brand = 'Brand#23' 11 and p_container in ('SM CASE', 'SM BOX', 'SM PACK', 'SM PKG') 12 and l_quantity >= 5 and l_quantity <= 5 + 10 13 and p_size between 1 and 5 14 and l_shipmode in ('AIR', 'AIR REG') 15 and l_shipinstruct = 'DELIVER IN PERSON' 16 ) 17 or 18 ( 19 p_partkey = l_partkey 20 and p_brand = 'Brand#15' 21 and p_container in ('MED BAG', 'MED BOX', 'MED PKG', 'MED PACK') 22 and l_quantity >= 14 and l_quantity <= 14 + 10 23 and p_size between 1 and 10 24 and l_shipmode in ('AIR', 'AIR REG') 25 and l_shipinstruct = 'DELIVER IN PERSON' 26 ) 27 or 28 ( 29 p_partkey = l_partkey 30 and p_brand = 'Brand#44' 31 and p_container in ('LG CASE', 'LG BOX', 'LG PACK', 'LG PKG') 32 and l_quantity >= 28 and l_quantity <= 28 + 10 33 and p_size between 1 and 15 34 and l_shipmode in ('AIR', 'AIR REG') 35 and l_shipinstruct = 'DELIVER IN PERSON' 36 ); 37 revenue 38 null