select
    od.item_code ITEM_CODE
    ,i.item_name NAME
    ,sum(od.unitprice * order_qty) TOTAL_AMT
from
    orders_dtl od
    left join orders o on od.order_no = o.order_no
    left join item i on i.item_code = od.item_code
where
    o.order_date between '2023-05-14' and '2023-05-20'
group by
    od.item_code, i.item_name
order by
    total_amt desc, od.item_code desc
limit 5
;