SELECT odd.ITEM_CODE AS CODE,
    it.ITEM_NAME AS NAME,
    SUM(odd.ORDER_QTY) AS SUM_QTY
FROM WAREHOUSE AS wa
JOIN ORDERS AS od
ON wa.WH_CODE = od.WH_CODE
JOIN ORDERS_DTL AS odd
ON od.ORDER_NO = odd.ORDER_NO
LEFT OUTER JOIN ITEM AS it
ON odd.ITEM_CODE = it.ITEM_CODE
GROUP BY NAME
HAVING SUM_QTY > 50
ORDER BY SUM_QTY DESC,
    NAME DESC;