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