SELECT od.ITEM_CODE AS CODE
	, i.ITEM_NAME AS NAME
	, sum(od.ORDER_QTY) AS SUM_QTY
FROM ORDERS_DTL AS od
INNER JOIN ORDERS AS o
	ON od.ORDER_NO = o.ORDER_NO
LEFT JOIN ITEM AS i
	ON od.ITEM_CODE = i.ITEM_CODE
WHERE o.WH_CODE = '100'
GROUP BY od.item_code
	, i.item_name
HAVING SUM_QTY >= 50
ORDER BY sum_qty DESC
	, od.item_code DESC