select
    od.ITEM_CODE as CODE
    , i.ITEM_NAME as NAME     
    , sum(UNITPRICE)* sum(ORDER_QTY) as TOTAL_AMT
from
    ORDERS_DTL od 
    inner join orders o 
        on od.ORDER_NO = o.ORDER_NO 
    inner join ITEM i 
        on od.ITEM_CODE = i.ITEM_CODE 
where
    o.ORDER_DATE >= '2023-05-14' 
    and o.ORDER_DATE <= '2023-05-20' 
group by CODE
order by
    TOTAL_AMT desc
     ,CODE desc
limit 5;