select ITEM.ITEM_CODE as CODE, ITEM_NAME as NAME,
    (select sum(ORDER_QTY)
    from ORDERS_DTL
    join ORDERS on ORDERS_DTL.ORDER_NO == ORDERS.ORDER_NO
    where ITEM.ITEM_CODE == ORDERS_DTL.ITEM_CODE and WH_CODE == 100)
    as SUM_QTY
from ITEM
where SUM_QTY >= 50
order by SUM_QTY desc, CODE desc