SELECT
    B.ITEM_CODE AS CODE
    ,D.ITEM_NAME AS NAME
    ,SUM(B.ORDER_QTY)
FROM
    ORDERS  AS A
JOIN
    ORDERS_DTL AS B
ON
    A.ORDER_NO = B.ORDER_NO
JOIN
    WAREHOUSE AS C
ON
    C.WH_CODE = A.WH_CODE
JOIN
    ITEM AS D
ON
    D.ITEM_CODE = B.ITEM_CODE
GROUP BY
    D.ITEM_CODE
HAVING
    SUM(B.ORDER_QTY) > 50
ORDER BY
    3 DESC ,1 DESC