SELECT I.ITEM_CODE, SUM(
	CASE WHEN ORDER_DATE BETWEEN '2023-04-01' AND '2023-06-30' THEN ORDER_QTY
	ELSE 0
	END) AS SUM_QTY
FROM
	ORDERS O 
	INNER JOIN ORDERS_DTL OD
		ON O.ORDER_NO = OD.ORDER_NO
	INNER JOIN ITEM I
		ON OD.ITEM_CODE = I.ITEM_CODE
	GROUP BY I.ITEM_CODE
ORDER BY
	SUM_QTY DESC, I.ITEM_CODE DESC