with base as (
select
    ITEM_CODE 
    ,sum(UNITPRICE * ORDER_QTY) as TOTAL_AMT
from
    ORDERS_DTL as odd
    inner join
    ORDERS as od
    on odd.ORDER_NO = od.ORDER_NO
where
    od.ORDER_DATE between "2023-05-14" and "2023-05-20"
group by
    ITEM_CODE
order by
    TOTAL_AMT desc
limit 5
)
select
    b.ITEM_CODE as CODE
    ,i.ITEM_NAME as NAME
    ,TOTAL_AMT
from
    base as b
    inner join
    item as i
    on b.ITEM_CODE=i.ITEM_CODE
order by
    TOTAL_AMT desc
    ,b.ITEM_CODE desc