with tmp as(
select
    od.item_code as CODE
    ,it.item_name as NAME
    ,sum(od.unitprice * od.order_qty) as TOTAL_AMT
from
    orders_dtl as od
inner join orders as odr
on od.order_no = odr.order_no
inner join item as it
on od.item_code = it.item_code

where
    odr.order_date between date('2023-05-14') and date('2023-05-20')
group by
    CODE,NAME
order by
    total_amt desc
    ,code desc
)

select * from tmp