SELECT
ORDERS_DTL.ITEM_CODE as CODE,
ITEM.ITEM_NAME as NAME,
SUM(ORDERS_DTL.ORDER_QTY) as SUM_QTY
FROM
ORDERS
LEFT JOIN ORDERS_DTL
ON ORDERS.ORDER_NO = ORDERS_DTL.ORDER_NO
LEFT JOIN WAREHOUSE
ON ORDERS.WH_CODE = WAREHOUSE.WH_CODE
LEFT JOIN ITEM
ON ORDERS_DTL.ITEM_CODE = ITEM.ITEM_CODE
WHERE WAREHOUSE.WH_NAME = '浦和倉庫'
GROUP BY ORDERS_DTL.ITEM_CODE,ITEM.ITEM_NAME
HAVING SUM_QTY >= 50
ORDER BY SUM_QTY DESC,CODE DESC