select
    i.ITEM_CODE as CODE,
    i.ITEM_NAME as NAME,
    (ord.unitprice * ord.order_qty) as TOTAL_AMT
from
    item as i
inner join(
    select *
    from orders as o
    inner join orders_dtl as od
    on o.order_no = od.order_no
    where
        o.order_date >= "2023-05-14"
    and o.order_date <= "2023-05-20"
    ) as ord
on
    i.item_code = ord.item_code
group by
    ord.item_code
order by
    total_amt desc,
    ord.item_code desc
limit 5;