select 
  i.ITEM_CODE CODE,
  i.ITEM_NAME NAME,
  sum(o.unitprice * o.order_qty) TOTAL_AMT
from orders_dtl o
left join orders os using(order_no)
left join item i using(item_code)
where
    '2023-05-14' <= os.order_date and os.order_date <= '2023-05-20'
group by 1,2
order by 3 desc, 1 desc
limit 5