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