with tmp as(
select c.ITEM_CODE as CODE,
c.ITEM_NAME as NAME,
b.unitprice * b.ORDER_QTY as TOTAL_AMT,
rank() over(order by 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')
select CODE,NAME,TOTAL_AMT
  from tmp
 where rn <= 5
order by TOTAL_AMT desc,CODE desc