github.com/matrixorigin/matrixone@v1.2.0/pkg/sql/plan/tpch/q16.sql (about)

     1  select
     2  	p_brand,
     3  	p_type,
     4  	p_size,
     5  	count(distinct ps_suppkey) as supplier_cnt
     6  from
     7  	partsupp,
     8  	part
     9  where
    10  	p_partkey = ps_partkey
    11  	and p_brand <> 'Brand#35'
    12  	and p_type not like 'ECONOMY BURNISHED%'
    13  	and p_size in (14, 7, 21, 24, 35, 33, 2, 20)
    14  	and ps_suppkey not in (
    15  		select
    16  			s_suppkey
    17  		from
    18  			supplier
    19  		where
    20  			s_comment like '%Customer%Complaints%'
    21  	)
    22  group by
    23  	p_brand,
    24  	p_type,
    25  	p_size
    26  order by
    27  	supplier_cnt desc,
    28  	p_brand,
    29  	p_type,
    30  	p_size
    31  ;