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')
        (a.order_date = '2023-05-14'
        or a.order_date = '2023-05-15'
        or a.order_date = '2023-05-16'
        or a.order_date = '2023-05-17'
        or a.order_date = '2023-05-18'
        or a.order_date = '2023-05-19'
        or a.order_date = '2023-05-20')
        
left outer join item as c
using(item_code)
group by 1, 2
order by 3 desc, 1 desc
limit 5;