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 AS OD
 ON OD.WH_CODE = WH.WH_CODE
 
INNER JOIN ORDERS_DTL AS ODD
 ON ODD.ORDER_NO = OD.ORDER_NO
 
LEFT OUTER JOIN ITEM AS IT
 ON IT.ITEM_CODE = ODD.ITEM_CODE
 
WHERE WH.WH_NAME = '浦和倉庫'

GROUP BY
ODD.ITEM_CODE,
IT.ITEM_NAME

HAVING SUM_QTY >= 50

ORDER BY 
 SUM_QTY DESC,
 CODE DESC;