github.com/matrixorigin/matrixone@v1.2.0/test/distributed/cases/benchmark/tpch/03_QUERIES/q13.result (about) 1 use tpch; 2 select 3 c_count, 4 count(*) as custdist 5 from 6 ( 7 select 8 c_custkey, 9 count(o_orderkey) 10 from 11 customer left outer join orders on 12 c_custkey = o_custkey 13 and o_comment not like '%pending%accounts%' 14 group by 15 c_custkey 16 ) as c_orders (c_custkey, c_count) 17 group by 18 c_count 19 order by 20 custdist desc, 21 c_count desc 22 ; 23 c_count custdist 24 0 50 25 17 8 26 16 7 27 22 6 28 14 6 29 11 6 30 20 5 31 12 5 32 10 5 33 9 5 34 7 5 35 23 4 36 21 4 37 15 4 38 13 4 39 4 4 40 26 3 41 19 3 42 8 3 43 6 3 44 18 2 45 5 2 46 30 1 47 29 1 48 28 1 49 25 1 50 24 1 51 3 1