github.com/matrixorigin/matrixone@v1.2.0/test/distributed/cases/benchmark/tpch/03_QUERIES/q16.sql (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  ;