github.com/matrixorigin/matrixone@v1.2.0/test/distributed/cases/benchmark/tpch/03_QUERIES/q2.result (about) 1 use tpch; 2 select 3 s_acctbal, 4 s_name, 5 n_name, 6 p_partkey, 7 p_mfgr, 8 s_address, 9 s_phone, 10 s_comment 11 from 12 part, 13 supplier, 14 partsupp, 15 nation, 16 region 17 where 18 p_partkey = ps_partkey 19 and s_suppkey = ps_suppkey 20 and p_size = 48 21 and p_type like '%TIN' 22 and s_nationkey = n_nationkey 23 and n_regionkey = r_regionkey 24 and r_name = 'MIDDLE EAST' 25 and ps_supplycost = ( 26 select 27 min(ps_supplycost) 28 from 29 partsupp, 30 supplier, 31 nation, 32 region 33 where 34 p_partkey = ps_partkey 35 and s_suppkey = ps_suppkey 36 and s_nationkey = n_nationkey 37 and n_regionkey = r_regionkey 38 and r_name = 'MIDDLE EAST' 39 ) 40 order by 41 s_acctbal desc, 42 n_name, 43 s_name, 44 p_partkey 45 limit 100 46 ; 47 s_acctbal s_name n_name p_partkey p_mfgr s_address s_phone s_comment 48 -283.84 Supplier#000000005 IRAQ 44 Manufacturer#4 Gcdm2rJRzl5qlTVzc 21-151-690-3663 . slyly regular pinto bea