select 
  item.ITEM_CODE as CODE
  , item.ITEM_NAME as NAME
  , sum(dtl.UNITPRICE * dtl.ORDER_QTY) as TOTAL_AMT
from
  ORDERS o
    inner join ORDERS_DTL dtl on dtl.ORDER_NO = o.ORDER_NO
    inner join ITEM item on item.ITEM_CODE = dtl.ITEM_CODE
where
  o.ORDER_DATE between '2023-05-14' and '2023-05-20'
group by
  item.ITEM_CODE, item.ITEM_NAME
order by
 TOTAL_AMT desc
  , item.ITEM_CODE desc
limit 5