select
    item.item_code as CODE
    ,item.item_name as NAME
    ,sum(dtl.UNITPRICE * dtl.ORDER_QTY) as TOTAL_AMT
from
    orders_dtl as dtl
    inner join ITEM
        on dtl.item_code = item.item_code
    inner join orders as o
        on o.order_no = dtl.order_no
        and o.order_date between '2023-05-14' and '2023-05-20'
group by
    item.item_code
order by
    TOTAL_AMT DESC
    ,item.ITEM_CODE desc
limit 5
;