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