select 
    item.ITEM_CODE as CODE,
    item.ITEM_NAME as NAME,
    (od.UNITPRICE * od.ORDER_QTY) as TOTAL_AMT
from
    ITEM as item
inner join
    orders_dtl as od on od.item_code = item.item_code,
    orders as o on o.order_no = od.order_no
where
    o.order_date between '2023-05-14' and '2023-05-20'
order by
    TOTAL_AMT desc,
    item.ITEM_CODE desc
    
;