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