SELECT
    C.ITEM_CODE AS CODE,
    C.ITEM_NAME AS NAME,
    C.SUM_QTY
FROM(
    SELECT
    ORDERS_DTL.ITEM_CODE,
    ITEM_NAME,
    SUM(ORDERS_DTL.ORDER_QTY) AS SUM_QTY
    FROM ORDERS
    INNER JOIN ORDERS_DTL ON ORDERS.ORDER_NO = ORDERS_DTL.ORDER_NO
    LEFT JOIN ITEM ON ORDERS_DTL.ITEM_CODE = ITEM.ITEM_CODE
    WHERE WH_CODE = '100' 
    GROUP BY ORDERS_DTL.ITEM_CODE,ITEM.ITEM_NAME
) AS C
WHERE SUM_QTY >= 50
ORDER BY
SUM_QTY DESC,
CODE DESC