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 ;