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 D.ITEM_CODE=I.ITEM_CODE
where O.ORDER_DATE between '2023-05-14' and '2023-05-20'
group by CODE
order by TOTAL_AMT desc, CODE desc
limit 5
;