SELECT OD.ITEM_CODE AS CODE
	, I.ITEM_NAME AS NAME
	, SUM(OD.ORDER_QTY) AS SUM_QTY
FROM ORDERS AS O
INNER JOIN ORDERS_DTL AS OD
	ON O.ORDER_NO = OD.ORDER_NO
LEFT JOIN ITEM AS I
	ON OD.ITEM_CODE = I.ITEM_CODE
INNER JOIN WAREHOUSE AS W
	ON O.WH_CODE = W.WH_CODE
WHERE W.WH_CODE = '100'
GROUP BY OD.ITEM_CODE
	, I.ITEM_NAME
HAVING SUM_QTY >= 50
ORDER BY SUM(OD.ORDER_QTY) DESC
	, I.ITEM_CODE DESC