select
    ORDERS_DTL.ITEM_CODE as CODE
    ,ITEM.ITEM_NAME as NAME
    ,ORDERS_DTL.UNITPRICE*SUM(ORDERS_DTL.ORDER_QTY) as TOTAL_AMT
from
    ORDERS_DTL
    inner join ORDERS
        on ORDERS_DTL.ORDER_NO = ORDERS.ORDER_NO
    inner join ITEM
        on ORDERS_DTL.ITEM_CODE = ITEM.ITEM_CODE
where
    ORDERS.ORDER_DATE between '2023-05-14' and '2023-05-20'
group by ORDERS_DTL.ITEM_CODE
order by
    TOTAL_AMT desc
    ,CODE desc
limit 5