SELECT   
	D.ITEM_CODE AS "CODE",  
	ITEM_NAME AS "NAME",  
	SUM(UNITPRICE*ORDER_QTY) AS "TOTAL"  
FROM  
	ORDERS_DTL D  
	LEFT OUTER JOIN ORDERS O  
		ON D.ORDER_NO = O.ORDER_NO  
	LEFT OUTER JOIN ITEM I  
		ON D.ITEM_CODE = I.ITEM_CODE  
WHERE  
	O.ORDER_DATE BETWEEN '2023-05-14' AND '2023-05-20'  
GROUP BY   
	D.ITEM_CODE, ITEM_NAME  
ORDER BY  
	TOTAL DESC,  
	CODE DESC