select o.ITEM_CODE AS CODE,MAX(c.ITEM_NAME) AS NAME, sum(o.ORDER_QTY) as SUM_QTY
FROM ORDERS_DTL as o
LEFT OUTER JOIN ORDERS as a
ON o.ORDER_NO = a.ORDER_NO 
LEFT OUTER JOIN WAREHOUSE as b
ON b.WH_CODE = a.WH_CODE
LEFT OUTER JOIN ITEM as c
ON c.ITEM_CODE = o.ITEM_CODE
GROUP BY CODE
HAVING SUM_QTY <= '50'