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