select
    i.ITEM_CODE as CODE,
    i.ITEM_NAME as NAME,
    ord.q as TOTAL_AMT
from
    item as i
inner join(
    select
        od.item_code,
        sum(od.unitprice * od.order_qty) as q
    from orders as o
    inner join
        orders_dtl as od
    on
        o.order_no = od.order_no
    group by
        od.item_code
    order by
        od.item_code desc
        ) as ord
on
    i.item_code = ord.item_code
group by
    i.item_code,
    i.item_name
order by
    total_amt desc,
    ord.item_code desc
limit 5;