SELECT t.CODE AS CODE, t.NAME AS NAME, t.SUM_QTY AS SUM_QTY FROM (
SELECT od.ITEM_CODE AS CODE, i.ITEM_NAME AS NAME, SUM(od.ORDER_QTY) AS SUM_QTY
FROM ORDERS AS o, WAREHOUSE AS wh, ORDERS_DTL AS od
LEFT OUTER JOIN ITEM AS i ON i.ITEM_CODE = od.ITEM_CODE
WHERE
wh.WH_CODE = o.WH_CODE AND wh.WH_NAME = "浦和倉庫"
AND od.ORDER_NO = o.ORDER_NO
GROUP BY od.ITEM_CODE
) as t
WHERE t.SUM_QTY >= 50
ORDER BY t.SUM_QTY DESC, t.CODE DESC;