github.com/matrixorigin/matrixone@v1.2.0/test/distributed/cases/benchmark/tpch/03_QUERIES/q16.result (about)

     1  use tpch;
     2  select
     3  p_brand,
     4  p_type,
     5  p_size,
     6  count(distinct ps_suppkey) as supplier_cnt
     7  from
     8  partsupp,
     9  part
    10  where
    11  p_partkey = ps_partkey
    12  and p_brand <> 'Brand#35'
    13  and p_type not like 'ECONOMY BURNISHED%'
    14  and p_size in (14, 7, 21, 24, 35, 33, 2, 20)
    15  and ps_suppkey not in (
    16  select
    17  s_suppkey
    18  from
    19  supplier
    20  where
    21  s_comment like '%Customer%Complaints%'
    22  )
    23  group by
    24  p_brand,
    25  p_type,
    26  p_size
    27  order by
    28  supplier_cnt desc,
    29  p_brand,
    30  p_type,
    31  p_size
    32  ;
    33  p_brand	p_type	p_size	supplier_cnt
    34  Brand#11	STANDARD PLATED TIN	20	4
    35  Brand#12	MEDIUM PLATED STEEL	20	4
    36  Brand#13	PROMO BURNISHED COPPER	7	4
    37  Brand#13	SMALL BRUSHED COPPER	20	4
    38  Brand#14	ECONOMY POLISHED STEEL	24	4
    39  Brand#14	LARGE ANODIZED TIN	20	4
    40  Brand#15	LARGE POLISHED TIN	20	4
    41  Brand#15	STANDARD PLATED STEEL	24	4
    42  Brand#21	SMALL BRUSHED COPPER	35	4
    43  Brand#22	STANDARD ANODIZED TIN	35	4
    44  Brand#23	ECONOMY ANODIZED TIN	7	4
    45  Brand#23	LARGE PLATED BRASS	35	4
    46  Brand#23	SMALL ANODIZED NICKEL	33	4
    47  Brand#24	LARGE ANODIZED TIN	2	4
    48  Brand#31	STANDARD PLATED STEEL	20	4
    49  Brand#32	PROMO PLATED TIN	2	4
    50  Brand#33	MEDIUM ANODIZED COPPER	35	4
    51  Brand#33	PROMO PLATED COPPER	7	4
    52  Brand#33	STANDARD BURNISHED NICKEL	7	4
    53  Brand#34	SMALL PLATED BRASS	14	4
    54  Brand#42	STANDARD POLISHED BRASS	21	4
    55  Brand#43	ECONOMY BRUSHED STEEL	20	4
    56  Brand#43	SMALL POLISHED NICKEL	2	4
    57  Brand#45	LARGE BURNISHED BRASS	14	4
    58  Brand#45	STANDARD POLISHED STEEL	24	4
    59  Brand#51	ECONOMY POLISHED STEEL	7	4
    60  Brand#52	MEDIUM PLATED STEEL	20	4
    61  Brand#52	MEDIUM POLISHED BRASS	2	4
    62  Brand#52	SMALL BURNISHED NICKEL	14	4
    63  Brand#53	MEDIUM POLISHED TIN	2	4
    64  Brand#53	PROMO BRUSHED COPPER	24	4
    65  Brand#53	PROMO POLISHED NICKEL	33	4
    66  Brand#21	MEDIUM BURNISHED STEEL	24	2
    67  Brand#22	SMALL PLATED STEEL	2	2
    68  Brand#32	MEDIUM BRUSHED STEEL	7	2
    69  Brand#42	SMALL POLISHED STEEL	35	2
    70  Brand#43	MEDIUM ANODIZED BRASS	14	2
    71  Brand#45	STANDARD BURNISHED BRASS	2	2
    72  Brand#52	PROMO POLISHED STEEL	35	1
    73  Brand#53	ECONOMY BRUSHED TIN	21	1
    74  Brand#53	STANDARD BURNISHED STEEL	7	1