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;