select
  T.T1 as CODE
 ,T.T2 as NAME
 ,T.T3 as TOTAL_AMT
from
 (
  select
    od.ITEM_CODE as T1
   ,i.ITEM_NAME as T2
   ,SUM(od.UNITPRICE * od.ORDER_QTY) as T3
   ,row_number() over (partition by od.ITEM_CODE order by SUM(od.UNITPRICE * od.ORDER_QTY) desc) as T4
  from
   ORDERS o
  join
   ORDERS_DTL od
  on
   o.ORDER_NO = od.ORDER_NO
  join
   ITEM i
  on
   od.ITEM_CODE = i.ITEM_CODE
  where
   o.ORDER_DATE >= '2023-05-14' and o.ORDER_DATE <= '2023-05-20'
  group by
   i.ITEM_CODE
 ) T
order by
 TOTAL_AMT desc, CODE desc limit 5;