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