SELECT * FROM (
SELECT od.ITEM_CODE AS CODE, IFNULL(i.ITEM_NAME, "NULL") 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
)
WHERE SUM_QTY >= 50
ORDER BY SUM_QTY DESC, CODE DESC;