q11

SELECT
    PS_PARTKEY,
    SUM(PS_SUPPLYCOST * PS_AVAILQTY) AS VALUE
FROM
    PARTSUPP,
    SUPPLIER,
    NATION
WHERE
    PS_SUPPKEY = S_SUPPKEY
    AND S_NATIONKEY = N_NATIONKEY
    AND N_NAME = 'GERMANY'
    AND PS_SUPPLYCOST :varies
    AND S_ACCTBAL :varies
GROUP BY
    PS_PARTKEY HAVING
        SUM(PS_SUPPLYCOST * PS_AVAILQTY) > (
            SELECT
                SUM(PS_SUPPLYCOST * PS_AVAILQTY) * 0.0001000000
            FROM
                PARTSUPP,
                SUPPLIER,
                NATION
            WHERE
                PS_SUPPKEY = S_SUPPKEY
                AND S_NATIONKEY = N_NATIONKEY
                AND N_NAME = 'GERMANY'
        )
ORDER BY
    VALUE DESC

plan_diag

reduced_diag

cost_diag

card_diag

plan1

plan2

plan3

plan4

plan5

plan6

plan7

plan8

Album last updated on 5/19/07 1:10 AM