select
    i.ITEM_CODE as CODE,
    i.ITEM_NAME as NAME,
    sum(od.UNITPRICE * od.ORDER_QTY) as TOTAL_AMT
from ORDERS o
inner JOIN ORDERS_DTL od on o.ORDER_NO = od.ORDER_NO and o.ORDER_DATE between '2023-05-14' and '2023-05-20'
LEFT JOIN ITEM i on od.ITEM_CODE = i.ITEM_CODE
group by CODE
order by TOTAL_AMT desc, CODE desc
limit 5
;