WITH SOKO AS(
     SELECT
         WH_CODE
     FROM
         WAREHOUSE
     WHERE WH_NAME = '浦和倉庫'
)
, ODS AS(
     SELECT
      A.*
     FROM ORDERS A,SOKO B
     WHERE A.WH_CODE  = B.WH_CODE
)
SELECT 
  B.ITEM_CODE CODE
 ,ITEM.ITEM_NAME NAME
 ,SUM(B.ORDER_QTY) SUM_QTY
FROM ODS A,ORDERS_DTL B
LEFT JOIN ITEM 
     ON B.ITEM_CODE  = ITEM.ITEM_CODE 
WHERE A.ORDER_NO = B.ORDER_NO
GROUP BY B.ITEM_CODE
HAVING SUM(B.ORDER_QTY) >= 50
ORDER BY SUM(B.ORDER_QTY) DESC,B.ITEM_CODE DESC