SELECT 
  I.ITEM_CODE as CODE,
  I.ITEM_NAME as NAME,
  SUM(OD.UNITPRICE * OD.ORDER_QTY) as TOTAL_AMT  
FROM ITEM  I
INNER JOIN ORDERS_DTL OD
ON I.ITEM_CODE = OD.ITEM_CODE
INNER JOIN ORDERS O
ON O.ORDER_NO = OD.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;