Query Template
select
s_name,
s_address
from
supplier,
nation
where
s_suppkey in (
select
ps_suppkey
from
partsupp
where
ps_partkey in (
select
p_partkey
from
part
where
p_name like 'forest%'
)
and ps_availqty < (
select
0.5 * sum(l_quantity)
from
lineitem
where
l_partkey = ps_partkey
and l_suppkey = ps_suppkey
and l_extendedprice :varies
)
)
and s_nationkey = n_nationkey
and s_acctbal :varies
and n_name = 'AMERICA'
order by
s_name
Optimizer Diagrams
|