select
    b.item_code as CODE,
    c.item_name as NAME,
    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')
left outer join item as c
using(item_code)
group by 1, 2
order by 3 desc, 1 desc;