select 
  b.item_code as CODE 
  ,item_name as NAME 
  ,sum(unitprice * order_qty) as TOTAL_AMT
from orders as a
inner join orders_dtl as b 
  on a.order_no = b.order_no 
inner join item as c 
  on b.item_code = c.item_code 
where date(a.order_date) >= '2023-05-14'
  and date(a.order_date) <= '2023-05-20'
group by 1,2
order by total_amt desc, code desc
limit 5
;