with base1 as (
select
  dtl.ITEM_CODE as CODE
 ,itm.ITEM_NAME as NAME
 ,sum(dtl.UNITPRICE * dtl.ORDER_QTY) as TOTAL_AMT
from
    ORDERS as main
inner join
    ORDERS_DTL as dtl using(ORDER_NO)
inner join
    ITEM as itm using(ITEM_CODE)
where
    main.ORDER_DATE between '2023-05-14' and '2023-05-20'
group by
     dtl.ITEM_CODE
    ,itm.ITEM_NAME
)
, base2 as (
select
  CODE
 ,NAME
 ,TOTAL_AMT
 ,row_number() over(order by TOTAL_AMT desc, CODE desc) as rank
from
  base1
)
select
  CODE
 ,NAME
 ,TOTAL_AMT
from
  base2
where
  rank <= 5
order by
     TOTAL_AMT desc
    ,CODE desc