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 ods on od.order_no=ods.order_no
    inner join item as it on od.item_code=it.item_code
where
    ods.order_date between "2023-05-14" and "2023-05-20"
group by
    code
order by
    total_amt desc,
    code desc
limit 5
;