select
  OD.ITEM_CODE AS CODE
  , I.ITEM_NAME AS NAME
  , SUM(OD.UNITPRICE * ORDER_QTY) AS TOTAL_AMT
from
  ORDERS_DTL AS OD
inner join
  ORDERS AS O
on
  OD.ORDER_NO = O.ORDER_NO
inner join
  ITEM AS I
on
  OD.ITEM_CODE = I.ITEM_CODE
where
  O.ORDER_DATE between '2023-05-14' and '2023-05-20'
group by
  CODE
  , I.ITEM_NAME
order by
  TOTAL_AMT desc
  , OD.ITEM_CODE
limit 5
;