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 (select * from orders where julianday(order_date) between julianday('2023-05-14') and julianday('2023-05-20'))as a
        inner join orders_dtl as b
        using(order_no)
        group by 1) as aa
    inner join item as bb
    using(item_code)
    order by 3 desc, 1 desc;