text:         select
          	p_brand,
          	p_type,
          	p_size,
          	count(distinct ps_suppkey) as supplier_cnt
          from
          	partsupp,
          	part
          where
          	p_partkey = ps_partkey
          	and p_brand <> 'Brand#45'
          	and p_type not like 'MEDIUM POLISHED%'
          	and p_size in (49, 14, 23, 45, 19, 3, 36, 9)
          	and ps_suppkey not in (
          		select
          			s_suppkey
          		from
          			supplier
          		where
          			s_comment like '%Customer%Complaints%'
          	)
          group by
          	p_brand,
          	p_type,
          	p_size
          order by
          	supplier_cnt desc,
          	p_brand,
          	p_type,
          	p_size;