SELECT ORDERS_DTL.ITEM_CODE CODE,MAX(ITEM.ITEM_NAME) NAME, sum(ORDERS_DTL.ORDER_QTY) SUM_QTY
FROM ORDERS_DTL 
LEFT OUTER JOIN ORDERS 
ON ORDERS_DTL.ORDER_NO = ORDERS.ORDER_NO 
LEFT OUTER JOIN WAREHOUSE 
ON WAREHOUSE.WH_CODE = ORDERS.WH_CODE
LEFT OUTER JOIN ITEM 
ON ITEM.ITEM_CODE = ORDERS_DTL.ITEM_CODE
GROUP BY ORDERS_DTL.ITEM_CODE
HAVING SUM_QTY >= 50
ORDER BY SUM_QTY DESC,CODE DESC