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