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