SELECT
 i.ITEM_CODE as CODE
 ,i.ITEM_NAME as NAME
 ,sum(UNITPRICE * ORDER_QTY) as TOTAL_AMT
FROM ORDERS as o
INNER JOIN ORDERS_DTL as od
  ON o.ORDER_NO = od.ORDER_NO
INNER JOIN ITEM as i
  ON i.ITEM_CODE  = od.ITEM_CODE 
WHERE ORDER_DATE >= '2023-05-14' 
  and ORDER_DATE <= '2023-05-20' 
GROUP BY CODE
ORDER BY 
  TOTAL_AMT desc,
  CODE desc
limit 5;