select
    I.ITEM_CODE as CODE
    ,I.ITEM_NAME as NAME
    ,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
    O.ORDER_DATE between '2023-05-14' and '2023-05-20'
order by 3 desc, 1
limit 5