SELECT
    OD.item_code AS CODE
    , I.item_name AS NAME
    , SUM(OD.order_qty) AS SUM_QTY 
FROM
    warehouse H 
    LEFT OUTER JOIN orders O 
        ON H.wh_code = O.wh_code 
    LEFT OUTER JOIN orders_dtl OD 
        ON O.order_no = OD.order_no 
    LEFT OUTER JOIN item I 
        ON OD.item_code = I.item_code 
GROUP BY
    OD.item_code 
HAVING
    SUM(OD.order_qty) >= 50 
ORDER BY
    SUM_QTY DESC 
    , I.item_code DESC