SELECT
TJuchuMeisai.ITEM_CODE AS 'CODE',
MItem.ITEM_NAME AS 'NAME',
SUM(ORDER_QTY) AS 'SUM_QTY'
FROM ORDERS TJuchu
INNER JOIN WAREHOUSE MSoko
ON TJuchu.WH_CODE = MSoko.WH_CODE
INNER JOIN ORDERS_DTL TJuchuMeisai
ON TJuchuMeisai.ORDER_NO = TJuchu.ORDER_NO
LEFT JOIN ITEM MItem
ON MItem.ITEM_CODE = TJuchuMeisai.ITEM_CODE
WHERE MSoko.WH_NAME = '浦和倉庫'
GROUP BY CODE,NAME
HAVING SUM(ORDER_QTY) >= 50
ORDER BY 
SUM_QTY DESC,
CODE DESC
;