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