select
 D.ITEM_CODE as CODE,
 I.ITEM_NAME as NAME,
 SUM(D.UNITPRICE * D.ORDER_QTY) As TOTAL_AMT
from
 ORDERS as O
 inner join ORDERS_DTL as D
   on O.ORDER_NO = D.ORDER_NO
 inner join ITEM as I
   on I.item_code = D.item_code
where
 O.ORDER_DATE BETWEEN '2023-05-14' AND '2023-05-20'
group by
 D.ITEM_CODE, I.ITEM_NAME
order by
 TOTAL_AMT desc, CODE asc
LIMIT 5