SELECT ORDERS_DTL.ITEM_CODE as CODE, ITEM.ITEM_NAME as NAME, SUM(ORDERS_DTL.ORDER_QTY) as SUM_QTY
FROM WAREHOUSE
INNER JOIN ORDERS
ON WAREHOUSE.WH_CODE = ORDERS.WH_CODE
INNER JOIN ORDERS_DTL
ON ORDERS.ORDER_NO = ORDERS_DTL.ORDER_NO
LEFT OUTER JOIN ITEM
ON ITEM.ITEM_CODE = ORDERS_DTL.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 ASC;