select ITEM_CODE as CODE ,
    ( select ITEM_NAME from ITEM where  ORDERS_DTL.ITEM_CODE = ITEM.ITEM_CODE ) as NAME , 
    sum(ORDER_QTY * UNITPRICE) as TOTAL_AMT 
from ORDERS_DTL
where ORDER_NO in (
    select order_no from ORDERS
    where ORDER_DATE between '2023-05-14' and '2023-05-20'
    )
group by ITEM_CODE
order by TOTAL_AMT desc , CODE desc 
LIMIT 5