SELECT ITEM.ITEM_CODE as CODE, ITEM.ITEM_NAME as NAME, SUB.SUM_QTY
FROM (
SELECT ITEM_CODE, sum(ORDER_QTY) as SUM_QTY
FROM ORDERS_DTL as dtl
INNER JOIN ORDERS as s ON dtl.ORDER_NO = s.ORDER_NO
WHERE s.WH_CODE = 100
GROUP BY ITEM_CODE
) AS SUB
INNER JOIN ITEM ON SUB.ITEM_CODE = ITEM.ITEM_CODE
WHERE SUM_QTY >= 50
ORDER BY SUB.SUM_QTY DESC, ITEM.ITEM_CODE DESC