select

ot.ITEM_CODE as CODE,
it.ITEM_NAME as NAME,
sum(ot.UNITPRICE * ot.ORDER_QTY) as TOTAL_AMT

from ORDERS_DTL as ot
left join ORDERS as od
using(ORDER_NO)

left join ITEM as it
using(ITEM_CODE)

where od.ORDER_DATE between '2023-05-14' and '2023-05-20'
group by 1,2
order by 3 desc, 1
limit 5
;