SELECT OD.ITEM_CODE AS CODE,IT.ITEM_NAME AS NAME,SUM(UNITPRICE*ORDER_QTY) AS TOTAL_AMT
FROM ORDERS_DTL AS OD
JOIN 
(SELECT ORDER_NO
FROM ORDERS
WHERE ORDER_DATE BETWEEN '2023-05-14' AND '2023-05-20') AS ORD
ON ORD.ORDER_NO = OD.ORDER_NO
JOIN ITEM AS IT
ON IT.ITEM_CODE = OD.ITEM_CODE
GROUP BY OD.ORDER_NO
ORDER BY SUM(UNITPRICE*ORDER_QTY) DESC,OD.ITEM_CODE DESC
LIMIT 5;