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;
  