select
  c.ITEM_CODE as CODE
  , c.ITEM_NAME as NAME
  , sum(b.ORDER_QTY * b.UNITPRICE) 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 a.ORDER_DATE between '2023-05-14' and '2023-05-20'
group by 1, 2
order by 3 desc, 1 desc
limit 5
;