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