with tmp as(
select c.ITEM_CODE as CODE,
c.ITEM_NAME as NAME,
sum(b.unitprice * b.ORDER_QTY) as TOTAL_AMT,
rank() over(order by sum(b.unitprice * b.ORDER_QTY) desc) as rn
  from ORDERS a
  join ORDERS_DTL b
    on a.order_no = b.order_no
  join item c
    on c.item_code = b.item_code
 where a.ORDER_DATE between '2023-05-14' and '2023-05-20'
group by c.ITEM_CODE,c.ITEM_NAME)
select CODE,NAME,TOTAL_AMT
  from tmp
 where rn <= 5
order by TOTAL_AMT desc,CODE desc