select
  b.ITEM_CODE as CODE,
  c.ITEM_NAME as NAME,
  SUM(b.UNITPRICE * b.ORDER_QTY) as TOTAL_AMT
from
  orders a
  left join orders_dtl b
    on a.ORDER_NO = b.ORDER_NO
  left join item 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
  b.ITEM_CODE,c.ITEM_NAME
order by total_amt desc, b.ITEM_CODE limit 5