SELECT ORDERS_DTL.ITEM_CODE CODE
,ITEM.ITEM_NAME NAME
,SUM(ORDER_QTY) SUM_QTY
FROM ORDERS
LEFT JOIN WAREHOUSE ON ORDERS.WH_CODE = WAREHOUSE.WH_CODE
LEFT JOIN ORDERS_DTL ON ORDERS.ORDER_NO = ORDERS_DTL.ORDER_NO
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(ORDER_QTY) >= 50
ORDER BY SUM(ORDER_QTY) DESC
,ORDERS_DTL.ITEM_CODE DESC