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