| Album » OptE » q20 (7 Slides) | [Page 1 of 1] :: Jump To |
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 = PARTSUPP.PS_PARTKEY
AND L_SUPPKEY = PARTSUPP.PS_SUPPKEY
AND L_EXTENDEDPRICE :varies
)
)
AND S_NATIONKEY = N_NATIONKEY
AND S_ACCTBAL :varies
AND N_NAME = 'AMERICA'
ORDER BY
S_NAME
|
|||||||||||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||||||||
