SELECT b.ITEM_CODE as CODE,c.ITEM_NAME as NAME,
    SUM(b.ORDER_QTY) as SUM_QTY
FROM ORDERS a,ORDERS_DTL b,ITEM c,WAREHOUSE d
WHERE a.ORDER_NO = b.ORDER_NO
AND b.ITEM_CODE  = c.ITEM_CODE 
AND a.WH_CODE  = d.WH_CODE 
AND d.WH_NAME ='浦和倉庫'
AND SUM_QTY>='50'
GROUP BY b.ITEM_CODE;