| Album » OptB » q16 (7 Slides) | [Page 1 of 1] :: Jump To |
p_brand,
p_type,
p_size,
count(distinct ps_suppkey) as supplier_cnt
from
partsupp,
part
where
p_partkey = ps_partkey
and p_retailprice :varies
and ps_suppkey in (
select
s_suppkey
from
supplier
where
s_acctbal :varies
)
group by
p_brand,
p_type,
p_size
order by
supplier_cnt desc,
p_brand,
p_type,
p_size
|
|||||||||||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||||||||
