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