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