select
            aa.item_code as CODE,
            bb.item_name as NAME,
            aa.TOTAL_AMT
        from(
            select
                c.item_code,
                sum(total) as TOTAL_AMT
            from(
                select
                    b.item_code,
                    b.unitprice * b.order_qty as total
                from (select distinct order_no 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)) as c
                group by 1) as aa
        inner join item as bb
        using(item_code)
        order by 3 desc, 1 desc;