select
    aa.item_code as CODE,
    bb.item_name as NAME,
    aa.TOTAL_AMT

from(
    select
        b.item_code,
        sum(b.unitprice * b.order_qty) as TOTAL_AMT
    from orders as a
    inner join orders_dtl as b
    on
        a.order_no = b.order_no
        and julianday(a.order_date) between julianday('2023-05-14') and julianday('2023-05-20')
    group by 1) as aa
inner join item as bb
using(item_code)
order by 3 desc, 1 desc;