sprawko3zad6

SELECT DISTINCT *
FROM(
        SELECT  C.CUSID AS ID, C.CUS_NAME AS NAME,
                C.CREDIT_LIMIT AS LIMIT,
                (C.CREDIT_LIMIT-C.BALANCE) AS DOSTEPNE_SRODKI,
                OD.PART# AS CZESC,
        (
            SELECT SUM(ODET.NUM_ORDERED)
            FROM ORDER_DETAILS ODET, T_ORDERS TD
            WHERE ODET.ORDER#= TD.ORDER# AND TD.CUSID = C.CUSID AND ODET.PART#=OD.PART#
        ) AS ILOSC,
        DENSE_RANK() OVER (PARTITION BY (OD.PART#) ORDER BY
        (
            SELECT
            SUM(ODET.NUM_ORDERED)
            FROM ORDER_DETAILS ODET, T_ORDERS TD
            WHERE ODET.ORDER# =TD.ORDER# AND TD.CUSID = C.CUSID AND ODET.PART#=OD.PART#
        )DESC) AS RANKING
        FROM CUSTOMER C, T_ORDERS O, ORDER_DETAILS OD
        WHERE O.CUSID=C.CUSID AND O.ORDER#=OD.ORDER#
        ORDER BY 5 ASC
    )
WHERE RANKING=1;