SELECT ODD.ITEM_CODE AS CODE , IT.ITEM_NAME AS NAME , SUM(ODD.ORDER_QTY) AS SUM_QTY

FROM WAREHOUSE AS WH

INNER JOIN ORDERS OD ON OD.WH_CODE = WH.WH_CODE

INNER JOIN ORDERS_DTL ODD ON ODD.ORDER_NO = OD.ORDER_NO 

LEFT JOIN ITEM AS IT ON IT.ITEM_CODE = ODD.ITEM_CODE

WHERE WH_NAME = '浦和倉庫'

GROUP BY CODE , NAME 

HAVING SUM_QTY >= 50
ORDER BY SUM_QTY DESC , CODE DESC