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