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