select
    I.ITEM_CODE AS CODE 
    ,I.ITEM_NAME AS NAME
    ,sum(unitprice * 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
    order_date between '2023-05-14' and '2023-05-20'
group by 1,2
order by 3 desc, 1 desc
limit 5