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