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

--SELECT * FROM ORDERS_DTL A WHERE A.ITEM_CODE = 'P008'