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