select
  ITEM_CODE as CODE,
  ITEM_NAME as NAME,
  sum(UNITPRICE * ORDER_QTY) as TOTAL_AMT
from ORDERS
inner join ORDERS_DTL using (ORDER_NO)
inner join ITEM using (ITEM_CODE)
where
  ORDER_DATE between '2023-05-14' and '2023-05-20'
group by
  ITEM_CODE
order by
  TOTAL_AMT desc,
  ITEM_CODE desc
limit 5