github.com/matrixorigin/matrixone@v1.2.0/test/distributed/cases/benchmark/tpch/03_QUERIES/q22.result (about) 1 use tpch; 2 select 3 cntrycode, 4 count(*) as numcust, 5 sum(c_acctbal) as totacctbal 6 from 7 ( 8 select 9 substring(c_phone from 1 for 2) as cntrycode, 10 c_acctbal 11 from 12 customer 13 where 14 substring(c_phone from 1 for 2) in 15 ('10', '11', '26', '22', '19', '20', '27') 16 and c_acctbal > ( 17 select 18 avg(c_acctbal) 19 from 20 customer 21 where 22 c_acctbal > 0.00 23 and substring(c_phone from 1 for 2) in 24 ('10', '11', '26', '22', '19', '20', '27') 25 ) 26 and not exists ( 27 select 28 * 29 from 30 orders 31 where 32 o_custkey = c_custkey 33 ) 34 ) as custsale 35 group by 36 cntrycode 37 order by 38 cntrycode 39 ; 40 cntrycode numcust totacctbal 41 11 4 29942.58 42 19 2 17120.35 43 20 1 9091.82 44 26 1 7354.23