SELECT
  DTL.ITEM_CODE as CODE,
  ITEM_NAME as NAME,
  SUM(ORDER_QTY) as SUM_QTY
  FROM ORDERS_DTL DTL
  INNER JOIN (
   SELECT
    ORDER_NO
   FROM ORDERS 
   LEFT JOIN WAREHOUSE
    ON WAREHOUSE.WH_CODE = ORDERS.WH_CODE
  )ORD
    ON DTL.ORDER_NO  = ORD.ORDER_NO 
 LEFT JOIN ITEM
  ON DTL.ITEM_CODE = ITEM.ITEM_CODE
   GROUP BY DTL.ITEM_CODE
  HAVING SUM_QTY >= 50
 ORDER BY SUM_QTY DESC ,CODE DESC