select 
    ITEM.ITEM_CODE as CODE
    , ITEM.ITEM_NAME as NAME
    , sum(ORDERS_DTL.UNITPRICE * ORDERS_DTL.ORDER_QTY) as TOTAL_AMT
from 
    ORDERS_DTL 
        left join ORDERS 
            on ORDERS.ORDER_NO = ORDERS_DTL.ORDER_NO 
        left join ITEM 
            on ITEM.ITEM_CODE = ORDERS_DTL.ITEM_CODE 
where 
    ORDERS.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 
;