select
    od.ITEM_CODE as CODE
    ,it.item_name as NAME
    ,SUM(od.UNITPRICE * od.ORDER_QTY) as TOTAL_AMT
from
    orders_dtl as od
inner join
(
    select
        ORDER_NO
    from
        orders
    where
        ORDER_DATE >= '2023-05-14'
        and ORDER_DATE <= '2023-05-20'
) as odr
    on od.ORDER_NO = odr.ORDER_NO
inner join ITEM as it
    on od.ITEM_CODE = it.ITEM_CODE
group by od.ITEM_CODE
order by
    total_amt desc
    ,od.ITEM_CODE desc